If we transfer the data from legacy system to oracle base
tables. I want to hold the data in interface table how?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 9 Yes | 3 No |
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
Is This Answer Correct ? | 2 Yes | 0 No |
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
Is This Answer Correct ? | 3 Yes | 2 No |
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.
Is This Answer Correct ? | 2 Yes | 1 No |
What are the Major differences between appcore.pll and appcore2.pll
4 Answers Infosys, Sierra Atlantica,
What is oracle soa suite?
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
while running a interface if we get 100 records as erors. how to debug it.
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.
What is the most critical part which you had faced in your project ?
1 Answers LG, Satyam, Tech Mahindra,
Difference between Bind and Lexical parameters?
Which module is not in multiorg
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
where the accounting related data is stored ?
The report output is 10 pages then how many times between pages report trigger will fire?