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.