My Oracle Support Banner

Add Quote Lines to Existing Quote Error: "FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-04062" OR Add Quote Lines to New Quote Error"ORA-01403: no data found" (Doc ID 1556982.1)

Last updated on JULY 11, 2022

Applies to:

Oracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.
QOTHDDET

Symptoms

On : 12.1.3 version, FORMS User Interface

Adding new quote lines to existing quote in Quoting forms, receive error:


Error

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-04062

 

Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Responsibility: Oracle Quoting forms
  2. Navigation: Quotes
  3. Update an existing quote or add new lines to existing quote receive FRM-40735 error

 


OR

Adding new quote lines to new (created) quote in Quoting forms, receive error:

Error

ORA-01403: no data found


Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Responsibility: Oracle Quoting forms
  2. Navigation: Quotes
  3. Create new quote and add new quote lines receive ORA-1403 error



Changes

1. Patches applied
or
2. ASO Hook (ASO_QUOTE_CUHK) customized

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.