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 |
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
What is oracle soa suite and what are its different components?
Do you know what is applysys in oracle application database schema, what is apps?
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
what is the difference between procedure and function
What is the Exception. Types of exception, Difference between those. And example
what is meant by Drill Down in Discoverer report? why it will be use?
can we use look up type instead of a pofile option?or valueset?is it possible how?
what is latest version in reports
What are the files we submit while your program move to testing instance?