kiran

• Jul 16th, 2006

 

Study Design Document and define Mapping Rules, Business Object info. As a first step, create staging table as a replica of Flat file n Interface tables. Dump the flatfile data into Staging table. Ensure that additional columns for update of record status and Error messages are created in staging table. Create a Pkg/proc(as per document) and transfer the data from staging table to validation proc. before transferring the data into validation proc, ensure that duplicate rows are deleted(use ROWID) and validate the data. Validation Pkg shud be such that if the records passes all the validations, Record status column will be updated to 'Y' and if the records do not pass validations record status wil be updated to 'N' and error message will be inserted. (use Pragma Autonomous Transactions for insertion of error message).

Create a proc to transfer data from staging table to interface table and run Standard Program to hit the data into Base Tables.

kiran - 98497 56230.

Deepali

• Jul 18th, 2006

 

Hi

Following step needs to follow:-

1) create staging table and control file

2)  run sql loader to load data in staging table.

3) perform validation on data.

4) transfer data to interface table using some transformation logic.

5) Run import program (incase of if module is inventory) to move data to base table.

thx

Shruti

• Sep 27th, 2006

 

1- Identification (check if the Open interface exists for loading the data into the base tables)

2- Create a staging table( having data colums, conditonal colums)

3- Load data into staging table

4- Create a pre interface table

5- Load the data into the pre interface table from the staging table

6- Mappings

7- Write a procedure to validate the data

includes validations like : No duplication of data, Integrity constraints (for master- detail table)

8- If the data is valid then load the data into the interface table

9- Run the interface program to load data into the base table.

kumar

• Oct 1st, 2006

 

I we want to transfer the data from legacy system to oracle we will use the interfaceshere we have two types of interfaces one is inbound interface and other is outbound interfaceinterface is nothing but to transfer the data from one location to other. i.e from database tables to flat files or flat files to database tablesinbound interface is used to transfer the data from legacy system flat file to oracle database tableshere are the steps to transfer the dat from flat file to oracle apps database table1.transfer the data of flat file to staging table or pre interface table or temp table buy using sql * loader.here if the any error in the data then the error data will goes to the bad file or discard file2.by using PL/SQL procedues will created to transfer the data from staging interface table to interface table,during this process if any error in the data then the error data will goes into the error table.all this process is called as post validation process 3.then the data will be transfer from the interface table to base tables by using the standared program (which oracle defined).during this process if nay error in the data will goes to the error file