After Applying Patches, Workplan Errors with JBO-27122 (Doc ID 1573216.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Updating Workplans errors with:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select
PROJ_ELEMENT_ID
,ELEMENT_VERSION_ID
 ,PEV_STRUCTURE_ID
 ,PROJECT_ID
 ,STRUCTURE_NUMBER
 ,STRUCTURE_NAME
 ,STRUCTURE_VERSION_NUMBER
 ,STRUCTURE_VERSION_NAME
 ,DESCRIPTION
 ,SCHEDULED_START_DATE

...

Changes

 Applied patches

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