Financial breakdown structure task errors-java.sql.SQLException: ORA-01008: not all variables bound
(Doc ID 360319.1)
Last updated on SEPTEMBER 05, 2024
Applies to:
Oracle Project Planning and Control - 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.
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
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |