OKS_IMPORT_LINE_PUB Error Updating Service Line: OKC_CONTRACTS_INVALID_VALUE (COL_NAME=COVERAGE_ID)

(Doc ID 2331015.1)

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.

Symptoms

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.

ERROR
-----------------------
OKC_CONTRACTS_INVALID_VALUE (COL_NAME=COVERAGE_ID)


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.



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