Change Request To PO Rejected But PO Is Approved (Doc ID 2250042.1)

Last updated on MARCH 30, 2017

Applies to:

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

Symptoms

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
approval.

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:
select poh.segment1,
poh.authorization_status,
poll.*
from po_headers_all poh,
po_line_locations_all poll
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;



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms