Claims Autopay Is Erroring As It Cannot Process A Decrease Budget Adjustment (Doc ID 2131676.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

Trade Management > Claims >

Trying to run claims autopay, but receiving error due to negative amount from adjustment.

1.The offer code I gave was created via conversion
2.Accrual adjustment (Decrease) was done to bring the remaining accruals as
part of conversion for the offer (There was negative adjustment done to bring
the offer to accrual balance.) To bring the accrual to some 300 EUR.
3.Then POS was loaded
4.Eligibility criteria matched for that offer
5.Again accrual happened more
6.In total we have all positive accruals for that accrual

Claim got created for that offer via manual it works fine
but auto pay process is not recognizing the positive accruals lying in offer
utilization table it considering that one negative adjustment done as part of
conversion.

Please note utilization table for the sample auto pay offer has positive and
one negative adjustment lines but auto pay only looking at negative and not
looking at positive




OZFAUTOPAY module: Claims Autopay
+---------------------------------------------------------------------------+

Current system time is 04-MAY-2015 10:53:50

+---------------------------------------------------------------------------+

**Starts**04-MAY-2015 10:53:51
**Ends**04-MAY-2015 10:54:02
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Operating Unit: Europe Operations OU
-----------------------------------------------------
/*--- Start AUTOPAY for customer XXXXXXXXXXXXXXXXXXXX ---*/
---------------------------------
Line 1: Amount=-2.35
Plan Type : OFFR
Plan Id : 100000634
Product Level Type: FAMILY
Product Id : 9474
NP l_total_acctd_amount_rem : 0
NP l_amount : -2.35
---------------------------------
Line 2: Amount=5.3
Plan Type : OFFR
Plan Id : 100000634
Product Level Type: PRODUCT
Product Id : 20169051
NP l_total_acctd_amount_rem : -2.35
NP l_amount : 5.3
---------------------------------
Line 3: Amount=112.5
Plan Type : OFFR
Plan Id : 100000634
Product Level Type: PRODUCT
Product Id : 20172740
NP l_total_acctd_amount_rem : 2.95
NP l_amount : 112.5
---------------------------------
Line 4: Amount=100.7
Plan Type : OFFR
Plan Id : 100000634
Product Level Type: PRODUCT
Product Id : 20192095
NP l_total_acctd_amount_rem : 115.45
NP l_amount : 100.7
---------------------------------
Line 5: Amount=134.67
Plan Type : OFFR
Plan Id : 100000634
Product Level Type: PRODUCT
Product Id : 20195472
NP l_total_acctd_amount_rem : 216.15
NP l_amount : 134.67
===> Failed.
(1) Cannot Associate negative amount with a positive Accrual.
/*--- End ---*/
 
/*--- Start AUTOPAY for customer XXXXXXXXXXXXXXXXXXXXX ---*/
===> Failed.
(1) The program failed to create claim for XXXXXXXXXXXXXXXXXXXX . The utilization amount must be positive for autopay to create a claim.
/*--- End ---*/

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms