Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Fusion Technical - Procure to Pay Cycle complete flow

Name: Oracle Fusion Technical - Procure to Pay Cycle complete flow
Rating: 4.3 (98 reviews)

P2P Cycle in Oracle Fusion CLoud ERP with base tables and Roles required for P2p Cycle , subject areas / OTBI

Created byRavinder Reddy Guduru

Last updated 12/2021

English

What you'll learn

complete procure to pay cycle (P2P or P2P) cycle in oracle fusion cloud ERP with base table ans subject areas
how to create requisition and base tables and subject area
how to create purchase order and po base tables and po cubject area
how to create ap invoice and ap invoice base tables and ap subject area
how to create payment againt invoice and payment base tables and payment subject area
how to create payment format (Check)
How create Payment process profile PPP
How to create Payement Document againt Bank account
Xla Tables with Joins
GL Tables With Joins

Course content

7 sections • 21 lectures • 3h 37m total length

Introduction0:30
Explore the complete procure-to-pay cycle in oracle fusion, from requisition to payments, including posting and the related tables in the p2p flow.
Basic Folw Of P2P Cycle1:50

Create User and Employee then Add Required Roles to user for P2P Cycle24:47
Manage approval for requisition and Po and Payment Format and payment document32:14
How To create item and Item Class16:27
item and item class base tables11:38
Item and Item Class subject areas4:18
Learn to check item and item class data via otbi subject areas, grant inventory balance access to inventory and warehouse managers, and run an analysis to filter by item class.

create Requisition .5:41
Learn to create a requisition in the procure-to-pay cycle, from logging in and entering item details to submitting for approval and tracking header, lines, and distributions.
Requisition Base Tables8:25
Requisiton Subject Area4:51
Explore the requisition subject area in Oracle Fusion procure-to-pay, access real-time procurement data, and view header, lines, item details, requester, buyer, ship to location, and delivery information.

Purchase order Creation7:05
Create a purchase order from a requisition using the document builder, configure lines, schedules, and distributions, and submit for approval to finalize the order.
Purchase Order Base Tables and link with Requisition10:01
Learn how to model purchase orders by exploring base tables, linking header and line data to requisitions, and mapping items, unit prices, quantities, shipping and delivery details.
Suject area for PO5:13
Access the Oracle Fusion procurement subject area by ensuring the user has category manager and procurement administrator roles, then build a purchasing analysis with items, ship-to details, and budget details.

Create AP Invoice .13:19
Automate AP invoice creation from receipt data or receiving transactions with scheduled programs, or run the import payables process manually, then validate postings and supplier data to ensure accurate invoices.
Ap Invoice Base Tables13:19
Explore how AP invoices are stored in base tables, including header, lines, distributions, unpaid amounts, supplier links, and payment schedules.
Post to GL via XLA2:07
XLA and Gl Base Table with Joins24:26
Learn to link AP invoices to GL via XLE base tables with joins, using AP headers and lines, Excel events, and import references to enable end-to-end procure-to-pay reporting.

Requirements

Oracle Fusion basics

Description

Procure To pay cycle in oracle Fusion Cloud ERP

1. Create Requisition

2. Create Purchase Order

3. Create Receipt

4. Create AP Invoice

5. Create Payment

6. Post To GL

7. Bases tables For requisition

8. Base tables For Purchasing

9. Base tables for Receiving transactions

10. Base tables for AP invoice and AP Invoice payments

11. Base Tables For XLA and GL

12 .Roles required to perform P2P Cycle

13 .Basics for Payment Format (Manage Formats)

14.Payment Documents for bank accounts (Manage Bank Accounts )

15 . Payment Process Request / profile

16. How to create item / item class

17.base tables for item and item class

#P2PCYCLE

#ORACLEFUSIONTECHNICAL

#ORACLE CLOUD

#oraclecloudreport

#oracleHCM

#Oraclefinancecloud

#oraclefusioncloud

#oracleOTBIreports

#Oraclefinancebasetables

Top 9 Inventory Tables in Oracle Fusion

1.EGP_SYSTEM_ITEMS

2.EGP_CATEGORY_SETS_VL

3.EGP_CATEGORIES_VL

4.EGP_ITEM_CATEGORIES

5.INV_ORG_PARAMETERS

6.EGP_ITEM_REVISIONS_B

7.EGP_ITEM_CAT_ASSIGNMENTS

8.INV_ONHAND_QUANTITIES_DETAIL

9.INV_RESERVATIONS

Requisition Tables

POR_REQUISITION_HEADERS_ALL

POR_REQUISITION_LINES_ALL

POR_REQ_DISTRIBUTIONS_ALL

Purchase Requisition

A requisition is a request for the goods or services. A purchase requisition is a formal document that is used when an employee needs to purchase or order something on behalf of their organization. The purchasing process is not processed when Purchase Requisition is created. This document informs the department managers or purchasing staff of the decision first. The purchasing department can start the process of purchasing the requested products or services after they receive an approved Purchase Requisition document.

Who this course is for:

Oracle Fusion / Could ERP Functional Consultants
Oracle Fusion/Cloud ERP Technical Consulatants
Oracle Apps EBS Technical Consultants
Oracle Apps EBS Functional Consultants
Oracle Developers

Oracle Fusion Technical - Procure to Pay Cycle complete flow

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 2min

Prerequisites For Procure To Pay cycle or P2P Cycle5 lectures • 1hr 29min

Create Requisition3 lectures • 19min

Create Purchase Order3 lectures • 22min

Create Receipt2 lectures • 17min

Create AP invoice4 lectures • 53min

Create Payment2 lectures • 14min

Requirements

Description

Who this course is for: