BASEL OSFI PMF Rules fails with ORA-38104 Error
(Doc ID 3037034.1)
Last updated on JULY 26, 2024
Applies to:
Oracle Financial Services Basel Regulatory Capital Basic - Version 8.0.0 and laterInformation in this document applies to any platform.
Symptoms
In BASEL 8.1.2.4.2 OSFI PMF Rules RLDRV040 and RLDRV149 fails with ORA-38104 Error
PR2_XX Task Logs of Rule RLDRV040 :
[BACKEND] [GenericRDBMSRuleEngine] [executeRule] FINAL QUERY ::: MERGE INTO FSI_CAP_DERIVATIVES TT USING ( SELECT * FROM ( SELECT /*+ PARALLEL(4) */
[ERROR] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] java.sql.SQLException: Could not execute sql command - Original message: ORA-38104: Columns referenced in the ON Clause cannot be updated: "TT"."N_CAP_NETTABLE_POOL_SKEY"
PR2_XX Task Logs of Rule RLDRV149 :
FINAL QUERY ::: MERGE INTO FSI_CAP_ACCT_RISK_CATEGORY TT USING ( SELECT * FROM ( SELECT /*+ PARALLEL(4) */
[ERROR] [BACKEND] [GenericRDBMSRuleEngine] [executeRule] java.sql.SQLException: Could not execute sql command - Original message: ORA-38104: Columns referenced in the ON Clause cannot be updated: "TT"."N_CCR_HEDGING_SET_SKEY"
Changes
Data Model Changes with PK's/FK's on the tables used for Rules.
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 |
| Changes |
| Cause |
| Solution |