My Oracle Support Banner

Purchase Orders Are Not Closing Automatically (Doc ID 2605634.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

In Oracle Purchasing, Purchase orders are not closing automatically based on below criteria.

Auto close should happen with the following scenarios:

First, the Profile 'PO: Auto close 2-way matched shipments if fully
invoiced' is only useful when the shipment is 2-way matching.

Case 1 : profile 'Yes', 2-way matching
- RECEIPT_REQUIRED_FLAG = N, INSPECTION_REQUIRED_FLAG = N
==> should auto close when fully invoiced
-- RECEIPT_REQUIRED_FLAG = N, INSPECTION_REQUIRED_FLAG = Y
==> will not auto close when fully invoiced as inspection is required

Case 2 : profile 'No', 2-way matching
==> will not auto close when fully invoiced

Case 3 : 3-way matching
1. Create Receipt
2. Run 'Pay on Receipt Auto Invoice' which created Invoice.
3. Match to PO first then Validate Invoice
==> should auto close when fully invoiced and fully received

Case 4 : 4-way matching
==> should auto close when fully invoiced, fully received and fully accepted

When running datafix script poxpocrf.sql, the following error is captured in the FND debug log:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.