How to Remove Failed OTL Receipt and Correction Records From Receiving Interface tables (RTI/RHI)?
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
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.
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