rvtptcontrol failed rvtth-&ERP_NUMBER

（1）
select *
from apps.rcv_shipment_headers rsh
where receipt_num='20111069117'
rsh.RECEIPT_NUM='20226'
--接收单号
（2）
select *
from apps.rcv_transactions rt
where rt.SHIPMENT_HEADER_ID =26265399
--shipment_header_id
（3）
select *
from   apps.mtl_txn_request_lines mtr
where txn_source_id=40237300
--rt的transaction_id

 

（4）
select *
from   apps.mtl_txn_request_lines mtr
where reference_id= 782340
--line_location_id
and reference ='PO_LINE_LOCATION_ID'
（3）和（4）应该没有记录。此时做不了退货和交货。
解决方法
For 11i:
1. Download and apply Patch 4369686 on a test instance which will provide the datafix script, invinbup.sql.
2. Verify the following file version:

 

 invinbup.sql 115.10.115100.3
（最好是这个版本，以前的版本有bug）
---------------------------

 

如果低于版本115.10.115100.3，会产生版本控制的问题
   Similar to case #1, but the original version of the script to create the move orders did NOT handle non-revision controlled items correctly.  In the inbound upgrade script, invinbup.sql, if the item is not revision controlled, but the receipt is stamped with a revision (in item_revision), the move order program (create_mo) fails because of a control mismatch. The script has been corrected in newer versions invinbup.sql 115.10.115100.3 and higher.

 

接收的时候，虽然物料为inactive，但是由于之前审批的po中物料选择了版本如：下面的物料有版本A
  

 

那么接收的时候，物料有版本控制。

 

但是物料改为active后，并没有启用版本
  

 

这就会造成低版本sql处理不成功（运行成功，但是没有效果）

 

-----------------------------
3. If you apply the patch, it should automatically run invinbup.sql.However, if you already had the script, you will have to manually run the SQL.
   a.运行sqlplus
   b.Sql>@$INV_TOP/patch/115/sql/invinbup.sql

 

c.系统提示：输入接收号
   d.等待完成
 

 

 

1.Bounce Receiving Transaction Manager:

- $ps -ef | grep RCVOLTM (to see how many processes are running)
-Deactivate Receiving Transaction Manager
(System Administrator > Concurrent > Manager > Administer)
-$ps -ef | grep RCVOLTM (repeat until no processes are running)
-Restart Receiving Transaction Manager

2.Set Profile RCV: Processing Mode=Immediate

 

Processing Mode values:
On-line:
This is the most commonly used processing mode. When the user saves a transaction, no other application activity can be performed until the process completes. Either the number of records saved will be indicated for a successful transaction or an error message will be displayed. Uses Receiving Transaction Manager (executable RCVOLTM, located in $PO_TOP/bin).

Immediate:
When the user saves a transaction, the Receiving Transaction Processor concurrent program will automatically start and process the data in the RCV_TRANSACTIONS_INTERFACE table that was created for the Receipt. Control of the form is returned to the User who may then perform other application activity. Transaction errors that occur are written to the PO_INTERFACE_ERRORS table and can be viewed from the Transaction Status Summary. Additional information may be available in the log file for the Receiving Transaction Processor concurrent request (View/Requests). Uses Receiving Transaction Processor (executable RVCTP, located in $PO_TOP/bin).

 

Retest your issue.

If that doesn't help please provide the following information.

3. Please provide the output of the concurrent program " Diagnostics: Apps Check "

Navigation path to run the concurrent request:
Step 1. OM superuser > View > Request > Single Request > Diagnostics: Apps Check
Step 2. Please key in following parameters
Name = Diagnostics: Apps Check
Parameters to enter:
Application 1 = Order Management
Application 2 = Purchasing
Application 3 = Inventory

Please upload the output of Diagnostics: Apps Check concurrent request to this SR.