VIRIDIAN Digital Banking - Backend 5.3.18

Changelog

• Activación Acceso Completo: En el proceso de envío del código de activación en oficinas  y desde el Kioscos, para activar un dispositivo del cliente con Acceso Completo, se corrige el error: 16134 El estado del usuario encontrado es incorrecto” que impedía completar el proceso. Con este ajuste esperamos reducir significativamente los casos de soporte sobre este tema.
• Actualización de Datos - Kioscos: Se corrigió la validación en Actualización de Datos para que el mensaje “Revisa los datos introducidos” no se muestre cuando la información de la Dirección de trabajo ha sido completada correctamente.
• Apertura de DPFs: Se sube la tasa de la apertura de DPFs de 7.5% a 7.95% para los casos de clientes que tengan la anterior BM que no obtiene este dato del Banco.
• General: Se corrigió el error al mostrar las imágenes de la Tarjetas de Crédito y Débito en la Banca Móvil con rediseño. Ahora se muestra la imagen que corresponde.

Tags:

• viridian-config
• manager-api
• utilities-api
• frontend-kiosk

Modo de aplicación: En caliente (sin mantenimiento)

Fecha: lunes, 6 de julio de 2026

Tareas previas

info

Les solicitamos por favor realicen los pasos Selección de versión del release y Descarga de componentes en horario de oficina para poder tener todo el equipo a disposición en caso de error.

Selección de versión del release

1. En el servidor de administración, ejecutar el siguiente comando ansible:

   ansible-playbook release.yml -t select -e="version=5.3.18"

   info

   Este comando selecciona la versión del release.

Descarga de componentes

1. En el servidor de administración, ejecutar el siguiente comando ansible:

   ansible-playbook release.yml -K -t warmup

   info

   Este comando descarga las nuevas versiones de todos los componentes que serán actualizados.

Instrucciones

Cambios en servidores

1. Ninguno.

Cambios en base de datos

1. Ejecutar el siguiente script:

   INSERT INTO man_action (code, subtype_code, order, status, user_create, date_create, user_update, date_update, admin_user_create, admin_user_update, admin_date_update)
       VALUES('UPSERT_PLATFORM_BANK_ACTION', 'ADMIN_OPERATION', '1005', 'ACTIVE', NULL, CURRENT, NULL, NULL, 'admin', NULL, NULL);
   INSERT INTO man_action (code, subtype_code, order, status, user_create, date_create, user_update, date_update, admin_user_create, admin_user_update, admin_date_update)
       VALUES('UPSERT_PLATFORM_LIMIT', 'ADMIN_OPERATION', '1005', 'ACTIVE', NULL, CURRENT, NULL, NULL, 'admin', NULL, NULL);
   INSERT INTO man_action (code, subtype_code, order, status, user_create, date_create, user_update, date_update, admin_user_create, admin_user_update, admin_date_update)
       VALUES('UPSERT_PLATFORM_SCHEDULE', 'ADMIN_OPERATION', '1005', 'ACTIVE', NULL, CURRENT, NULL, NULL, 'admin', NULL, NULL);
   
   -- SCRIPT PARA INFORMIX
   
   CREATE TABLE IF NOT EXISTS platform_control (
       id                                  bigserial NOT NULL,
       module_code                         varchar(20) NOT NULL,
       module_name                         varchar(100) NOT NULL,
       bank_action_code                    varchar(20) NOT NULL,
       bank_action_name                    varchar(10) NOT NULL,
       disabled_code_error                 varchar(10),
       disabled_desc_error                 varchar(200),
       schedule_code_error                 varchar(10),
       schedule_desc_error                 varchar(200),
       limits_general_amount_code_error    varchar(10),
       limits_general_amount_desc_error    varchar(200),
       limits_general_count_code_error     varchar(10),
       limits_general_count_desc_error     varchar(200),
       limits_customer_amount_code_error   varchar(10),
       limits_customer_amount_desc_error   varchar(200),
       limits_customer_count_code_error    varchar(10),
       limits_customer_count_desc_error    varchar(200),
       limits_exception_amount_code_error  varchar(10),
       limits_exception_amount_desc_error  varchar(200),
       limits_exception_count_code_error   varchar(10),
       limits_exception_count_desc_error   varchar(200),
       status                              varchar(40) NOT NULL,
       user_create                         varchar(40),
       date_create                         datetime year to second NOT NULL,
       user_update                         varchar(40),
       date_update                         datetime year to second,
       admin_user_create                   varchar(40),
       admin_user_update                   varchar(40),
       admin_date_update                   datetime year to second,
       PRIMARY KEY (id) CONSTRAINT pk_platform_control_id
   );
   
   
   -- platform_schedule
   
   CREATE TABLE IF NOT EXISTS platform_schedule (
       id                                  bigserial NOT NULL,
       fk_platform_control                 bigint NOT NULL,
       days                                varchar(50) NOT NULL,
       start_time                          varchar(10) NOT NULL,
       end_time                            varchar(10) NOT NULL,
       status                              varchar(40) NOT NULL,
       user_create                         varchar(40),
       date_create                         datetime year to second NOT NULL,
       user_update                         varchar(40),
       date_update                         datetime year to second,
       admin_user_create                   varchar(40),
       admin_user_update                   varchar(40),
       admin_date_update                   datetime year to second,
       PRIMARY KEY (id) CONSTRAINT pk_platform_schedule_id,
       FOREIGN KEY (fk_platform_control) REFERENCES platform_control (id) CONSTRAINT fk_platform_schedule_control
   );
   
   -- platform_limit
   
   CREATE TABLE IF NOT EXISTS platform_limit (
       id                                  bigserial NOT NULL,
       fk_platform_control                 bigint NOT NULL,
       limit_type                          varchar(20) NOT NULL,
       customer_type                       varchar(20),
       customer_code                       varchar(20),
       currency                            varchar(3) NOT NULL,
       daily_amount_limit                  decimal(19,2),
       weekly_amount_limit                 decimal(19,2),
       monthly_amount_limit                decimal(19,2),
       daily_count_limit                   bigint,
       weekly_count_limit                  bigint,
       monthly_count_limit                 bigint,
       status                              varchar(40) NOT NULL,
       user_create                         varchar(40),
       date_create                         datetime year to second NOT NULL,
       user_update                         varchar(40),
       date_update                         datetime year to second,
       admin_user_create                   varchar(40),
       admin_user_update                   varchar(40),
       admin_date_update                   datetime year to second,
       PRIMARY KEY (id) CONSTRAINT pk_platform_limit_id,
       FOREIGN KEY (fk_platform_control) REFERENCES platform_control (id) CONSTRAINT fk_platform_limit_control
   );
   
   -- 1. LOGIN / ALL (manager-api, 8000X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'LOGIN', 'Ingreso a la BM/BW', 'ALL', 'Todos', 'ENABLED',
       '80000', '80001', '80002', '80003', '80004', '80005', '80006', '80007',
       CURRENT, 'SYSTEM'
   );
   
   -- 2. QR_PAYMENT / ALL (digitalpay-qr, 8001X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'QR_PAYMENT', 'Pago de QRs', 'ALL', 'Todos', 'ENABLED',
       '80010', '80011', '80012', '80013', '80014', '80015', '80016', '80017',
       CURRENT, 'SYSTEM'
   );
   
   -- 3. TRANSFER / OTHER_BANK (transactions-api, 8002X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'TRANSFER', 'Transferencias a otros bancos', 'OTHER_BANK', 'Otros bancos', 'ENABLED',
       '80020', '80021', '80022', '80023', '80024', '80025', '80026', '80027',
       CURRENT, 'SYSTEM'
   );
   
   -- 4. TRANFER / SAME_BANK (transactions-api, 8003X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'TRANFER', 'Transferencias al mismo banco', 'SAME_BANK', 'Mismo banco', 'ENABLED',
       '80030', '80031', '80032', '80033', '80034', '80035', '80036', '80037',
       CURRENT, 'SYSTEM'
   );
   
   -- 5. TRANSFER / SAME_CUSTOMER (transactions-api, 8004X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'TRANSFER', 'Transferencias entre cuentas propias', 'SAME_CUSTOMER', 'Propias', 'ENABLED',
       '80040', '80041', '80042', '80043', '80044', '80045', '80046', '80047',
       CURRENT, 'SYSTEM'
   );
   
   -- 6. SERVICE_PAYMENT / ALL (servicepayments-api, 8005X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'SERVICE_PAYMENT', 'Pago de servicios', 'ALL', 'Todos', 'ENABLED',
       '80050', '80051', '80052', '80053', '80054', '80055', '80056', '80057',
       CURRENT, 'SYSTEM'
   );
   
   -- 7. SERVICE_PAYMENT / GESTORA (servicepayments-api, 8006X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'SERVICE_PAYMENT', 'Pago Gestora', 'GESTORA', 'Gestora', 'ENABLED',
       '80060', '80061', '80062', '80063', '80064', '80065', '80066', '80067',
       CURRENT, 'SYSTEM'
   );
   
   -- 8. TRADE_TRANSFER / ALL (trade-api, 8007X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'TRADE_TRANSFER', 'Transferencias internacionales', 'ALL', 'Todos', 'ENABLED',
       '80070', '80071', '80072', '80073', '80074', '80075', '80076', '80077',
       CURRENT, 'SYSTEM'
   );
   
   -- 9. BATCH_PAYMENTS / ALL (batchpayments-api, 8008X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'BATCH_PAYMENTS', 'Pago de lotes', 'ALL', 'Todos', 'ENABLED',
       '80080', '80081', '80082', '80083', '80084', '80085', '80086', '80087',
       CURRENT, 'SYSTEM'
   );
   
   -- 10. MONEY_ORDER / ALL (beneficiaries-api, 8009X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'MONEY_ORDER', 'Efectivo Móvil (Móvi)', 'ALL', 'Todos', 'ENABLED',
       '80090', '80091', '80092', '80093', '80094', '80095', '80096', '80097',
       CURRENT, 'SYSTEM'
   );
   
   -- 11. LOANS / ALL (transactions-api, 8010X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'LOANS', 'Créditos (Móvil)', 'ALL', 'Todos', 'ENABLED',
       '80100', '80101', '80102', '80103', '80104', '80105', '80106', '80107',
       CURRENT, 'SYSTEM'
   );
   
   -- 12. WIRE_TRANSFER / IN (wiretransfer-api, 8011X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'WIRE_TRANSFER', 'Cobro de Remesas Familiares', 'IN', 'Cobro', 'ENABLED',
       '80110', '80111', '80112', '80113', '80114', '80115', '80116', '80117',
       CURRENT, 'SYSTEM'
   );
   
   -- 13. WIRE_TRANSFER / OUT (wiretransfer-api, 8012X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'WIRE_TRANSFER', 'Envío de Remesas Familiares', 'OUT', 'Envío', 'ENABLED',
       '80120', '80121', '80122', '80123', '80124', '80125', '80126', '80127',
       CURRENT, 'SYSTEM'
   );
   
   -- 14. DIGITAL_CREDIT / ALL (digitalcredit-spi, 8013X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'DIGITAL_CREDIT', 'Mis Créditos (Móvil)', 'ALL', 'Todos', 'ENABLED',
       '80130', '80131', '80132', '80133', '80134', '80135', '80136', '80137',
       CURRENT, 'SYSTEM'
   );
   
   -- 15. INSURANCE_SALES / ALL (insurance-sales, 8014X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'INSURANCE_SALES', 'Compra de seguros (Móvil)', 'ALL', 'Todos', 'ENABLED',
       '80140', '80141', '80142', '80143', '80144', '80145', '80146', '80147',
       CURRENT, 'SYSTEM'
   );
   
   -- 16. CUSTOMER_DATA_UPDATE / ALL (onboarding-api, 8015X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'CUSTOMER_DATA_UPDATE', 'Actualización de Datos (Móvil)', 'ALL', 'Todos', 'ENABLED',
       '80150', '80151', '80152', '80153', '80154', '80155', '80156', '80157',
       CURRENT, 'SYSTEM'
   );
   
   -- 17. DFP_OPENING / ALL (transactions-api, 8016X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'DFP_OPENING', 'Abre tu DPF (Móvil)', 'ALL', 'Todos', 'ENABLED',
       '80160', '80161', '80162', '80163', '80164', '80165', '80166', '80167',
       CURRENT, 'SYSTEM'
   );
   
   -- 18. REFERRAL_PROGRAM / ALL (manager-api, 8017X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'REFERRAL_PROGRAM', 'Programa de Referidos', 'ALL', 'Todos', 'ENABLED',
       '80170', '80171', '80172', '80173', '80174', '80175', '80176', '80177',
       CURRENT, 'SYSTEM'
   );
   
   -- 19. MY_FINANCES / ALL (myfinances-api, 8018X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'MY_FINANCES', 'Mis Finanzas', 'ALL', 'Todos', 'ENABLED',
       '80180', '80181', '80182', '80183', '80184', '80185', '80186', '80187',
       CURRENT, 'SYSTEM'
   );
   
   -- 20. UNITY_COLLECT / ALL (digitalpay-qr, 8019X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'UNITY_COLLECT', 'Cobranzas Masivas (Web)', 'ALL', 'Todos', 'ENABLED',
       '80190', '80191', '80192', '80193', '80194', '80195', '80196', '80197',
       CURRENT, 'SYSTEM'
   );
   
   -- 21. GUARANTEE_BOND / ALL (guaranteebond-api, 8020X)
   INSERT INTO platform_control (
       module_code, module_name, bank_action_code, bank_action_name, status,
       disabled_code_error, schedule_code_error,
       limits_general_amount_code_error, limits_general_count_code_error,
       limits_customer_amount_code_error, limits_customer_count_code_error,
       limits_exception_amount_code_error, limits_exception_count_code_error,
       date_create, user_create
   ) VALUES (
       'GUARANTEE_BOND', 'Fianzas Bancarias (Web)', 'ALL', 'Todos', 'ENABLED',
       '80200', '80201', '80202', '80203', '80204', '80205', '80206', '80207',
       CURRENT, 'SYSTEM'
   );

Cambios en componentes

1. En el servidor de administración, ejecutar el siguiente comando ansible:

   ansible-playbook release.yml -K -t deploy -e "type=hot"

Limpieza de archivos generados por el release

1. En el servidor de administración, ejecutar el siguiente comando ansible:

   ansible-playbook admin.yml -K -t cleanup

Verificación de componentes

1. En los servidores de aplicaciones, ejecutar el siguiente comando:

   docker ps -vs

   info

   Este comando muestra el estado de todos los docker containers ordenados alfabéticamente.

2. Revisar el output del comando y asegurarse de que todos los docker containers tengan un status UP y no haya ningún docker container detenido.

Resumen de versiones

componente	release 5.3.17	release 5.3.18
viridian-config-properties	9.38.0	9.39.1
server-config	9.1.0
server-eureka	9.1.0
vdb-routes-public	9.13.0
vdb-routes-internal	9.5.0
vdb-routes-bank	9.4.0
gateway-public	9.5.1
gateway-internal	9.4.0
gateway-external	9.3.0
bank-gateway	9.7.0
bank-service	9.4.0
batchpayments-api	9.6.0
batchpayments-hosted	9.5.0
beneficiaries-api	9.9.0
digitalcredit-api	9.5.1
digitalpay-qr	9.19.0
guaranteebond-api	9.5.0
manager-api	9.29.0	9.30.0
manager-hosted	9.13.0
myfinances-api	9.7.1
notifications-hosted	9.11.0
onboarding-api	9.21.0
servicepayments-api	9.7.0
statements-api	9.6.0
trade-api	9.10.3
transactions-api	9.12.0
transactions-hosted	9.5.0
utilities-api	9.16.0	9.17.0
wiretransfer-api	9.6.0
insurance-agents	9.5.0
insurance-sales	9.5.0
assistant-requests	9.8.0
frontend-vdb	9.17.0
frontend-vdb-2	9.17.0
frontend-admin	9.10.0
frontend-kiosk	9.5.4	9.6.0