ORA-01861 Error Happening In Work Order Operations Screen (Doc ID 2301979.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Production Planning

When attempting to update work order
the following error occurs.

ORA-01861: Literal does not match format string in Package AHL_PRD_WORKORDER_PVT Procedure UPDATE_JOB

The issue can be reproduced at will with the following steps:
①Enable acquisition setting of Debug Log
 FND:Debug Log Enabled : Yes

②Search WorkOrder on the Work Order OverView screen

③ Select WorkOrder and press the Go button

④ Press the Apply button on the WorkOrder Operations screen
 ⇒⑤error happened


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms