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

Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
11
Views
2
Comments

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

  • sankb99
    sankb99 Rank 3 - Community Apprentice

    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;

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    thanks for your response.

    Have you modified the OOTB mapping to include the bank details?