Financial breakdown structure task errors-java.sql.SQLException: ORA-01008: not all variables bound (Doc ID 360319.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Project Management - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Project Foundation - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 30-Sep-2013


Symptoms

Navigation:

>Login to SSWA.
>Choose Projects Super User.
>Navigate to Project templates.
>Select the project template and click on the Update pencil.
>Under Setup Options, navigate to >Financial>Financial Breakdown Structure. Click on the Update pencil icon.
>Open the task detail and click on the Update pencil icon. Errors with:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.
Statement: select
proj_element_id,
element_version_id,
project_id,
'PA_STRUCTURES' as object_type,
structure_version_number as element_number,
:1 as call_mode,
:2 as form_read_only,
:3 as financial_only,
structure_version_name as element_name
from pa_structure_versions_v
where
element_version_id = :4
and structure_type = :5
.
.
java.sql.SQLException: ORA-01008: not all variables bound

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