Difference In Amount During Purchase And Cancellation (Doc ID 2362383.1)

Last updated on JANUARY 23, 2025

Applies to:

Goal

On : 7.5.0.0.0 version, Subscription Management

Scenario :

• The product has monthly cycle forward event and scaled amount of 9.9.
• Then purchasing this product for 90 days with a discount amount 22.20, the sample input flist for OP_SUBSCRIPTION_PURCHASE_DEAL:
  0 PIN_FLD_POID POID [0] 0.0.0.1 /account 11285443 0
  0 PIN_FLD_PROGRAM_NAME STR [0] "Integration Program"
  0 PIN_FLD_END_T TSTAMP [0] (1515654000) Thu Jan 11 02:00:00 2018
  0 PIN_FLD_DEAL_INFO SUBSTRUCT [0] allocated 20, used 5
  1 PIN_FLD_PRODUCTS ARRAY [0] allocated 20, used 11
  2 PIN_FLD_QUANTITY DECIMAL [0] 1
  2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 10095309 0
  2 PIN_FLD_STATUS ENUM [0] 1
  2 PIN_FLD_STATUS_FLAGS INT [0] 0
  2 PIN_FLD_CYCLE_DISC_AMT DECIMAL [0] 22.2
  2 PIN_FLD_PURCHASE_END_UNIT INT [0] 4
  2 PIN_FLD_PURCHASE_END_OFFSET INT [0] 90
  2 PIN_FLD_USAGE_END_UNIT INT [0] 4
  2 PIN_FLD_USAGE_END_OFFSET INT [0] 90
  2 PIN_FLD_CYCLE_END_UNIT INT [0] 4
  2 PIN_FLD_CYCLE_END_OFFSET INT [0] 90
  1 PIN_FLD_NAME STR [0] ""
  1 PIN_FLD_POID POID [0] 0.0.0.1 /deal -1 0
  1 PIN_FLD_END_T TSTAMP [0] (0)
  1 PIN_FLD_START_T TSTAMP [0] (0)
• This results in a balance for this account as 7.5 (29.7-22.2=7.5).
• It results in 0 charge after cancelling the same product after two months, while it is expected to charge 5.

Qn1.  Why is the above behavior observed ?

Qn2.  For the accounts which have already purchased the 'cycle_disc_amt' (fixed discount amount), can it update the purchased product objects with the respective 'cycle_discount' i.e. % discount using PCM_OP_SUBSCRIPTION_SET_PRODINFO ?
 

Solution

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