My Oracle Support Banner

Tax Calculations Issue In OM And AR After 12.2.9 Upgrade not finding zone details. (Doc ID 2822622.1)

Last updated on NOVEMBER 22, 2021

Applies to:

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

Symptoms

On: 12.2.9, Tax Related

ACTUAL BEHAVIOR
---------------

After upgrade to R12.2.9 the relationship for some geography ids are not
found  making Zone_id NULL in the array.     

The rules associated to those locations are affected hence tax is not
automatically calculated.


fnd log listing the following:

 

Returning from HZ_GEO_GET_PUB.get_zone with x_return_status:S x_msg_count: x_msg_data:number of records in x_zone_tbl :0
ZX_TDS_RULE_BASE_DETM_PVT: get_geography_info(-), p_return_status = S, p_error_buffer  =
Number of rows in Zone table : 1
ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(+)
ZX_TDS_RULE_BASE_DETM_PVT: evaluate_numeric_condition(+)
p_Operator_Code: =, p_condition_value: 13000, p_trx_value: -99
ZX_TDS_RULE_BASE_DETM_PVT: evaluate_condition(-)
ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl(-), p_return_status = S, p_error_buffer  =
condition is false

Changes

 Upgrade to 12.2.9

Cause

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
Symptoms
Changes
Cause
Solution
References


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