E-QR: Schedule Query With Output Type = Email And Format = XFORM does not Send the Attachment to Email. (Doc ID 3031371.1)

Last updated on JUNE 26, 2024

Applies to:

Symptoms

When attempting to schedule a PS Query with transformation to Type = Email and Format = XFORM, no output is generated in log output neither is sent as email.

The issue can be reproduced at will with the following steps:
1. Navigate to Reporting Tools > Query > Query Manager.
2. Add a new Query.
3. Select Employees record.
4. Select a few fields (e.g. Emplid, First name , Last name, Job title etc).
5. Save the query.
6. Select edit option.
7. Modify the selected fields, by removing the unique reference of table name from field:
For example A.EMPLID modify it as EMPLID.
Similarly for first name, last name and job title.
8. Go to transformations option.
9. Check the XSLT by clicking on edit.
10. Then select Preview - it will generate the output file as desired.
11. Save the query.
12. Navigate to Reporting Tools > Query > Schedule Query.
13 Set the Type=Email, Format= XFORM, Transformation = XFORM_TEST and fill the distribution email.
14. No output is sent through email.

Changes

 Upgrade to PeopleTools version 8.60.05.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.