My Oracle Support Banner

Not Able To Add Or Update Discount Line To The Offer In Trade Management (Doc ID 2727671.1)

Last updated on NOVEMBER 18, 2022

Applies to:

Oracle Trade Management - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Offers

Not able to add or update discount line to the offer in Trade Management where the offer / modifier was created in Advanced Pricing.

1) Created Off Invoice Offer with few Item categories.
2) Added ALL ITEMS to the Offer with Modifier Type as Surcharge.
3) Tried to add another discount line to the offer via UI but encountered the below error.

Error Messages
  1. p_modifier_line_tbl.COUNT :1
  2. calling process_qp_list_lines
  3. in process_qp_list_lines
  4. in process_regular_discounts
  5. p_modifier_line_tbl(j).start_date_active
  6. p_modifier_line_tbl(j).end_date_active
  7. calling qp pub from process_regular_discounts
  8. return status of qp pub from process_regular_discountsE
  9. v_modifiers_tbl.COUNT0
10. You cannot change the Modifier Type.

4) We are able to add discount line to the Offer via Advanced Pricing Modifier but not able to add it from the UI.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.