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

Last updated on AUGUST 26, 2020

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. Please note that 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: Customer has a batch process which validates this flag to get base amount of the product, and as a result of this problem, the customer is unable to get correct charge, as the customer's codes validation seeks for override flag 33445532 and not anything greater

Question:
Customer noticed that instead of just setting the status flags to 33554432, it seems the flags were summed up (33554432 + 8 = 33554440) in this case.
And 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 behavior 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.