Lease and Finance Management - EBS (MOSC)

MOSC Banner

Oracle Service Contract - Issue with oks_import_subline_pub.create_subline

edited Nov 10, 2021 4:26PM in Lease and Finance Management - EBS (MOSC) 1 commentQuestion
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 --

DECLARE
l_api_version NUMBER;
l_init_msg_list VARCHAR2(20) := 'T';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center