My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.