PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

TraceMagic 1.2.0.0 does not capture all SELECT statements

edited Oct 31, 2012 6:59AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered
This is my first time using TraceMagic v1.2.0.0 with file <OPID>_hostname.tracesql.

In the tracesql file I see plenty of these statements :

COM Stmt=SELECT PTCUSTOMFORMAT FROM PSUSEROBJTYPE WHERE ........

COM Stmt=SELECT DISPLAYONLY FROM PSOPROBJ A ,PSOBJGROUP........

COM Stmt=SELECT TREE_NAME, SETID, SETCNTRLVALUE, EFFDT, TO_CHAR(EFFDT,'YYYY-MM-DD'), TREE_BRANCH, EFF_STATUS, DESCR, TREE_CATEGORY, TREE_STRCT_ID, VALID_TREE, NODE_FIELDNAME, DTL_FIELDNAME, NODE_RECNAME, DTL_RECNAME, LEVEL_RECNAME FROM PSTREEDEFACCVW ......................

But within TraceMagic -> All SQL Statements tab, these statements are not captured.

Any ideas why this would be the case ?

The SQL statements captured appears to be only tables with prefix PS_*.

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