Report on selected bank account
SummaryI need to report on the selected/default bank account where a colleague may have more than one in the system
I need to report on the selected/default bank account a person has in the system as my BIP report will bring back both of them if a colleague has two (or more). I've found bugs/knowledge related to this i.e. Doc 2198323.1 suggests this should be possible using SQL, but Bug 23502153 is raised as there's an Enhancement Request in progress to allow the reporting on this from OTBI.
Following the logic provided on the Doc above, I've attached my SQL but this still brings back both bank accounts. Is anyone able to help please? Or is anyone able to confirm if this isn't yet possible before the ER is in place?