Tax Is Overcharged For Min-Max Tax Rule in Oracle Retail Point of Service (Doc ID 1453502.1)

Last updated on AUGUST 07, 2015

Applies to:

Oracle Retail Point-of-Service - Version 13.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Point Of Service (ORPOS) find that tax calculation is incorrect for Min-Max tax rule. For example if we have a threshold tax where tax is 4.625 % for clothing under $110 and 8.625% for clothing over $110. The tax rings correctly for items under $110 but incorrectly for item at $110 or over.

Prerequisites:

1. Run sql script below to set up Min-Max tax rule:

Steps To Reproduce:

1. Ring item 924 having price $20. [Tax of $1 is correctly calculated]
2. Price Override of item 924 to $60. [Wrong tax is calculated]

Actual Result : Tax of $6.60 is wrongly calculated.
Expected Result : Tax of $3.60 must be applied as per Min-Max tax rule.

 

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