EBS Customizations (MOSC)

MOSC Banner

View doesn't pull all modified records as of a certain time

edited Oct 23, 2011 8:51PM in EBS Customizations (MOSC) 1 comment

I'm hoping to find an answer to this question - DBA's and Developers think this is a 'Data' problem, but all of my tests indicate that the data is fine.

I have a view that used to be able to process thousands of records.

Lately it only pulls about 24 records at the most.

The only thing that recently changed is that we upgraded from 10g to 11g.

The intended functionality of this view is to pull everything >= a date_time_stamp field in another table.
I've taken the view and forced a date and time of 10/20/2011 16:00:00 and expect to find over 2500 records. 

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