PBCS: Getting Error ORA-00040 (Doc ID 2295562.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A to N/A [Release 11.1]
Information in this document applies to any platform.

Symptoms

Customer is getting the following error:

2017-07-18 19:22:58,711 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0
2017-07-18 19:22:58,712 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END
2017-07-18 19:22:58,712 DEBUG [AIF]: AIFUtil.callOdiServlet - START
2017-07-18 19:22:58,733 INFO [AIF]: EssbaseService.exportData - START
2017-07-18 19:22:58,799 DEBUG [AIF]: appId:5, appType:HPL, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:Y, isFccsLoad:false, isJournalLoad:false
2017-07-18 19:22:58,800 DEBUG [AIF]: LOAD_METHOD:HCM, LOAD_TYPE:DATA, EXPORT_MODE:REPLACE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:true, BATCH_SIZE:10000
2017-07-18 19:22:58,892 INFO [AIF]: cloudServiceType: Planning, Resolved user name for application access: cpatterson
2017-07-18 19:22:59,169 ERROR [AIF]: EPMFDM-140145:Application OPPLAN could not be found on Essbase server
2017-07-18 19:22:59,175 DEBUG [AIF]: Defaulting data load dimension to: Scenario
2017-07-18 19:22:59,175 DEBUG [AIF]: Defaulting driver dimension to: Account
2017-07-18 19:22:59,175 DEBUG [AIF]: dataLoadDim: Scenario, driverDim: Account
2017-07-18 19:22:59,175 DEBUG [AIF]: SELECT * FROM ( SELECT SCENARIO,ACCOUNT,DATA,'"'||ENTITY||','||UD1||','||UD2||','||UD3||','||UD4||','||YEAR||','||PERIOD||'"' "Point-of-View"
  ,'Finance' "Data Load Cube Name" FROM AIF_HS_BALANCES WHERE LOADID = 686 )
PIVOT XML( MAX(DATA) FOR (ACCOUNT) IN (SELECT ACCOUNT FROM AIF_HS_BALANCES WHERE LOADID = 686) )
2017-07-18 19:22:59,179 INFO [AIF]: Creating data file: /u03/inbox/outbox/OPPLAN_686.dat
2017-07-18 19:27:10,473 ERROR [AIF]: java.sql.SQLException: ORA-00040: active time limit exceeded - call aborted

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