Created Associate Earnings to Claim Line too High (Multiple Value) With OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim (Doc ID 747553.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 11.5.10 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Dec-13***


Symptoms

When attempting to associate earnings to claim line by using API, the amount which is associated by using API is a multiplicator by 5 of the claim amount.

Claim Lines need to be Associated to a Specific Offer (Lumpsum) using standard Trade Management (TM) API in below process :

1. Push the Claim transactions in the system via interface process
2. Then associating the earnings
3. Close the Claim.

All of above is done by APIs

To associate earnings to claim lines , a workaround call API process has been provided by Oracle
Support and we did apply it in our custom built process but is still not working properly as
required.

OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim
(1.0 --p_api_version IN NUMBER
,FND_API.G_FALSE --p_init_msg_list IN VARCHAR2 := FND_API.g_false
,FND_API.G_FALSE --p_commit IN VARCHAR2 := FND_API.g_false
,FND_API.g_valid_level_full --p_validation_level IN NUMBER := FND_API.g_valid_level_full
,lc_return_status --x_return_status OUT NOCOPY VARCHAR2
,ln_msg_count --x_msg_count OUT NOCOPY NUMBER
,lc_msg_data --x_msg_data OUT NOCOPY VARCHAR2
,p_claim_id --p_claim_id IN NUMBER
,lr_funds_util_flt --p_funds_util_flt IN funds_util_flt_type);

The above API do associate the earnings for the claim line but the amount being associated is more
than what has been defined for the Claim Line Amount and from the Lumpsum Offer.
(sometomes 5 times more and anyway more than the claim line amount (what it shoudl be )).


Ex.
Lumpsum Offer Header Amount = 1167.25
Lumpsum Offer Line Amount for Item ABC = 1167.25

Claim Header Amount = 466.90
Item = ABC
Qty = 145
Claim Line Amount for Item ABC = 466.90

After API call, the Associated Earnings for Claim Line = 2334.50 which is 5x the amount of the
actual Claim Line amount that has been pushed on the system by interface.


When we tried to manually update the Associated Earnings amount to just 466.90, we received an
error from the UI
- Error The total associated earnings must be the same as or less than the claim line amount.


Attached with this TAR are the data used, Screen shots of the UI having the said Error Results,
code logic and the actual Package procedure utilizing the standard OTM APIs

Error

No error when associating the earnings to claim but at a following step when updating claim lines
with Offer and Item by calling Update Claim Line API

Error message is :

Update Claim Lines Failed
API Return Status:E
The total associated earnings must be the same as or less than the claim line amount.

Error was due from the Assoc Earnings Amount created was greater than the Claim Line Amount due
from STEP#2

Steps To Reproduce:
STEP#1
Create Claim Header
Claim Header was Created successfully

STEP#2
Create Claim Line and at the same time Associate Earnings:

Call Assoc Earning API

OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim
(1.0 --p_api_version IN NUMBER
,FND_API.G_FALSE --p_init_msg_list IN VARCHAR2 :=
FND_API.g_false
,FND_API.G_FALSE --p_commit IN VARCHAR2 :=
FND_API.g_false
,FND_API.g_valid_level_full --p_validation_level IN NUMBER :=
FND_API.g_valid_level_full
,lc_return_status --x_return_status OUT NOCOPY VARCHAR2
,ln_msg_count --x_msg_count OUT NOCOPY NUMBER
,lc_msg_data --x_msg_data OUT NOCOPY VARCHAR2
,p_claim_id --p_claim_id IN NUMBER
,lr_funds_util_flt --p_funds_util_flt IN funds_util_flt_type
);

Results:
Assoc Earnings created successfully

There was no Error at this point but the Product Name (Item Name) and Quantity is not
being displayed on the UI

Assoc Earnings Amount is having a much larger amount that the Claim Line Amount which is
wrong.

END LOOP Claim Lines


STEP#3
Update Claim Lines to set the missing Product Name (Item Name) and Quantity which is not being
displayed on the UI

Call Update Claim Line API

OZF_Claim_PUB.Update_Claim_Line_Tbl(
1.0 --p_api_version IN NUMBER
,FND_API.G_TRUE --p_init_msg_list IN VARCHAR2 := FND_API.g_false
,FND_API.G_TRUE --p_commit IN VARCHAR2 := FND_API.g_false
,FND_API.g_valid_level_full --p_validation_level IN NUMBER :=
FND_API.g_valid_level_full
,lc_return_status --x_return_status OUT NOCOPY VARCHAR2
,lc_msg_data --x_msg_data OUT NOCOPY VARCHAR2
,ln_msg_count --x_msg_count OUT NOCOPY NUMBER
,lt_claim_line_ttype --p_claim_line_tbl IN claim_line_tbl_type
,FND_API.g_false --p_change_object_version IN VARCHAR2 := FND_API.g_false
,ln_error_index --x_error_index OUT NOCOPY NUMBER
);

API Return error status with below messages

Update Claim Lines Failed
API Return Status:E
The total associated earnings must be the same as or less than the claim line amount.

Error was due from the Assoc Earnings Amount created was greater than the Claim Line Amount due
from STEP#2



Changes

As a pre-requisite :
At 11.5.10.2 leval apply <Patch 7553408>
At R12 level apply <Patch 7434587>

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