Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
In HR Analytics (OBIA 7.9.6.3) How to get employees bank account details from Oracle EBS to BAW.

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 ?
Answers
-
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;
0 -
thanks for your response.
Have you modified the OOTB mapping to include the bank details?
0