13499934: 12.1.3: HP-UX Itanium : FRM-30064: Unable to parse statement select
Problem Summary---------------------------------------------------
getting error "FRM-30064: Unable to parse statement select" when applying ONT patch 13499934
Problem Description
---------------------------------------------------
applying patch 13499934 in production environment and getting the same error on 4 forms
FRM-30064: Unable to parse statement select oiv.item,oiv.item_description,oiv.component_item_id
from oe_option_items_v oiv,bom_bill_of_materials bbm
WHERE oiv.top_bill_sequence_id = bbm.bill_sequence_id
AND bbm.assembly_item_id=:parameter.lov_num_param1
AND bbm.organization_id= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')
AND bbm.alternate_bom_designator IS NULL.
ORA-04023:
Object select oiv.item,oiv.item_description,oiv.component_item_id from
oe_option_items_v oiv,bom_bill_of_materials bbm WHERE
oiv.top_bill_sequence_id = bbm.bill_sequence_id AND
bbm.assembly_item_id=:1 AND bbm.organization_id=
OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') AND
bbm.alternate_bom_designator IS NULLRecord Group OPTION_ITEM_HS