Error During RTV APP--20110: Encountered the error in trigger JAI_RCV_RT_BRIUD_T1ORA-06508: PL/SQL: could not find program unit being called

(Doc ID 2258782.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Financials for India - Version 12.2.4 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Inventory Transactions

When attempting to run Trip Stop Interface from Order Management for sales order 6011697, the following error occurs.

ERROR
-----------------------
InterfaceTripStop: processing stop_id 1635498 for INV
MTL_ONLINE_TRANSACTION_PUB.process_online returns false
Error Code:Transaction processor error
Error Explanation:
Retrieving messages from the stack
InterfaceTripStop: Stopping because of ERROR.
InterfaceTripStop: total stops processed: 1


NOTE: There are no records stuck in mtl_transactions_interface table.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From OM > Run Trip Stop Interface for order 6011697

The process fail as mentioned above.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The customer is unable to perform RTV transactions. They currently has about 20 transactions pending due tot his issue.
This will affect month end, year end, and perhaps raise a flag during external audit.

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