Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

SI INTERESTRATES population does not work



As part of the upgrade to Pega 7 with Smart Investigate (SI) 7.11 a modification in the DDL of the Out-of-the-box (OOTB) table INTERESTRATES was introduced (new unique column ID).

However, the standard Connect-SQL PegaSI-Data-InterestRateMaintenance • Oracle • SIRateAdd in RS:PegaSI:07-11-01, does not insert ID in the table, which leads to oracle error.

Error Messages

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PEGAUSER"."INTERESTRATES"."ID").

Steps to Reproduce

Use the Connect-SQL SIRateAdd.

Root Cause

The combination of currency, feed date, rate, type will always be different.

So, when user does a “save” on the same combination again, it gives an error - "Interest rate already exists".


The connect sql is not used any more in latest SI 7.11 version.

User need to use the activity "SaveToDB" as per the requirements.

This activity will automatically add the values for ID column and calls ‘SaveInterestRates’ activity which does an Obj-Save.

Published May 4, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us