My Oracle Support Banner

FRM-40734: INTERNAL ERROR PL/SQL ERROR While Trying to Add Qualifiers to a Modifier (Doc ID 1969231.1)

Last updated on JULY 12, 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

To view full details, 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 a vibrant support community of peers and Oracle experts.