Bulk Import Issue: Bulk Import Process Does Not Update HZ_ORGANIZATION_PROFILES Columns (Doc ID 848688.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Trading Community - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Oracle Customers Online - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Oracle Receivables - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Oracle Trading Community - Version: 11.5.10 to 11.5.10.3
Oracle Customers Online - Version: 11.5.10 to 11.5.10.3
This problem can occur on any platform.
EXECUTABLE:ARHLWRPB - TCA Import - Batch Data Load Main Wrapper

Symptoms

On 11.5.10.2 in Production:
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms