Import an Order with its customer account and address using Order Import Process

Import an Order with its customer account and address using Order Import Process

Import an order, the customer account, and the customer address using Order Import process

In this example, the address is categorized as Bill_To and Ship_To address.

1. Populate the order import interface tables.

INSERT INTO oe_headers_iface_all (order_source_id,

                                  orig_sys_document_ref,

                                  operation_code,

                                  ordered_date,

                                  order_type_id,

                                  price_list_id,

                                  orig_sys_customer_ref,

                                  orig_bill_address_ref,

                                  created_by,

                                  creation_date,

                                  last_updated_by,

                                  last_update_date)

     VALUES (1046,                                          -- order_source_id

             'IL070524-01',                           -- orig_sys_document_ref

             'INSERT',                                       -- operation_code

             SYSDATE,                                          -- ordered_date

             1430,                                            -- order_type_id

             1000,                                            -- price_list_id

             'IL CUST ACT 01',                        -- orig_sys_customer_ref

             'IL CUST ADD 01',                        -- orig_bill_address_ref

             1007880,                                            -- created_by

             SYSDATE,                                         -- creation_date

             1007880,                                       -- last_updated_by

             SYSDATE                                       -- last_update_date

                    );

INSERT INTO OE_CUSTOMER_INFO_IFACE_ALL (CREATED_BY,

                                        CREATION_DATE,

                                        CUSTOMER_INFO_REF,

                                        CUSTOMER_INFO_TYPE_CODE,

                                        CUSTOMER_NUMBER,

                                        CUSTOMER_TYPE,

                                        LAST_UPDATE_DATE,

                                        LAST_UPDATED_BY,

                                        ORGANIZATION_NAME,

                                        EMAIL_ADDRESS)

     VALUES (1007880,                                            -- created_by

             SYSDATE,                                         -- creation_date

             'IL CUST ACT 01',                            -- customer_info_ref

             'ACCOUNT',                             -- customer_info_type_code

             'IL CUST 001',                                 -- customer_number

             'ORGANIZATION',                                  -- customer_type

             SYSDATE,                                      -- last_update_date

             1007880,                                       -- last_updated_by

             'IL NEW ORG 01',                             -- organization_name

             'one@one.com'                                    -- email_address

                          );

INSERT INTO OE_CUSTOMER_INFO_IFACE_ALL (ADDRESS1,

                                        ADDRESS2,

                                        ADDRESS3,

                                        ADDRESS4,

                                        CITY,

                                        COUNTRY,

                                        CREATED_BY,

                                        CREATION_DATE,

                                        CUSTOMER_INFO_REF,

                                        CUSTOMER_INFO_TYPE_CODE,

                                        IS_BILL_TO_ADDRESS,

                                        IS_SHIP_TO_ADDRESS,

                                        LAST_UPDATE_DATE,

                                        LAST_UPDATED_BY,

                                        PARENT_CUSTOMER_REF,

                                        POSTAL_CODE,

                                        STATE)

     VALUES ('III rd Floorb',                                      -- address1

             '200 Rhode Island',                                   -- address2

             'San Francisco',                                      -- address3

             'CA 94103',                                           -- address4

             'San Francisco',                                          -- city

             'US',                                                  -- country

             1007880,                                            -- created_by

             SYSDATE,                                         -- creation_date

             'IL CUST ADD 01',                            -- customer_info_ref

             'ADDRESS',                             -- customer_info_type_code

             'Y',                                        -- is_bill_to_address

             'Y',                                        -- is_ship_to_address

             SYSDATE,                                      -- last_update_date

             1007880,                                       -- last_updated_by

             'IL CUST ACT 01',                          -- parent_customer_ref

             '94103',                                           -- postal_code

             'CA'                                                     -- state

                 );

Note:

You only need to have one record with customer_info_type_code = 'ADDRESS' in OE_CUSTOMER_INFO_IFACE_ALL if the address has Ship-To and Bill-To Business Purpose.

2. Run Order Import process

It should import new order and new customer account, customer address.