PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

sqlplus query to capture *unchanged and *changed rows only from PSPROJECTITEM

edited Nov 16, 2015 10:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

Hello,

After PeopleSoft project compares the project compare report source and target status gets stored in PSPROJECTITEM table.

During upgrade , we have situation where we are not performing project compare through app designer and re-suing existing definition to import project.

Now we have to tally the number object from ready to get copy to target and to identify number of custom objects. In order to do that I wanted to extract rows from PSPROJECTITEM table for column targetstatus has *unchanged and *changed values. I attempted to use regular expression function but it does not helping much. What is query to extract these rows?

Tagged:

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