Custom Fact Measures
The following files have been extended with 20 generic numerical fields on the end of the files:
-
SALES.csv
-
MARKDOWN.csv
-
INVENTORY.csv
-
ORDER_DETAIL.csv
-
DEAL_INCOME.csv
-
RECEIPT.csv
These flex fields will be loaded exactly as-is with no conversions or transformations, except to aggregate them from the
input data to the base intersection of item/location/fiscal week. All flex fields use SUM as the aggregation method. If a
flex field in the output PDS table has a prefix, like PO_FLEX1_NUM_VALUE
, it means it is additionally splitting
the data by that type, such as PO vs. Transfer receipt measures. If there is no prefix, then the flex measure is summed only
to item/location/week level. These fields provide a way to send additional custom measures to Planning applications when the
source of the measures is the same as your basic foundation data. Refer to the RAP Data Interfaces Guide in My Oracle
Support (Doc ID 2539848.1) for the complete file specifications.