Autoinvoice fails with get_geography_info Not Found Zone info (Doc ID 1233387.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle Trading Community - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

R12, Autoinvoice errors

The following error is found in the tax debug log file.

X_TDS_RULE_BASE_DETM_PVT: get_tsrm_num_value(-), p_return_status = S, p_error_b uffer =
17240597 27-AUG-10 ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info location_id: 15415
17240598 27-AUG-10 ZX.PLSQL.ZX_TCM_GEO_JUR_PKGget_zone.begin get_zone(+)
17240599 27-AUG-10 ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info Not Found Zone info in cache... call HZ_GEO_GET_PUB.get_zone
17240600 27-AUG-10 ZX.PLSQL.ZX_TCM_GEO_JUR_PKGget_zone The following SQL error occurred: ORA-01403: no data found ORA-01403: no data f ound.
17240601 27-AUG-10 ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_geography_info.END ZX_TDS_RULE_BASE_DETM_PVT: get_geography_info(-), p_return_status = U, p_error_b uffer =

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