You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Not able to get AR Customer contact information in case of multiple sites

Summary:

I am trying to fetch AR Customer contact information which is displayed on Oracle Fusion screen. In case of multiple sites with each site having it's each contact person, I am getting cross joins between tables and not able to fetch the correct data. These type of customers do not have data in HZ_CONTACT_POINTS table for their corresponding sites. Hence, I am finding no way to join the contact person with the individual site.

With below query, in case of multiple sites with each site having it's individual contact person, I am data with cross join

SELECT hp.party_name

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!