How To Add A Contact At Customer Level With Phone Via Customer Interface

How To Add A Contact At Customer Level With Phone Via Customer Interface [ID 176858.1]    
  
Modified 19-NOV-2008     Type PROBLEM     Status PUBLISHED   

Checked for relevance on 20-Nov-2008

How To Add A Contact At Customer Level With Phone Via Customer Interface 
------------------------------------------------------------------------
Example:

1. Run these scripts via 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-04-01',                -- orig_system_reference
'CUSTOMERNAME4',           -- customer_name
'01-04-01',                -- orig_system_address_ref, change it if you put another address
'ADDRESS4',                -- 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
'CUSTOMERNAME4',           -- 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-04-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 contact 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
(
 '01-04-01'         -- ORIG_SYSTEM_CONTACT_REF
,'01-04-01'         -- ORIG_SYSTEM_TELEPHONE_REF Change it if the phone number is different
,'01-04-01'         -- ORIG_SYSTEM_CUSTOMER_REF
,null               -- ORIG_SYSTEM_ADDRESS_REF null only when you put at customer level
,'I'                -- INSERT_UPDATE_FLAG
,'Fenner4'          -- CONTACT_FIRST_NAME
,'Giraldo4'         -- CONTACT_LAST_NAME
,'MR.'              -- CONTACT_TITLE must be exist in ar_lookups lookup_type = CONTACT_TITLE
,'Manager'          -- CONTACT_JOB_TITLE meaning must be exist in ar_lookups lookup_type = RESPONSIBILITY
,'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
,'test@test.com'    -- EMAIL_ADDRESS
,204                -- ORG_ID
);

commit;

2. Run customer Interface Program from the application.

 

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

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