PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

nVision performance with drilldowns and report books in 8.52

edited May 28, 2013 12:02PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered
We have seen a continued decrease in performance related to nVision drilldowns and report books. We are looking into the possible corruption of the pstreeselectXX tables based
on various web postings and mos article 608488.1. The mos article states the following:

"The data in the PSTREESELECTXX tables can be purged.  Customers should do this if the data gets out of synch (especially after an upgrade).  Data can be deleted from both PSTREESELECTXX and the control table PSTREESELCTL."

It appears we do have orphaned records based on the following queries:

select count(*) from PSTREESELECT08 where SELECTOR_NUM not in (select SELECTOR_NUM from pstreeselctl);

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