My Oracle Support Banner

Fusion Global Payroll : Custom Report Failing with error: SQL query time exceeds the limit (2400 sec). (Doc ID 2472690.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

Custom report failing with the below error:

::JOB_WAIT_TIME_SECONDS{1.2}::JOB_FETCH_TIME_MINUTES{40}::JOB_EXECUTION_TIME_MINUTES{40}::JOB_PRIORITY_COLON_NORMAL::SQL query time exceeds the limit (2400 sec). Stopped processing.::[INSTANCE_ID=bip.bi_serverHA]

 Error is:

[180912_10180000][dp id:1676142158][sch info:JobId:189021[ESS RequestId:913716]]java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

 The custom BI report was using pay_balance_view_pkg.get_balance_dimensions.

STEPS:

1. Extract scheduled to run at a specific time in the 'Submit a flow' task section.

2. Checking on the execution output, the above error is raised.

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
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.