My Oracle Support Banner

No Records Write to rev_hier_flattened After Running Batch_hierTransformation Batch (Doc ID 2197794.1)

Last updated on OCTOBER 16, 2023

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - 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 Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Oracle Financial Services Asset Liability Management Analytics (ALMBI)

Symptoms

When attempting to run the Hierarchy Transformation batch, no rows are output to REV_HIER_FLATTENED.

ACTUAL BEHAVIOR
After creating a new hierarchy which generates new sys id, REV_HIER_FLATTENED does not have any data with the ID after running batch_hierTransformation.  Similarly, if you edit a hierarchy and add new members, the new members are not added to REV_HIER_FLATTENED after running batch_hierTransformation.

EXPECTED BEHAVIOR
batch_hierTransformation will generate data to table rev_hier_flattened.

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.