QPXPRMLS ORA-01406 Error When Using Pricing Attributes On The Modifier Exclusion (Doc ID 2199217.1)

Last updated on NOVEMBER 02, 2016

Applies to:

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

Symptoms

 
Have additional item categories created as custom pricing attribute under the ITEM context. These attributes work fine when used on the modifier line to setup discounts/surcharges. However, if try to exclude items from a modifier using the custom attribute receive an error message  It works fine when the value is first entered but when trying to query the modifier the error message appears and when checked the exclusion tab the line had disappeared.This is causing the modifier to become unusable.

ERROR
-----------------------
ORA-01406 error when using pricing attributes on the modifier exclusion

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Pricing Manager
2. Modifiers/Modifier Setup
3. Query Modifier - ASTEST2
4. ORA-01406 error when using pricing attributes on the modifier exclusion
5. click ok and click on the exclude tab the error message appears again.
6. Can create the exclusion record everything looks good and I am able to save the record. It's when I come back to the modifier do I start seeing the issue.


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