Issue with Thousand Separator in Multi-Column All Data Type Rule in Data Management — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with Thousand Separator in Multi-Column All Data Type Rule in Data Management

Summary:


Content (please ensure you mask any confidential information):

Hi all,

I’m working with Oracle EPBCS Data Management and running into an issue with thousand separators in numeric amounts.

I have a Data Management rule defined as a multi-column, all data type rule. When the source file contains amounts with thousand separators (e.g., 1,234.56), Data Management accepts the file and shows the job as completed successfully, including the export step. However, the data does not actually get loaded into the Planning application.

It seems that Data Management is treating the amounts with thousand separators as text, so they don’t make it through to Planning.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!