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.

Answer / nagabhushan

If not inserted into GL_INTERFACE_CONTROL, cannot import
into GL.

what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,

---

How many schemas we have? how many you have used?

0 Answers  

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

What is an Index , Types od index why we are use index.

2 Answers   IBM,

---

What are the Major differences bteween key flexfields ,descriptive flexfields

4 Answers   Sierra Atlantica, TechBulls,

---

how to set org context?

3 Answers  

---

how many groups we can create for query?

3 Answers  

---

what is meant by boilerplates?

1 Answers  

---

in ap_terms table what data will be stored

1 Answers  

---

what are the tables of auto invoice.

2 Answers  

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---