ORA-14552 Error While Deleting Hierarchy Running Hierarchy Flattening Batch
(Doc ID 2723770.1)
Last updated on OCTOBER 29, 2020
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and laterOracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
OBIEE Repository Database (RPD)
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics (ALMBI / FTPBI)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI)
Reporting
Symptoms
On OFSAA 8.0.7.2.0 after manually creating Common COA hierarchy, the hierarchy flattening batch is failing. The following errors are thrown in the FSI_MESSAGE_LOG
ERROR
Mode and Hier Id :2--264471
Deleting Hier Id :264471
vSQL: select rev_hier.hierarchy_id from rev_hierarchies rev_hier, rev_hier_definitions rev_hier_def where rev_hier.hierarchy_id =rev_hier_def.hierarchy_id and rev_hier_def.flattened_rows_completion_code='PENDING' and rev_hier.dimension_Id = 3 and rev_hier.hierarchy_id = 264471
Error while deleting Hierarchy
Batch Hierarchy Load Overload
Oracle Error ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
The issue can be reproduced at will with the following steps:
1. Create hierarchy for Common COA from the UI
2. Run the hierarchy select rev_batchHierFlatten ('rev_batchHierFlatten_cmn_coa','20200930', '3', '264471') from dual;
3. Find the errors and failed run
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 |