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

Answer Posted / 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
data.
I hope this helps.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In support project one ticket alloted which steps follows manualy tell me ?

2221


do you know is it possible to run the interface without using oracle apps?

646


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2591


What is count(*) from po_vendors(any table)?

639


In oracle application how do you debug or trace errors?

639






Tell me how to find the custom directory in front end?

658


can we get profile values in report without using user exists is it possible how?

2316


What is oracle soa suite?

762


Is soa a part of oracle fusion middleware?

603


Plz anybody send me Technical specification for AP Interface

2009


List the various types of value set.

620


tell me the scenarios of the independent in reports

2106


Can we create tables in apps schema?

614


what is the differences between internal requisition and internal sales order?

2153


In hierarchical structure of a database? we have write query from where we should start?

1701