|
|
| Re: Customer Data Hub/Bulk Import of customers [message #169845 is a reply to message #169842] |
Sat, 29 April 2006 05:22  |
pranveerg
Messages: 3
Registered: April 2006
|
Junior Member |
|
|
I was trying the fallowing steps to bulk import customer's and addresses into TCA in CDH
Step 1: Registered Source Sysrem "FCS"
Step 2: Run below program to get unique BATCH_ID for the import
DECLARE
x_batch_id NUMBER;
x_return_status VARCHAR2(4000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(4000);
BEGIN
hz_imp_batch_summary_v2pub.create_import_batch(NULL,'BATCH_29042006-1','BATCH_29042006-1','FCS','BATCH IMPORT',12,x_batch_id,x_return_status,x_msg_count,x_msg_data);
dbms_output.put_line(SubStr('x_batch_id = '||TO_CHAR(x_batch_id),1, 255));
dbms_output.put_line(SubStr('x_return_status = '||x_return_status,1,255));
dbms_output.put_line(SubStr('x_msg_count = '||TO_CHAR(x_msg_count), 1, 255));
dbms_output.put_line(SubStr('x_msg_data = '||x_msg_data,1,255));
COMMIT;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
RAISE;
END;
/
Sept 3: Inserted records into HZ_IMP_PARTIES_INT & HZ_IMP_ADDRESSES_INT with the BATCH_ID given from the program, also gave unique values for PARTY_ORIG_SYSTEM_REFERENCE & SITE_ORIG_SYSTEM_REFERENCE.
Step 4: When trying to run import into registery, I am unable to give the same batchID (its not taking the same BATCH_ID value that I got from the program).
Can some one please tell me if I am missing some thing.
Please give me step by step approach. I appriciate your support, thank you
Regards,
Pranveer
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
