Dimension Loader Fn_drmDataLoader Allows Loading of Special Characters to Member Name and Description
(Doc ID 2858529.1)
Last updated on JULY 10, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.7 and laterOracle Financial Services Asset Liability Management - Version 8.0.7 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
When loading dimension data using the DRM Dimension Data Loader (fn_drmDataLoader), the utility allows loading special characters to the member name and description fields. You cannot enter the same special characters via the User Interface.
For example, you cannot enter the special characters &, ', or " (ampersand, single quote, double quote) when creating the dimension member name via the interface but the characters can be loaded to the name field without error.
Similarly, you cannot enter the special characters ~&+' "@ in the description field but they can be loaded without error.
You expect the Dimension Loader to error or flag the bad record when loading a value with a restricted character.
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 |