Enterprise Asset Management - EBS (MOSC)

MOSC Banner

Unable to Import Work orders using Import schdule with MS Project

edited Aug 21, 2012 3:28PM in Enterprise Asset Management - EBS (MOSC) 1 commentAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center