Import Journals - GL Interface table in Oracle fusion.

For the Import Journals - General Ledger, below is the interface table used in Oracle fusion.

GL_INTERFACE

In order to identify the records for the Journals which you load, always use the Group ID in the FBDI file that distinguishes the GL records.

Import the Journals using the Oracle FBDI, following are the steps needs to be followed :

1. Generate the GLInterface.csv file using the Oracle FBDI.

2. Load Interface File for Import

     Import Process : Import Journals

     Data File : Upload the GL Journal FBDI zip file to be uploaded.

3. Once the process completes successfully, run the next import process :

      Import Journals 

      Following are the parameters to be used for the import

      Data Access Set : Select the data access set

      Source : Select the source as per what is mentioned in the FBDI file.

      Ledger : Select the ledger to be imported.

      Group ID  : Identifier from the FBDI file.

      Post Account Errors to Suspense : No

      Create Summary Journals : No

      Import Descriptive Flexfields : No