EAM - Employee Assignment Error:oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT wo.operation_seq_num AS operation_seq_num, (Doc ID 3001200.1)

Last updated on FEBRUARY 07, 2024

Applies to:

Symptoms

When Assign Person using the Employee Assignment following error occurs.

ERROR
-----------------------

Error Page
Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
wo.operation_seq_num AS operation_seq_num,
wo.wip_entity_id AS wip_entity_id,
(select wip_entity_name from wip_entities where wip_entity_id=wo.wip_entity_id) As wip_entity_name,
wo.organization_id AS organization_id,
nvl(bso.standard_operation_id,null) AS standard_operation_id,
bso.operation_code AS standard_operation_code,
wo.department_id,
bd.department_code AS department_code,
wo.description AS description,
wor.resource_seq_num AS resource_seq_num,
wor.usage_rate_or_amount AS usage_rate,
wor.assigned_units AS assigned_units,
EAM_CREATEUPDATE_WO_PVT.UNASSIGNED_HOURS_OP_RES(wor.wip_entity_id, wor.operation_seq_num,wor.resource_id) As unassigned_hours,
NVL(wor.start_date,wo.first_unit_start_date) AS scheduled_start_date,
NVL(wor.completion_date,wo.last_unit_completion_date) AS scheduled_completion_date,
DECODE(
  (SELECT count(*)
  FROM WIP_OPERATION_RESOURCE_USAGE woru
  WHERE woru.wip_entity_id = wor.wip_entity_id
  AND woru.organization_id = wor.organization_id
  AND woru.operation_seq_num = wor.operation_seq_num
  AND woru.resource_seq_num = wor.resource_seq_num
  AND woru.instance_id IS NULL,



STEPS
-----------------------
1.Login into Maintenance Super user responsibility
2.Work Orders > All > Employee Assignment > Simple Search > Enter Work Order > Go
3.Check checkbox for the Work Order > Click Assign person > Assign two Employees > Save
4.View above error message

Cause

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