EAP: Pay Cycle Process AP_APY2015 Incorrectly Updates PAID_AMT_GROSS and PAID_AMT
Last updated on MARCH 07, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When creating two vouchers with the same vendor with amount of 99,999,999.99 each, the pay cycle ends in No Work since the sum of two vouchers with the same vendor exceeds 10 digits, and these two vouchers exist in PS_PYCYCL_ERR_TMP table.
However, upon checking the PS_PYMNT_VCHR_XREF table, the fields PAID_AMT_GROSS and PAID_AMT are populated by the gross amount value.
They should be zero since the vouchers were not paid yet as it ends up in error.
This issue occurs when running Express Pay Cycle only. Issue is not replicated when using traditional pay cycle.
1. Create two vouchers with the same vendor and gross amount of 99,999,999.99
2. Run Express PayCycle
Checking at the PS_PYMNT_VCHR_XREF table, the PAID_AMT and PAID_AMT_GROSS are both set to 99,999,999.99.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms