3.0 Sprint 3

1. Sprint Release

• 3.0 - Sprint 3
• Release date – March 18, 2016

2. Tag Name:  3.0-Sprint-3

3.  Deliverables

Database Changes: (Relevant only for upgrades)

Oracle: https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-3/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/oracle/3.0.sql

MySQL: https://github.com/openlibraryenvironment/ole/blob/3.0-Sprint-3/ole-app/ole-db/ole-sql/ole-liquibase-upgrade-sql/src/main/resources/org/kuali/ole/sql/mysql/3.0.sql

1) OLE-4237

             Added column ROW_ACT_IND to the table OLE_LOCN_T. 

2) OLE-6164

             Added column MANUAL_BILL to the tables OLE_DLVR_PTRN_BILL_T, OLE_DLVR_PTRN_BILL_FEE_TYP_T.

3) OLE-7273

            Updated SUB_FUND_GRP_CD = 'DEPOSI' in CA_SUB_FUND_GRP_T table for Deposit account.

            Updated FUND_GRP_CD = 'DP' in CA_SUB_FUND_GRP_T table for Deposit account.

            Updated the system parameter SUB_FUND_GRP_CD value to DEPOSI.

4) OLE-8029

            Added column FUND_CD to the table GL_BALANCE_T.

            Added constraint GL_BALANCE_FUND_CD_FK to the table GL_BALANCE_T.

            Added column FUND_CD to the table GL_ACCT_BALANCES_T.

            Added constraint GL_ACCT_BALANCES_FUND_CD_FK to the table GL_ACCT_BALANCES_T.            

5) OLE-8276

            Added column VOLUME_NUMBER to the table OLE_DS_ITEM_T_ADD.

System parameters:

1) OLE-7273

            Updated the system parameter SUB_FUND_GRP_CD value to DEPOSI.

Workflow xml change:

Nil

Manually run the following as it was missed in the sql generation process:

Oracle: 

UPDATE KRCR_PARM_T SET PARM_DESC_TXT = 'Sub Fund Group Code DEPOSI.', VAL = 'DEPOSI' WHERE PARM_NM = 'SUB_FUND_GRP_CD';

ALTER TABLE OLE_LOCN_T ADD ROW_ACT_IND VARCHAR2(1) DEFAULT 'Y';

MySQL

UPDATE KRCR_PARM_T SET PARM_DESC_TXT = 'Sub Fund Group Code DEPOSI.', VAL = 'DEPOSI' WHERE PARM_NM = 'SUB_FUND_GRP_CD';
ALTER TABLE OLE_LOCN_T ADD ROW_ACT_IND VARCHAR(1) NULL DEFAULT 'Y';

4. Jiras