Resubmit pending And Remove Orphan RTI Of ISO/IOT (Doc ID 2641413.1)

Last updated on JULY 15, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.