Oracle Service Contract - Issue with oks_import_subline_pub.create_subline
Hi,
Oracle Version#12.2.6
We want to add sublines to contract number and we are using this standard oks_import_subline_pub.create_subline API, we have got this api from oracle standard APIs.
Need to load sublines with Level = 'Product' and Serial_Number, we are able to load with Level = 'Item' but when trying to load with product_id couldn't find the exact value to be passed for product_id.
Please suggest from which table we can get product_id and below is the sample script we are using.
--- Sample Script --
Oracle Version#12.2.6
We want to add sublines to contract number and we are using this standard oks_import_subline_pub.create_subline API, we have got this api from oracle standard APIs.
Need to load sublines with Level = 'Product' and Serial_Number, we are able to load with Level = 'Item' but when trying to load with product_id couldn't find the exact value to be passed for product_id.
Please suggest from which table we can get product_id and below is the sample script we are using.
--- Sample Script --
DECLARE
l_api_version NUMBER;
l_init_msg_list VARCHAR2(20) := 'T';
Tagged:
0