Conversions

[Arjunn]

Hi friends,

Can anyone explain..

What is meant by API, ADI
How to do the conversions from legacy system to Oracle Apps by using API, ADI

TIA

[admin]

API = Application Programming Interface

To upload data from legacy to Oracle E-Business suite Oracle has provided API's in different modules which are used to upload data directly into the core tables instead of Interface tables with validations. These are just procedures where you pass the data as parameters for insertion into tables.

ADI = Application Desktop Integrator

This is a tool which is used to upload data of GL and FA from Excel sheets and also used to manage chart of account. You can generate output of financial reports through ADI and it also gives facility of drill down.

Pl download Financial and Sys Admin documents and you will find basics of ADI.

Thanks

[Arjunn]

thanks admin

[arvindmaurya]

Hi Admin,

Just wanted to be sure that it is the good practice that with the API we are inserting data directly in the core table and not in the interface table.

Whatever open interface i have seen they just put the data in the Interface table like Gl_interface for GL and then from the interface table oracle standard import and post program(for GL) is used to put the data in the core table.

I Gues we always API to put the data in the interface table , unless and until, if some client have any specific requirement.

Please through some light on the general practice of using the API