How Account Combination Import Data Is Processed

Use the Import Account Combinations file-based data import to import and update account combinations. You can download a spreadsheet template to use to prepare your account combination data.

The template contains an instruction sheet to help guide you through the process of entering your account combination information.

In addition to creating account combinations, you can also use the template to update attributes on existing account combinations. Enter the segment values for the existing account combinations and specify the attributes to update such as Enabled, Allow Posting, From Date, To Date, Alternate Account, and Preserve Attributes.

Note: An alternate account is used when its associated account combination is disabled or inactive.

To access the template, complete the following steps:

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

2. In the General Ledger chapter, click Import Account Combinations.

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

Follow these guidelines 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 use, but don't delete them.

Settings That Affect the Account Combinations Import Process

The Account Combinations Import Interface template contains an instructions tab, plus a tab that represents the table where the data is loaded.

The following table contains the names of the tabs in the Import Account Combinations spreadsheet template and a description of their contents.

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains an overview of the template and information about how to generate the data files for upload.
GL_BULK_COMBINATIONS_INT	Enter information about the account combinations that you're adding or updating, such as the chart of accounts, the segment values, and whether posting is allowed. You can also enter information for the General Ledger Accounts descriptive flexfield, which includes date and number validations. These validations ensure the information captured is more accurate and consistent. Note: The Date data type columns are ATTRIBUTE_DATE1 through ATTRIBUTE_DATE5 and the Number data type columns are ATTRIBUTE_NUMBER1 through ATTRIBUTE_NUMBER5.

After you prepare the data in the spreadsheet, click Validate Account Combinations to verify that the template doesn't have errors.

How Account Combinations Import Data Is Processed

To load the data into the interface table:

1. Click the Generate CSV File button on the instructions tab to create a CSV file in a .zip file format.

2. Save the .zip file locally.

3. Navigate to the Scheduled Processes work area.

4. Select the Load Interface File for Import process.

5. For the Import Process parameter, select Import Account Combinations.

6. For the Data File parameter, select the file that you saved in step 2.

7. If the process ends in error or warning:

   1. Review the log and output files for details about the rows that caused the failure.

   2. Correct the errors in the spreadsheet.

   3. Repeat steps 1 through 6 until the errors are resolved.

To load the data from the interface table into the product:

1. Navigate to the Scheduled Processes work area.

2. Select the Import Account Combinations process.

3. Optionally provide values for the Chart of Accounts and Group ID parameters.

4. Submit the process.

5. If the process ends in error or warning:

   1. Review the log file for details about the rows that cause the failure.

   2. Correct the spreadsheet.

   3. Follow the steps to delete the data from the interface table.

   4. Repeat the steps to load the data into the interface table.

To delete the data from the interface table without loading into the product:

1. Navigate to the Scheduled Processes work area and select the Purge Interface Tables process.

2. Accept the default value of File-based data import for the Purge Process Intent parameter.

3. Select Import Account Combinations for the Import Process parameter.

4. For the Load Request ID parameter, enter the process ID from the Load Interface File for Import process.

5. Submit the process.