Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

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

Create Primary Mailing Address Column

Accepted answer
36
Views
3
Comments
User_RD03L
User_RD03L Rank 4 - Community Specialist
in Oracle Fusion HCM Analytics

Hello,

We're trying to create BIP Report that that extracts all employees address. One of the requirement is to create
Primary Mailing column, output values should be (Y/N) to check if employees address is primary or not.

Our SQL uses PER_ALL_PEOPLE_F, PER_ADDRESSES_F and PER_PERSON_ADDR_USAGES_F but we haven't figured out yet on how
to create this condition in the Primary Mailing column.

Any help would be appreciated, thank you!

Tagged:

Best Answer

Answers

  • bmanikan
    bmanikan Rank 1 - Community Starter

    the mailining address ID on Per All People if present is your primary email address. The address usage has the person id to link to per all people f and the address and address usage can be linked using address id.

  • User_RD03L
    User_RD03L Rank 4 - Community Specialist

    Hello guys,

    Thanks for your help!