Renewal Type at Subline Level is Updated with Null Value when Using the API oks_import_subline_pub.update

(Doc ID 2325220.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Service Contracts - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, API Generator

Renewal Type at subline level is updated with NULL value while using the API oks_import_subline_pub.update

could see the below line is commented in the API oks_import_subline_pub.update_subline

--l_subline_tbl(i).renewal_type := nvl(p_subline_tbl(i).renewal_type,l_renewal_type); -- which table


at line 3095
IF p_subline_tbl(i).renewal_type <> OKC_API.G_MISS_CHAR THEN
/** validate renewal type **/
l_return_status := validate_renewal(p_subline_tbl(i).renewal_type);
IF l_return_status = 'E' THEN
OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'VALIDATE_RENEWAL_TYPE_CODE');
RAISE OKC_API.G_EXCEPTION_ERROR;
END IF;
END IF;

3455
--l_subline_tbl(i).renewal_type := nvl(p_subline_tbl(i).renewal_type,l_renewal_type); -- which table


UPDATE okc_k_lines_b
SET start_date = l_subline_tbl(i).start_date,
end_date = l_subline_tbl(i).end_date,
/*commented and modified for bug 25879695
LINE_LIST_PRICE = l_subline_tbl(i).unit_price ,*/
PRICE_UNIT = l_subline_tbl(i).unit_price ,
PRICE_NEGOTIATED = l_subline_tbl(i).price_subtotal,
LINE_RENEWAL_TYPE_CODE= l_subline_tbl(i).renewal_type,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_date = SYSDATE,
last_update_login = FND_GLOBAL.LOGIN_ID,
attribute_category = l_subline_tbl(i).attribute_category,
attribute1 = l_subline_tbl(i).attribute1,
attribute2 = l_subline_tbl(i).attribute2,
attribute3 = l_subline_tbl(i).attribute3,
attribute4 = l_subline_tbl(i).attribute4,
attribute5 = l_subline_tbl(i).attribute5,
attribute6 = l_subline_tbl(i).attribute6,
attribute7 = l_subline_tbl(i).attribute7,
attribute8 = l_subline_tbl(i).attribute8,
attribute9 = l_subline_tbl(i).attribute9,
attribute10 = l_subline_tbl(i).attribute10,
attribute11 = l_subline_tbl(i).attribute11,
attribute12 = l_subline_tbl(i).attribute12,
attribute13 = l_subline_tbl(i).a

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