EEX 9.2: AP_FG_PROC Failed With Error - Cannot Insert NULL Into ("SYSADM"."PS_PMT_DETAIL_STG"."PYMNT_DT") for Cash Advances
Last updated on SEPTEMBER 27, 2017
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, Payment Processing
When attempting to pay any cash Advance using Electronic Payments via Financial Gateway, AP_FG_PROC fails with error.
The issue can be reproduced at will with the following steps:
1. Create a Cash Advance and submit it for approval.
2. Get the Cash Advance approved.
3. Run Stage Payment and Post Liabilities process.
3. Pay the Cash Advance through PayCycle.
4. Run the AP_FG_PROC process.
AP_FG_PROC Process failed with below error:
Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_PMT_DETAIL_STG"."PYMNT_DT")
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