EBS 11.5 Bug:4649123 措施

Bug内容：

Applies to:

Oracle Warehouse Management - Version: 11.5.10.1
Oracle Inventory Management - Version: 11.5.10
This problem can occur on any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor

Symptoms

Mobile Intransit LPN Receipts error and get stuck in RCV_TRANSACTIONS_INTERFACE table if there are multiple shipments having the same shipment number.  (i.e.: Create two internal shipments with different source and destination org with the same shipment_num with packed LPN, then performing receipt of shipment)

The same error occurs when performing direct express receipts against a shipment that have multiple lines with the same item, there may be multiple MTL_MATERIAL_TRANSACTIONS records created after the transaction completes.
(i.e.:  a. Perform Misc receipt of an item into LPN A with qty 4.  Do another Misc receipt of another item into LPN B with qty 10; b.Create intransit shipment, entering LPN A FIRST, then LPN B SECOND; then c. In the destination org, perform express receipt of LPN B.)

Receiving Interface Errors report shows errors as follows:

Error in Shipment Line Information (in RCV_TRANSACTIONS_INTERFACE)
Column Name   INTERFACE_TRANSACTION_ID
Error Message  LPN validation failed. Please check log for details.

Column Name  INTERFACE_TRANSACTION_ID
Error Message WMSINB-18557:LPN validation failed. Please check log for details.  or
                        WMSINB-19139:LPN validation failed. Please check log for details.

Column Name  UNIT_OF_MEASURE
Error Message  Specified Unit Of Measure conversion to primary UOM not defined
                        (SHIPMENT UNIT OF MEASURE = Carton : PRIMARY UNIT OF MEASURE = Each)

Column Name   INTERFACE_TRANSACTION_ID
Error Message  RVSSH-020: ORA-1403: no data found
          Cause:    A SQL error has occurred in RVSSH.  The SQL error is &LSQL_ERR.
          Action:    Take note of both this error number and the actions you were

Receiving Transaction Processor (RVCTP) log shows the generic errors as follows:

Concurrent program RVCTP returned error
Cause:    RVCTP encountered an internal error.  Parameters: RVCTP,IMMEDIATE, 36288,
Action:    Note both this error number and the actions you are trying to perform. Contact your system adm

RVTBM-008: Subroutine rvtbm_immediate_mngr() returned error
Cause:    Subroutine rvtbm_immediate_mngr() returned an internal error.
Action:    Note this error number and the actions you are trying to perform. Contact your syste

RVTBM-120: Subroutine rvtptcontrol() returned error
Cause:    Subroutine rvtptcontrol() returned an internal error.
Action:    Note this error number and the actions you are trying to perform. Contact your system administrator

Cause

As explained in Bug:4649123 PENDING/IMMEDIATE TRX STUCK IN RCV_TRANSACTION_INTERFACE
For the first case, the code lacks a join between RSH.organization_id and wlpn.organization_id so that only shipment going to the certain org is selected (shipment_num is unique within org). As for Case#2, matching logic in receiving preprocessor is not picking up the right line because document_line_num is not being populated in RCV_TRANSACTIONS_INTERFACE when performing IntShip / IntReq receipts.

Solution

Apply Patch:4890926 which upgrades files
$INV_TOP/patch/115/sql/INVRCVVB.pls to version 115.107.115100.24
$INV_TOP/patch/115/sql/INVSTDRB.pls to version 115.164.115100.15

References

BUG:4616373 - Datafix: Pending/Immediate Trx Stuck In Rcv_Transaction_Interface
BUG:4649123 - Pending/Immediate Trx Stuck In Rcv_Transaction_Interface

以下是实际业务中我遇到的现象：
1）在po_requisition_lines输出界面输入两行数据，物料一样
2）在po_requisition_lines输出界面输入两行数据，物料不一样

审批之后，在EBS中进行如下操作
1）通过运行“创建内部订单”及“订单导入”请求将内部申请导入为销售订单

2）进行销售订单发运确认，运行“连接行程停靠站”

3）通过rcv_transactions_interface进行自动接收入库操作，具体代码参考 EBS实践—PO内部申请自动接收入库

 

导入接口表后，运行“接收事务处理处理器”请求，对于以上两种情况，出现以下的结果：

1）在rcv_transactions_interface中为document_line_num附值，document_line_num = po_requisition_lines.line_num

     1、当同一内部申请中只有一种物料（一行或多行）时，自动接收入库处理正常完成

     2、当同一内部申请中包括多种物料时，自动接收入库处理失败，查看po_interface_errors，错误信息为:无效的事务处理类型

2）不对rcv_transactions_interface附值

     1、当同一内部申请中只有一种物料（一行或多行）时，自动接收入库失败，查看po_interface_errors，错误信息为:未找到数据
     2、当同一内部申请中包括多种物料时，自动接收入库处理正常完成

 

在matelink上查找原因，发现以上BUG内容与我遇到的情况类似。于是对接口数据进行研究，发现document_line_num 应该对rcv_shipment_lines表中的line_num对应，进行相关数据修正后（document_line_num = rcv_shipment_lines.line_num），进行测试，以上两种情况均可正常进行接收入库，无需进行Patch修复。