My Oracle Support Banner

PO_POREOPEN Process Does not Reopen Closed Purchase Orders (Doc ID 2856083.1)

Last updated on AUGUST 15, 2023

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.


PO_POREOPEN Process does not Reopen Closed Purchase Orders.  If PO_STATUS is "C" in PS_PO_RC_HDR the user cannot reopen the purchase order by running the PO_POREOPEN process

NOTE: The following User Details / Company Names / Addresses / Emails / Telephone Numbers / Etc. are fictitious (based upon made-up data used in the Oracle DEMO Environments), any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 The issue can be reproduced at will with the following steps:
      1. Navigate : Setup Financials/Supply Chain > Business Unit Related > Purchasing > Purchasing Definition > US001 > PO Change Options
            Check PO Workflow Approval Required
      2. Navigate : Purchasing > Purchase Orders > Add/Update POs
            Create two purchase orders and dispatch it
            Note : PO is Auto Approved
            PO ID : 0000000477
            PO ID : 0000000478
      3. Navigate: Purchasing > Purchase Orders > Buyer Workbench
            Enter PO ID 0000000477
            Select the purchase order and click Close
            Select the PO and move to Qualified Grid
            Click Yes
            Click Yes for the message “Continue to Close POs. (10224,10)”
      4. Run the query
            select * from PS_PO_RC_HDR WHERE BUSINESS_UNIT = 'US001' and po_id='0000000477';
            PO_STATUS is D
            The PO status is complete
      5. Go back to PeopleSoft page
            Click Set Filter Options
            Checked Dispatched and Include Closed options
            Enter Purchase Order : 0000000477
            To : 0000000478
            Click Select All
            Click Close
            Click Select All
            Move purchase orders to Qualified Grid
            Click Ok
            Note : PO # 477 is at the Not Qualified grid because it is already closed
            Click Yes for the message “Continue to Close POs. (10224,10)”
            Both purchase orders are completed
      6. Run the Query
            select * from PS_PO_RC_HDR WHERE BUSINESS_UNIT = 'US001' and (po_id='0000000477' or po_id='0000000478');
            Issue : PO_STATUS is C for PO # 477
            PO_STATUS is D for PO # 478
      7. Navigate : Purchasing > Purchase Orders > Reconcile POs > Reopen POs
            Select Purchase Order : US001- 0000000477
            Run PO_POREOPEN process
      8. Navigate : Purchasing > Purchase Orders > Add/Update POs
            Enter PO ID US001- 0000000477
      Issue : Unable to Reopen the purchase order 





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

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