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


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.



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.