Update Customer Profile API

TCA Update Customer Profile API

Name of the API : UPDATE CUSTOMER PROFILE
Base Tables Affected : HZ_CUSTOMER_PROFILES
PL/SQL Procedure used : UPDATE_CUSTOMER_PROFILE
Package Used : HZ_CUSTOMER_PROFILE_V2PUB
Mandatory Parameters :
Parameter Name Parameter Type Data Type
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
p_customer_ profile_rec IN CUSTOMER_ PROFI LE_ REC_ TYPE,
p_object_version_number IN OUT NUMBER,
x_return_status OUT VARCHAR2,
x_msg_count OUT NUMBER,
x_msg_data OUT VARCHAR2

Procedure:

General Tips for Running the Update Customer Profile API:

a) Save the API in a script file and then run the script from the SQL Prompt (Example : RUN update_customer_profile.sql)
b) Set the organization id before running the script as :
EXEC fnd_client_info.set_org_context(‘<orgid>’); for 11i
OR For R12
EXEC mo_global.init (‘AR’);
EXEC mo_global.set_org_context(<org_id>, NULL, ‘AR’);
EXEC fnd_global.set_nls_context(‘AMERICAN’);
EXEC mo_global.set_policy_context(‘S’, <org_id>);

Example For Running Update Customer Profile API:

 Sample Output of the Update Customer Profile Script:

x_return_status = S
Object Version Number = 2
Credit Rating = Excellent
x_msg_count = 0
x_msg_data =

Script To Verify whether the Update Customer Profile API is successful:

 

Related posts:

Leave a Reply