Data access issue with HZ_LOCATIONS table — Cloud Customer Connect
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

Data access issue with HZ_LOCATIONS table

edited Jun 12, 2024 2:50PM in Reporting & Analytics for Sales 2 comments

Summary:

I am trying to troubleshoot an issue with a custom BI Publisher query. The report works just fine for some users, but for other users it never finishes and times out.

It seems the issue is related to the HZ_LOCATIONS table. The part of the query that seems to be having trouble is below. I have noted when running this query as both users and generating an Explain Plan, I get different results for "User 1" vs. "User 2".

For "User 2" there is some filter being applied, which is not involved when run as "User 1":

filter(CASE WHEN NVL("PERSONAL_ADDRESS_FLAG",'N')<>'Y' THEN "STATE" ELSE NULL END ='SC')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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