If we transfer the data from legacy system to oracle base
tables. I want to hold the data in interface table how?
- 4 Answers
- 13483 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
What does appl_top directory contain?
List the various types of value set.
Explain oracle apps architecture.
Are you familiar with internet architecture of oracle apps 11i?
tell me the scenarios of the independent in reports
tell me the scenarios of the independent in reports
tell my any difficult situtation you solved in your experience in your company?
please send me forms, xml pulisher questions,answers
What do you understand by soa?
What are the benefits of using soa architecture?
How to create a purchase order without a requisition?
What is a value set? List its various types.
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
Can you define an erp system?
