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 27, 2016

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.

Symptoms

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.

Steps:
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.

Error:
AP_FG_PROC Process failed with below error:
 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_PMT_DETAIL_STG"."PYMNT_DT")

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