Post Applying 8.1.2.0.2 patch Optimizer task failed with 'ORA-00904: "REMAINING_EAD": invalid identifier' Error
(Doc ID 3073826.1)
Last updated on MARCH 03, 2025
Applies to:
Oracle Financial Services Basel Regulatory Capital Basic - Version 8.1.2.0 and laterOracle Financial Services Basel Regulatory Capital Internal Ratings Based Approach - Version 8.0.0 and later
Information in this document applies to any platform.
Symptoms
CRM Pooling process failed at Optimizer task with below error.
LOG FILE
-----------------------
Filename = BaselSolver.log
See the following error:
[WEB] [BASELSOLVER] Thread # 1 Insert Processing Results Started
[WEB] [BASELSOLVER] Thread # 1- Insert Statement : INSERT INTO TMP_OPT_2020810000001_1 (F_DRAWN_EXP_FLAG , N_ACCT_SKEY , N_DM_MITIGANT_SKEY , N_GAAP_SKEY , N_MIS_DATE_SKEY , N_MITIGANT_SKEY , N_MTG_TREATMENT_TYPE_SKEY , N_RUN_SKEY , N_POOL_ID , N_EAD_PRE_MITIGATION , REMAINING_EAD_START , MITIGANT_VALUE , HAIRCUT_FACTOR , MITIGANT_VALUE_POST_HC , N_EXP_COVERED_FACTOR , REMAINING_MITIGANT_VALUE , REM_MITIGANT_VALUE_WO_HC , REMAINING_EAD) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)
[WEB] [BASELSOLVER] Exception occurred in method OptimizerDaoImpl::insertProcessingResults
java.sql.BatchUpdateException: ORA-00904: "REMAINING_EAD": invalid identifier
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9741) ~[ojdbc8.jar:19.24.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1447) ~[ojdbc8.jar:19.24.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9517) ~[ojdbc8.jar:19.24.0.0.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237) ~[ojdbc8.jar:19.24.0.0.0]
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:197) ~[com.bea.core.datasource6.jar:14.1.1.0]
at com.ofs.optimization.dao.impl.OptimizerDaoImpl.insertProcessingResults(OptimizerDaoImpl.java:225) [basel-optimizer-solver.jar:8.1.2.0.2_10425360049393]
at com.ofs.optimization.service.impl.OptimizerServiceImpl$MyCallable.call(OptimizerServiceImpl.java:639) [basel-optimizer-solver.jar:8.1.2.0.2_10425360049393]
at com.ofs.optimization.service.impl.OptimizerServiceImpl$MyCallable.call(OptimizerServiceImpl.java:347) [basel-optimizer-solver.jar:8.1.2.0.2_10425360049393]
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 |