CMRO Fleet Unit Association Page Error: ORACLE.JBO.SQLSTMTEXCEPTION: JBO-27122 (Doc ID 3068498.1)

Last updated on JANUARY 22, 2025

Applies to:

Symptoms

While trying to search the record in Fleet unit association page in CMRO, get this error while clicking on GO button:

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT auch1.name Unit_Name , auch1.unit_config_header_id , cii1.serial_number , mtl1.concatenated_segments , mtl1.inventory_item_id , mchb1.mc_header_id , mchb1.name Master_Config , NULL CurFleetAssoc , aspv1.Last_BUE_Run , 'N' Remove_units_selection_Flag , 'Y' old_record , flua1.simulation_plan_id , aspv1.primary_plan_flag , 'N' unit_selection_flag, ( row_number() OVER (PARTITION BY auch1.NAME ORDER BY auch1.NAME) ) RowNumber , 'SimPlan' Gen_Plan_Flag FROM ahl_fleet_unit_assocs flua1 , ahl_unit_config_headers auch1, ahl_simulation_plans_vl aspv1, csi_item_instances cii1 , mtl_system_items_kfv mtl1 , ahl_mc_headers_b mchb1 WHERE flua1.fleet_header_id IS NULL AND NOT EXISTS (SELECT fluai1.fleet_header_id FROM ahl_fleet_unit_assocs fluai1 WHERE fluai1.simulation_plan_id = aspv1.simulation_plan_id AND fluai1.unit_config_header_id = flua1.unit_config_header_id AND fluai1.fleet_header_id IS NOT NULL ) AND mchb1.mc_header_id = auch1.master_config_id AND mtl1.organization_id = cii1.last_vld_organization_id AND mtl1.inventory_item_id = cii1.inventory_item_id AND cii1.instance_id = auch1.csi_item_instance_id AND auch1.unit_config_header_id = flua1.unit_config_header_id AND flua1.simulation_plan_id = aspv1.simulation_plan_id AND aspv1.primary_plan_flag = 'N' AND aspv1.simulation_type = 'UMP' UNION SELECT auch2.name Unit_Name , auch2.unit_config_header_id , cii2.serial_number , mtl2.concatenated_segments , mtl2.inventory_item_id , mchb2.mc_header_id , mchb2.name Master_Config , ( SELECT fhbi2.name FROM ahl_fleet_headers_b fhbi2, ahl_fleet_unit_assocs fluai2 WHERE fhbi2.fleet_header_id = fluai2.fleet_header_id AND ( SYSDATE BE
...

Replication Steps
1. Login to Oracle Apps
2. R) Oracle CMRO -> Planning -> Fleet Forecasting -> Fleet Associations
3. The search fails with the above error, in the following cases:
a) Provide dates or
b) Master configuration or
c) Fleet info in the search criteria.

It only works when searched using:
a) By unit
------------

Cause

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