ACH bank information

Summary:

I customized the “Print Receivables Transactions” report located under
/shared/Financials/Receivables/Bill Presentment.

I would like to add bank information, such as Bank Name, Branch Number, and Bank Account Number—to the RTF template using the existing data model. I added the query below, but it returns NULL values.

Could you please help correct the query

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications is 25D

Code Snippet (add any code snippets that support your topic, if applicable):

Query used:

SELECT 
(SELECT cb.bank_name||'-'||cbb.branch_number||'-'||IBY_EBA.bank_account_num