Exception Error when Creating Repository Contract oracle.jbo.SQLStmtException JBO-27122 (Doc ID 1666945.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

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

Symptoms

When attempting to create a Contract, the page errors out.

Error:

Page error: You have encountered unexpected error.

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
 Statement: SELECT name,
Document_type
FROM OKC_BUS_DOC_TYPES_VL
WHERE document_type_class = 'REPOSITORY'
AND     (start_date AND     nvl(end_date, sysdate + 1) > sysdate
AND     ((OKC_REP_UTIL_PVT.is_sales_workbench() = 'N'
          AND (INSTR( FND_PROFILE.VALUE('OKC_REP_INTENTS'), intent) <> 0
               OR FND_PROFILE.VALUE('OKC_REP_INTENTS') IS NULL))
      OR (OKC_REP_UTIL_PVT.is_sales_workbench() = 'Y'
          AND intent IN ('S', 'O')))
and     (intent = :1 or :2 is null)
AND (name like'Acquisition Plan Summary' OR ('FALSE' = :3))          
ORDER BY name asc

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3270)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3065)
at _OA._jspService(_OA.java:228)

[...]

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
[...]

Steps:

(R) Contracts Workbench Administrator
(N) Contracts > Create Contract

What Is Working:

There is an instance where the Context 'Acquisition Plan Summary' (*) never existed.
That instance never had a problem.

(*) Development was contacted to confirm how that Context can become enabled without user intervention.

Changes

- Upgraded instance from 11.5.10.2 to Release 12.1.3.

- For the 'Repository Contracts Additional Information' DFF:
  . Disabled Context 'Acquisition Plan Summary'
  . Added defined segments for the Context 'Global Data Elements'.

- Not using Public Sector Procurement, so never enabled the feature in the upgrade process.
- Not using the Acquisition Plan feature anywhere in 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