Work Order Creation Fails With Invalid Package EAM_WORK_ORDER_ROUTE_PVT

(Doc ID 2315695.1)

Last updated on NOVEMBER 27, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms


When attempting to create any work orders, the following error occurs.

ERROR

on forms : FRM-40735 ON-INSERT Trigger raised unhandled exception ORA-01403

or

on self-service pages:
Exception Details.
oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:810)
at oracle.apps.eam.workorder.webui.CreateUpdateWOPGCO.processFormRequest(CreateUpdateWOPGCO.java:977)


STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Enterprise Asset Management
2. Navigation: Work Order -> Work Order
3. Enter basic fields
4. Save and receive the aforementioned error

or

1. Responsibility: Maintenance Super User
2. Navigation: Work Order -> All -> Create Work Order
3. Enter basic fields
4. Save and receive the aforementioned error

Cause

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