EBS:appsraj.OracleAppsTechnical

Overview Flow:

Requisition -> Request for quotation -> Quotation analysis -> Purchase Order -> Create Inventory Receipt -> Create Invoice -> Make payment against Invoice -> Creating Accounting -> Transfer to GL -> Post the Journal to GL

P2P Techno - Functional Flow:

Creation of Requisition: -

SELECT * FROM po_requisition_headers_all WHERE segment1 = '10222259';

SELECT * FROM po_requistion_lines_all WHERE requisition_header_id = '905489'

SELECT * FROM po_distributions_all where distribution_id in (624201,624202,624203,624204);

Creation of Purchase order against requisition: -

SELECT * FROM po_headers_all WHERE segment1 = '15128255';

SELECT * FROM po_lines_all WHERE po_header_id = 998860;

SELECT * FROM po_lines_locations_all WHERE po_header_id = '998860'

SELECT * FROM po_distributions_all where po_header_id = '998860'

(po_distributions_all .req_distribution_id = po_req_distributions_all.distribution_id)

Find PO / Requisition number:

SELECT DISTINCT

reqh.segment1 Req_Number, ph.segment1 PO_Number, ph.po_header_id

FROM po_headers_all ph,

po_distributions_all pos,

po_req_distributions_all rdis,

po_requisition_lines_all rel,

po_requisition_headers_all reqh

WHERE 1 = 1

AND ph.po_header_id = pos.po_header_id

AND pos.req_distribution_id = rdis.distribution_id

AND rdis.requisition_line_id = rel.requisition_line_id

AND rel.requisition_header_id = reqh.requisition_header_id

AND rel.requisition_header_id = '905489'

Receiving against Purchase Order: -

Navigation: - Purchase Super User -> Receiving -> Receipt

Query the PO number

Select number lines to create the receipt, enter the quantity, sub-Inventory. Next, click the ‘lot serial’ button and keen lot details, expiration date etc...,

Once click done, a receipt number will be created

SELECT * FROM rcv_shipment_headers WHERE receipt_num = '45074';

SELECT * FROM rcv_shipment_lines WHERE shipment_header_id = '869858';

SELECT * FROM rcv_transactions WHERE shipment_header_id = '869858';

Account Payable Module: -

Navigation: - Payable Super User -> Invoices -> Entry -> Invoices

Enter the po number and keen invoice amount, invoice date, invoice number, etc.,

Invoice should match /validate based on receipt, po number ..

And click the match button, next query PO number selects the line and enter what is your purchased quantity value

Next Click the actions button and select validate check box and press ‘Ok’ to validate the invoice

Once validate done, Status changed into ‘Needs Revalidation’

Re – enter, Invoice amount as per the total amount value and then re-do validation again, if it validation success, status should be changed into “validate”.

Creation of Accounting & Payment:

Next action to be perform the create the accounting

Once accounting has been successfully created. The Accounted status should be update as ‘YES’

Invoices:

SELECT * FROM ap_invoices_all WHERE invoice_num = ‘TSTINV1234’;

SELECT * FROM ap_invoice_distributions_All WHERE invoice_id = 561266;

Invoice Holds:

SELECT * FROM ap_holds_all WHERE invoice_id = 561266;

SELECT * FROM ap_holds_release_name_v WHERE RELEASE_LOOKUP_CODE = 'VARIANCE CORRECTED';

If payment button disable means, verify whether Invoice got holds or Approved status as “Required”

If it Approved Status required means, make “force Manual Approval”

Go to Action button -> select Force Approval -> okay.

Now you can verify the approval status and any holds

Payments:

Now go Action click “Pay in Full”

Enter required field

Next, transfer payment details into GL by using concurrent program - ‘Transfer Journal Entries to GL’ or “Payables Transfer to General Ledger”

Note: ‘Transfer Journal Entries to GL’ is the common program for all the modules

Enter the ledger, end date parameters