Errors When Trying To Query a Modifier - ORA-01403 FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502 (Doc ID 2672453.1)

Last updated on DECEMBER 11, 2023

Applies to:

Symptoms

On : Modifiers Setup

When attempting to query a modifier,
the following error occurs under the modifiers summary tab.

ERROR

  ORA-01403: no data found
  ---------------------------------------
  FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502.



STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2, Navigate to: Modifier > Modifier Setup
3, Query the modifier
4.  Error is shown: ORA-01403: no data found
5. Click Details... (button) for the error message
6. Shows Errors

  ORA-01403: no data found
  ---------------------------------------
  FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502.



ADDITIONAL SCENARIO / SYMPTOMS

Sometimes same error occurs when creating a modifier which includes an item category

Changes

 Recently upgraded database to 19c.

Cause

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