ERPstuff - Oracle EBS Community

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

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