Update DCB service point values for the attribute Hold shelf expiration period

Description

Problem

Currently, the default value DCB SP attribute “Hold shelf expiration period” is too short and causes supplier items to fall off the hold shelf which has a subsequent downstream effect of not updating the real item record with the loan. In addition, this introduces manual steps to fix the state when an item is checked in at the supplier library.

The ask is to set the default Hold shelf expiration period to 10 days which should be ample time to prevent the item from encountering these conditions.

2 legged transactions

  • borrower/pickup - real SP, customer governs the hold shelf expiration period

  • supplier - virtual SP, system set hold shelf expiration period = 10 days on creation

3 legged transactions

  • supplier - virtual SP, system set hold shelf expiration period = 10 days on creation

  • borrower - virtual SP, system set hold shelf expiration period = 10 days on creation

  • pickup - real SP, customer governs the hold shelf expiration period 

[Update 1/31/25] If the configuration value for the hold shelf expiration period is updated, the new value will be applied to existing transactions and new transactions.

Priority

Development Team

Volaris

Assignee

Solution Architect

Parent Field Value

None

Parent Status

None

Checklist

hide

Activity

Show:

Irina Pokhylets February 24, 2025 at 9:53 AM

mod-dcb v1.1.8 released https://github.com/folio-org/mod-dcb/releases/tag/v1.1.8 , some instructions are over here how to use the new table to set the hold shelf expiration values.

Irina Pokhylets February 24, 2025 at 9:29 AM

The functionality has been verified on eureka snapshot, works as expected.

Irina Pokhylets February 7, 2025 at 10:52 AM

Was introduced service_point_expiration_period table in mod-dcb for configuration of hold shelf expiration period for dcb service points. The default value of hold shelf expiration is 10 days. If the value needs adjustment, it could be updated by the FSE team in the table or via database script.


This table contains only one row, and if no row is present, the default value of hold shelf expiration will be 10 days. Changes to this table will only affect newly created virtual service points and virtual service points that are reused during the creation of a new DCB transaction. Existing virtual service points will not automatically update when changes are made to the hold-shelf-expiration value in the database. Additionally, the DCB service point originally created when this module was enabled for a tenant will not be altered if the hold shelf expiration value is dynamically updated in the table.

Tim Auger January 27, 2025 at 3:40 PM

Regarding the application of values, it is agreed from Product that the value set will apply to all service points per tenant.

Tim Auger December 10, 2024 at 3:31 PM

Howdy…#2 please, Storing Values in mod-dcb

Done

Details

Reporter

PO Rank

0

Front End Estimate

Out of scope

Back End Estimate

Medium < 5 days

Back End Estimator

Back-End Confidence factor

70%

Release

Sunflower (R1 2025)

Tech Design Ready

N/A

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 18, 2024 at 5:28 PM
Updated March 18, 2025 at 10:55 AM
Resolved March 18, 2025 at 10:55 AM
TestRail: Cases
TestRail: Runs