FRM-40734: INTERNAL ERROR PL/SQL ERROR/Error APP-QP-225701: Legal characters are "0-9"+, "and "-" While Trying to Add Qualifiers

(Doc ID 1969231.1)

Last updated on JULY 14, 2016

Applies to:

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


On : 12.2.3 version, Modifiers Setup only


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

APP-QP-225701: Legal characters are "0-9"+, "and "-"

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/%NORT%
7. Get error -

APP-QP-225701: Legal characters are "0-9"+, "and "-"
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