Sales Order Import Error: An unexpected error has occurred. Please contact your system administrator.

(Doc ID 2347849.1)

Last updated on JANUARY 11, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, when attempting to run Order Import, for a few Orders, the following error occurs.

ERROR
Error: An unexpected error has occurred. Please contact your system administrator.

From tax debug logfile:

ZX.PLSQL.ZX_TCM_GEO_JUR_PKGget_zone Returning from HZ_GEO_GET_PUB.get_zone with x_return_status:U x_msg_count:1 x_ms g_data:The following SQL error occurred: ORA-01403: no data found ORA-01403: no data found.number of records in x_zone_tbl :0

ZX.PLSQL.ZX_TCM_GEO_JUR_PKGget_zone The following SQL error occurred: ORA-01403: no data found ORA-01403: no data f ound.
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 =
ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.evaluate_trx_value_tbl Incorrect return_status after calling get_geography_info(), return_status: U
ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.process_set_condition Incorrect return_status after calling evaluate_trx_value_tbl(), did not get trx value
ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ Incorrect return_status after calling process_set_condition() , p_return_status = U

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