My Oracle Support Banner

Delete a Data Load Rule Gives Error: "ORA-00040: active time limit exceeded - call aborted" Delete a Data Load Rule (Doc ID 2611144.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 18.01.42 and later
Information in this document applies to any platform.


On : NA version, Financial Data Quality Management EE

When attempting to delete a Data Load Rule, it does not get deleted.

There were no errors showing up in the UI.

But the aif-WebApp.log had the following errors -
[2019-11-14T16:48:29.746+00:00] [EPMServer0] [ERROR] [] [oracle.apps.erpi.model] [tid: [STUCK].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: USERID] [ecid: ECID] [APP: AIF#] [SRC_CLASS:] [SRC_METHOD: deleteRule] An error occured while deleting data rule[[
java.sql.SQLException: ORA-00040: active time limit exceeded - call aborted

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(


When a data rule is deleted, we delete all the data associated with it. If the rule is associated with a lot of data, the deletion of data will take time.
On PBCS, Oracle Ops team has implemented resource management limits so the SQL statements that exceed the threshold. It gets terminated with "ORA-40: active time limit exceeded" 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

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