Java.sql.SQLException: Missing IN Or OUT Parameter At Index When Drilling Down To Commitments
(Doc ID 1645805.1)
Last updated on APRIL 12, 2024
Applies to:
Oracle Project Planning and Control - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
java.sql.SQLException: Missing IN or OUT parameter at index when drilling to commitments from Task
Problem Description
---------------------------------------------------
summary page.
Receive "oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. " Error after clicking on value in Task Summary page to view commitment details
Statement: SELECT * FROM (SELECT
NVL(cmt.CMT_PROMISED_DATE,NVL(cmt.CMT_NEED_BY_DATE,cmt.EXPENDITURE_ITEM_DATE)) commitment_date
,cmt.vendor_name supplier
,lookup.meaning commitment_type
,cmt.cmt_number commitment_number
,cmt.unit_of_measure uom
,hr.name expenditure_organization
,cmt.expenditure_type expenditure_type
,cmt.expenditure_category expenditure_category
,SUM(cmt.tot_cmt_quantity) quantity
,SUM(cmt.proj_raw_cost) proj_direct_cost
,SUM(cmt.tot_cmt_raw_cost) projfunc_direct_cost
,SUM(nvl(cmt.proj_burdened_cost,0) - nvl(cmt.proj_raw_cost,0)) proj_indirect_cost
,SUM(nvl(cmt.tot_cmt_burdened_cost,0) - nvl(cmt.tot_cmt_raw_cost,0)) projfunc_indirect_cost
,SUM(cmt.proj_burdened_cost) proj_total_cost
,SUM(cmt.tot_cmt_burdened_cost) projfunc_total_cost
, cmt.cmt_approved_flag approved
,cmt.description description
,tasks.TASK_NUMBER task_number
,DECODE(cmt_approved_flag ,'Y','Yes','N','No') approved_flag
FROM
pa_commitment_txns cmt
,hr_all_organization_units_tl hr
, ( SELECT
:1 p_project_id
,:2 p_calendar_type
,:3 p_start_date
,:4 p_end_date
FROM dual
) params
, pa_lookups lookup
,pa_tasks tasks
WHERE 1=1
AND cmt.project_id = p_project_id
AND cmt.organization_id = hr.organization_id
AND hr.LANGUAGE = USERENV('LANG')
Error Codes
---------------------------------------------------
JBO-27122
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 |