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.
