Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion HCM Analytics

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Person Id & Person Mailing Address not showing in Person Address PEO in BICC

Received Response
61
Views
2
Comments
S Raj Shekhar
S Raj Shekhar Rank 1 - Community Starter
in Oracle Fusion HCM Analytics

Hello,

HcmTopModelAnalyticsGlobalAM.PersonAM.PersonAddressPVO_Sql.sql


I am trying to fetch the Person Address data from the HcmTopModelAnalyticsGlobalAM.PersonAM.PersonAddressPVO using the BICC. This PVO has all the required fields that I need for my table but the PersonId (PersonDetailsPEOPersonId) and MailingAddressId (PersonDetailsPEOMailingAddressId) are coming as null even if they are provided in the PVO as columns.


When I checked the internal sql query of the PVO, I found that the PersonId has been fetched in the inner custom From clause but has been excluded in the final select clause due to which it is coming empty.

I request the customer support to fix this issue so that person Id is also fetched via this PVO as it is an important linking point to other Person tables to Address tables.

Answers