Contract Cause Cannot Be Viewed, Updated Or Submitted For Approval and page fails with You have encountered an unexpected error.

(Doc ID 2065663.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Procurement Contracts - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Contract Terms Authoring,
No contract cause can be viewed, updated or submitted for approval

Once a new Clause has been created, user is unable to select that clause and view it.
User is also unable to update or submit clause for review.

In occasions, the page does not load fully 


The following error message is displayed:

Error:


Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details.
 
Exception Details:
 
Error Page
Exception Details. oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: java.sql.SQLException incompatible with oracle.apps.fnd.framework.OAException at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:775) at oracle.apps.okc.articles.webui.ArticleSearchResultsCO.artViewHandler(ArticleSearchResultsCO.java:783) at oracle.apps.okc.articles.webui.ArticleSearchResultsCO.processFormRequest(ArticleSearchResultsCO.java:351) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at



Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Contract Terms Library Administrator
2. Contract > Clauses > Attempt to Open a clause.

Business Impact:
The issue has the following business impact:
Due to this issue, users cannot Open or review clauses.

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