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.

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,

---

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

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.

0 Answers   Accenture,

---

what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---

Which is the best website to learn Oracle Apps?

2 Answers  

---

Can we customize a form with out template.fmb

5 Answers   Zensar,

---

why do we validate the records while developing interface?

3 Answers   TCS,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

What is menu.

2 Answers   Accenture,

---

What is SET-OF-BOOKS?

3 Answers  

---

what are the pl/sql tables

1 Answers   IBM,

---