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

Last updated on MARCH 20, 2017

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

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 hundreds of Community platforms