EPY: "Error: ORA-01400: cannot insert NULL" in Custom SQR and/or COBOL After Applying Maintenance
(Doc ID 2736984.1)
Last updated on JULY 19, 2021
Applies to:PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When running a custom Special Pay process, the process ended in "Error: ORA-01400: cannot insert NULL" because a new Field was delivered.
What is the best way to find out information about a new field ? Is there anywhere to go that will show how this is used?
A new field is delivered with maintenance. If this record is used in a custom SQR, the new field will be entered as NULL unless the custom SQR is monified.
Example: When applying PUM Image 36, a new field PY_JUR_CODE was delivered.
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