SI INTERESTRATES population does not work
SummaryAs 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-SQLPegaSI-Data-InterestRateMaintenance • Oracle • SIRateAdd in RS:PegaSI:07-11-01, does not insert ID in the table, which leads to oracle error.
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PEGAUSER"."INTERESTRATES"."ID").
Steps to ReproduceUse the Connect-SQLSIRateAdd.
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 April 12, 2017 - Updated May 3, 2017