Java.sql.SQLException: Missing IN Or OUT Parameter At Index When Drilling Down To Commitments (Doc ID 1645805.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Management - Version 12.1.3 and later
Information 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

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