PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Select query resulting Zero rows

edited Mar 15, 2021 5:51AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 22 commentsAnswered

Hi Team,

SELECT query not resulting expected rows, instead it resulting ZERO rows. If i export and import the tables which are part of the query with <Orignal_Table_Name>_BKP and if ran the query against *_BKP tables...resulting the expected rows.


same query if we ran in R&D systems, getting expected results

Please advise me on this..

Oracle Version : 19c

Environment : Suse Linux 12 SP2


Thanks in Advance!!!

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