My Oracle Support Banner

Fusion Applications - Global Payroll - Unable To View Payslip From 'View Attachment' after enabling bursting: QueryTimeout exception: SQL query time exceeds the limit (1800 sec) (Doc ID 2674975.1)

Last updated on JUNE 12, 2023

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.01.0 version

ACTUAL BEHAVIOR
---------------
Unable to see the Payslip from the 'View Attachment' of the Process results after enabling Bursting of Payslips (to be received on email) - No data to display.
In the BIP Job History, there was a 'QueryTimeout exception: SQL query time exceeds the limit (1800 sec). Stopped processing.'


EXPECTED BEHAVIOR
-----------------------
To be able to view the payslip in the 'View Attachment' section.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Generated the Payslips for few employees
2. Click on the View Attachments



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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