Dimension Table Data Missing / Not Restored After DRM Hierarchy Loader Fails
(Doc ID 2902431.1)
Last updated on NOVEMBER 09, 2022
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 126.96.36.199.0 and later
Oracle Financial Services Asset Liability Management - Version 188.8.131.52.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 184.108.40.206.0 and later
Oracle Financial Services Profitability Management - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
You are running the fn_drmDataLoader Hierarchy Loader with parameter Sync Flag = Y. When you get an error during the load, the data in the DIM_<dimension>_B and DIM_<dimension>_TL tables is not reverted back to its original state. Instead, values are missing from the _B and _TL tables including the default member "-1" value.
For example, you get the error below in FSI_MESSAGE_LOG:
Error. Member in Hier Table stg_gl_hier_intf not present in base table DIM_GENERAL_LEDGER_B
After getting this error, the -1 default member is missing. You expect the DRM Loader to restore the rows in the _B and _TL tables when a validation error occurs.
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