My Oracle Support Banner

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 [1340] and later
Information in this document applies to any platform.


BIApps 7.9.6
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.