FRM-40734: INTERNAL ERROR PL/SQL ERROR While Trying to Add Qualifiers to a Modifier

(Doc ID 1969231.1)

Last updated on MAY 31, 2018

Applies to:

Oracle Advanced Pricing - Version 12.2 and later
Information in this document applies to any platform.
Shortname: QPXPRMLS.fmb


On : 12.2 version, Modifiers Setup only

When creating a qualifier, customer/customer name
in Value From if you put % or %NORTH% get error:

FRM-40734: Internal Error PL/SQL error occurred

The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2. Navigate to: Modifier > Modifier Setup
3. Open modifier form
4. Pull up modifier
5. Choose List Qualifiers
6. Enter a record
    customer/customer name/%NT%
7. Get error - FRM-40734: Internal Error PL/SQL error occurred


 Issue is in RDBMS version onwards.



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