EEX9.1: BRA Localization Cannot Process Payment for Cash Advance(s) Encounter Cannot Insert the Value NULL into Column EMPL_RCD
(Doc ID 2579973.1)
Last updated on AUGUST 22, 2019
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
For Brazil Localization only:
Issue: Cannot pay cash advances
1) Create two Cash Advances
2) Stage and Post Liability
3) Via Update Stage Payments mark one advance as Hold and leave the other available to process
4) Run payment selection
5) Run payment creation
SQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'EMPL_RCD', table 'FS91DMO.dbo.PS_EX_ADVNCE_CPY'; column does not allow nulls. INSERT fails. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement
Actual Result: Cannot generate payments for Cash Advance(s).
Expected Result: To generate payment to employee(s) for cash advance requests.
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