Bulk Import Issue: Bulk Import Process Does Not Update HZ_ORGANIZATION_PROFILES Columns

(Doc ID 848688.1)

Last updated on JANUARY 08, 2018

Applies to:

Oracle Trading Community - Version 11.5.10 and later
Oracle 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

Changes

 

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