Suggestion on Patch 13580080
Hi All
FRM-30064: Unable to parse statement select src_designator,src_description,designator_id ,organization_id,sr_instance_id,msc_get_name.instance_code(sr_instance_id)instance_code from msc_designators
where designator_type = :mrp_maint_work_orders.designator_type
union all
select msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES',1),' ',decode(:mrp_maint_work_orders.designator_type,12,-1001,13,-1002)designator_id,-23453,:mrp_plans.sr_instance_id,msc_get_name.instance_code(:mrp_plans.sr_instance_id)instance_code from DUAL
.
ORA-01790: expression must have same datatype as corresponding expression
Record Group MSC_MAINT_PLANS
where designator_type = :mrp_maint_work_orders.designator_type
union all
select msc_get_name.lookup_meaning('MSC_MAINTENANCE_PLAN_TYPES',1),' ',decode(:mrp_maint_work_orders.designator_type,12,-1001,13,-1002)designator_id,-23453,:mrp_plans.sr_instance_id,msc_get_name.instance_code(:mrp_plans.sr_instance_id)instance_code from DUAL
.
ORA-01790: expression must have same datatype as corresponding expression
Record Group MSC_MAINT_PLANS
Tagged:
0