随笔- 491 文章- 1 评论- 36 阅读- 145万

现象，克隆之后的环境，无法创建供应商，始终报以下错误

创建供应商时，无论输什么供应商名称，都报错：

此供应商名称已经存在。请重新输入。程序包 AP_VENDOR_PUB_PKG 过程 Create_Vendor 中出现错误 ORA-20001:

This Supplier Number already exists. Re-enter. ORA-20001: in Package AP_VENDOR_PUB_PKG Procedure Create_Vendor

原因是因为供应商编号在自动模式下，系统生成的下一自动编号已存在。

设置路径

解决办法：查询当前系统中的最大供应商编号，然后重新设置该值。

CAUSE

The issue is caused by the following setup:
Supplier number is automatic and next available number is less than the number exists suppliers in system.

The following bug was also having the same issue where Oracle Development advised to get the value correctly:
Bug 11693139: UNABLE TO CREATE SUPPLIERS. ORA-20001: IN PACKAGE AP_VENDOR_PUB_PKG PROCEDURE CR

The following SQL identified the invalid / incorrect data:
SELECT supplier_numbering_method, supplier_num_type, next_auto_supplier_num,
MAX(LPAD(segment1, 30, '0')) PADMAX_SUP_NUM
FROM ap_product_setup, ap_suppliers
GROUP BY supplier_numbering_method, supplier_num_type, next_auto_supplier_num;

SOLUTION

To implement the solution, please execute the following steps:

1. Please navigate to Payable System Options set up

2. Change the setup under Supplier Number for Next Available Number to one greatre than PADMAX_SUP_NUM (sql result column)

3. Save the record.

4. Now retest the issue by creating a new supplier.

参考文档

R12 AP模块配置手记

Unable To Create New Supplier due to This Supplier Number already exists. Re-enter. ORA-20001: in Package AP_VENDOR_PUB_PKG Procedure Create_Vendor