My Oracle Support Banner

Dimension Loader Fn_drmDataLoader Allows Loading of Special Characters to Member Name and Description (Doc ID 2858529.1)

Last updated on APRIL 08, 2022

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.7 and later
Oracle 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


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