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

How do you register report in oracle apps?

727


tell me the scenarios of the independent in reports

2219


A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

1782


Do you know where we can check the status of po?

747


What is a flexfield? List out its types.

746






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

727


can we use look up type instead of a pofile option?or valueset?is it possible how?

1866


Explain what are the tables of auto invoice?

736


What do you understand by soa?

780


Tell me how to debug the report?

732


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1781


What are file in oracle.

1900


Plz anybody send me Technical specification for AP Interface

2148


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1873


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1688