Can upload Journal Entries using ADI (Application Desktop Integrator) functionality.

ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet such as copying and pasting cells dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts security rules and reference information that are defined in the General Ledger (GL).

Using Journal Import we can bring the data from the feeder system.

Refer General Ledger UserGuide.

To import the Transactions from External Feeder Systems following are the steps

1. Populate the data from External system to GL_Interface table (GL_INTERFACE table acts like a bridge between the external system and the Oracle General Ledger Base tables where journals are stored).

2.Run the Journal Import process to import the date to base tables

(Errors in Journal Import are listed in Execution Report)

Thanks

K V Srinivasan

There are three ways:

1. Upload the data through GLDI-Applications Desktop Interator a web based tool to upload data to GL

2. Directly run Journal Import from Journal/Import of GL

3. From any sub module run individual module transfer to GL program Ex: Payables transfer to General Ledger

Thanks

Srilakshmi

There are several ways to import data into GL. It basically depends on the
type and size of file among other considerations.

Feeder system can be typically taken as - internal transfers - within Oracle
Modules like Receivable Payable Fixed assets.

Now as a Feeder each of the above said modules have respective Menu function to
Run after closing the period - 'Transfer to GL'

Since the data between modules is in the format of Oracle Standards and as a
period cannot be closed with discrepecies - in most cases it should do the job.
It is recommented to Run Jounal Import Execution Report to check the status of
each line.

Now to import legacy data that is available as a flat file.

a> create a control file

b> create a staging table

c> create a Sql loader Program

d> create a PL/sql program

e> Data file

1> Flat file ( legacy data)

2> Feeder utility - Sql*Loader

3> Create a custom_Staging_Table

4> Write a Pl/Sql program to Validate the data in custom_staging_table_data. IF
OK

5> Move data to GL_Interface_table.

6> From GL_Interface_table use import program to move to base table.