My Oracle Support Banner

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 later
Oracle 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


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