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 8.1.0.0.0 and laterOracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
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.
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 |