Oracle AI and Analytics

Rajesh Dhanapal

In HR Analytics (OBIA 7.9.6.3) How to get employees bank account details from Oracle EBS to BAW.

Is there any OOTB mappings already available ?

sankb99

not sure about OOTB mapping but the below query will give you the required details on employee bank detail.

SELECT DISTINCT

  pppmf.assignment_id ,

  pea.segment5 account_name ,

  pea.segment3 sort_code ,

  pea.segment4 account_number ,

  flv.meaning bank_name,

  popmf.org_payment_method_name AS payment_method_name

FROM pay_personal_payment_methods_f pppmf ,

  pay_org_payment_methods_f popmf,

  pay_external_accounts pea,

  hr_lookups hl,

  FND_LOOKUP_VALUES flv

WHERE pppmf.external_account_id = pea.external_account_id

AND pppmf.org_payment_method_id = popmf.org_payment_method_id

AND hl.lookup_type              = '<<provide lookup value here>>'

AND hl.lookup_code              = pea.segment1

AND TRUNC(sysdate) BETWEEN pppmf.effective_start_date AND pppmf.effective_end_date

AND TRUNC(sysdate) BETWEEN popmf.effective_start_date AND popmf.effective_end_date

AND TRUNC(sysdate) BETWEEN NVL(pea.START_DATE_ACTIVE,sysdate) AND NVL(pea.end_DATE_ACTIVE,sysdate)

AND pea.segment1 = flv.lookup_code

AND flv.lookup_type = '<<provide lookup value here>>'

AND flv.enabled_flag = 'Y'

AND NVL (flv.end_Date_Active, SYSDATE + 1) > SYSDATE

order by pppmf.assignment_id;