My Oracle Support Banner

FRM-40735: POST-QUERY Trigger Raised Unhandled On Modifier Using Item Category (Doc ID 2677288.1)

Last updated on JUNE 09, 2020

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Modifiers Setup only

Find that below error occurs when 

a) Trying to query existing modifier lines using 'Item Category'
b) Trying to create a new modifier line with 'Item Category'

The issue started after upgrading database to 19c.

Observed that there is a change in the package QP_UTIL with some SQL index optimizer hint added which is causing the variable length going more than 240 chars and it is causing this issue.

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

The issue can be reproduced at will with the following steps:
1. Oracle pricing Manager
2.Modifier > Query modifier > On Modifier Line


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.