RCVRCERC: Receipts Fail with No Errors (Doc ID 351306.1)

Last updated on SEPTEMBER 05, 2014

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
This problem can occur on any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI
FORM:RCVTXVTX.FMB - View Transactions Status GUI
EXECUTABLE:RVCTP - Receiving Transaction Processor

Symptoms

Transactions intermittently fail, but there is no corresponding error. Transaction Status Summary form shows the records as PENDING, but rcv_transactions_interface.processing_status_code=ERROR

There are no transactions in PO_INTERFACE_ERRORS.

Log file:
RCV_ROI_PREPROCESSOR 93: Calling explode_lpn
RCV_ROI_PREPROCESSOR 739: Exception in preprocessor:
RCV_ROI_PREPROCESSOR 740: sqlerrm: ORA-06508: PL/SQL: could not find program unit being called

The level 12 trace shows:
 shared_pool_reserved_size   31457280
 shared_pool_size    318767104

Records are stuck in rcv_transactions_interface table:

PROCESSING_MODE_CODE = ONLINE or BATCH or IMMEDIATE
TRANSACTION_STATUS_CODE = PENDING
PROCESSING_STATUS_CODE = ERROR

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