Header Ads

  • Recent Post

    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.

    Post Top Ad

    Post Bottom Ad