ebs解决在创建销售订单时如果客户是塞尔维亚国家抛unable to determine the country code for the location id:798 and location错误

APPLIES TO:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.

SYMPTOMS

On :  12.1.1 version, Transaction Entry

When attempting to save the sales order.
the following error occurs.

ERROR
-----------------------
unable to determine the country code for the location id:798 and location type: BILL_TO


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a sales order, and the customer country is The Republic of Serbia
2. Save the sales order

CAUSE

Tables un-synchronization


The details can be found in Bug: 7651259: COUNTRY CODE=SERBIA MISSING IN THE GEOGRAPHY HIERARCHY

SOLUTION

Please test the following solution in your cloned test instance:

1. Run ARHGEFTR.sql manually from sqlplus,

The path: 
patch/115/sql/ ARHGEFTR.sql
注：

文件在$AR_TOP/patch/115/sql目录

在app服务器执行sqlplus连接数据库

执行ARHGEFTR.sql文件
2. Then check if the issue can be fixed.