Getting Error During Product Cancellation (Doc ID 2522587.1)

Last updated on JUNE 03, 2022

Applies to:

Symptoms

On : 7.5.0.18.0 version, Subscription Management

While executing below flist for cancel product we are getting error saying that valid from not found. It coming in case of change package order

Reproducible steps:

1. Product with the Monthly Cycle Forward event which impacts the Currency resource 48.

2. In parallel have an Non Currency Resource 1000115 which is impacted with the refund amount while cancelling the product( proration set for the product).

3. In production : For example if the initial value of the NCR 1000115 is 5 and if you are impacting -6(refund) amount then its throwing the error reported.

The NCR is set to '0' and no error is thrown.

 The proration setting for the product is based on the requirement for the product charging rules. The issue is happening in production for few change package scenarios (product cancellation) where the non-currency balance is not sufficient as compared to the cancellation refund amount.

Able to reproduce the issue with changing the non-currency balance irrespective of the product prorate configuration.

nap(22532)> r << 1

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 15159175428 0

0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 16383522290 0

0 PIN_FLD_PRODUCTS ARRAY [0] allocated 20, used 3

1 PIN_FLD_QUANTITY DECIMAL [0] 1

1 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 16383522826 0

1 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 13999807059 0

0 PIN_FLD_PROGRAM_NAME STR [0] "test"

0 PIN_FLD_END_T TSTAMP [0] (1547040163) 1

buffer: 1

nap(22532)> xop PCM_OP_SUBSCRIPTION_CANCEL_PRODUCT 0 1

xop: opcode 100, flags 0

# number of field entries allocated 20, used 1

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 15159175428 0

ERROR

Cause

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