Submit Offline Transactions/Create Settlement Batches Gives PLS-00302: component 'UPDATE_STATUS' must be declared

(Doc ID 1477191.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.1.0 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When executing the "Submit Offline Transactions" or "Create Settlement Batches" request, the message "PLS-00302: component 'UPDATE_STATUS' must be declared" is seen within the log file for the request:

IBY_FC_SUBMIT_OFFLINE_TRXNS module: Submit Offline Transactions

.....

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
IBY_TRANSACTIONCC_PKG.insert_other_txn: ENTER
IBY_TRANSACTIONCC_PKG.insert_other_txn: Number of trxns::1
l_ecappTab.COUNT:2
Fetching records for ECAPPID:673
Fetching records for ECAPPID:222
application_short_name:IBY
record counter:4
Crash in inner exception block=ORA-06550: line 1, column 21:
PLS-00302: component 'UPDATE_STATUS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
update_status has been executed for :IBY
application_short_name:AR
Invoking update_status Procedure for the application:AR
record counter:4
AR_ECAPP_PKG.UPDATE_STATUS()+
4
AR_ECAPP_PKG.correct_settlement_error()+
Receipts being processed     Operating Unit
------------------------     --------------
24                           81
26                           81
28                           81
SE_18jul_1                   81
Calling API Reverse_Remittances_in_err
Call ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()+
Call ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover()-
AR_ECAPP_PKG.correct_settlement_error()-
AR_ECAPP_PKG.UPDATE_STATUS()-
update_status has been executed for :AR
Updation of iby_trxn_summaries_all successful
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

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