Friday, October 18, 2013

Supplier Interface in Oracle Apps R12



 There are three interface tables in oracle apps Supplier Interface.
1] AP_SUPPILERS_INT
2] AP_SUPPLIER_SITES_INT
3] AP_SUP_SITE_CONTACTS_INT
Supplier Interface Programs:
1]  Supplier Open Interface Import
2]  Supplier Sites Open Interface Import
3]  Supplier Site Contacts Open Interface Import
1] AP_SUPPLIERS_INT
This is the Open interface table for Supplier used to store Supplier header information. The columns mapped to corresponding AP_SUPPLIERS table.
‘Supplier Open Interface Import’ request is used to import Supplier Header Information into Oracle.
Mandatory Columns:
            VENDOR_INTERFACE_ID  
è AP_SUPPLIERS_INT_S.NEXTVAL [ Unique Identifier]
           
VENDOR_NAME                 è Supplier Name
Other Important Columns:
            VENDOR_TYPE_LOOKUP_CODE
è Supplier Type [e.g. Company etc]
            SUMMARY_FLAG                          
è Key Flexfield Summary Flag
            ENABLED_FLAG                           
è Key Flexfield Enable flag
            NUM_1099                                        
è Tax identification number
            INVOICE_CURRENCY_CODE    
è Invoice Currency Identifier
            TERMS_ID                                       
è Payment Terms Identifier
            SEGMENT1                                     
è Vendor Number
2] AP_SUPPLIER_SITES_INT
This is the Open interface table to import supplier sites information. The columns mapped to corresponding AP_SUPPLIER_SITES_ALL table.
‘Supplier Sites Open Interface Import’ request is used to import Supplier site Information into Oracle.
Mandatory Columns:
            VENDOR_SITE_INTERFACE_ID   è AP_SUPPLIER_SITES_INT_S.NEXTVAL [Unique Identifier]
           
VENDOR_SITE_CODE                  è Supplier Site Name
            VENDOR_ID                                                
è Vendor ID created in AP_SUPPLIERS table after submission of Supplier Open Interface Import request.

Other Important Columns:
            ADDRESS_LINE1                è First Line of Address
            ADDRESS_LINE2               
è Second Line of Address
            ADDRESS_LINE3               
è Third line of Address
            CITY                                      
è City Name
            STATE                                  
è State Name
            COUNTRY                           
è Country Name
            ZIP                                         
è Postal Code
            PHONE                                 
è Phone Number
            FAX                                       
è Fax Number
            EMAIL_ADDRESS             
è Supplier Site URL
            PURCHASING_SITE_FLAG
è To indicate purchasing allow from this site [Y/N]
            RFQ_ONLY_SITE_FLAG  
è To indicate quotations allow from this site [Y/N]
            PAY_SITE_FLAG               
è To indicate payable invoice allow for this site [Y/N]
            INVOICE_CURRENCY_CODE
è Invoice Currency Identifier
            TERMS_ID                           
è Payment Terms ID
3] AP_SUP_SITE_CONTACT_INT:
This is Open interface table for supplier site contacts. The columns mapped to corresponding AP_SUPPLIER_CONTACTS table.
Supplier Site Contacts Open Interface Import’ request is used to import Supplier site Contacts Information into Oracle.
Mandatory Columns:
            VENDOR_CONTACT_INTERFACE_ID è AP_SUP_SITE_CONTACT_INT_S.NEXTVAL [Unique Identifier]
           
VENDOR_SITE_CODE                           è Supplier Site Code
Other Important Columns:
            VENDOR_ID                                        è Vendor_ID created in AP_SUPPLIERS table after submission of Supplier Open Interface Import request.
            VENDOR_SITE_ID                
è Vendor_Site_ID created in AP_SUPPLIER_SITES_ALL table after submission of Supplier Sites Open Interface Import request.
            PREFIX                                    
è Title e.g. [Mr, Mrs, Doctor etc]
            FIRST_NAME                           
è Contact First Name
            MIDDLE_NAME                      
è Contact Middle Name
            LAST_NAME                                       
è Contact Last Name
            AREA_CODE                                       
è Area Code of Contact phone number
            PHONE                                     
è Contact phone number
           
FAX_AREA_CODE                  è Area Code of Contact facsimile number
            FAX                                           
è Contact facsimile number     



Validation during Supplier Import using interface:
1] AP_SUPPLIER_INT.VENDOR_NAME
            Validation for duplicate Supplier Name in AP_SUPPLIERS table.
2] AP_SUPPLIER_INT.VENDOR_TYPE_LOOKUP_CODE
            Validations for valid Supplier Type in PO_LOOKUP_CODES table for LOOK_TYPE
as ‘VENDOR TYPE’.
3] AP_SUPPLIER_INT.SEGMENT1
            Validation for duplicate Supplier Number in AP_SUPPLIERS table.
4] AP_SUPPLIER_SITES_INT.VENDOR_SITE_CODE
            Validation for duplicate Supplier Site Name in AP_SUPPLIER_SITES table.
5] AP_SUPPLIER_SITES_INT.COUNTRY
            Validation for country code in FND_TERRITORIES_VL table.

AP_SUPPLIER_INT_REJECTIONS table contains suppliers, sites, contacts rejections information

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect