The one of the customer record under the IE Operating unit is having some data corruption, the customer account details are not able to see from the customer search window. The customer record and invoices are created through interface the data is showing from back end. when they try to query from front end, result not showing.
Solution:-
Oracle GDF and other Seeded Objects Data Fixes
| Data Fix – Receipt Application issue |
Create back up table
create table SCRATCH.HZ_CUST_PROF_S160321 as
select * from APPS.HZ_CUSTOMER_PROFILES where cust_account_id=*******;
Please run this script for each customer by replacing the Customer Account ID.
set serveroutput on;
DECLARE
p_init_msg_list VARCHAR2(100):= FND_API.G_FALSE;
p_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
p_create_profile_amt VARCHAR2(100):= FND_API.G_TRUE;
x_cust_account_profile_id NUMBER;
x_return_status VARCHAR2(100);
x_msg_count NUMBER;
x_msg_data VARCHAR2(100);
BEGIN
p_customer_profile_rec.cust_account_id:=1566953; —-> please replace the value with correct customer account id
p_customer_profile_rec.created_by_module:=’TCA_V2_API’;
HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile(
p_init_msg_list,
p_customer_profile_rec,
p_create_profile_amt,
x_cust_account_profile_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_cust_account_profile_id: ‘||x_cust_account_profile_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(‘***************************’);
END;
Commit;
