Promotion Attribute Cancellation With Action Cancel Change Incorrect Calculated (Doc ID 2664843.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Symptoms

Loyalty Promotion Attribute is not updated as expected when a Transaction is cancelled. The reverted attribute value was incorrectly calculated once Transaction is cancelled.

Make sure that an Accrual Promotion already exists.

1- Create Promotion Attribute

Loyalty Promotions Administration > Promotions> Promotion Specific Attributes

Name: spentvalue

Field: Number 1

Data Type: Number

Cancel Action: Cancel Change

2- Create ABC Bucket Test Promotion (Rule Model = Hierarchy)

Promotion > Rules:

Promotion Rule 1: check_txn_and_update ( apply to Transactions)

Criteria: check_points> [Transaction.Field.Points] > 0

Action: update_spentvalue > Update Attribute > spentvalue = [Promotion.Field.Number 1] + [Transaction.Field.Points]

Promotion Rule 2: check_attribute_and_assign (apply to Attributes)

Criteria: promo_atrrib_check > [Promotion.Field.Number 1] >= 1500

Action:

1 - assign_points_spent > Assign Points = Point Type: "test" > Add 1500

2 - subtract_spentvalue > Update Attribute > spentvalue = [Promotion.Field.Number 1] - 1500

3) Test: Member:Bucket Test

a. Create new txn and Assign 1000 points (1-2ZOFI)

Processing Info:

b. Create new txn and Assign 769 Points (1-2ZOG9)

Processing Info:

b1. In the Processing Info View > Member Attributes Applet, it shows ABC Bucket Test > Promotion Attribute Id 1-4967510 = 1,769

b.2 In the Processing Info View > Member Promotion attribute Applet, click "Process" to process the bucket.

Result: ABC Bucket Test > Promotion Attribute Id 1-4967510 = 269 as expected (1769 - 1500)

 d. Now create new txn for 5 points (1-2ZOH6)

Processing Info:

ABC Bucket Test > Promotion Attribute Id 1-4967510 = 274

e.  Make sure that you have Cancellation Promotion, if not create one as below:

 Name: ABC Cancellation Promotion (Apply To - Cancellation)

Name: base_cancellation_rule_1

No criteria

Actions:

1 Name: base_cancel_action_txn_1 > Type – Cancel Transaction

2 Name: base_cancel_action_attribs_2 >  Type – Invoke Custom Action> Method: CancelTxnAttributes

f. Cancel above TRANSACTION of 5  (1-2ZOH6)

A New Redemption Transaction is created with Base Points = 5

Processing Info:

 g. A Redemption Cancellation Transaction is created, Process it:

Processing Info:

Changes

Cause

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