difference between Interface and API
Interface :-
--> interface is to be done more than once
--> we have two types of interafce
1) inbound Interface : It is used to send the data from flat files to base
tables.
2) outbound Interface : It is used to extract the data from base tables to
falt files.
--> after creating all concurrent programs, we have to create request set based on
requriment we need to set the process.
--> we can do interface for many things like
-- item , suppliers , customer ,sales orders, purchase orders etc...
i) for Item interface we have to validate
-- segment1 , uom , organization_code.
ii) for supplier interface we have to validate
-- vendor_name ,segment1
for supplier_sites
-- site_name
for supplier contacts.
INTERFACE PROCESS :-
---> First we have to download the data from flat file to stagging table for this
we have to use sql * loader.
---> For this we have to creat one stagging table and control file based on flatile
file.
---> Next we have to create one concurrent program to EXECUTE control file.
---> By submitting this concurrent program we can move the from flat file to
stagging table.
---> After getting the data into stagging table,we can do validations.
---> After compliting validations,we can move the data from stagging table to
interface tables.
---> For this we have to create one more concurrent program.
---> Next,by submitting this concurrent program,we can move the data from stagging
table to interface tables.
---> Then we have to submit one standrad concurrent program(import items),to move
the data from interface tables to base tables.
---> After creating all concurrent programs, we have to create request set AND
based on requriment we need to set the process.
API(Application Programming Interface) :-
--> By using API we can insert the data directly into base tables without using
interface tables.
---> No need to do manual validation,
--> To avoid creating multiple concurrent programs we use API.
--> we have two types of API'S
* Public API
* PRIVATE API
--> some API'S we use regularly
-- dbms_output.put_line
-- fnd_file.put_line(fnd_file.output)
--fnd_file.put_line(fnd_file.log)
--> while using API we have 3mandatory input and output parameters needed
-- input parameters
* p_api_version
p_init_msg_list
p_commit
-- output parameters
* x_return_status
x_msg_count
x_msg_data
--> API FOR CREATING Items
-- ego_item_pub.process_item
--> API for suppliers
-- pos_vendor_pub_pkg.create_supplier
--> API For supplier_sites
-- pos_vendor_pub_pkg.create_supplier_sites
--> API for supplier_contacts
--pos_vendor_pub_pkg.create_supplier_contacts .
file path:-/fmw/ebs/test/app/fs2/EBSapps/appl/xxtest/12.0.0/bin
