Incorrect Calculation Of Accrual Amount For Splitted Order Lines In Trade Managment (Doc ID 2044349.1)

Last updated on AUGUST 14, 2015

Applies to:

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

Symptoms

In 12.1.3, Incorrect calculation of Accrual amount for split order lines in Trade management

We see the Accrual amount(Adjusted amount) calculated wrongly in OZF_FUNDS_UTILIZED_ALL_B for partial shipments. The Accrual amount gets calculated at the time of booking the line (For the whole quantity)and in addition to the the accrual amount again gets calculated when the line gets split while shipping.

Accruals are posted to GL only while Invoicing as per our profile option setups but the accrual amount gets calculated multiple times whenever the order line get split and a new child line is created.

For Instance if the order quantity is 1000 ($1/each) and the discount rate is 10%. We do shipments partially (500+500).
The Accrual amount will be calculated as 100 first time and after the 1st shipment we again have a accrual amount for 50 which in total 150 but actually for $1000 the accrual amount should be $100.

We give Off-Invoice discount and we have this issue only for partial B2B shipments.

We need to find a solution to get the accrual amount calculation done only once for the total quantity and not for the partial quantity every time when it splits.






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