Hi Anil,
When we importing the journals in GL module we need to
insert the one row into GL_INTERFACE_CONTROL for each
group_id.Now my question is what is the use of inserting
the data into GL_INTERFACE_CONTROL table and if I not
inserted into GL_INTERFACE_CONTROL what will happen

Answers were Sorted based on User's Feedback

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERF..

Answer / amit chhiber

Hi Anil,

Oracle has provided the feature of multi table journal
import which will enable the data to be imported from more
than one table. This increases the performance of journal
import program in case of huge data.
The Journal Import program looks in the
GL_INTERFACE_CONTROL, to understand the table from which
the data should be imported for a particular combination of
Source and Group ID. Usually in your regular practice, you
are adding a row in this table and specifying that the data
is in GL_INTERFACE table. However as explained, you can
also specify a different table name here(say X), in which
case Journal Import will go to that table(X), to import the
I hope this helps.

Is This Answer Correct ?    11 Yes 1 No

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERF..

Answer / nagabhushan

If not inserted into GL_INTERFACE_CONTROL, cannot import
into GL.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Oracle Apps Technical Interview Questions

tell me the scenarios of between pages in reports

5 Answers  

which parameters passed in report in oracle developer how to pass

3 Answers  

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

What does appl_top directory contain?

0 Answers  


1 Answers  

Are you familiar with internet architecture of oracle apps 11i?

0 Answers  

How will u register concurrent request ?

1 Answers   Convergys,

Tell me how to debug the report?

0 Answers  

what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)