My Oracle Support Banner

EAP 9.2: Fully Received PO Receipt Not Eligible To Copy Into Voucher If Contains Cancelled PO Receipt Line With Serial Control Status As Incomplete (Doc ID 2740158.1)

Last updated on DECEMBER 27, 2020

Applies to:

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

Symptoms

A problem has been detected when trying to create a new Voucher transaction in the system, by defaulting existing PO Receipt using the Copy From PO Receipt feature at the Invoice Information tab. The Receipt Number From look-up feature is not displaying a PO Receipt value if the below conditions are met:

     - The PO Receipt has to be in Fully Received status

     - The PO Receipt contains multiple PO Receipt Lines

     - At least one PO Receipt Line uses an Item that has been marked as Serial Control, and has been marked as cancelled

     - The cancelled PO Receipt Line has no Serial IDs populated, and as such the Serial Status is 'Incomplete'

Under the above circumstances, the PO Receipt, even though it contains other valid and fully received PO Receipt Lines, is being filtered out by the delivered PS_VCHR_RECV_VW17 View due to the criteria here below:

     AND NOT EXISTS (

     SELECT 'X'

     FROM PS_RECV_LN_SHIP_FS F

     WHERE F.BUSINESS_UNIT = A.BUSINESS_UNIT

     AND F.RECEIVER_ID = A.RECEIVER_ID

     AND F.SERIAL_CONTROL = 'Y'

     AND F.SERIAL_STATUS = 'I' )

In such cases, the cancelled PO Receipt Line using a Serial Control Item may not have the Serial ID values, and as such, will never impact Asset Management module, for which its Serial Status will be left as 'Incomplete'.

The Copy Worksheet main search functionality though will display this PO Receipt correctly, and only list those fully received PO Receipt Lines, leaving out the cancelled PO Receipt Line.

It is important that a similar scenario was already addressed when all lines of the PO Receipt were cancelled:

       <Document 2306311.1> - EAP: Canceled Purchase Order Receipt With Serial Control Items Prevents Purchase Order From Defaulting Into Voucher Transaction Even If Quantity/Amount Remain Available 

REPLICATION STEPS:

     1.- Create a new Purchase Order with 3 Lines, two of them using a Serialized Item, enter the pertinent Asset information, and Dispatch it

     2.- Create a first PO Receipt for this Purchase Order for all 3 lines

     3.- Complete the Serial ID information from one of the PO Receipt Lines using a Serial Control Item

     4.- Proceed to cancel the second PO Receipt Line using a Serial Item, leaving blank the Serial ID values

     5.- Fully interface the new PO Receipt

     6.- The PO Receipt is now fully received for 2 of the lines, and one cancelled Line using Serial Control Item

     7.- Create a a second PO Receipt for the same Purchase Order, and this time default the one remaining Line (the one cancelled in the first PO Receipt)

     8.- Complete the Serial ID information from the PO Receipt Line

     9.- Fully interface this second PO Receipt

     10.- Create a new Regular Voucher, and use the Copy From functionality by choosing the option of PO Receipt, and click on Go link

     11.- At the Copy Worksheet page, define the PO Business Unit, PO Number, and Receipt Unit search criteria

     12.- Click on the look-up view for the Field Receipt Number From

     13.- ISSUE: The View only lists as eligible for default into a Voucher the second PO Receipt, ignoring the first one

     14.- Click on Cancel button from the Look-Up view

     15.- Click on Search button at the Copy Worksheet page, still having the values of PO Business Unit, PO Number, and Receipt Unit

     16.- In the Select Receiver Lines section, the system is now displaying both PO Receipts, with all their valid and received lines

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

The Accounts Payable Users are unable to properly select the PO Receipt values for those affected transactions having cancelled PO Receipt Lines using Serial Control Items in Incomplete Status. It is confusing to the Users because the Receipt Number From look-up search will hide that transaction, but the Copy Worksheet search will display it. This is inconsistent.

If a PO Receipt Line is using a Serial Control Item, and has a Serial Status of 'Incomplete', it should not prevent the whole PO Receipt transaction from being displayed within the search results of the Receipt Number From Look-Up feature if that line has been Cancelled. The delivered PS_VCHR_RECV_VW17 View should include some additional validation criteria such as the below one:

AND F.RECV_SHIP_STATUS <> 'X'

Should the PO Receipt Line be cancelled, its existing row in Record PS_RECV_LN_SHIP_FS with a SERIAL_STATUS = 'I' should be ignored.

 

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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