7 Support for Global 1 Amount Exchange Date Calculation

This chapter describes how to configure the Global 1 Amount Exchange Date calculation in Oracle Financial Analytics for JD Edwards EnterpriseOne. It contains the following topics:

• Section 7.1, "Configuring the Exchange Date for JD Edwards EnterpriseOne Accounts Payable"

• Section 7.2, "Exchange Date for JD Edwards EnterpriseOne Account Receivables"

7.1 Configuring the Exchange Date for JD Edwards EnterpriseOne Accounts Payable

JD Edwards EnterpriseOne customers using Oracle Financial Analytics can now choose either the invoice date or the general ledger date to populate the field EXCHANGE_DT in Accounts Payable (AP).

This release includes a new Oracle Business Intelligence Data Warehouse Administration Console (DAC) parameter, $$EXCHANGE_DATE, that you can use to specify the invoice date or the general ledger date. Based on your selection, the EXCHANGE_DT field in the W_AP_XACT_FS table is populated with the appropriate date in the Oracle Business Analytics Warehouse.

To configure the $$EXCHANGE_DT parameter:

1. Make sure to configure the invoice date or general ledger date the same as it is in JD Edwards EnterpriseOne so that your results are the same as the JD Edwards EnterpriseOne source system values.

2. In the DAC client, select the Design view, and then select your custom container from the drop-down list.

3. Click the Tasks tab, and perform a query for the AP transaction fact-related tasks.

4. In the Detail area of the selected tasks, click the Parameters tab.

5. Modify the parameter value as follows:

   • Specify INV to use the invoice date.

   • Specify GL to use the general ledger date.

6. Save your changes.

7.2 Exchange Date for JD Edwards EnterpriseOne Account Receivables

The EXCHANGE_DT field in W_AR_XACT_FS will be populated from the F03B11-RPERDJ table. The JD Edwards EnterpriseOne application stores the exchange date in the F03B11 table, which contains the value selected by the user through the processing option.