My Oracle Support Banner

Unable To Create Subledger Defintion Giving Save Failed Error In Definition Screen (Doc ID 3028210.1)

Last updated on JUNE 14, 2024

Applies to:

Oracle Insurance Accounting Analyzer - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

We are unable to create subledger definition and it is giving error on subledger definition details screen, as from what we have tested its mainly because of select general ledger accounts tab where its not allowing us to select more then 288 general ledger entries/members in the hierarchy any entry once 288 general ledgers are selected is giving an error while saving as save failed error.

Error in fsapps.log

22-05-24 10:07:19,894 GMT AM] [INFO ] [WEB] [FSAPPS] com.ofs.fsapps.subledger.dao.SubLedgerAccountingDAO : saveParseRuleConditions End
[22-05-24 10:07:19,894 GMT AM] [INFO ] [WEB] [FSAPPS] [com.ofs.fsapps.subledger.dao.SubLedgerAccountingDAO : saveSubLedgerRuleCondition] End
[22-05-24 10:07:20,903 GMT AM] [ERROR] [WEB] [FSAPPS] [com.ofs.fsapps.subledger.dao.SubLedgerAccountingDAO : saveSubLedgerAccountDefinition] Exception
java.sql.BatchUpdateException: 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!

In this Document
Symptoms
Cause
Solution
References


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