Bank account issue for supplier.
I am facing issue while fetching supplier bank details from system. A few cases:
1. For some suppliers there is no bank account defined. I am checking in Banking details in supplier setup where there is no bank defined on supplier or site level, but when I query the same supplier in tables:
apps.IBY_EXTERNAL_PAYEES_ALL IEPA,
apps.iby_account_owners IBAO,
apps.iby_ext_bank_accounts IEBA
Data is available and bank account number comes. which is incorrect.
2. If I use iby_pmt_instr_uses_all table in query then no data comes but only 5 suppliers detail comes in data. Whereas there are many supplier for which bank account is defined and is correctly coming.