My Oracle Support Banner

ORA-00904 Error Occurs in eAM Scheduler's Workbench (Doc ID 413072.1)

Last updated on AUGUST 26, 2021

Applies to:

Oracle Work in Process - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
DataWriter.java

Symptoms

On 11.5.10 in Production:
When attempting to reschedule work orders via the Scheduler Workbench, the following error occurs.  The error persists whether the 'Firm' flag is either checked or not.

ERROR
SerializableThrowableWrapper: from <URL>

Wrapped: oracle.apps.fnd.promise.ReferenceException: source null, throwable:
oracle.apps.fnd.promise.ReferenceException: source null, throwable: java.sql.SQLException:
ORA-00904: "WIP_REQUIREMENT_OPERATIONS": invalid identifier
: Found Exception when writing dirty chunks: ORA-00904: "WIP_REQUIREMENT_OPERATIONS": invalid
identifier
: Found Exception when writing dirty chunks: Found Exception when writing dirty chunks:
ORA-00904: "WIP_REQUIREMENT_OPERATIONS": invalid identifier
at oracle.apps.wip.gantt.eamgantt.server.database.DataWriter.writeData(DataWriter.java:101)
at
oracle.apps.wip.gantt.eamgantt.server.service.PostDataService.writeData(PostDataService.java:126)
at oracle.apps.wip.gantt.eamgantt.server.service.PostDataService.execute(PostDataService.java:75)

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility: Enterprise Asset Management
2. Navigation: Work Order Planning -> Scheduler Workbench
3. Drag work order bar to reschedule the work order.
4. Error appears at the bottom of the screen.
5. When Details is clicked more errors appear.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.