Advanced Features for Importing Transaction Data to Accounting Hub

You have the flexibility to upload transaction from Universal Content Manager to the interface table, import accounting transactions from the interface table, and create accounting as three separate processes.

For example, you can choose to split a large batch of accounting transactions into multiple data files and import them to interface table separately. After all the files are uploaded, you can submit the Import Accounting Transactions from Interface process to import all transactions into Accounting Hub and create accounting. Optionally, you can create accounting using the Create Accounting process at a later stage.

To have such a flexibility for importing transaction data, you have to do these tasks:

• Enable the Flexible Configuration of Accounting Hub Cloud Service feature.

• Download and use the updated transaction template.

• Configure parameters for the Import Accounting Transactions process.

• Configure parameters for the Import Accounting Transactions from Interface process.

Enable the Flexible Configuration of Accounting Hub Cloud Service Feature

The Flexible Configuration of Accounting Hub Cloud Service feature is enabled by default unless you disable it manually. We highly recommend keeping this feature enabled because many other dependent features may not be supported if you disable it. Note that you can't opt-out from this advanced feature if any of your subledgers already has Support Transaction Reversal enabled.

You must download a new transaction template and populate the template with the source value in corresponding columns. The new template displays the unused columns in XlaTrxH.csv and XlaTrxL.csv files as CHAR1, CHAR2, CHAR3...., NUMBER1, NUMBER2, NUMBER3...., DATE1, DATE2, DATE3...., LONG_CHAR1, LONG_CHAR2, LONG_CHAR3....and so on. You can't remove these columns from the template, but you can keep these columns blank if unused.

Configure Parameters for the Import Accounting Transactions Process

The following table describes the parameters you can configure for the Import Accounting Transaction process:

Parameter	Description
Import from Interface	Select whether to upload transaction data to the interface table and import transaction from interface to Accounting Hub in a single step. Choose Yes if the transaction data for an import set is in a single data file. Choose No if the transaction data for an import set is split into multiple data files. In this case, you can wait until all the transaction data is imported to the interface table and then submit the Import Accounting Transaction from Interface to import the transactions to Accounting Hub.
Import Set	The group of transactions that are processes together. If this information isn't entered, each data file is considered a single import set.
Create Accounting	Select whether to submit create accounting process after transactions are imported from the interface table.
Report Style	Select the format in which the report output is generated.
Transfer to General Ledger	Select whether to transfer the subledger journal entries to General Ledger.
Post in General Ledger	Select whether to post subledger journal entries in General Ledger.
Update Subledger Balances	Select whether to submit update subledger account balances process to update supporting reference balance after create accounting process is complete.

Configure Parameters for the Import Accounting Transactions from Interface Process

You use the Import Accounting Transaction from Interface process to import transaction data from interface tables into Accounting Hub. For example, you may choose to load transactions to interface tables without triggering the import in the same run. Later, you can use the Import Accounting Transactions from Interface process to import these transactions. This is an optional process, and you only need to run this if the Import Accounting Transactions process is submitted with Import from Interface = N.

The following table describes the parameters you can configure for the Import Accounting Transaction from Interface process:

Parameter	Description
Subledger Application	Select the subledger application for which you want to import accounting transactions from interface table and create accounting.
Import Set	The group of transactions that are processes together. If this information isn't entered, each data file is considered a single import set.
Create Accounting	Select whether to submit create accounting process after transactions are imported from the interface table.
Report Style	Select the format in which the report output is generated.
Transfer to General Ledger	Select whether to transfer the subledger journal entries to General Ledger.
Post in General Ledger	Select whether to post subledger journal entries in General Ledger.
Update Subledger Balances	Select whether to submit update subledger account balances process to update supporting reference balance after create accounting process is complete.