2.1 Sprint 3

1. Sprint Release

2.1 - Sprint 3
Release date – December 25, 2015

2. Commit Id

Commit Id - b427403

3. Deliverables

Database Changes: (Relevant only for upgrades)

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

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

1) OLE-7791

Renamed the table OLE_LOAN_INTRANSIT_HISTORY_T to OLE_RETURN_HISTORY_T
Added the column RETURNED_ITEM_STATUS to the table OLE_RETURN_HISTORY_T
Renamed the sequence table OLE_LOAN_INTRANSIT_HISTORY_S to OLE_RETURN_HISTORY_S

2) OLE-8274

Added system parameters HOLDINGS_CALL_NUMBER_TYPE ,ITEM_CALL_NUMBER_TYPE ,E-HOLDINGS_CALL_NUMBER_TYPE to set call number type default on the holding/Item/Eholdings record

3) OLE-8456

Added columns E_RES_RCP_ROLE_ID, E_RES_RCP_GROUP_ID to the table OLE_E_RES_REC_T

4) OLE-8535

Added system parameter TEMPORARY_HISTORY_RECORD_DAYS

System parameters:

1) OLE-8274

Added HOLDINGS_CALL_NUMBER_TYPE ,ITEM_CALL_NUMBER_TYPE ,E-HOLDINGS_CALL_NUMBER_TYPE system parameters Parameter to set call number type default on the holding/Item/Eholdings record

2) OLE-8535

Added system parameter TEMPORARY_HISTORY_RECORD_DAYS

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

Oracle:

INSERT INTO KRCR_PARM_T (NMSPC_CD, CMPNT_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, VAL, PARM_DESC_TXT, EVAL_OPRTR_CD, APPL_ID) VALUES ('OLE-DLVR', 'Deliver', 'TEMPORARY_HISTORY_RECORD_DAYS', 'OLE7047', '1', 'CONFG', '10', 'This parameter value is used to specify the days to determine the temporary history records to be retained after check-in.', 'A', 'OLE')

MySQL

INSERT INTO KRCR_PARM_T (NMSPC_CD, CMPNT_CD, PARM_NM, OBJ_ID, VER_NBR, PARM_TYP_CD, VAL, PARM_DESC_TXT, EVAL_OPRTR_CD, APPL_ID) VALUES ('OLE-DLVR', 'Deliver', 'TEMPORARY_HISTORY_RECORD_DAYS', 'OLE7047', '1', 'CONFG', '10', 'This parameter value is used to specify the days to determine the temporary history records to be retained after check-in.', 'A', 'OLE')

Worflow xml change:

Nil

4. Jiras

S.No.	Component/s	Key	Summary	Priority	Issue Type	Labels	Comments
1	Select & Acquire	OLE-6116	Text boxes for Access Information in e-instance record are too small	Major	Enhancement	Usability
2	Deliver	OLE-6341	The "Bill No" column in both the Bills and Bills in Detail sections need to be sorted as numbers, not strings.	Major	Bug/Defect
3	Describe	OLE-6516	Better display when deleting a bib	Major	Enhancement	Usability
4	Select & Acquire	OLE-6896	double quotes in donor notes not working	Minor	Bug/Defect
5	Select & Acquire	OLE-7275	General Ledger Entry search by fiscal period returning incomplete results	Minor	Bug/Defect
6	Describe	OLE-7295	Batch delete fails to delete once files are over a certain size	Blocker	Bug/Defect
7	Describe, Select & Acquire	OLE-7404	Better Control of Donor Code in Item record	Major	Bug/Defect
8	Select & Acquire	OLE-7590	PO Amendment Editable Fields	Major	Enhancement
9	~~Deliver~~	~~OLE-7743~~	~~Saved Deliver notices should be linked to the patron in patron lookup~~	~~Major~~	~~Enhancement~~	~~Penn~~	Not working with Oracle; Looking into the issue.
10	Deliver	OLE-7791	Item Transit history incomplete, should be changed to Return History	Major	Enhancement
11	Select & Acquire	OLE-7832	Purchase Order Bulk Amendment not updating split accounting lines	Major	Bug/Defect	FiscalYearRollover
12	Select & Acquire	OLE-7833	Purchase Order Bulk Amendment not fully updating prices	Major	Bug/Defect	FiscalYearRollover
13	Describe, Select & Acquire	OLE-7981	e-holdings status not identified in batch process	Major	Bug/Defect	ERM
14	Select & Acquire	OLE-8024	Platform vendor field can't be changed after a vendor is selected	Major	Bug/Defect	ERM
15	Select & Acquire	OLE-8025	Restore Offset Account link to Maintenance menu	Trivial	Task
16	Select & Acquire	OLE-8095	E-Instance inherited fields don't display the value of their parent E-Resource	Major	Bug/Defect
17	Select & Acquire	OLE-8110	Special Processing Instruction Note not triggering until last item on PO received	Major	Bug/Defect
18	Deliver, Describe, System Integration	OLE-8163	Exports of bound-with bibs should include Items and holdings	Critical	Bug/Defect
19	Describe	OLE-8274	Parameter to set call number type default on the holding record.	Blocker	Enhancement
20	Select & Acquire	OLE-8335	Problems Setting ERM Vendor to Inactive	Major	Bug/Defect
21	Select & Acquire	OLE-8418	OC-135 Pop up Windows to appear without scrolling	Major	Bug/Defect
22	Select & Acquire	OLE-8419	OC-137 in SRR, acknowledge with Enter Key	Major	Bug/Defect
23	Select & Acquire	OLE-8440	Need warning message prior to e-resource being deleted	Major	Enhancement	ERM
24	Select & Acquire	OLE-8456	Subscription alert on e-resource: assign to role, group, or individual	Major	Enhancement	ERM
25	Deliver	OLE-8462	incident report on check-in of claim return and yes selected for some item types	Major	Bug/Defect
26	Describe, System Integration	OLE-8466	Search Workbench not displaying records, even when indicating found	Major	Bug/Defect
27	Select & Acquire	OLE-8470	Stacktrace error after removing e-resource linking relationship	Major	Bug/Defect
28	Deliver	OLE-8490	Missing Pieces function does not work in QA	Critical	Bug/Defect
29	Select & Acquire	OLE-8492	Attempts to Delete E-holding from inside E-Resource Always Blocked	Major	Bug/Defect
30	Select & Acquire	OLE-8493	Recurring Payment fields on Requisition erased by later actions	Minor	Bug/Defect
31	Deliver	OLE-8494	Requests expire prior to onhold expiration date	Major	Bug/Defect
32	Deliver	OLE-8495	Request edit screen has lost display of on hold expiration date and ability to edit in 2.1	Critical	Bug/Defect
33	Deliver	OLE-8526	2.0 Notices - Courtesy notice options do not include "due date"	Critical	Bug/Defect
34	Deliver	OLE-8535	Delete Temp History Records JOB still using KRMS	Major	Bug/Defect