How To Add A Phone At Customer Level Via Customer Interface

Problem : How To Add A Phone At Customer Level Via Customer Interface

Modified 19-NOV-2008     Type PROBLEM     Status PUBLISHED    

Checked for relevance on 20-Nov-2008

How To Add A Phone At Customer Level Via Customer Interface
----------------------------------------------------------

Example:

1. Run these scripts by SQL*Plus

-----------------------------------
-- insert the BILL_TO information
-----------------------------------

truncate table ar.ra_customers_interface_all;

insert into ar.ra_customers_interface_all
(orig_system_customer_ref,
customer_name,
orig_system_address_ref,
address1,
address2,
address3,
address4,
city,
county,
state,
province,
country,
postal_code,
site_use_code,
primary_site_use_flag,
customer_status,
insert_update_flag,
last_updated_by,
last_update_date,
created_by,
creation_date,
customer_number,
customer_name_phonetic,
customer_category_code,
location,
org_id
)
VALUES(
'01-08-01',                -- orig_system_reference
'CUSTOMERNAME8',           -- customer_name
'01-08-01',                -- orig_system_address_ref, change it if you put another address
'ADDRESS8',                -- address1
NULL,                      -- address2
NULL,                      -- address3
NULL,                      -- address4
'San Mateo',               -- city
'San Mateo',               -- county
'CA',                      -- state
NULL,                      -- provice
'US',                      -- country
'94401',                   -- postal_code
'BILL_TO',                 -- SITE USE
'Y',                       -- primary_site_use_flag
'A',                       -- customer_staus
'I',                       -- insert_update_flag
-1,                        -- last_updated_by
sysdate,                   -- last_update_date
-1,                        -- created_by
sysdate,                   -- creation_date
null,                      -- customer_number if automatic customer number is no
'CUSTOMERNAME8',           -- customer_name_phonetic
'CUSTOMER',                -- customer_category_code
null,                      -- location if autositenumber is no
204                        -- org_id
);

 

----------------------------------------------
-- insert the customer profile information
----------------------------------------------

truncate table ar.ra_customer_profiles_int_all;

INSERT INTO ar.ra_customer_profiles_int_all
(orig_system_customer_ref,
insert_update_flag,
customer_profile_class_name,
credit_hold, 
last_updated_by,
last_update_date,
created_by,
creation_date,
org_id
)
VALUES
('01-08-01',           -- orig_system_customer_ref
'I',                   -- insert_update_flag
'DEFAULT',             -- Should be valid profile class
'N',                   -- This can be 'Y','N' not null.
-1,                    -- last_updated_by
sysdate,               -- last_update_date
-1,                    -- created_by
sysdate,               -- created_by
204                    -- org_id
);

 

-----------------------------------------------------
-- Add a phone information
-----------------------------------------------------

truncate table ar.ra_contact_phones_int_all;

insert into ar.ra_contact_phones_int_all
(
 ORIG_SYSTEM_CONTACT_REF
,ORIG_SYSTEM_TELEPHONE_REF
,ORIG_SYSTEM_CUSTOMER_REF
,ORIG_SYSTEM_ADDRESS_REF
,INSERT_UPDATE_FLAG
,CONTACT_FIRST_NAME
,CONTACT_LAST_NAME
,CONTACT_TITLE
,CONTACT_JOB_TITLE
,TELEPHONE
,TELEPHONE_EXTENSION
,TELEPHONE_TYPE
,TELEPHONE_AREA_CODE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,EMAIL_ADDRESS
,ORG_ID
)
values
(
 null              -- ORIG_SYSTEM_CONTACT_REF
,'01-08-01'        -- ORIG_SYSTEM_TELEPHONE_REF Change it if the phone number is different
,'01-08-01'        -- ORIG_SYSTEM_CUSTOMER_REF
,null              -- ORIG_SYSTEM_ADDRESS_REF null only when you put at customer level
,'I'               -- INSERT_UPDATE_FLAG
,null              -- CONTACT_FIRST_NAME
,null              -- CONTACT_LAST_NAME
,null              -- CONTACT_TITLE review ar_lookups lookup_type = CONTACT_TITLE
,null              -- CONTACT_JOB_TITLE
,'4555555'         -- TELEPHONE
,'89555'           -- TELEPHONE_EXTENSION
,'FAX'             -- TELEPHONE_TYPE be exist in ar_lookups lookup_type = PHONE_LINE_TYPE
,'407'             -- TELEPHONE_AREA_CODE
,sysdate           -- LAST_UPDATE_DATE
,-1                -- LAST_UPDATED_BY
,sysdate           -- CREATION_DATE
,-1                -- CREATED_BY
,null              -- EMAIL_ADDRESS
,204               -- ORG_ID
);

commit;

2. Run customer Interface Program from the application.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23739124/viewspace-661796/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23739124/viewspace-661796/