Fusion PIM: Item Import Errors With Java.sql.SQLException: ORA-00040: Active Time Limit Exceeded - Call Aborted (Doc ID 1507263.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Fusion Product Hub - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to import items, the following error occurs in the ESS request log file.

ERROR
-----------------------
JBO-27024: detail error is ora-0040 and is wrapped as JBO-27024
  AttrSetValException: for inventoryItemId
  DML Exception: Error in selecting entity ItemVersionEO
  Ora-00040 Active time limit exceeded

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms