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