My Oracle Support Banner

FRM-40735 and ORA-01403 Error Occurs When Primary Qty Reserved Value Is Updated (Doc ID 2269457.1)

Last updated on AUGUST 20, 2021

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.


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

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