JBO-27122 Error When Trying To Save Multiple Debrief Lines (Doc ID 1497232.1)

Last updated on MARCH 12, 2021

Applies to:

Symptoms

An error occurs while trying to save more then one Debrief line at a time.

Error:

You have encountered an unexpected error. Please contact the System Administrator for assistance.

Error Details. page:

Exception Details.  
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (--Verify parent is identical to customer_product_id
select msibk.concatenated_segments item_number, msibk.description,  
cii.serial_number, cii.external_reference, cii.instance_number,  
cii.instance_id,
cii.owner_party_account_id party_account_id,
cii.owner_party_id customer_id,
cii.operational_status_code,
flv.meaning instance_operational_status,
'Y' as dummy_flag
from   csi_item_instances cii,
      mtl_system_items_b_kfv msibk,
      fnd_lookup_values_vl  flv
where  cii.creation_complete_flag = 'Y'
and    cii.instance_id = :1
and    cii.quantity = 1
and    msibk.inventory_item_id = cii.inventory_item_id
and    msibk.organization_id =cii.INV_MASTER_ORGANIZATION_ID
and flv.lookup_type(+) = 'CSI_OPERATIONAL_STATUS_CODE'
and flv.lookup_code(+) = cii.operational_status_code
union
--Parent is a component under the customer_product_id
select  msibk.concatenated_segments item, msibk.description,
cii.serial_number, cii.external_reference,cii.instance_number,
cii.instance_id,
cii.owner_party_account_id party_account_id,
cii.owner_party_id customer_id,
cii.operational_status_code,
flv.meaning instance_operational_status,
'Y' as dummy_flag
from    csi_item_instances cii,
       csi_ii_relationships cir,
       mtl_system_items_b_kfv msibk,
       fnd_lookup_values_vl  flv
where   cii.creation_complete_flag = 'Y'
and     cii.instance_id = cir.subject_id
and     cii.quantity = 1
and        cir.object_id in
       (select object_id from csi_ii_relationships
        start with object_id = :2
        connect by prior subject_id = object_id)
and     msibk.inventory_item_id = cii.inventory_item_id
and     msibk.organization_id = cii.INV_MASTER_ORGANIZATION_ID
and flv.lookup_type(+) = 'CSI_OPERATIONAL_STATUS_CODE'
and flv.lookup_code(+) = cii.operational_status_code
union
-- All components for an account
select   msibk.concatenated_segments item_number, msibk.description, cii.serial_number, cii.external_reference, cii.instance_number,  cii.instance_id,
cii.owner_party_account_id party_account_id, cii.owner_party_id customer_id,
cii.operational_status_code,
flv.meaning instance_operational_status,
'Y' as dummy_flag
from     csi_item_instances cii,
       mtl_system_items_b_kfv msibk,
       fnd_lookup_values_vl  flv
where    cii.creation_complete_flag = 'Y'
and         cii.owner_party_account_id = :3
and      cii.quantity = 1
and      msibk.inventory_item_id = cii.inventory_item_id
and      msibk.organization_id = cii.INV_MASTER_ORGANIZATION_ID
and cii.instance_id=nvl(:4, cii.instance_id)
and flv.lookup_type(+) = 'CSI_OPERATIONAL_STATUS_CODE'

STEPS
-----------------------
1. Login to Oracle Apps
2. (R) Depot Repair Manager
    Create Repair Order > Repair Task tab
3. Create a Repair Task and Assign to a Technician.
4. Click the Debrief button to open the Debrief HTML
5. Enter multiple Material debrief lines and save.
=> Error:
    You have encountered an unexpected error. Please contact the System Administrator for assistance.

Changes

Cause

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