Coverage Related Columns are not Updated in OKS_K_LINES_B by Upgrade Script OKSCVBMG.SQL
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.
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
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