Interested to Buy Any Domain ? << Click Here >> for more details...
If we transfer the data from legacy system to oracle base
tables. I want to hold the data in interface table how?
- 4 Answers
- 15173 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you explain the difference between architecture followed in 10g & 11g?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What is a value set? List its various types.
How do you register report in oracle apps?
Do you know what are user profiles in apps. Any examples you can give?
What is instead of trigger in where we will use?
What do you understand by concurrent programs?
What are the different components of soa suite?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Which oracle apps version you are very confident in?
Are you familiar with internet architecture of oracle apps 11i?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
