My Oracle Support Banner

11i: WEBADI - Upload an Accounted Transactions Batch Leads to Exception Name: oracle.apps.bne.exception.BneFatalException - Program error Log File Bookmark: 206198 (Doc ID 438837.1)

Last updated on AUGUST 17, 2018

Applies to:

Oracle Project Planning and Control - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Attempting to upload a batch accounted transactions leads to an error "Exception Name: oracle.apps.bne.exception.BneFatalException - Program error Log File Bookmark: 206198".

After this error, no one can log into the system at all. When users try to log in they get the following error:
"Oracle error &ERRNO: &REASON has been detected in &ROUTINE."
OR
"SQL_PLSQL_ERROR"

From the BNE log the following error is shown:

PM ERROR BneBaseSQL.executeQuery: Exception while running query. Error Code: 1000,       Message: ORA-01000: maximum open cursors exceeded 
PM ERROR BneBaseSQL.executeQuery: Query: SELECT TASK_NUMBER
TASK_NUMBER,TASK_NAME TASK_NAME FROM PA_TASKS_EXPEND_V WHERE PROJECT_NUMBER = :1 AND TASK_NUMBER = '1309' ORDER BY TASK_NUMBER ASC 
PM ERROR BneBaseSQL.executeQuery: Args : EGPKE-Con-BO 
PM ERROR BneBaseSQL.executeQuery: Stack trace: java.sql.SQLException:
ORA-01000: maximum open cursors exceeded

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!


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