kehri_anurag

 Profile Answers by kehri_anurag Questions by kehri_anurag

• Apr 21st, 2006

 

For Importing the data from feeder system to Oracle GL.

1) Upload the data into GL_INTERFACE using SQL *LOADER or any other.

2) Run the Interface program..so the data will be loade to the base table..

3) In this entire process you have to use PL /SQL procedures

thomas

• Apr 22nd, 2006

 

1. Load the data in GL INTERFACE.

2. Call Journal Import

3. Call Journal Posting

You can do virtually all the above from a single PL/SQL package. This information is alo available in the GL trm, and help can be takn from the Oracle metalink.

Guest

• Jun 11th, 2006

 

Import data from Legacy system to GL

1> Trasnfer data from Legacy sytem to GL_INTERFACE table by creating PLSQL Procedure with related defined Source name in GL setups.

2> Open Standard form GL IMPORT form and select used Source Name and group id.

3> Post JV.

Import data from AP to GL

Run Standard report in AP  'Payables Transfer To GL'