PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Bundles in Campus Solutions Database

edited Apr 1, 2013 3:26PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
Dear Experts,

We are working a PS Campus Solution Systems 9.0 system with PT 8.51 & Oracle database 11.2.0. During our audit we realized that our Vanilla Instance (DEMO) is lacking by huge number of Regs & Tax bundles from that of the Production. We want to sync the Vanilla instance with that of the production. To figure out the  number of bundles that DEMO is lagging behind by PRODUCTION, I used the below Query

SELECT UPDATE_ID, DESCR FROM PS_MAINTENANCE_LOG WHERE UPPER(DESCRLONG) LIKE '%BUNDLE%' AND UPDATE_ID NOT IN (SELECT UPDATE_ID FROM PS_MAINTENANCE_LOG@DEMO_TEST) ORDER BY 2 DESC

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