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.

Goal

BIApps 7.9.6
EBS 11.5.10.2
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.
 




Solution

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
Goal
Solution


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