Maintenance Workbench Search/Forecast Shows Error FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-29532 (Doc ID 1114655.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10.2 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

*Symptoms
Briefly describe the symptoms of the problem. Remember to delete any customer specific information

On : 11.5.10.2 version,

When doing a forecast in the Maintenance Workbench, the following error occurs.

FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-29532


The issue can be reproduced at will with the following steps:
- Go to Enterprise Asset Management > Work Order Planning > Maintenance Workbench
- Enter Asset Number
- Press button Launch -> error can be displayed here
- In the Maintenance Workbench press button 'Forecast work' (lowest of the three buttons on the left hand side)
- Select Forecast Work > All Assets -> Asset Number inserted
- Enter values for: Set Name, Start Date, Cutoff Date, tick the three checkboxes on the upper-right
- Press button Simulate -> error can be displayed here


Changes

Upgraded to 11g database as well as applied EAM patches

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