Hi Marito,

Find below the query to get supplier bank details:

SELECT ASP.SEGMENT1 VENDOR_NUM
,ASP.VENDOR_NAME
,ASA.VENDOR_SITE_CODE
,HOU.NAME OU_NAME
,IEBA.COUNTRY_CODE
,CBBV.BANK_NAME
,IEBA.BANK_ACCOUNT_NAME_ALT
,CBBV.BANK_NUMBER
,CBBV.BANK_BRANCH_NAME
,CBBV.BRANCH_NUMBER
,CBBV.EFT_SWIFT_CODE
,IEBA.BANK_ACCOUNT_NUM
,IEBA.IBAN
,IEBA.CURRENCY_CODE
FROM AP_SUPPLIERS ASP
,AP_SUPPLIER_SITES_ALL ASA
,IBY_EXTERNAL_PAYEES_ALL IEPAYEES
,IBY_PMT_INSTR_USES_ALL IPIUA
,IBY_EXT_BANK_ACCOUNTS IEBA
,CE_BANK_BRANCHES_V CBBV
,IBY_ACCOUNT_OWNERS IAOWNERS
,HR_OPERATING_UNITS HOU
WHERE IAOWNERS.PRIMARY_FLAG = 'Y'
AND IAOWNERS.EXT_BANK_ACCOUNT_ID = IEBA.EXT_BANK_ACCOUNT_ID
AND IAOWNERS.EXT_BANK_ACCOUNT_ID = IPIUA.INSTRUMENT_ID
AND IEPAYEES.EXT_PAYEE_ID = IPIUA.EXT_PMT_PARTY_ID
AND IEPAYEES.PAYEE_PARTY_ID = IAOWNERS.ACCOUNT_OWNER_PARTY_ID
AND IEPAYEES.SUPPLIER_SITE_ID = ASA.VENDOR_SITE_ID
AND ASA.VENDOR_ID = ASP.VENDOR_ID
AND IEBA.BRANCH_ID = CBBV.BRANCH_PARTY_ID(+)
AND HOU.ORGANIZATION_ID = ASA.ORG_ID;

Above query will list all suppliers bank details:

Supplier Number, Name, Supplier Site Code, Operating unit that belong to supplier site, Country, Bank name, Bank alternative Name (like Arabic Name of the bank), Bank Number, Branch number and name, the swift code, the account number, IBAN, and currency code.

And the list is open to add any other column/s you prefer.

Hello Garcia,

The message of the ORA error is so descriptive it’s pointing the query that causing the issue and the issue it self which is nothing but the sub query returned more than one row and this is not correct specially that you are using “=” operator not logical operator like “IN” or “NOT IN”. It’s up to your requirement.

To find the application URL from the backend use one of the following queries :

SELECT HOME_URL FROM ICX_PARAMETERS;

Result

http://<host.domain:port>/OA_HTML/AppsLogin

OR

SELECT FPOV.PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTION_VALUES FPOV
WHERE FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
AND PROFILE_OPTION_NAME = 'APPS_FRAMEWORK_AGENT'
AND LEVEL_VALUE = 0;

Result

http://<host.domain:port&gt;