Error from BEN100a.SQR Run- SQL Status = 1400, SQL Error = ORA-1400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_PER"."MEDICARE_ELIG_RSN")
(Doc ID 2062794.1)
Last updated on JULY 07, 2020
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When the benefits snapshot BEN100a.sqr runs, it generates an error for NULL values.
SQL Status = 1400, SQL Error = ORA-1400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_PER"."MEDICARE_ELIG_RSN")
The issue can be replicated in certain circumstances:
1. Create a fresh run control ID and date for the Ben100a run
2. Run the process.
3. Check the log for this message:
The following error was generated: SQL Status = 1400, SQL Error = ORA-1400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_PER"."MEDICARE_ELIG_RSN")
Cause
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
Symptoms |
Cause |
Solution |