Submit Offline Transactions/Create Settlement Batches Gives PLS-00302: component 'UPDATE_STATUS' must be declared (Doc ID 1477191.1)

Last updated on JANUARY 30, 2023

Applies to:

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
+---------------------------------------------------------------------------+

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.