EBS 11.5 Bug:4649123 措施

buhong

　　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修复。