Behavior of PCM_OP_SUBSCRIPTION_SET_PRODINFO When Setting Purchased_product_t.PIN_FLD_STATUS_FLAGS (Doc ID 2399163.1)

Last updated on DECEMBER 27, 2023

Applies to:

Goal

On : 7.5.0.18.0 version, Subscription Management

Scenario:

1. The purchased_product object has status_flags = 8 (as a result of previous actions and this is a custom value).
2. PCM_OP_SUBSCRIPTION_SET_PRODINFO was executed to override the amount using the input below as an example.

3. The input includes the override flag, the execution was successful, no errors.
4. Upon checking on purchased_product_t, the STATUS_FLAGS column has value = 33554440, instead of 33554432.

Issue:

The user has a batch process which validates this flag to get base amount of the product. As a result of this problem, the user is unable to get correct charge, because the validation code seeks for override flag 33445532 and not anything greater.

Question:

Instead of just setting the status flags to 33554432, it seems the flags were summed up (33554432 + 8 = 33554440) in this case.
When trying PCM_OP_SUBSCRIPTION_SET_PRODINFO with PIN_FLD_STATUS_FLAGS to 8, it replaces 33554440 in the purchased_product_t table.

What should be the correct value of these flags?
 

Solution

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