E-QR: Receiving Think-time PeopleCode Event (ViewAttachment) Error When Adding XSLT Transform Then PREVIEW
(Doc ID 2802977.1)
Last updated on OCTOBER 06, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.
Adding XSLT transformations to some Queries generates an error for the PREVIEW feature in Query Manager. Impacts Queries with Prompts that are using this feature but only fails for Preview. However, normal Query execution working.
Called from:QRYXSLT_WRK.QRYXFORMPREVIEW.FieldChange Statement:48
Think-time PeopleCode events such as messages requiring a user response cannot be executed if a SQL update, insert, or delete has occurred in the commit interval. Examples of PeopleCode that invoke update type of SQL includes Process Scheduler, TriggerBusinessEvent, or MarkWorked. A unit of work cannot contain both think-time events and update type SQL.
The issue can be reproduced with the following steps:
1. Reporting Tools > Query > Query Manager
2. Open delivered Query "QA_CS_FA_SLC" and go to the Transformations tab
3. Click "Add XSLT" button
4. Add a "Name" like "tab"
5. Add valid XSLT text and click "OK" button
6. Click "Preview" button
7. Observe "Think-Time" error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document