Payables and Cash Management - EBS (MOSC)

MOSC Banner

Bank account issue for supplier.

edited Jan 13, 2018 4:00AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center