My Oracle Support Banner

Claim API OZF_SD_REQUEST_PUB.UPDATE_SD_REQUEST Clears Out all Stored Attributes (Doc ID 1370450.1)

Last updated on JULY 17, 2020

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

OZF_SD_REQUEST_PUB.update_sd_request API Call clears all the attributes which are stored in the SSD Request header attributes

Steps to Reproduce



Running the API Script

---To update to active status
DECLARE
ln_org_id NUMBER := 104;
lv_appl_name VARCHAR2(3) := 'OZF';
lv_return_status VARCHAR2(100);
ln_msg_cnt NUMBER;
lv_msg_data VARCHAR2(1000);
lr_sd_header_rec OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type;
lt_sd_line_tab OZF_SD_REQUEST_PUB.SDR_lines_tbl_type;
lt_sd_cust_tab OZF_SD_REQUEST_PUB.SDR_cust_tbl_type;
l_error_message VARCHAR2(2000);
l_msg_data_tmp VARCHAR2(2000);
BEGIN
MO_GLOBAL.init(lv_appl_name);
MO_GLOBAL.set_policy_context('S',ln_org_id);
FND_GLOBAL.apps_initialize(2678,51124,682);
--Assigning values
lr_sd_header_rec.request_header_id := 3962;
lr_sd_header_rec.user_id := 2678;
--product details
lt_sd_line_tab(1).request_line_id := 7262;
lt_sd_line_tab(1).requested_discount_value := 150;
--API Call
OZF_SD_REQUEST_PUB.update_sd_request(
p_api_version_number => 1.0
,p_init_msg_list => FND_API.G_TRUE
,p_commit => FND_API.G_FALSE
,p_validation_level => FND_API.G_VALID_LEVEL_FULL
,x_return_status => lv_return_status
,x_msg_count => ln_msg_cnt
,x_msg_data => lv_msg_data
,p_SDR_hdr_rec => lr_sd_header_rec
,p_SDR_lines_tbl => lt_sd_line_tab
,p_SDR_cust_tbl => lt_sd_cust_tab);
--Print out the status
IF (lv_return_status <> 'S') THEN
FOR msg IN 1 .. fnd_msg_pub.count_msg LOOP
l_msg_data_tmp := fnd_msg_pub.get (p_msg_index => msg, p_encoded
=> 'F');
l_error_message :=
SUBSTR(l_error_message||l_msg_data_tmp||chr(10),1,1000);
END LOOP;
END IF;
DBMS_OUTPUT.put_line('Status -'||lv_return_status);
DBMS_OUTPUT.put_line('Msg Count -'||ln_msg_cnt);
DBMS_OUTPUT.put_line('Msg Data -'||l_error_message);
END;
--

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.