My Oracle Support Banner

How to Use Tax Rules Using Not Equal To Operator (Doc ID 1267188.1)

Last updated on NOVEMBER 11, 2021

Applies to:

Oracle E-Business Tax - Version 12.0.0 and later
Information in this document applies to any platform.


We are actively trying to build up participation in our EBTax community. We'd love your input, ideas, collaboration and solutions to be part of the experience. Check us out at on the E-Business Tax communities page


The objective of this note is to explain the old and current behavior when tax rules using the ‘Not Equal To’ operator are defined.

The tax product supports the ‘Not Equal To’ operator, which is used for the tax condition and tax rules. The ‘Not Equal To’ operator is generally used to define a condition that excludes a single value. The tax rule condition is evaluated as TRUE if the value entered in the transaction is different than the value defined in the condition.


Old behavior:
If the user did not enter the value in the transaction (i.e., left the relevant field as NULL), the system used to evaluate the tax rule condition as TRUE. This was incorrect and not in line with the system design.

Current behavior:
We have modified the rule evaluation process and ensured that the condition is evaluated as FALSE when the value in the transaction is NULL.

We did not modify the rule evaluation process for fiscal classification/registration status/user defined geography rules. If the value is not defined in the fiscal classification/registration status/user defined geography setup, then NULL is treated as a value.

Refer to the following table for the respective file versions.

ScenarioBehavior DescriptionFile version details- 12.1.XFile version
details- 12.0.X
1 Old behavior- NULL is considered a value and the rule is evaluated as TRUE. zxdirulenginpvtb.pls 120.124.12010000.4 zxdirulenginpvtb.pls 120.107.12000000.27
2 General current behavior- NULL is NOT considered a value and the rule is evaluated as FALSE. zxdirulenginpvtb.pls 120.124.12010000.5 zxdirulenginpvtb.pls 120.107.12000000.28


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.