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
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
data.
I hope this helps.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / nagabhushan
If not inserted into GL_INTERFACE_CONTROL, cannot import
into GL.
Is This Answer Correct ? | 3 Yes | 4 No |
for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake
why do we go for oracle apps technical other than sap and other packages?
what is inbound and outbound interface?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
List the types of flexfield?
what are the steps to develop a new report?
In one flat file i got headers and lines data how you can write control file now ?
What is multoorg and what is it's level or structure
we have 4 managers if one person logon the system automatically displays his siganature and name how?
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
what is the use of format trigger?a
What are triggers?