All Receiving Transactions Fail with rvtptcontrol Error

All Receiving Transactions Fail with rvtptcontrol Error

Applies to:

Oracle Application Install - Version: 11.5.10.0 and later.

Oracle Inventory Management - Version: 11.5.1 to 12.1.3

Description:

All Receiving transactions fail with rvtptcontrol. After some research work I found that the error occurs when many transactions fail with same error it is usually because the receiving executables (RVCTP and RCVOLTM) are out of sync.

Solution:

1.      Resolve INVALID Objects

1.1  Set environment

1.2  cd $ORACLE_HOME/rdbms/admin

1.3  sqlplus / as sysdba

1.4  SQL>@utlrp.sql

2.      Relink Receiving executables

2.1  cd $AD_TOP/bin

2.2  sh adrelink.sh force=y ranlib=y "PO RCVOLTM"

2.3  sh adrelink.sh force=y ranlib=y "PO RVCTP"

3        Bounce Receiving Transaction Manager:

3.1  (System Administrator > Concurrent > Manager > Administer)

3.2  Deactivate Receiving Transaction Manager

3.3  ps -ef | grep RCVOLTM (repeat until no processes are running)

3.4  Restart Receiving Transaction Manager

4        Perform transactions and retest the issue

5        If the transaction still fails, bounce the database and then perform another transaction.

6        If bouncing the database or flushing Shared Pool resolves the issue only for a few days (or a few weeks) and bounce database (or flush Shared Pool) must be repeated periodically to resolve the issue, please log a Service Request.

Your comments, especially which will help us improve the functionality, will be greatly appreciated :)