Database Administration (MOSC)

MOSC Banner

Report not returning all rows matching criteria

edited Aug 18, 2012 6:48PM in Database Administration (MOSC) 8 commentsAnswered ✓
I have a report that queries a view (memberInfo) on a table (Member). It has been working fine until lately it not returning all rows that match a certain criteria.
For example, when I run the report to return all users who have a certain job title its not returning several users that I can verify are in the 'Members' table matching that criteria. I can run a select statement in SQLPlus and verify that the member matching the jobtitle criteria does infact exist.I exported the report and table to my test envirnment and it works fine there. Any help greatly appreciated, thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center