Journals

Note the Import form for Journals is different to the Budget Amounts Import form. The Import Budgets form is shown below the Import Journals form.

Importing Journals

Once the data has been successfully loaded into the interface table, the Journal Import process must be run to populate the data into the Oracle tables.

Click the ‘Submit Concurrent Program’ button:

The following form will appear:

Click on the

and the following Parameter form will appear:

Import Journals Fields Described

• Data Access Set ID: This field is automatically populated by the Wizard

• Source: From the List of Values, select the Source that has been used for your journal batches

• Ledger: This is required for R12 installations. Select from the List of Values

• Group ID: Select the relevant Group ID for your batches from the List of Values

• Run Options:

Post Errors to Suspense

If you select 'Yes', a Suspense account must have been defined before out of balance 'Actuals' journals can be imported. A default blank value is equivalent to 'No'.

Create Summary Journals

If you select 'Yes' all transactions within one journal that share the same currency, account and period will be summarized. A default blank value is equivalent to 'No'.

Import Descriptive Flexfields

If you select 'Yes' the DFF’s will be imported. A default blank value is equivalent to 'No'.