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

Last updated on AUGUST 15, 2023

Applies to:

Symptoms

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

 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 

Changes

Cause

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