Getting Error 'You Have Encountered An Unexpected Error' While Adding An Additional Commodity Role (Doc ID 1322481.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Oracle Applications 12.1.2

When attempting to add an additional commodity role to the existing assigned person on the commodity, the user encounters the following error:

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT person_id employee_id,
First_name,
middle_name,
last_name,
party_id ,
first_name || ' ' || last_name as display_name
FROM PER_WORKFORCE_CURRENT_X --R12 CWK
WHERE person_id NOT IN
(SELECT person_id
FROM po_commodity_grants
WHERE commodity_id = :1)) QRSLT WHERE (EMPLOYEE_ID = :1)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
...
java.sql.SQLException: Missing IN or OUT parameter at index:: 2
...


Steps to Replicate:

Resp = Purchasing
Nav: Setup > Items > Commodities > Commodities
In the Commodities page, click the Update icon for the desired Commodity Code
Select the Person Assignments tab
Click the Update Roles icon for the desired person
The Update Roles page shows Selected Roles and Available Roles

Select an available role and move it to the Selected Roles section.
Click Apply
Encounter an error:
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Changes

Upgraded from 11.5.10.2 to R12.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.