Bulk Import Issue: Bulk Import Process Does Not Update HZ_ORGANIZATION_PROFILES Columns
(Doc ID 848688.1)
Last updated on NOVEMBER 27, 2020
Applies to:
Oracle Trading Community - Version 11.5.10 and laterOracle Customers Online - Version 11.5.10 and later
Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
EXECUTABLE:ARHLWRPB - TCA Import - Batch Data Load Main Wrapper
Symptoms
While running Bulk Import Process from Customer Online Responsibility, it was verified that it does not update hz_organization_profiles table.
Bulk Import is expected to update hz_organization_profiles.
Following documents the steps to reproduce the issue:
1. Create Batch from SQL PLUS
DECLARE
x_batch_id NUMBER;
x_return_status VARCHAR2(2000);
x_msg_count NUMBER;
x_msg_data VARCHAR2(2000);
p_batch_name VARCHAR2(2000);
p_description VARCHAR2(2000);
p_original_system VARCHAR2(2000);
p_load_type VARCHAR2(2000);
p_est_no_of_records NUMBER;
BEGIN
p_batch_name := 'SSJ10';
p_description := 'p_description';
p_original_system := 'DNB'; -- This is the source system defined in Oracle Customer Online (OCO)
p_load_type := FND_API.G_MISS_CHAR;
p_est_no_of_records := 5;
hz_imp_batch_summary_v2pub.create_import_batch (
'T',
p_batch_name,
p_description,
p_original_system,
p_load_type,
p_est_no_of_records,
x_batch_id,
x_return_status,
x_msg_count,
x_msg_data);
dbms_output.put_line('***************************');
dbms_output.put_line('Output information ....');
dbms_output.put_line('x_batch_id: '||x_batch_id);
dbms_output.put_line('x_return_status: '||x_return_status);
dbms_output.put_line('x_msg_count: '||x_msg_count);
dbms_output.put_line('x_msg_data: '||x_msg_data);
dbms_output.put_line('***************************');
IF x_msg_count >1 THEN
FOR I IN 1..x_msg_count
LOOP
dbms_output.put_line(I||'. '||SubStr(FND_MSG_PUB.Get(p_encoded =>
FND_API.G_FALSE ), 1, 255));
END LOOP;
END IF;
END;
2. Activate a batch
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |