EBS: 导入物料 --请求错误

库存组织:100,物料编号:100103024419,错误编码:INV_IOI_ERR_IN_PROCESS_ITEM,错误列:INVENTORY_ITEM_ID,错误信息:INVPPROC.inproit_process_item ORA-00001: 违反唯一约束条件 (INV.MTL_ITEM_REVISIONS_B_U2)

 

EBS: 导入物料--请求错误日志

从MTL_INTERFACE_ERROR表找出错误详细信息,

如:MESSAGE_NAME = INV_IOI_ERR_IN_PROCESS_ITEM,

ERROR_MESSAGE = INVPPROC.inproit_process_item: CSTPACOV(1):ORA-01403: 未找到任何数据 

COLUMN_NAME = INVENTORY_ITEM_ID 

TABLE_NAME =  MTL_SYSTEM_ITEMS_INTERFACE

 --*****************************

MESSAGE_NAME = CST_ERR_IN_OI

ERROR_MESSAGE = CSTPACOV(1):ORA-01403: 未找到任何数据

COLUMN_NAME = 空值

TABLE_NAME =  MTL_SYSTEM_ITEMS_INTERFACE

--*********************************

列:INVENTORY_ITEM_ID,INVPPROC.inproit_process_item: CSTPACOV(1):ORA-01403: 未找到任何数据

原因:

程序包 CSTPACOV,不能找到 主组织的 物料类别

 

 

+---------------------------------------------------------------------------+
库存管理系统: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

INCOIN: 导入物料
+---------------------------------------------------------------------------+

当前的系统时间为 31-07-2024 10:27:12

+---------------------------------------------------------------------------+

[31-07-2024 10:27:12]: **Starts**
[31-07-2024 10:27:16]: **Ends**
+---------------------------------------------------------------------------+
FND_FILE 中日志消息开始
+---------------------------------------------------------------------------+
Import Items
--------------------------------------------------------------------------------
Argument 1 (ORG_ID) = 96
Argument 2 (ALL_ORG) = 1
Argument 3 (VAL_ITEM_FLAG) = 1
Argument 4 (PRO_ITEM_FLAG) = 1
Argument 5 (DEL_REC_FLAG) = 1
Argument 6 (PROCESS_SET) = 1
Argument 7 (MODE) = 1
Argument 8 (Gather Stats) = 1
--------------------------------------------------------------------------------
 
+---------------------------------------------------------------------------+
FND_FILE 中日志消息结束
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
未请求任何完成选项。

Output file size: 
0


未打印输出文件,因为:
已禁用此报表的打印选项。
Deleting empty output file.

+---------------------------------------------------------------------------+
已成功完成并发请求
当前的系统时间为 31-07-2024 10:27:16

+---------------------------------------------------------------------------+
posted @ 2024-07-31 20:52  samrv  阅读(22)  评论(0编辑  收藏  举报