How to create invoice in AP if Pay On Receipt AutoInvoice setup is missed on supplier

 https://purchasingpo.blogspot.com/2022/05/how-to-create-invoice-in-ap-if-pay-on.html

INVOICE_STATUS_CODE in the RCV_TRANSACTIONS table is kept null if Autopay setup is not present on the supplier. To Rectify the same, first do Autopay setup on supplier and then amend the INVOICE_STATUS_CODE field from null to ‘PENDING’ as below,

select l.invoice_status_code from rcv_transactions l where l.shipment_header_id = ?

INVOICE_STATUS_CODE

PENDING

Now, amend the PAY_ON_CODE field from null to 'RECEIPT' in po_headers_all table

select q.pay_on_code from po_headers_all q where q.segment1= '?'

PAY_ON_CODE

RECEIPT

Run “Pay On Receipt AutoInvoice” Program afterwards

 

 

The easiest way to find Approvers assigned in Position Hierarchy - Oracle EBS R12

https://purchasingpo.blogspot.com/2019/05/the-easiest-way-to-find-approvers.html

The easiest way to find Approvers assigned in Position Hierarchy

Navigate to HRMS> Work Structures> Position> Diagrammer

Press F11 and search for Position Hierarchy Name

Press Ctrl+F11

Press Open Editor

Expand

It is Showing Hierarchy from Top to Down

You can use the following styles as easy for you

How to know the position hierarchy used in a PO document - Oracle EBS R12

https://purchasingpo.blogspot.com/2019/05/how-to-know-position-hierarchy-used-in.html

Requisitions

select prh.segment1, pps.name
from po_requisition_headers_all prh, po_action_history pah, per_position_structures pps
where pah.approval_path_id = pps.position_structure_id
and prh.requisition_header_id = pah.object_id
and object_type_code = 'REQUISITION'
and action_code = 'SUBMIT'
and prh.segment1 = '&REQNUMBER'

Purchase Orders

select ph.segment1, pps.name
from po_headers_all ph, po_action_history pah, per_position_structures pps
where pah.approval_path_id = pps.position_structure_id
and ph.po_header_id = pah.object_id
and object_type_code = 'PO'
and action_code = 'SUBMIT'
and ph.segment1 = '&PONUMBER'

APP-FND-02904: ORG ID is required.

https://purchasingpo.blogspot.com/2019/01/app-fnd-02904-org-id-is-required.html

APP-FND-02904: ORG ID is required.

Guide to Solve APP-FND-XXXXX Issues in Procurement (Doc ID 1522850.1)

http://purchasingpo.blogspot.com/2016/01/blog-post.html