Requisition and Receipt Document Status Display Incorrect Payment Document ID (Doc ID 2061363.1)

Last updated on NOVEMBER 30, 2015

Applies to:

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

Symptoms

Requisition and Receipt Document status will either not show the Document Type of Payments or incorrect Payment Reference is displayed.

When the Payment Reference (PS_PAYMENT_TBL.PYMNT_ID_REF) also exists as a Payment Id (PS_PAYMENT_TBL.PYMNT_ID) then Requisition and Receipt Document
status will display the Document Type Payment but incorrect Payment Reference is displayed.

This is specific to MSQL Server environment. Same scenario in Oracle/DB2 Environments have expected results.

Replication:

1.  Add Requisition US001/RQ-1 for Vendor SHARE/USA0000001 , Item SHARE/16001 and Qty = 10
2.  Add Requisition US001/RQ-2 for Vendor SHARE/USA0000002 , Item SHARE/16002 and Qty = 10
3.  Add PO US001/RQPO-1 , copied from Requisition US001/RQ-1, Qty = 10,Receiving required, Matching required.
4.  Add PO US001/RQPO-2 , copied from Requisition US001/RQ-2, Qty = 10,Receiving required, Matching required.
5.  Dispatch above POs
6.  Add PO Receipt US001/RQRPO-11, copied from PO US001/RQPO-1, Qty = 5
7.  Add PO Receipt US001/RQRPO-21, copied from PO US001/RQPO-2, Qty = 5
8.  Add Voucher US001/00000180 with Invoice Id = RQVPO-11, copied from Receipt US001/RQRPO-11.
9.  Run matching and match Voucher.
10.  Using Express Payment , pay the voucher. Check # 0000009019 (Payment Reference or PYMNT_ID_REF)
11.  Review the Requisition Document Status for US001/RQ-1 - Document Type Payment Doc Id 0000009019 is NOT displayed.
     Following Document Type displayed:
     Purchase Order
     Receipt
     Voucher

12.  Click on Document Status Inquiry for Purchase Order - Document Type Payment Doc Id 0000009019 is displayed
13.  Click on Document Status Inquiry for Receipt - Document Type Payment Doc Id 0000009019 is NOT displayed
14.  Click on Document Status Inquiry for Voucher - Document Type Payment Doc Id 0000009019 is displayed

Following is to demonstrate when the Payment Reference (PS_PAYMENT_TBL.PYMNT_ID_REF) also exists as a Payment Id (PS_PAYMENT_TBL.PYMNT_ID) then Requisition  and Receipt Document
status will display the Document Type Payment but incorrect Payment Reference is displayed.


15.  Query PS_PYMNT_VCHR_XREF to find out  PYMNT_ID for BUSINESS_UNIT ='US001' and VOUCHER_ID ='00000180'


SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, A.PYMNT_CNT, A.PYMNT_ID, A.PAID_AMT,
A.PYMNT_SELCT_STATUS, A.REMIT_SETID, A.REMIT_VENDOR, A.BANK_SETID, A.BANK_CD,
A.BANK_ACCT_KEY
 FROM PS_PYMNT_VCHR_XREF A
 WHERE ( A.BUSINESS_UNIT = 'US001'
    AND A.VOUCHER_ID = '00000180')


PYMNT_ID = 0000010057

16.  Add Voucher US001/00000181 with Invoice Id = RQVPO-21, copied from Receipt US001/RQRPO-21
17.  Run matching and match Voucher.
18.  Record manual payment on Voucher US001/00000181 and specify Payment Reference = 0000010057

(Note this is the same number which is the PYMNT_ID on the earlier Voucher US001/00000180. For this test , manual payment is used to create Payment Id Reference (PYMNT_ID_REF) same as a an existing PYMNT_ID )

19.  Review the Requisition Document Status for US001/RQ-1 - Document Type Payment is displayed with Payment Doc Id = 0000010057.
       Following Document Type displayed:
       Purchase Order
       Receipt
       Voucher
       Payment

Note the Payment Reference displayed is 0000010057 which is incorrect

20.  Click on Document Status Inquiry for Purchase Order - Document Type Payment Doc Id 0000009019 is displayed which is correct
21.  Click on Document Status Inquiry for Receipt - Document Type Payment Doc Id 0000010057 is  displayed which is incorrect.
22.  Click on Document Status Inquiry for Voucher - Document Type Payment Doc Id 0000009019 is displayed which is correct

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