FRM-40735 and ORA-01403 Error Occurs When Primary Qty Reserved Value Is Updated

(Doc ID 2269457.1)

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:

  1. Navigate to WIP > WIP > Discrete> Discrete Jobs
  2. Query a job.
  3. Click Sales Order button.
  4. 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