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