EAP: Canceled Purchase Order Receipt With Serial Control Items Prevents Purchase Order From Defaulting Into Voucher Transaction Even If Quantity/Amount Remain Available (Doc ID 2306311.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

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

Symptoms

ISSUE:

A problem has been detected when trying to create a new Voucher transaction in the system, by defaulting existing Purchase Orders using the Copy From PO feature at the Invoice Information tab, or at the Add A New Value main page before adding the Voucher. If those Purchase Orders are using Serial Control Items, and have multiple PO Receipts linked to it, but at least one is set to Canceled status, the SQL View PS_VCHR_PO_HRC_VW used to find valid Purchase Order ID values will filter it out because of the below reason:

NOT EXISTS (
SELECT 'X'
FROM PS_RECV_LN_SHIP_FS F
WHERE F.BUSINESS_UNIT_PO = A.BUSINESS_UNIT
AND F.PO_ID = A.PO_ID
AND F.SERIAL_CONTROL = 'Y'
AND F.SERIAL_STATUS = 'I' )

A PO Receipt that uses Items configured for Serial Control, but that have been canceled without being fully interfaced, will met the condition where PS_RECV_LN_SHIP_FS.SERIAL_STATUS = 'I'.

REPLICATION STEPS:

     1.- Create a new Purchase Order, using a Serialized Item, enter Asset information, and Dispatch it
     2.- Create a first PO Receipt for this Purchase Order for the full amount
     3.- Cancel the first PO Receipt
     4.- Create a second PO Receipt for the same Purchase Order, again, for the full amount, and define Serial Numbers
     5.- Fully interface the new PO Receipt,
     6.- Create a new Voucher, and try to default the Purchase Order into the new transaction from the main Voucher Add page
     7.- SQL View PS_VCHR_PO_HRC_VW is not selecting the affected Purchase Order as a valid value
     8.- Click on Add A New Voucher, and once at the Invoice Information tab, use the Copy From PO functionality, and click on the PO ID look-up
     9.- The Purchase Order in question, although dispatched, and fully received, it is not listed as a valid value

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ACTUAL RESULT:

Several Purchase Orders have been affected by this problem, and users cannot default them into new Voucher transactions.

EXPECTED BEHAVIOR:

No matter if prior PO Receipts have been cancelled, as long as there are new PO Receipts that confirmed all the quantities/amounts have been received, this should allow the Purchase Order to be a valid value to default into a new Voucher.

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