Retrieve Time from OTL (RCVOTLR) Fails to Process Several Timecards Leaving Stuck Rows in RCV_TRANSACTIONS_INTERFACE (Doc ID 1481415.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Retrieve Time from OTL (RCVOTLR) fails to process several Purchase Order (PO) Timecards. No clear error message is presented explaining why the transaction failed or the record got stuck.

Rows stuck in RCV_TRANSACTIONS_INTERFACE look like the following:

TRANSACTION_TYPE    RECEIVE
PROCESSING_STATUS_CODE    ERROR
PROCESSING_MODE_CODE    BATCH
TRANSACTION_STATUS_CODE    PENDING
UNIT_OF_MEASURE        Hour
INTERFACE_SOURCE_CODE    RCV
UOM_CODE       HR
AUTO_TRANSACT_CODE         DELIVER
DESTINATION_TYPE_CODE    RECEIVING
VALIDATION_FLAG        Y
TIMECARD_ID        nnnn

Since these are Oracle Time and Labor (OTL) related records, they cannot be resubmitted as regular Receiving Open Interface (ROI) Receiving transactions (by rerunning the Receiving Transaction Processor). So related timecards in question must be resubmitted, but new attempts continue to fail and end up as stuck records in Receiving (RCV) interface table.

Steps to Reproduce:

Another symptom maybe that PO Number And Line Number Are Not Required Fields On Purchasing Time Card Layout

Cause

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