Last updated on MARCH 30, 2017
Applies to:Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.
Users are finding that approved PO's are not returned in the search for Items
to Receive. After investigations found that a change request has been raised
and approved on the requisition. The PO change request has been rejected by
the system due to the Accounting date not being in an open period. However
the PO is showing as Approved not Rejected and not Reserved.
It is expected that the PO would have the approval status 'Rejected' where
the user could then amend the GL date to a current period and re-submit for
The problem is that the Approve button is greyed out so nothing can be done to the document.
Can use the following script to determine the issue exists:
from po_headers_all poh,
where poh.po_header_id = poll.po_header_id
and poll.approved_flag = 'R'
and poll.encumbered_flag = 'N'
and poh.authorization_status = 'APPROVED'
order by 1;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms