My Oracle Support Banner

How to Remove Failed OTL Receipt and Correction Records From Receiving Interface tables (RTI/RHI)? (Doc ID 1381488.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:RCVOTLR - Retrieve Time from OTL
Executable:RVCTP - Receiving Transaction Processor


Failed Oracle Time and Labor (OTL) Timecards receipt and correction transaction records remain in the in Receiving interface tables (RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE) in Error status. These transaction records are NOT eligible to be deleted in Transaction Status Summary form as described in <Note 303544.1>.
This note describes how to remove these failed records.


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

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