My Oracle Support Banner

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.

Symptoms


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?

Changes

 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.

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
Changes
Cause
Solution
References


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