Import External Transactions to Tax Repository

Transactions from an external system can be imported to the Tax Repository through the Tax Entry Repository Data Upload Interface.

The Import External Transactions to the Tax Repository process validates the interface data, calculates tax, determines recovery, and inserts transactional data in the core tax repository tables. In addition to importing external transactions, you can submit the interface process in a quote mode to simulate subledger tax calculation. Use the worksheets provided and the generation process to prepare a data file for upload.

Use the Tax Entry Repository Data Upload spreadsheet for simple to complex tax data distributions. This spreadsheet is typically intended for high volume imports.

To access the template, complete the following steps:

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 Tax Entry Repository Data Upload Interface.

4. 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.

• Do not change the order of the columns in the template.

• You can hide or skip the columns you do not use, but do not delete them.

Note: You can load the spreadsheet data to an interface table using the predefined Tax Entry Repository Data Upload Spreadsheet and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For more information about file-based data import, see the File Based Data Import for Oracle Financials Cloud guide.

Use Tax Entry Repository Data Upload spreadsheet for the following type of entry:

Type of Entry	Usage	Access
Taxable transactions	Purchase or sales transactions using: Third-party customer or supplier details Specific item distributions for more complex accounting requirements Tax distributions for specific recovery scenarios from external systems Summary tax line allocations to support scenarios beyond prorated allocation of purchase transaction tax Higher volume data	Download the Tax Entry Repository Data Upload Interface spreadsheet for Oracle Fusion Applications. Follow the instructions on the Instructions and CSV Generation tab to process your spreadsheet data.

Settings That Affect the Tax Entry Repository Data Upload Interface Process

Prepare the data in the worksheets included. The individual tabs of the worksheet model the elements of a transaction. There are three sheets in the template:

• Instructions and CSV Generation

• Transaction Headers

• Transaction Lines

Transaction Headers and Transaction Lines are the minimum requirements to create a transaction and calculate tax. Each column of the worksheets will have help comments to provide information about the value and data type of the attribute.

How Tax Entry Repository Data Upload Interface Is Processed

Load the Data into the Interface Tables

1. After you finish preparing the data in the parent and child sheets, click the Generate CSV File button. The process generates both a CSV file and a ZIP file.

2. Load the data using the Load Interface File for Import process:

   1. Sign in to the Oracle Public Cloud SFTP server.

   2. Transfer the ZIP file to the SFTP server location.

   3. Sign in to Oracle Fusion Applications.

   4. Navigate to Scheduled Processes.

   5. Select Load Interface File for Import.

   6. Select the Import External Transactions to the Tax Repository Import Process.

   7. Select the appropriate Data File that was loaded to the SFTP server location and submit.

   8. Review the results of the process.

   9. If necessary, correct any errors in the CSV file and rerun the Load Interface File for Import process.

3. Correct load errors:

   1. If the load of the CSV file fails on any row, the Load Interface File for Import process ends in error and the Load File to Interface child process ends in either warning or error.

   2. All rows that were loaded from the CSV file are deleted including the ones that loaded successfully. This lets you edit the problematic data in the spreadsheet and resubmit without having to separate the successful rows from the rows that need modification.

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

   4. Correct the data in the template you used.

   5. Repeat steps 1 and 2 of this section: Generate the CSV file and load the data using the Load Interface File for Import process.

   6. Repeat all of these steps until all data is loaded successfully.