R11 UNABLE TO UPLOAD VIA THE WEB ADI INTEGRATOR WHEN MORE THAN 500 EXPENDITURE RECORDS ARE PROCESSED (Doc ID 1064513.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Project Costing - Version 11.5.1 to 12.0.6 [Release 11.5 to 12.0]
Information in this document applies to any platform.

Symptoms

We are unable to upload via the Web ADI Integrator when more than 500 records are processed.
The BNE LOG file shows:

1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.executeQuery: Exception while running query. Error Code: 604, Message: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.executeQuery: Query: SELECT CONCATENATED_SEGMENTS,CODE_COMBINATION_ID FROM GL_CODE_COMBINATIONS_KFV WHERE CHART_OF_ACCOUNTS_ID = (SELECT GL.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS GL,PA_IMPLEMENTATIONS IMP WHERE IMP.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID AND IMP.ORG_ID = :1) AND CODE_COMBINATION_ID = '131561' ORDER BY 1 ASC
1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.executeQuery: Args : 83
1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.executeQuery: Stack trace: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:810)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at oracle.apps.bne.utilities.sql.BneBaseSQL.executeQuery(BneBaseSQL.java:1535)
at oracle.apps.bne.utilities.sql.BneBaseSQL.getFirstRow(BneBaseSQL.java:617)
at oracle.apps.pa.webadi.integrator.validators.PaCreditCodeComboIdValidator.validateColumn(PaCreditCodeComboIdValidator.java:166)
at oracle.apps.bne.integrator.upload.BneFineValidator.runValidatorMethod(BneFineValidator.java:1005)
at oracle.apps.bne.integrator.upload.BneFineValidator.validateColumns(BneFineValidator.java:683)
at oracle.apps.bne.integrator.upload.BneSAXUploader.processDeepestLevel(BneSAXUploader.java:2192)
at oracle.apps.bne.integrator.upload.BneSAXUploader.startElement(BneSAXUploader.java:1170)
at oracle.xml.parser.v2.XMLContentHandler.startElement(XMLContentHandler.java:181)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1280)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:328)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:295)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:230)
at oracle.apps.bne.integrator.upload.BneUploader.processUpload(BneUploader.java:301)
at oracle.apps.bne.integrator.upload.BneAbstractUploader.processUpload(BneAbstractUploader.java:109)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadThread.run(BneAsyncUploadThread.java:139)




And further errors show:


1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.forceBatchExecute: Exception while running executeBatch. Error Code: 1000, Message: ORA-01000: maximum open cursors exceeded

1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.forceBatchExecute: Query: INSERT INTO PA_TRANSACTION_INTERFACE_ALL(EXPENDITURE_TYPE,TASK_NUMBER,TRANSACTION_SOURCE,ACCT_RAW_COST,PROJECT_NUMBER,GL_DATE,ATTRIBUTE9,
ATTRIBUTE8,ATTRIBUTE7,ATTRIBUTE6,ATTRIBUTE5,ORG_ID,ATTRIBUTE4,DENOM_BURDENED_COST,ATTRIBUTE3,ATTRIBUTE2,ATTRIBUTE1,
EXPENDITURE_ENDING_DATE,PERSON_BUSINESS_GROUP_NAME,BATCH_NAME,ORGANIZATION_NAME,QUANTITY,CR_CODE_COMBINATION_ID,
ORIG_TRANSACTION_REFERENCE,DENOM_CURRENCY_CODE,DR_CODE_COMBINATION_ID,ATTRIBUTE10,ATTRIBUTE_CATEGORY,EXPENDITURE_ITEM_DATE,SYSTEM_LINKAGE,DENOM_RAW_COST) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31)
1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.forceBatchExecute: Args : 301-Sr line, 99, Data Conversion, 4756.55, 0100108, 2009-12-16 00:00:00.0, null, null, null, null, null, 83, null, null, null, null, null, 2009-12-20 00:00:00.0, null, CONV Back, 011077-O, 1, 131583, 1, null, 131583, null, null, 2009-12-16 00:00:00.0, null, 4756.55
1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneBaseSQL.forceBatchExecute: Stack trace: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3649)
at oracle.apps.bne.utilities.sql.BneBaseSQL.forceBatchExecute(BneBaseSQL.java:1710)
at oracle.apps.bne.integrator.upload.BneSQLUpload.shutdownUpload(BneSQLUpload.java:377)
at oracle.apps.bne.integrator.upload.BneSAXUploader.shutdownUpload(BneSAXUploader.java:2701)
at oracle.apps.bne.integrator.upload.BneSAXUploader.endElement(BneSAXUploader.java:1598)
at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1310)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:328)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:295)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:230)
at oracle.apps.bne.integrator.upload.BneUploader.processUpload(BneUploader.java:301)
at oracle.apps.bne.integrator.upload.BneAbstractUploader.processUpload(BneAbstractUploader.java:109)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadThread.run(BneAsyncUploadThread.java:139)

1/4/10 1:39 PM Web ADI Upload Job 12015 ERROR BneSQLUpload.shutdownUpload() The following exception occurred: oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement.
at oracle.apps.bne.utilities.sql.BneBaseSQL.forceBatchExecute(BneBaseSQL.java:1721)
at oracle.apps.bne.integrator.upload.BneSQLUpload.shutdownUpload(BneSQLUpload.java:377)
at oracle.apps.bne.integrator.upload.BneSAXUploader.shutdownUpload(BneSAXUploader.java:2701)
at oracle.apps.bne.integrator.upload.BneSAXUploader.endElement(BneSAXUploader.java:1598)
at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1310)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:328)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:295)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:230)
at oracle.apps.bne.integrator.upload.BneUploader.processUpload(BneUploader.java:301)
at oracle.apps.bne.integrator.upload.BneAbstractUploader.processUpload(BneAbstractUploader.java:109)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadThread.run(BneAsyncUploadThread.java:139)



.

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