Resubmit pending And Remove Orphan RTI Of ISO/IOT
(Doc ID 2641413.1)
Last updated on JULY 15, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
SCENARIO 1
==============
Example for Inter Organization Shipments:
1. Login to Inventory responsibility
2. Transactions => Inter-organization Transfers INVTTMTX form
3. Create Inter-organization Transfer
4. Add more than 4 lines
5. Save and submit the IOT
6. Find the records in the RTI table in RUNNING ONLINE status
Transaction_Type SHIP
Processing_Status_Code RUNNING
Processing_Mode_Code ONLINE
Transaction_Status_Code PENDING
SCENARIO 2
==============
Sometimes Intransit Shipments (from Ship Confirm of Internal Order or Inter-Organization Transfer) are not available to be Received; One of the following errors may occur:
APP-PO-14094: No records meet your search criteria
FRM-40212: Invalid Value for the field SHIPMENT_NUM.
This error will be displayed on the Expected Receipts form if the Issue transaction occurred in the Source/Shipping Org AND
1. There are SHIP unprocessed records in rcv_transactions_interface table as PENDING or ERROR or RUNNING:
select * from rcv_transactions_interface where transaction_type='SHIP' and processing_mode_code='ONLINE';
These records will not be visible on Transaction Status Summary form
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |