Unable to Import Work orders using Import schdule with MS Project
Hi,
Unable to Import Work orders using Import schdule using MS Project even after saving file with .XML ., please suggest
Getting exception like '
Error Page
Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT UNIQUE wpr.wip_entity_id, wip_entity_name, wpr.organization_id, wo_scheduled_start_date, wo_scheduled_completion_date, duration, instance_number as asset_number, wo_description, wpr.owning_department_id, asset_group_id, asset_group, asset_activity, work_order_type, work_order_type_disp, wpr.shutdown_type, priority, status_type_disp, asset_type, project_number, task_number, maintenance_object_id, maintenance_object_type, maintenance_object_source, wpr.system_status, wpr.status_type, wpr.operation_seq_num, op_description, op_department_id, op_department_code, opIsCompleted, wpr.resource_seq_num, wpr.resource_id, resource_type, resource_code, usage_rate, res_uom, wpr.assigned_units as assigned_units, wori.instance_id, NVL(wori.serial_number,ppf.full_name) AS instance_name, opCt, resCt, resInstCt, shutdown_type_disp, resource_type_disp, wpr.ESTIMATE_NUMBER as ConstructionEstimateNumber FROM (SELECT Wo_Op.wip_entity_id, Wo_Op.wip_entity_name, Wo_Op.organization_id, Wo_Op.scheduled_start_date AS wo_scheduled_start_date, Wo_Op.scheduled_completion_date wo_scheduled_completion_date, duration, asset_number,0