Home » Applications » Oracle Fusion Apps & E-Business Suite » Intercompany and GL_JE_Headers and Line
Intercompany and GL_JE_Headers and Line [message #184549] Thu, 27 July 2006 00:47 Go to next message
Messages: 65
Registered: November 2001
Can anyone tell how the link established bewteen the Intercompany Transaction and between Journal.

Is there anything link between
gl_iea_transaction and GL_JE_Headers and GL_JE_Lines
thanks in advnce
Re: Intercompany and GL_JE_Headers and Line [message #184633 is a reply to message #184549] Thu, 27 July 2006 04:53 Go to previous messageGo to next message
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
If you log on to MetaLink, then click on the "Knowledge" tab and scroll down to the bottom, on the left hand side you will find the "Online" section where the last entry is "eTRM". Click on this.

Select the version you are on (11.5.10 is the default), then search for GL_IEA_TRANSACTIONS (note it must be in upper case). When the two items (GL Table and APPS Synonym) are displayed, click on the GL Table, then click on the FND Design Data: SQLGL.GL_IEA_TRANSACTIONS and this will display the Foreign Keys. Unfortunately, there is no mention of GL_HE_HEADERS or GL_JE_LINES here.

A similar search, starting from GL_JE_LINES produced no reference back to GL_IEA_TRANSACTIONS.

So it would appear (at least to this end user with a small amount of technical understanding) that there is no link. However, I am not an expert in this area and somebody with a better technical understanding (or more knowledge of the Intercompany Accounting) might know otherwise.

Embarassed Sorry I couldn't help, but if I have pointed you in the right direction, then that is a good start.


[Updated on: Thu, 27 July 2006 04:56]

Report message to a moderator

Re: Intercompany and GL_JE_Headers and Line [message #284511 is a reply to message #184633] Thu, 29 November 2007 23:01 Go to previous message
Messages: 19
Registered: November 2007
Location: San Francisco
Junior Member
I expect one of the attributeX columns in GL_JE_LINES will hold the id from the gl_IEA table.

You cna tst it by entering a GIS transaction with a very distinct amount or description and then post it, searach gl_je_lines and vie wall the columns for the id - it will be in one of those numbered columns I am sure. Sorry I don't have access to an instance right now to test it myself.

Best of Luck
Previous Topic: Probem in designing org structure
Next Topic: Automatic Interunit accounting??
Goto Forum:

Current Time: Thu Aug 24 00:09:38 CDT 2017

Total time taken to generate the page: 0.01372 seconds