We have duplicate banking information for someone with 2 jobs
We have duplicate banking information in Expenses for those individuals with more than one job. In HR, the banking information (DIRECT_DEPOSiT) is kept independently of job. When the bank information is messaged via Integration Broker into expenses, we end up with as many sets of duplicate banking information as the person has jobs.
Technically, for each PS_EX_EE_ORG_DTL record, there is a row for each bank account in Ex_EE_PYMNT_DTL. For instance, if a person has 2 jobs and 3 bank accounts, there will be 6 rows in EX_EE_PYMNT_DTL.
Is this expected behaviour for v9.2? How do you determine which EX_EE_PYMNT_DTL is used for expense payments? This is confusing.