Bundles in Campus Solutions Database
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