1. Implementing Accounting Hub
  2. Import Subledger Accounting Mappings

Import Subledger Accounting Mappings

You can import high volume mappings that are greater than 2,000 lines using the subledger accounting import mappings spreadsheet template.

To do this, you must first use the Create Mapping Set page to create a mapping set rule definition with the corresponding input sources and output types.

Let's walk through the steps to access the template:

  1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

  2. In the Table of Contents, click File-Based Data Imports.

  3. Click Subledger Accounting Mappings Import.

  4. In the File Links section, click the link to the Excel template.

Here are few things to keep in mind when preparing your data in the worksheet:

  • Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

  • Don't change the order of the columns in the template.

  • You can hide or skip the columns you don't need to use, but don't delete them.

Settings That Affect the Subledger Accounting Mappings Import Process

The Subledger Accounting Mappings Import template contains an instructions tab, a tab that represents the table where the data is loaded, and some example tabs that contain sample mappings for different scenarios. This table shows the tabs in the Subledger Accounting Mappings Import template and their descriptions:

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains information about using the template and generating CSV files.

Mappings

Enter information about the subledger accounting mappings you're importing into the interface table.

Example1_CCID_Output

Contains an example of mappings for a mapping set rule with the account combination output type.

Example2_Segment_Output

Contains an example of mappings for a mapping set rule with the segment output type.

Example3_Value_Set_Output

Contains an example of mappings for a mapping set rule with the value set output type.

Example4_FlexAccountComb_Input

Contains an example of mappings for a mapping set rule with the account combination input source type.

Example5_FlexfieldSegment_Input

Contains an example of mappings for a mapping set rule with the segment input source type.

How Subledger Accounting Mappings Is Processed

Create the Spreadsheet

Enter the mapping information in the Mappings worksheet. Refer to the tool tips on column headers for detailed instructions. Here are some best practices that you must follow to minimize errors while uploading the mapping data:

  • Make sure that Mapping Set Short Name is in the upper case.

  • Confirm that the format for the Start Date and End Date columns is YYYY-MM-DD.

  • If the end date value is given for a mapping line, you must also provide a start date value.

  • Make sure that the Default Mapping column has only one of the following values:

    • Blank

    • N

    • Y

    Note: Don't use values such as No, n, Yes, or y because they're invalid.

  • Specify only one mapping line as the default mapping.

  • You must provide values for all mandatory fields. The mandatory fields can differ based on the output type of the mapping set. Here are the details of mandatory fields for different output types:

    Mapping Set Output Type

    Mandatory Fields for Output Type

    Mandatory Fields for Output Value

    Account Combination

    Chart of Accounts

    Account Combination

    Segment

    Chart of Accounts

    Segment

    Segment or Value Set

    Value Set

    Chart of Accounts

    Value Set

    Segment or Value Set

  • Make sure that no space or new line character is appended to the actual data as it may result in import failure because of value mismatch.

  • To delete an existing row from the Mappings sheet, select and right-click the row. Then, click Delete. Don't press the Delete key to delete a row because the application can consider such rows as blanks on validation.

You can also refer the example worksheets for more information. For example, how to use the account combination or segment value as the output for the mappings.

After you finish preparing the mapping data, click the Validate button to validate date format, line numbers, required fields, and default mapping. Correct the reported errors and save the spreadsheet template.

Generate the Zip File

After you finish preparing the spreadsheet template, you need to generate a Zip file that's used to import data into the application. Here is how you generate the Zip file:

  1. On the Instructions and CSV Generation tab of the template, click the Generate CSV File button to generate a Zip file containing one CSV file.

    You can also enter mapping information directly in a CSV file instead of the spreadsheet template. To do this, you must enter mapping information in the CSV file in the same format as in the Subledger Accounting Mappings Import template. Here is the order of columns in the Accounting Mappings Import template:

    • Line Number

    • Application Name

    • Mapping Set Short Name

    • Chart of Accounts Short Name

    • Transactions Chart of Accounts Short Name

    • Value Set Short Name

    • Segment Short Name

    • Account Combination

    • Segment or ValueSet

    • Source Value 1

    • Source Value 2

    • Source Value 3

    • Source Value 4

    • Source Value 5

    • Source Value 6

    • Source Value 7

    • Source Value 8

    • Source Value 9

    • Source Value 10

    • Effective Start Date

    • Effective End Date

    • Default Mapping

  2. Review the generated XlaImportMappingsTemplate.csv that's appended as a worksheet in the same spreadsheet. It must have the same number of mapping lines that exist in the Mappings worksheet.

Load File for Import

After you generate the Zip file and verify the CSV file, you must load the Zip file to the interface and application database tables. Let's look at the steps to load the Zip file.

  1. Navigate to Tools > Scheduled Processes.

  2. Click Schedule New Process.

  3. Select the Load Interface File for Import process and then click OK.

  4. In the Process Details dialog box, select Import Accounting Setup process.

  5. Upload the Zip file that you generated and click Submit.

    The mapping details are imported to the interface and application database tables.

Correct Import Errors

Here is how you can correct errors that occurred while loading the CSV file:

  • Review the log and output files of the Load File to Interface child process for information about the data that caused the failure.

  • The Load Interface File for Import process ends in error and the Load File to Interface child process ends in either warning or error.

  • All rows that were loaded from the CSV file are deleted, even those rows that loaded successfully. This lets you edit the erroneous data in the spreadsheet and resubmit without having to separate the successful rows from the rows that need modification.

These are the steps to correct errors caused when validations are performed by the application:

  • Review the log and output files of the Import Accounting Setup process.

  • The output file provides the summary and details of the uploaded files, including any reported error.

Secure the Upload Mapping Process

You can use the Application Implementation Consultant role to upload the mapping template. However, you can also define new roles to do this task. Make sure that you assign these rights to the new roles:

  • The privileges to manage mapping sets such as the Manage Subledger Mapping Sets and Manage Subledger Mapping Set Value privileges.

  • A duty role to load interface file for import such as the FSCM Load Interface Administration duty.