My Oracle Support Banner

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 SEPTEMBER 30, 2021

Applies to:

Oracle Advanced Pricing - Version 12 and later
Information in this document applies to any platform.
QPXPRMLS.fmb - Modifier Setup Form


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

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.