Funds Capture Process Manager> Authorization: Missing IN Or OUT Parameter At Index Oracle.jbo.SQLStmtException: JBO-27122: SQL Error
(Doc ID 2809207.1)
Last updated on JULY 11, 2022
Applies to:Oracle Payments - Version 12.2.10 and later
Information in this document applies to any platform.
In Funds Capture Process Manager > Home > Authorizations, when opening authorization details it fails with error
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: select ieb.bank_account_type as DAcctType, ieb.iban_number as DIBAN, ieb.bank_name as DBankName,ieb.BANK_BRANCH_NAME as DBranchName, ieb.BRANCH_NUMBER as DBranchNumber, ieb.eft_swift_code as DBIC,ieb.BANK_ACCOUNT_NUMBER,ieba.MASKED_BANK_ACCOUNT_NUM as UMBankAccountNumber,ieba.MASKED_IBAN as UMIbanfrom iby_ext_bank_accounts_v ieb, iby_ext_bank_accounts iebawhere 'MASKED'=trim(:mask_disp)AND ieb.EXT_BANK_ACCOUNT_ID = nvl(:3, ieb.ext_bank_account_id [...]
The issue can be reproduced at will with the following steps:
1. Navigate to Responsibility: Funds Capture Process Manager > Home > Authorizations
2. Open one authorization record
3. Authorization detail fails with error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document