ORA-01403: no data found FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06508 When Attempting to Create New Contracts

(Doc ID 2015005.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Service Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Service Authoring
On a fresh implementation of service contracts and when creating a service contract or opening Contract forms the following error occurs:

Error:
ORA-01403: no data found
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06508.


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

The issue can be reproduced at will with the following steps:
1. login to the Oracle environment and go to the responsibility 'Service Contracts Manager'.
  Navigate to any OKS menu e.g.
2. click on Tools > New,
   Then select Category Service/Subscription Agreement and click Create
3. hit the error

Business Impact:
The issue has the following business impact:
Due to this issue, users cannot create contracts.

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