ORA-04025 - Cursor leaks and Business Object leak when FINS Requirement Manager is intensive used.
(Doc ID 2752048.1)
Last updated on APRIL 05, 2021
Applies to:Siebel CRM - Version 17.0 [IP2017] to 21.3 [Release V17]
Information in this document applies to any platform.
On invocation of below scenario:
- use workflow to invoke FINS Requirement Manager business service, method RunRequirementTemplate for generating documents
the 'FINS Requirement Template' Business Object is leaking with its BCs:
FINS Requirement Template Item - Common
FINS Siebel Record Related Item - Common
Those business objects have been registered with the model and so when logging out they will be cleaned up for the number of iterations of the scenario.
Check the Application Object Manager for Business Object leak:
ObjMgrSessionLog Debug 5 xxx Business Object leak: FINS Requirement Template
and then followed by the deletion of the BCs like :
BusComp "FINS Requirement All Template - Common" at xxx was deleted.
This should close the corresponding cursors except for one which will be put in the cursor cache. In heavy environments this could lead to open cursor leak behavior and ORA-04025 error.
Use FINS Requirement Manager functionality along with database connection pooling.
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