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 JUNE 16, 2017

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

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