Importing Pre-Mapped Transactions

Note:

This feature is available only in 11.1.2.4.100 (patch 20307212). For information about new features and updating to release 11.1.2.4.100, see My Oracle Support https://support.oracle.com/.

When you import pre-mapped transactions, you enable authorized users to import BEX, SRC, or SUB transactions into reconciliations, where the transactions have already been pre-assigned an account ID. The imported transactions are inserted into the existing Account Reconciliation Manager transaction tables (including the summary amounts table), and assigned the appropriate account ID, period ID and transaction type.

These transactions are importable regardless of whether a reconciliation for the period exists (the data is keyed off of Account ID and Period ID, not Reconciliation ID).

The following users are authorized to use the import feature, subject to the security rights noted:

Administrator

All reconciliations

Power User

Reconciliations included within the Power User’s security filter

Preparer

Reconciliations where the user is assigned the Primary Preparer role, or the Backup Preparer role, where the user is currently the Active preparer (because the primary is unavailable), or a member of a Team/Group assigned the Preparer role, regardless of the Claimed status.

Note:

Preparers should be able to import transactions regardless of whether reconciliation exists or not. For role checking, use profile security.

To import pre-mapped transactions:

1. Click Tools, and then Import Transactions.
2. Enter the following fields:

   • File—Click Browse, navigate to the import file and then click Open.

   • Transaction—Select a transaction type. Example: Explained Balance, Adjustment to Source System, Adjustment to Subsystem

   • Period—Select a period for the transactions.

   • Import Type

   • Date Format

     Note:

     This feature is available only in 11.1.2.4.100 (patch 20307212). For information about new features and updating to release 11.1.2.4.100, see My Oracle Support https://support.oracle.com/.

     Select a Date Format from the drop down list of allowed date formats. Date formats are not translated. By default, the date format is set to the locale date format of the exported file location.

     For example:

     • MM/dd/yyyy

     • dd/MM/yyyy

     • dd-MMM-yy

     • MMM d, yyyy

     Note:

     The import file format is similar to that of the existing transaction import file (from the reconciliation action dialog box) but adds a Reconciliation Account ID column to identify reconciliations.

     Amount1, Amount2, and Amount3 are the amounts associated with the Transaction. If an amount is missing, then zero amount is imported. Amount Currency1, Amount Currency2, and Amount Currency3 are the currency codes associated with each Amount.

     Amount1 and Amount Currency1 are always mapped to Entered, Amount2 and Amount Currency2 are always mapped to Functional, and Amount3 and Amount Currency3 are always mapped to Reporting.

     Reconciliation Account ID	Short Description	Long Description	Transaction Date	Close Date	Amount1	Amount Currency1	Attribute 1	Attribute Value 1
     110-01	Transaction 1		30-Jun-13	30-Jun-13	215,028.00	USD	Impact	Low
     110-02	Transaction 1		30-Jun-13	30-Jun-13	410	USD		Low
     110-02	Transaction 2		30-Jun-13	30-Jun-13	1,018.00	USD		Low