Answer / nagaraju chittamsetty

Hi to all,
Actually there is no possibility to insert data into base
tables directly.We use Standard API provided by oracle
people.
Suppose let us assume that if we want to transfer standard
purchase orders into po base tables we are useing
po_headers_interface,po_lines_interface,po_distribuitons_int
erface.
After transer the data into interface tables we are run the
standard API like import standard purchase orders api which
will validate the data,then insert into respective base
tables.

Answer / nagendra

Legacy System->Staging Table->Pre-Interface Tables
->Interface Tables->Base Tables

1. Legacy System means other system. For e.g. Cobol
2. We create staging table in database(Oracle Apps
environment)
3. Using SQL Loader utility we get the data from Legacy to
Staging Table
4. Transfer the data to Pre-Interface Tables
5. Validate the data and transfer that to Interface Tables
6. Validate the data and use Standard API's to transfer
the data to Oracle Base Tables. For e.g.
(MTL_SYSTEM_ITEMS_B)

Note: Where Pre-Interface Tables are optional

Answer / prasad reddy

Hi ,

That is your wish , if you want keep records in interface
you can do that.

while submitting item import standard program you could
see the parameter called

Delete processed row YES/NO if yes it will delete all
the rows.

In case of other interfaces i not sure , let you know that
bit later.



Regards,
-Prasad

Answer / srinivas.r

Yes,well said by nagaraju.
We are not directly insert the data into oracle base table
from flatfiles.For that first we should move the data first
into interface table later by running the standard API it
will validate the data and move to the base tables.This is
the process.

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

2 Answers   TCS,

---

what are the match approvals in PO?

3 Answers  

---

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

0 Answers   KPIT,

---

API?s FOR CUSTOMER INTERFACE? Tell me some API's?

1 Answers  

---

Hoe to skip middle of the record by using SQL*Loader?

5 Answers  

---

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

what is difference between procedure and function

5 Answers   E Logic,

---

List the types of flexfield?

0 Answers  

---

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

---