Some Party Sites Are Not Present In W_customer_loc_d
(Doc ID 1367560.1)
Last updated on OCTOBER 01, 2019
Applies to:Human Resources Compensation Analytics - Version 7.9.6  and later
Information in this document applies to any platform.
warehouse DB version - OEL 5.2
middletier DB version - OEL 4.2
Only customer account sites from hz_cust_acct_sites_all are brought in to the warehouse but not those which are party_sites . We want to understand why all locations are NOT brought into warehouse.
Below query shows which locations are not brought into warehouse.
select distinct party_site_id from hz_party_sites minus SELECT distinct party_site_id FROM HZ_CUST_ACCT_SITES_ALL ;
All locations associated with those party sites resulting from above query are not in BIApps warehouse.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document