RCVRCERC: Receipts Fail with No Errors
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
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.
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:
PROCESSING_MODE_CODE = ONLINE or BATCH or IMMEDIATE
TRANSACTION_STATUS_CODE = PENDING
PROCESSING_STATUS_CODE = ERROR
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