Populating Report Batch Failed With 'ORA-01089' Error
(Doc ID 3073588.1)
Last updated on FEBRUARY 28, 2025
Applies to:
Oracle Insurance Accounting Analyzer - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
The OFSAA Populate Reporting batch failed with below error.
LOG FILE
-----------------------
Filename = TRANSFORM DATA_#INFODOM#_POPULATE_RPT_TBLS_<ID>_YYYYMMDD_1_Task0_RUNPROCEDURE.log
See the following error:
[INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := DT_IIA_POPULATE_RPT_TBLS('#INFODOM#_POPULATE_RPT_TBLS_<ID>_YYYYMMDD_1','20250131',202823); END;
Error Msg :-> ORA-01089: immediate shutdown or close in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 215
ORA-06512: at "OFSAAATM.PR_FCT_REP_DRILLDOWN_LOAD", line 1742
ORA-06512: at "OFSAAATM.DT_IIA_POPULATE_RPT_TBLS", line 27
ORA-06512: at line 1
Process ID: 3299702
Session ID: 24 Serial number: 50020
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 |
| References |