JBO-27122 Error When Trying To Save Multiple Debrief Lines
(Doc ID 1497232.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Field Service - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |