Financial Management - PSFT (MOSC)

MOSC Banner

BILDGL01 failed SQL Error number ORA-01400: cannot insert NULL occurred. Process request failed

edited Dec 8, 2013 10:10PM in Financial Management - PSFT (MOSC) 8 commentsAnswered
Dear All,

We are having an issue with the Billing GL entry process BILDGL01 erroring out with the SQL Error number ORA-01400: cannot insert NULL occurred.  Process request failed.

It says SQL Status =  1400, SQL Error  = ORA-01400: cannot insert NULL into "SYSADM"."PS_BI_LOADGL_PROC"."INVOICE_RANGE_OPT")

We checked the run control table and there we have proper data for the field INVOICE_RANGE_OPT for the corresponding oprid & run control id.

We are seeing more frequently after we went live for the bundle upgrade to bundle #25 in 9.1 release.

Can anyone let me know if there any such reported issue after bundle #25 in 9.1 release. I have attached the log file from the failed instance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center