EBS 11.5 bug:4649123 measures

Bug content: applies To:

Oracle Warehouse management-version:11.5.10.1
Oracle Inventory management-version:11.5.10
This problem can occur to 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 Havi  ng 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 this have multiple lines with the same it EM, there may is multiple Mtl_material_transactions records created after the transaction completes.
(i.e.: A. Perform Misc receipt of an item in LPN A with qty 4. Do another Misc receipt of the another item into LPN B with qty 10; B.create intransit Shipment, entering LPN A-I, then LPN B SECOND; Then C. In the destination org, perform express receipt of LPN B.)

Receiving Interface Errors 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 the log for details.

Column Name interface_transaction_id
Error message WMSINB-18557:LPN validation failed.  Please check the log for details. Or
WMSINB-19139:LPN validation failed. Please check the log for details.

Column Name Unit_of_measure
Error Message Specified The 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 for 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 of your 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 of your 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 of your are trying to perform. Contact your system administrator
cause

As explained in Bug:4649123 Pending/immediate TRX stuck in Rcv_transaction_interface
For the "A", the code lacks a join between rsh.organization_id and wlpn.organization_id so this only shipment going To the certain org are selected (Shipment_num is unique within org). As for case#2, matching logic in receiving preprocessor isn't picking up the right line because document_line_num are 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

Here's what I've encountered in the actual business:
1 input two lines of data in the Po_requisition_lines output interface, the same material
2 input two lines of data in the Po_requisition_lines output interface, the material is different

After approval, do the following in EBS
1 Import internal requisition into sales order by running "Create internal orders" and "Order Import" requests

2) Carry out sales order delivery confirmation, run the "Connecting Trip station"

3) through the Rcv_transactions_interface to automatically receive warehousing operations, specific code reference EBS practice-PO internal application to automatically receive storage

After you import the interface table, run the Receive transaction processor request, and for both of these cases, the following results appear:

1) in Rcv_transactions_interface for Document_line_num attached value, Document_line_num = Po_requisition_lines.line_num

1, when the same internal application only one item (a line or more lines), automatically receive warehousing processing is completed normally

2, when the same internal application includes a variety of materials, automatic receipt of warehousing processing failed to view po_interface_errors, the error message is: Invalid transaction type

2) does not attach value to Rcv_transactions_interface

1. When there is only one item in the same internal application (a line or more lines), the automatic receipt of the storage failed, view po_interface_errors, error message: No data found
2, when the same internal application includes a variety of materials, automatic receipt of warehousing processing normal completion

Find the reason on the matelink and find that the above bug content is similar to what I encountered. Then the interface data is studied, and it is found that the document_line_num should be corresponding to the line_num in the Rcv_shipment_lines table, and the relevant data should be corrected (Document_line_num = Rcv_shipment_ Lines.line_num), for testing, both of the above conditions can be normal to receive storage, without patch repair.