My Oracle Support Banner

EEX 9.2: AP_FG_PROC Failed With Error - Cannot Insert NULL Into ("SYSADM"."PS_PMT_DETAIL_STG"."PYMNT_DT") for Cash Advances (Doc ID 2119227.1)

Last updated on APRIL 21, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Expenses - 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")


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

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