When Trying To Create Custom Pricing Context Attribute Error Occurs :ORA-28115: Policy With Check Option Violation In Package QP_SEG_UTIL Procedure Insert_Row
(Doc ID 2992868.1)
Last updated on DECEMBER 20, 2023
Applies to:
Oracle Advanced Pricing - Version 12.2.12 and laterInformation in this document applies to any platform.
Symptoms
When trying to create custom Pricing Context Attribute below error occurs.
ERROR
-----------------------
ORA-28115: policy with check option violation in Package QP_Seg_Util Procedure Insert_Row
The issue can be reproduced at will with the following steps:
1.Go to Oracle Pricing Manager -> Setup -> Attribute Management -> Attribute Linking and Mapping
2.Pricing Transaction Entity: Order Fulfillment
Context Type: Pricing Context
Code: XXXXXX (custom)
Click "Contexts" button
Add new attribute
Changes
Database upgrade to 19c
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |