Loading Exported Journal Entries

In Transaction Matching, you can export adjustments or transactions as dual-sided journal entries that can then be imported into your ERP system or data export file. Using Data Integration, you can create a data source associated with an Accounts Reconciliation journal adjustments source system, and then load the entries to a data export application. When the entries are exported in the integration, all adjustments and transaction that have an open status and match any applied filter criteria are exported.

To load exported journals entries:

1. From the Data Integration home page, and then from the Actions menu, select Applications.
2. Create the source Account Reconciliation Journal Adjustments application.

   Complete the following:

   1. From the Data Integration home page, and then Actions, select Applications.
   2. On the Applications page, click (Add icon).
   3. On the Create Application page, and from then Category, select Data Source.
   4. From Type, select Account Reconciliation Journal Adjustments.
   5. From Application, select the Account Reconciliation Journal Adjustments application.

   6. In Prefix, optionally specify a prefix to make the application name unique.

      The prefix supports up to a maximum of ten characters.

   7. Click OK.

      

3. Create the target application.

   Note:

   If you want to write back to the Oracle ERP Cloud instead of a file, see: Writing Back Actuals to the Oracle General Ledger.
   1. From the Data Integration home page, and then Actions, select Applications.
   2. On the Applications page, click (Add icon).
   3. On the Create Application page, and then Category, select Data Export.
   4. From Type, select the Data Export to File.
   5. From Application, select the target application to which to export adjustments.

   6. In Prefix, optionally specify a prefix to make the application name unique.

      The prefix supports up to a maximum of ten characters.

   7. Click OK.

4. From the Application page, click to the right of the application, and then select Application Details.
5. Select the Dimensions tab.
6. In the Application Details section, in the Name field, specify the name of the custom application.
7. Select the Dimension Details tab.
8. Click Add.
9. In Dimension Name, enter the name of the Account dimension, and then specify Account in the Target Dimension Class. and Data Table Column Name fields.

   When you specify Account in the Target Dimension Class. the value Account prefills automatically in the Data Table Column Name field.

   This step enables you to create dimensions not defined in the target application. You must create an "Account" dimension name and associate it with an "Account" target dimension class, which is a property defined by the dimension type. You also associate it with an "Account" data table column name, which identifies the table column name of the column in the staging table. These definitions are required by Data Integration.

   You do not need to create an "Amount" dimension because it defaults on the Map Dimensions page.

   You can create other dimension names, such as UD1 through UD20 or "Entity" as needed.

10. Create the integration between the source Account Reconciliation Journal Adjustments source application and the data export to file or ERP application.

    Complete the following

    1. From the Data Integration home page, click , and then select Integration.

       The General page is displayed in Create Integration view.

    2. In Name and Description, enter a name and description for the Account Reconciliation Journal Adjustments Transactions Integration.

    3. In Location, enter a new location name, or pick an existing location to specify where to load data.

    4. Click (Select a Source).

    5. From the Select a Source page, click the Account Reconciliation Journal Adjustments source application.

    6. Click (Select a Target).

    7. From the Select a Target page, select the data export file application or Oracle ERP Cloud application.

    8. Click Save.

11. Select Map Dimensions.

    When you add an Account Reconciliation Journal Adjustment data source, the dimensions in application are populated automatically on the Dimension Detail tab.

12. From Import Format, select the name of the import format to use for the integration.
    You can also add a user defined import format name.
13. Select the Dimension Detail tab.
14. Map all dimension names in the Dimension Names column with the value Generic in the Target Dimension Class column and click Save.
15. From the Data Integration home page, click to the right of the integration, and then select Map Members
16. On the Map Members page, map members between the Accounts Reconciliation Journal Adjustment source columns and the custom target application columns.

    Do not add mappings for the "Data" dimension.

17. From the Data Integration home page, click to the right of the Account Reconciliation Journal Adjustment /Transaction Mapping integration, and then select Options.
18. Click the Filter tab.
19. Click .
20. On the Filters tab, complete any parameters based on the transaction matching type.

    Available parameters:

    • Type—Specify the type of reconciliation.

      Available types:

      • Transactions
      • Adjustments

    • Match Type—Specify the match type ID such as "Clearing."

      Match Types determine how the transaction matching process works for the accounts using that match type. They determine the structure of the data to be matched, as well as the rules used for matching. Additionally, match types are used to export adjustments back to an ERP system as journal entries in a text file.

    • Data Source—Specify the data source when the transaction matching transaction type is "Transactions."

      Leave this field blank when the transaction matching transaction type is "Adjustments."

      Names for the data sources that appear in Data Integration are actually sourced from the Transaction Matching data sources. The convention used in the drop-down is Match Type Name: Data Source Name.

      For example, application choices might include:

      • InterCo3:AR
      • InterCo3:AP1 3
      • Bank BAI:BAI_Bank_File
      • Bank BAI:GL
      • INTERCO2:AR
      • INTERCO2:AP
      • INTERCO:AR 8
      • INTERCO:AP 9
      • CLEARING:CLEARING

    • Filter—If you choose Type as the Transaction, specify the filter name for transactions.

      The filters is defined in data source configuration in Account Reconciliation as shown below:

    If you choose Type as Adjustment, specify the filter value in JSON format.

    You can select specific transaction types and/or the accounting date while exporting the journal for Adjustments.

    To specify the filter for Adjustments, use the Filter field to select the following:

    • (Adjustment) Type—Specify the adjustment type available for the match type selected in the previous step. You can specify one or more values. If you don't select a value, the default used is All.

    • Adjustment Date—Specify the operand and date values (using the Date Picker to select the dates). The operands available for filtering are: EQUALS, BEFORE, BETWEEN, and AFTER.

      The date format must be YYYY-MM-DD. If you use EQUALS, BEFORE, and AFTER operands, use the JSON format: accountingDate and then specify the accounting date. If you select a BETWEEN operand, use the JSON format:

      • fromAccountingDate for the "from" Accounting Date
      • toAccountingDate for the "to" Accounting Date

      Here are some sample JSON formats:

      {"adjustmentTypes" : ["Invoice Dispute","Coding Error"],"operator" : "BETWEEN", "fromAccountingDate" : "2022-02-01", "toAccountingDate" : "2022-02-10"}

      {"adjustmentTypes" : ["Invoice Dispute","Coding Error"],"operator" : "EQUALS", "accountingDate" : "2022-02-01"}
      

      {"operator" : "AFTER", "accountingDate" : "2022-02-01"}

      {"adjustmentTypes" : ["Invoice Dispute","Coding Error"]}

21. From the Data Integration home page, select the Account Reconciliation Journal Adjustment /Transaction Mapping integration, and then click to the right of the Account Reconciliation Journal Adjustment data source integration, and then select Workbench.
22. In the Workbench, test and validate the data by executing the integration to ensure that the data is loaded properly, and your data looks correct. Data Integration transforms the data and stages it to post to the Oracle ERP Cloud.
    For information on running the integration using runIntegration in Working with EPM Automate for Oracle Enterprise Performance Management Cloud EPMAUTOMATE.
    Additionally, to post journals to Oracle ERP Cloud, see Writing Back Actuals to the Oracle ERP Cloud - Oracle General Ledger in Administering Data Management for Oracle Enterprise Performance Management Cloud .