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.
On: 12.2.9, Tax Related
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
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
p_Operator_Code: =, p_condition_value: 13000, p_trx_value: -99
ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl(-), p_return_status = S, p_error_buffer =
condition is false
Upgrade to 12.2.9
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