CVB For Up Charges Is Incorrect (Doc ID 2973519.1)

Last updated on SEPTEMBER 15, 2023

Applies to:

Symptoms

The CVB (TSFVFD) seams to be wrongly calculated.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.1 TSFCST (Transfer Cost) - this upcharges represents 100% of the Weighted Average Cost/Acquisition Cost; Include in upcharge indicator='N'
1.2 TSFMKUP (Transfer Markup) - this upcharges represents 20% of the Weighted Average Cost/Acquisition Cost; Include in upcharge indicator='Y'
2 - Created one CVB
2.1 TSFVFD = TSFCST + TSFMKUP
3 - Created a 3rd upcharge
3.1 TSFDUTY (Transfer Duty) - this upcharges represents 10% of the TSFVFD; Include in upcharge indicator='Y'
4 - Added upchages TSFCST, TSFMKUP and TSFDUTY to department 112
5 - Created item 100095001 under department 112, and defaulted upcharges from department 112
5.1 the cost of the item is 10 USD

Expected result: TSFVFD=12; TSFDUTY=10% * 12 = 1.2
Actual result: TSFVFD= 3.6652; TSFDUTY=10% * 3.6652 = 0.3665

Cause

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