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

S Raj Shekhar

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.

Ashish-Oracle

@S Raj Shekhar Since the query is related to Fusion BICCC. Please reach out to the Fusion Community Forum below for accurate answers.

https://community.oracle.com/customerconnect/

S Raj Shekhar

@Ashish-Oracle I think this is the correct forum for asking my question as this was the only forum where BI Cloud Connector(BICC) was available to me as a viable tag option to put into