BILDGL01 failed SQL Error number ORA-01400: cannot insert NULL occurred. Process request failed
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.