QPXPRMLS ORA-01406 Error When Using Pricing Attributes On The Modifier Exclusion
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.
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.
ORA-01406 error when using pricing attributes on the modifier exclusion
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.
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