Matrix denorm table limitations in pricing
in Pricing
- We have created condition, result columns in Manage Matrix Classes - Pricing Term Adjustment
- Enabled the date effectivity in matrix class so that we can use date ranges in the matrix
- Create attribute based discount list, our condition+result columns are 12 excluding the date fields
- Now we are reviewing QP_MATRIX_RULES table to get this information and send back to upstream system
- The issue is - table data is not retaining. Example in Discount List fbdi template - if we use value_string5 for Account Number when this gets loaded to base table, its jumping to value_string1
- Oracle agreed that this is a bug. QP_MATRIX_DENORMS_VL table isnt helping bcos our columns are >10
Tagged:
0