Error: Unable To Determine The Country Code For The Location Id: 222 And Location Type: Poo (Doc ID 1301152.1)

Last updated on DECEMBER 24, 2015

Applies to:

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

Symptoms

Customer is booking an order in OM and receives the following error in the tax debug log (<Note 417238.1>)

ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()-, p_tax_param_code:INTERNAL_ORG_LOCATION_ID x_tax_param_value:142
get_master_geography(+) B: SEL hz_geography_types: in: p_geography_type=COUNTRY
get_location_table_name(+)B: p_location_type= INTERNAL_ORG
R: x_location_table_name=HR_LOCATIONS_ALLget_location_table_name(-)
get_location_info(+)
Found the location info in cache for location id: 142 for table HR_LOCATIONS_ALL
get_location_info(-)
B: SEL hz_geo_name_ref: in: p_location_id=142, p_geography_type=COUNTRY, x_location_table_name=HR_LOCATIONS_ALL
Found the geography id and geography name info in cache
R: x_geography_id=1, x_gegraphy_code=US, x_geography_name=United States- get_master_geography(-)
ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+
ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()-, p_tax_param_code:POA_LOCATION_ID x_tax_param_value:142
get_master_geography(+) B: SEL hz_geography_types: in: p_geography_type=COUNTRY
get_location_table_name(+)B: p_location_type= POA
get_pos_loc_or_site(+) B: SEL zx_party_types: in: p_party_type=
E: EXC: OTHERS: 100: ORA-01403: no data found
E: EXC: OTHERS: p_party_type= Party type information could not be retrived.
R: x_location_table_name=get_location_table_name(-)
get_location_info(+)
Found the location info in cache for location id: 142 for table HR_LOCATIONS_ALL
get_location_info(-)
B: SEL hz_geo_name_ref: in: p_location_id=142, p_geography_type=COUNTRY, x_location_table_name=HR_LOCATIONS_ALL
Found the geography id and geography name info in cache
R: x_geography_id=1, x_gegraphy_code=US, x_geography_name=United States- get_master_geography(-)
ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+
ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()-, p_tax_param_code:POO_LOCATION_ID x_tax_param_value:222
get_master_geography(+) B: SEL hz_geography_types: in: p_geography_type=COUNTRY
get_location_table_name(+)B: p_location_type= POO
get_pos_loc_or_site(+) B: SEL zx_party_types: in: p_party_type=
E: EXC: OTHERS: 100: ORA-01403: no data found
E: EXC: OTHERS: p_party_type= Party type information could not be retrived.
R: x_location_table_name=get_location_table_name(-)
get_location_info(+)
get_location_info(-)
E: EXC: OTHERS: 100: ORA-01403: no data found
"E: EXC: OTHERS: x_geography_id=,
x_gegraphy_code=, x_geography_name="
Incorrect return_status after calling ZX_TCM_CONTROL_PKG.get_location_country
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