11/3/11

Why PSQRYSTATS and PSQRYEXECLOG records are not populated always??

PSQRYSTATS and PSQRYEXECLOG records get populated only for queries that are run from PIA i.e., either from Query Manager or Query Viewer.


Find more details about how these records get populated in my previous post: All about PeopleSoft Query Administration


But, why OPRID is not populated for every row in PSQRYSTATS and PSQRYEXECLOG record? The OPRID field gets populated for Private queries only as the OPRID field has no significance for public queries.

2 comments:

  1. Query ran from PIA. Still don't have record in PSQRYEXECLOG

    ReplyDelete
  2. You need to turn on logging for the query in question. This is done on the Query Administration page.

    ReplyDelete

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month