3 Replies Latest reply on Sep 25, 2008 11:42 AM by 661862

    AP Supplier Contacts Interface

    FrancescoDM
      Hi to all.
      Hi have some doubts for supplier conversion on R12. I need to convert Supplier, Supplier Sites and Supplier Contacts. For what I saw I can join the Supplier and Supplier Sites using the same SUPPLIER_INTERFACE_ID so the interface understand the supplier --> supplier site connection. I do not understand how to do the same association between supplier site and contacts. In AP_SUP_SITE_CONTACT_INT there is not a supplier site interface id, and if I populate it with vendor site code and organization id, the conversion of contact does not work because it ask for vendor_id. But I do not know the Vendor ID when I populate the interface!

      Am I missing something?
      Or should I do the conversion in Two step? First supplier and supplier site, and only after the contacts?

      Please Kindly advise.
        • 1. Re: AP Supplier Contacts Interface
          456359
          Did you try using the vendor_interface_id ?
          • 2. Re: AP Supplier Contacts Interface
            FrancescoDM
            Hi, I managed to have it working. Probably I was missing the link with supplier site code. Btw the script is the following, if it can help


            INSERT INTO AP_SUPPLIERS_INT
            ( VENDOR_INTERFACE_ID ,
            SEGMENT1,
            TERMS_NAME,
            PAYMENT_PRIORITY ,
            PAY_GROUP_LOOKUP_CODE,
            VENDOR_NAME,
            VENDOR_TYPE_LOOKUP_CODE,
            STATUS )
            values(AP_SUPPLIERS_INT_S.NEXTVAL, --VENDOR_INTERFACE_ID
            '545456', --SEGMENT1,
            -- 566, --EMPLOYEE_ID,
            'IMMEDIATE', --TERMS_NAME,
            1 , --PAYMENT_PRIORITY ,
            'AAAA', --PAY_GROUP_LOOKUP_CODE,
            'DUMMYCOMPANY', --VENDOR_NAME,
            'COMPANY', --VENDOR_TYPE_LOOKUP_CODE,
            'NEW' -- STATUS
            );

            COMMIT;


            INSERT INTO AP_SUPPLIER_SITES_INT(
            STATUS,
            VENDOR_INTERFACE_ID, -- VENDOR_INTERFACE_ID,
            VENDOR_SITE_INTERFACE_ID,
            VENDOR_SITE_CODE,
            ADDRESS_STYLE,
            ADDRESS_LINE1,
            ADDRESS_LINE2,
            ADDRESS_LINE3,
            CITY,
            ZIP,
            COUNTRY,
            EMAIL_ADDRESS,
            PAY_SITE_FLAG,
            PURCHASING_SITE_FLAG,
            --OPERATING_UNIT_NAME
            ORG_ID)
            values
            (
            'NEW',--STATUS
            AP_SUPPLIERS_INT_S.CURRVAL ,--VENDOR_INTERFACE_ID
            AP_SUPPLIER_SITES_INT_S.NEXTVAL,--VENDOR_SITE_INTERFACE_ID
            'DUMMY SITE',--VENDOR_SITE_CODE
            'NE',--ADDRESS_STYLE
            'ADDRESS1',--ADDRESS_LINE1
            'ADDRESS2',--ADDRESS_LINE2
            'ADDRESS3',--ADDRESS_LINE3
            'Anywhere',--CITY
            '00100',--ZIP
            'IT', ---COUNTRY
            'AT@DUMMYCOMPANY.COM',--EMAIL_ADDRESS
            'Y',--PAY_SITE
            'Y', -- PURCHASING_SITE_FLAG
            121 )--OPERATING_UNIT_ID
            COMMIT;

            -------------


            -----------

            INSERT INTO AP_SUP_SITE_CONTACT_INT (
            VENDOR_INTERFACE_ID,
            VENDOR_CONTACT_INTERFACE_ID,
            VENDOR_SITE_CODE,
            ORG_ID,
            -- OPERATING_UNIT_NAME,
            FIRST_NAME,
            LAST_NAME,
            PHONE,
            EMAIL_ADDRESS)
            VALUES (
            AP_SUPPLIERS_INT_S.CURRVAL ,--VENDOR_INTERFACE_ID
            AP_SUP_SITE_CONTACT_INT_S.NEXTVAL,
            'DUMMY SITE',
            121,
            -- 'DUMMY OPERATING UNIT', --OPERATING_UNIT_NAME,
            'JOE',
            'DOE',
            '555d-54',
            'j.wood@dummycompany.com')

            COMMIT;
            • 3. Re: AP Supplier Contacts Interface
              661862
              Try this ..

              INSERT INTO ap_suppliers_int(vendor_interface_id) values (ap_suppliers_int_s.NEXTVAL);

              INSERT INTO ap_supplier_sites_int(vendor_interface_id,vendor_site_interface_id) values (ap_suppliers_int_s.CURRVAL,ap_supplier_sites_int_s.NEXTVAL)

              INSERT INTO ap_sup_site_contact_int(vendor_interface_id,vendor_contact_interface_id) Values (ap_suppliers_int_s.CURRVAL,ap_supplier_sites_int_s.CURRVAL)