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
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Explain what are the tables of auto invoice?
What is a flexfield? List out its types.
Can you differentiate between mediator and osb?
How can you achieve loose coupling in soa framework?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Which oracle apps version you are very confident in?
where to define interorganization transaction charges and what are the different options?
testing tools?
can we get profile values in report without using user exists is it possible how?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is a value set? List its various types.
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
How can we import the data into a database using sql * loader?
please send me forms, xml pulisher questions,answers