About Configuring Financial Analytics CSV Files for JD Edwards EnterpriseOne

The table lists the CSV worksheet files and the domain values for Financial Analytics for JD Edwards EnterpriseOne.

Worksheet File Name	Description
file_group_acct_codes_jde.csv (See Configuring the file_group_acct_codes_jde.csv)	Lists the Group Account Codes and the corresponding domain values for the JD Edwards EnterpriseOne application.
file_lkp_fiscal_period_Qtr_Config_jde.csv (See Configuring the file_lkp_fiscal_period_Qtr_Config_jde.csv)	Lists the Time Dimension Fiscal Period and the corresponding domain values for the JD Edwards application.

Configuring the file_group_acct_codes_jde.csv

The file_group_acct_codes_jde.csv is a flat file that is used to identify the Group Account Codes for each object account range for each company. For example, for company 00001 you might specify group account codes for accounts 1000 to 2000 as REVENUE.

For a detailed list of the domain values for all possible Group Account Codes, see Oracle Business Analytics Warehouse Data Model Reference.

1. Edit the file file_group_acct_codes_jde.csv.

   The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:

   • Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.

   • Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.

   Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.

2. In the Company field, populate the company that you are setting up and specify the ranges in the From and To column of that row with the corresponding Group Account Code.
3. Save and close the file.

Configuring the file_lkp_fiscal_period_Qtr_Config_jde.csv

You must configure the file_lkp_fiscal_period_Qtr_Config_jde.csv file to support the metrics that are based on the Fiscal Quarter.

1. Identify the Fiscal Quarter data in your JD Edwards EnterpriseOne source system by using the following SQL:

   Select CDDTPN,CDFY from F0008
   

2. Edit the file file_lkp_fiscal_period_Qtr_Config_jde.csv.

   The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:

   • Source-independent files: <Oracle Home for BI>\biapps\etl\data_files\src_files\.

   • Source-specific files: <Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>.

   Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.

3. For each Date pattern, set the following fields:

   Field	Value
   FiscalPattern	CDDTPN.
   YEAR	CDFY.
   Period	Period Number Numeric.
   Quarter No	As there is no concept of Quarter in JD Edwards EnterpriseOne, define a numeric quarter number to which the period belongs.
   Quarter Start Date	Customized Quarter Start Date for each period. Each quarter can span as many periods as users configure. The format is DD/MM/YYYY.
   Quarter End Date	Customized Quarter End Date for each period. Each quarter can span as many periods as users configure. The format is DD/MM/YYYY.

4. Ensure that there are no unnecessary spaces in the flat file.
5. Save and close the file.