Configuring Domain Values and CSV Worksheet Files

1.   If you modify or extend a seeded list of values, you must configure the CSV files for Oracle Financial Analytics by mapping values from your source systems to the domain values.

2.   To extract the lists of values from your source system, which you then compare with the seeded values.

3.   If the lists of values are different from the seeded values, you need to follow the instructions to configure the domain values and CSV worksheet files.

4.   Typically, the number of rows returned by the source system will not match the number of rows provided in the domain valuesXXX.csv files.

5.   If so, you need to delete extra rows or insert additional rows in the CSV file to accommodate all the values returned by the source system in context.

6.   You also need to determine which row should have 'Return' and which row should have 'Delivery' in the W_XACT_TYPE_CODE column.

Table  lists the CSV worksheet files and the domain values for Financial Analytics and Oracle EBS in the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_shared\LkpFiles).

Table  Domain Values and CSV Worksheet Files for Oracle Financial Analytics and Oracle EBS

Worksheet File Name	Description	Session
domainValues_Xact_Types_DocTypes_ora12.csv	List the Transaction types and the corresponding domain values for the Oracle EBS R12 application.	SDE_ORA_TransactionType Dimension_GLCOGSDerive