Ebus Tax: Sales Order Does Not Reflect The Tax As Per The Tax Rule

(Doc ID 1381151.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Oracle Order Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


On : 12.1.3 version, E-Bus Tax Integration for Order Management

After applying the following patches, Tax calculated on sales order is not as per the Tax Rule.

Patch 12612699
Patch 9544144
Patch 8936101
Patch 11686403
Patch 10179680


Tax Engine is set up for the sales transactions based on Customer parameters.
We can generate the AR Invoices as part of the Contract Billing in Oracle Lease management, as expected, with the Tax values based on Customer Setup.
But using the same customer, while creating the Sales Order in Order Management, does not read the same tax rule but calculate the Tax based on Default rate.

From the Screen Prints of the Invoice attached, the Tax is calculated with ZERO amount as expected in billing.
However, the tax on the sales order is $210.00

But the sales order for this Invoice shows tax amount as 210 which is 21% that is the standard rate for Belgium, the related tax Regime.
The important point here is, the Bill to Customer and the ship to address both are in US, and US is not a tax Jurisdiction considered in our set ups.
So basically this should get into error, rather than picking up the default Tax rate.

The defaulting Rule for the attribute on the line 'Tax Classification Code' is setup to use the API = 'OE_DEFAULT_PVT.GET_TAX_CODE.

We see the following error in the log file:

ERROR
-----------------------
E: unspported category: p_fsc_cat_rec.classification_category= TRX_GENERIC_CLASSIFICATION get_prod_trx_cate_value(-)
fsc_code:
ZX_TDS_RULE_BASE_DETM_PVT: get_fc(-), p_return_status = S, p_error_buffer =
ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value(-), p_return_status = S, p_error_buffer =
ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(+)
ZX_TDS_RULE_BASE_DETM_PVT: evaluate_alphanum_condition(+)
p_Operator_Code: =, p_condition_value:SALES_TRANSACTION, p_trx_value:
ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(-)
condition is false

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created Contract in Oracle Lease Management and Billed.
2. The Invoices generated are picking up the Tax Rule as expected.
3. Used the same customer and created Sales Order in Order Management, it pick up the Default Tax Rate and not the Tax rate based on the Tax Rule.
4. The Debug shows the transaction does not identify the Transaction Business Category - Sales Transaction - when the Sales Order is created.

Changes

 

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