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.