Validations for the Import Accounting Transactions Process

To ensure that the transaction data is uploaded correctly and without any errors, you need to review it before uploading. You should check for the following elements while reviewing the transaction data.

• The .zip file

  • The name of the .zip file must begin with XlaTransaction.

  • There's exactly one metadata file in the .zip file.

  • The header and line transaction files exist in the .zip file.

• Metadata

  • The metadata file contains a valid application short name.

• Header transaction file

  • The header file contains the source header row.

  • All the sources or the column names in the header row are valid.

  • The source header row of the header transaction file contains Transaction_number, Transaction_type, and Ledger_name.

  • All headers have at least one line for non-reversal records. Line record is optional for reversal header record.

• Line transaction file

  • The line transaction file contains the source header row.

  • The source header row of the line transaction file contains Transaction_number.

  • All lines have at least one header.

• Ledger setup

  • The ledger is setup in subledger accounting.

  • The ledger is allowed to process events. Do not use reporting or secondary ledgers with the valuation method disabled.

  • The ledger and even type details are valid.

• Data type

  • The date and number columns are in the correct format.

  • The date format must be YYYY-MM-DD.