You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Matrix denorm table limitations in pricing

  1. We have created condition, result columns in Manage Matrix Classes - Pricing Term Adjustment
  2. Enabled the date effectivity in matrix class so that we can use date ranges in the matrix
  3. Create attribute based discount list, our condition+result columns are 12 excluding the date fields
  4. Now we are reviewing QP_MATRIX_RULES table to get this information and send back to upstream system
  5. 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
  6. Oracle agreed that this is a bug. QP_MATRIX_DENORMS_VL table isnt helping bcos our columns are >10
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!