My Oracle Support Banner

Combination Operator MIN is not Working Properly for the PO Assessment with CVB (Doc ID 2220411.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.0.1 and later
Information in this document applies to any platform.


The cost components associated with the CVB [Computation Value Bases] are not being compared correctly during the calculation process to determine the appropriate value for the assessment.

Steps to Recreate:

1. Using the Assessment and CVB, create a PO:
    a. item = xxxxxxxx
    b. loc = xxxx
    c. supplier site = xxxx
    d. dept = xxxx
    e. quantity = 1

The CVB must have '<' in its combo_oper field in the CVB_HEAD table.

2. Click item in the Purchase Order(PO) window to add the item and the quantitiy and click OK. Select the Item and from Options, choose Harmonized Tariff Schedules(HTS).
3. Make sure that the Import Country of the Cost Component is the same as the PO so attach the assessment.
4. Update the combination operator manually in the Database to ‘<’ for the minimum value and click Recalculate on the Form.
5. Unit cost of the item is 10.
The value of TDTYUS1 will be 10% of the minimum cost component attached to it (TDTYUS1) and is attached to the item which is DTYUS2 with 0.8. So, Total US Duty Sample CVB = 10% of (DTYUS2)
= 10% of (8% of unit cost)
= 10% of (0.8)
Total US Duty Sample CVB = 0.08 but return 0.00





To view full details, sign in with your My Oracle Support account.

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

In this Document

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