OKS_IMPORT_LINE_PUB Error Updating Service Line: OKC_CONTRACTS_INVALID_VALUE (COL_NAME=COVERAGE_ID)
Last updated on NOVEMBER 21, 2017
Applies to:Oracle Service Contracts - Version 12.2.4 and later
Information in this document applies to any platform.
When attempting to use API OKS_IMPORT_LINE_PUB.UPDATE_CONTRACT_LINE to update the information on existing SERVICE contract lines. the following error occurs.
The issue occurs when NOT passing the coverage_id value to the API. If this value is not passed, then the API is internally deriving the corresponding coverage_id from oks_k_lines_b table and then validating it in the okc_k_lines_b table with below condition
SELECT 'X' FROM okc_k_lines_b cleb
WHERE cleb.chr_id < 0 and cleb.lse_id in (2,15,65,66)
AND cleb.id = p_cov_id
Since chr_id value is null for the coverage line in okc_k_lines_b table, the API is throwing the Invalid Coverage id error.
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