Coverage Related Columns are not Updated in OKS_K_LINES_B by Upgrade Script OKSCVBMG.SQL (Doc ID 2066087.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Service Contracts - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Coverage related columns are not upgraded properly in R12 OKS_K_LINES_B.
Service Request form throws error: "FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403"
The cause of the error is that COVERAGE_ID , STANDARD_COV_YN  are blank in OKS_K_LINES_B table.
On further analysis we could see that huge number of the line records in OKS_K_LINES_B have these columns blank.
OKSCVBMG.sql is not picking up the records for upgrade

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