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
where txn_source_id=40237300
--rt的transaction_id
select *
from
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:
(最好是这个版本,以前的版本有bug)
---------------------------
那么接收的时候,物料有版本控制。
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.
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.