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

Symptoms

On : 12.2 version, Modifiers Setup only


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

ERROR
FRM-40734: Internal Error PL/SQL error occurred



STEPS
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


Changes

 Issue is in RDBMS version 11.2.0.3.0 onwards.

 

Cause

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