Prasad Patkar

• Apr 20th, 2006

 

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).
 

kavitha

• Apr 25th, 2006

 

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

Refer General Ledger UserGuide.

vasan_kali

 Profile Answers by vasan_kali 

• May 18th, 2006

 

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

srilakshmi

• May 26th, 2006

 

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

aaditya180399

 Profile Answers by aaditya180399 Questions by aaditya180399

• Nov 14th, 2006

 

Right Answer given by K V Srinivasan

roycbe

 Profile Answers by roycbe 

• Mar 25th, 2008

 

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.