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 APRIL 19, 2018

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


Goal

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.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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