FRM-40735 and ORA-01403 Error Occurs When Primary Qty Reserved Value Is Updated
Last updated on MAY 28, 2017
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
On Discrete Job form (WIPDJMDF), Sales Order screen, when Primary Qty Reserved value is changed, following error message is shown.
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403.
The issue can be reproduced at will with the following steps:
- Navigate to WIP > WIP > Discrete> Discrete Jobs
- Query a job.
- Click Sales Order button.
- Update Primary Qty Reserved.
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