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 |
How to make Parameter as Mandatory?
what is meant by lexical parameter
Do you know where we can check the status of po?
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
What is profile and what is level of profile option and it's hierarchy
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.
Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems
When you run he report you have to get only that particular organization po numbers or item number how can do it?
what is meant by Drill Down in Discoverer report? why it will be use?
What are the tables in GL?
wht r the basetables of customer interface?
what is meant by bind parameter?