payable transfer to GL process

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
champ_guru_24
Posts: 15
Joined: Thu Mar 08, 2007 6:58 am
Location: India

payable transfer to GL process

Post by champ_guru_24 »

Hi All,

Can some Guru mention in here all that happens during payable transfer to GL process? What all tables are hit and how GL batches are created in gl_je_batches table? In what manner those batches are created, what all lines are created in gl_je_headers table etc... ?

Regards,

Abhay
SIVAKUMAR_G
Posts: 194
Joined: Tue May 15, 2007 7:45 am
Location: United Arab Emirates

Post by SIVAKUMAR_G »

Hi

If you have Diagnostic Patch Applied run the AP List Diagnostic script after every step what you do in AP Module, it will show the complete details

For Example if you create an Invoice what tables are pouplated, when you perform Validation if there is any hold what tables are created and when accounted what tables are populated

Similary when You run the Payables transfer process also it will show clearly the following

The basic information are transferred using reference columns 1 to 30 in GL_INTERFACE Table

From the GL_INTERFACE Table when you run the Import Journal process it populates GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES Tables

You can see the above details alos in AP List script if you have applied Diagnostic Patch in your Instance

Hope this helps

Regards
Sivakumar
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest