My Oracle Support Banner

Requisition Open Quantity Not Updated on Purchase Order Line Cancellation (Doc ID 2371369.1)

Last updated on JANUARY 04, 2021

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Requisition Open Quantity Not Updated on Purchase Order Line Cancellation

Item Setup

1) Supplier Default UOM is CS

2) Accept Any UOM is unchecked at Item Supplier Page

Steps to Reproduce the Issue:

1.Create requisition US005/14 for the item (10006) and quantity as 4 EA.

2.Go to Add/Update purchase order. Select below supplier id and copy PO from Requisition (req). Once req is copied below msg will pop up. Click OK

Row 1 Changed to Item Supplier UOM (10105,93)


3.Save the Purchase Order (US005/17). The PO qty will be 1CS as converted by the system based on item vendor UOM. Now the PO qty is greater than req qty as per EA UOM.

4.Dispatch the PO and now again open the PO and cancel line no.1 from status tab. Below msg will pop up. Click Yes.

This action will cancel line 1 for this purchase order. Continue?(10200,229)
The action that you are taking will cancel this line for this Purchase Order.
If you do not want to cancel this line then you cannot perform the action at this time.

5.Again below message will pop up. Click Yes

There are associated requisitions, open all requisitions for re-sourcing?(10200,390)
If the response is No you will be asked if you want to open requisition quantity for every line cancelled.
If the response is 'Yes' you will not be asked again if you want to open requisition quantity for every line cancelled.

6. Click Yes to following message Open requisition quantity for req 0000000014 line 1 sched 1 dist 1?(10200,372)

Opening the requisition quantity will allow the requisition distribution to be referenced on a future contract release.

The purchase order sources from contract. When you cancel, you can opt to open the contract quantity that original requisition can be referenced again.

7.Run both the queries as shown below to check the open qty and amount as zero and the source status is available for such reqs.

This is happening even for requisitions having quantity less than PO qty in terms of standard UOM.

Select qty_open, amt_open from ps_req_ln_distrib where business Unit = 'US005' and req_id = '0000000014';

Result: QTY_OPEN = 0 , AMT_OPEN = 0

Select system_source, source_Status from ps_req_line where business Unit ='US005' and req_id = '0000000014';




Requisition lines that were cancelled in order to re-source them to another Supplier. Users not able to re-source these lines, even though they show "available".

Issue is replicable when the po qty is more than requisition qty in terms of standard UOM. The open amount and open qty is not updated when the PO line is cancelled.



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.