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