EAP: Excel Voucher Upload defaulting PYMNT_CNT = 0 on VCHR_PYMNT_STG (Doc ID 1635446.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

The Excel Voucher Upload spreadsheet is used in order to create Vouchers with payment information. The Template is setup with the Default Value for PYMNT_CNT = 0 on VCHR_PYMNT_STG. Once Generate XML and Post is run, the Voucher STG tables are loaded. When Voucher Build is run, the Voucher is created in a Postable status even though the PYMNT_CNT = 0 on PYMNT_VCHR_XREF, which is incorrect. PYMNT_VCHR_XREF.PYMNT_CNT should always be 1 or greater. It should never be 0.

STEPS
1. On the ExcelUploadforVoucher > Template tab, Default Value for PYMNT_CNT = 0 on VCHR_PYMNT_STG
2. Create a Voucher with Payment information using the Excel Voucher Upload spreadsheet
3. Click Generate XML and Post
4. Through SQL, confirm that the VCHR_xxx_STG tables are populated accordingly for the Voucher
5. Notice that PYMNT_CNT = 0 on VCHR_PYMT_STG
6. Run Voucher Build
7. Voucher Build runs successfully to completion
8. Voucher > Summary page, Entry Status = Postable
9. Voucher > Payments page, Payment: is set to 0, which is incorrect. It should be set to 1. In addition, the Go to Review Errors icon, which is the yellow triangle with the exclamation point, is appearing
10. Voucher > Error Summary page, Message states “This Voucher does not have any errors.”
11. Through SQL, PYMNT_VCHR_XREF shows that PYMNT_CNT = 0 for the Voucher created

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