Cannot Input Large Quantity of Values Into Prepayment Model From User Interface (Doc ID 2970138.1)

Last updated on OCTOBER 05, 2023

Applies to:

Symptoms

You cannot input a large Prepayment Model definition from the user interface.  You are using the spreadsheet import for to input values for a large model.  For example, the model uses 39 Reprice Term rows X 240 Expired Term columns.

You can run the export successfully, populate the spreadsheet, and copy and paste the values in the user interface with no problems.  And when you click on Apply, you get a message saying it is successful.  However, when you save and re-open the Prepayment Model, the definition is corrupt.  Not all Reprice Term rows are listed.  Additionally, the data is incomplete in FSI_PPMT_MODEL_HYPERCUBE.

Checking the alm.log in the web layer, the following error exists:

[04-05-23 14:56:18,078 GMT PM] [INFO ] [WEB] select c.column_name COLUMN_NAME from fsi_ppmt_model_hypercube_map c where c.ppmt_mdl_dim_type_cd = (select distinct m.DIMENSION_ID from FSI_M_PPMT_MODEL m where m.POSITION = ? and m.PPMT_MDL_SYS_ID= ?)
[04-05-23 14:56:21,147 GMT PM] [ERROR] [WEB] Exception in execute java.sql.SQLException: ORA-01000: maximum open cursors exceeded

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8.jar:19.3.0.0.0]
.
.
.
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01000: maximum open cursors exceeded

As a result, values are missing from the user interface.

Cause

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