新克隆环境无法创建供应商,报供应商名称已存在

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

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

此供应商名称已经存在。 请重新输入。 程序包 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

转载于:https://www.cnblogs.com/huanghongbo/p/5308076.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值