Actions
Feature #13
openCR - Customer Personal Data & Subscription Data Upload (Unilever)
Added by Andi Malik Rizki Maula about 2 months ago. Updated 17 days ago.
Start date:
12/19/2025
Due date:
% Done:
0%
Estimated time:
Files
Updated by nurangky augustine about 2 months ago
Updated by nurangky augustine about 2 months ago
Updated by Andi Malik Rizki Maula about 2 months ago
Updated by nurangky augustine about 2 months ago
Updated by nurangky augustine about 2 months ago
- File Test Script Upload.xlsx added
Updated by nurangky augustine about 2 months ago
- File Test Script Upload.xlsx Test Script Upload.xlsx added
Updated by nurangky augustine about 2 months ago
- File deleted (
Test Script Upload.xlsx)
Actions
#8
Updated by nurangky augustine about 2 months ago
Updated by anggito tantyo about 2 months ago
Updated by kevin krisandi about 2 months ago
Updated by Andi Malik Rizki Maula about 2 months ago
- File cr-unilever-v20251222-001-27f6317.zip added
Updated by Andi Malik Rizki Maula about 2 months ago
- Private changed from No to Yes
Updated by Andi Malik Rizki Maula about 2 months ago
- Private changed from Yes to No
Updated by anggito tantyo about 2 months ago
Updated by Andi Malik Rizki Maula about 2 months ago
- File cr-unilever-v20251222-002-e3a7871.zip added
Updated by Andi Malik Rizki Maula about 2 months ago
- File deleted (
cr-unilever-v20251222-002-e3a7871.zip)
Updated by Andi Malik Rizki Maula about 2 months ago
- File deleted (
cr-unilever-v20251222-001-27f6317.zip)
Updated by anggito tantyo about 2 months ago
- File MST_TRX_SUMMARY.xlsx MST_TRX_SUMMARY.xlsx added
Updated by Andi Malik Rizki Maula about 2 months ago · Edited
Version:
- cr-unilever/v20251222-001-ec5e961
Scripts:
- [ddl] scripts/ddl-dml/01_ddl_table_changes.sql
- [dml] scripts/ddl-dml/02_dml_modules.sql
Objects:
- objects/avt/avantrade-web-sellingagent.zip
Notes:
- DDL for FILE_UPLOAD_ID column in TRX_CUSTOMER_PERSONAL_UPLOAD_DETAILS table.
- DML for MST_TRX_SUMMARY FILE_LOCATION update.
- Fixed logic for setting questionnaire_id, question_id, and answer_id.
- Fixed DOB spouse validation.
Actions
#22
Updated by aron nigel about 2 months ago
- File Upload Data Customer (2).xlsx Upload Data Customer (2).xlsx added
- File 583.docx 583.docx added
Updated by Andi Malik Rizki Maula about 2 months ago
Version:
- cr-unilever/uat-prod/v20251229-001-972cf91
Objects:
- objects/avt/avantrade-web-sellingagent.zip
Notes:
- CIF number validation fixes.
Updated by Andi Malik Rizki Maula about 2 months ago
Version:
- cr-unilever/v20251229-002-64ff20a
Objects:
- objects/avt/avantrade-web-sellingagent.zip
- objects/avt/birt.zip
Notes:
- CIF number validation fixes.
- Take out generated investment account from CIF upload in SID registration report.
Updated by Andi Malik Rizki Maula about 1 month ago
Version:
- cr-unilever/v20260106-001-048bc4c
Objects:
- objects/avt/avantrade-web-sellingagent.zip
Notes:
- FSIDMMA-588: Added e-mail address format validation.
- FSIDMMA-589: Added province code format validation and data existence in DB.
Updated by Andi Malik Rizki Maula about 1 month ago
Version:
- cr-unilever/v20260107-001-bd6e061
Objects:
- objects/avt/avantrade-web-sellingagent.zip
Notes:
- FSIDMMA-586: Fixed null uploaded subscription order unit causing booking list report error.
- FSIDMMA-590: Fixed account management approval error.
Updated by Andi Malik Rizki Maula about 1 month ago
Version:
- cr-unilever/v20260108-001-935dbde
Objects:
- objects/avt/avantrade-web-sellingagent.zip
Notes:
- FSIDMMA-591: Added CIF_BANK and Customer CIF equality validation.
Updated by Andi Malik Rizki Maula about 1 month ago
Versions:
- cr-unilever/v20260109-001-38b39b1
Objects:
- avt/avantrade-web-sellingagent.zip
Release Note:
- FSIDMMA-592: Fixed TRX_AMOUNT validation error due to scientific notation format.
Updated by Andi Malik Rizki Maula about 1 month ago
Versions:
- cr-unilever/v20260109-003-1087768
Objects:
- avt/avantrade-web-sellingagent.zip
Release Note:
- FSIDMMA-594: Fixed FEE_AMOUNT validation error caused by empty value.
Updated by Andi Malik Rizki Maula about 1 month ago
Versions:
- cr-unilever/v20260109-004-068b51d
Objects:
- avt/avantrade-web-sellingagent.zip
Release Note:
- FSIDMMA-594: Fixed FEE_AMOUNT validation error caused by empty value.
Updated by Andi Malik Rizki Maula about 1 month ago · Edited
Go Live¶
Versions:
- avantrade-web-sellingagent: cr-unilever/v20260109-004-068b51d
- birt: cr-unilever/v20251229-002-64ff20a
Objects:
- avt/avantrade-web-sellingagent.zip
- avt/birt.zip
Scripts:
- avt/ddl-dml/00_ddl_backup.sql
- avt/ddl-dml/01_ddl_table_changes.sql
- avt/ddl-dml/02_dml_modules.sql
- avt/dql/dql_export_cif_stg_new.sql
- avt/dql/dql_export_second_ifua.sql
Documents:
- CR Upload Unilever - Release Document v0.1.0-DRAFT.xlsx
Release Note:
- CR Unilever customer personal data & subscription data upload features.
Updated by Andi Malik Rizki Maula 26 days ago
Go Live¶
Versions:
- avantrade-web-sellingagent: cr-unilever/v20260109-004-068b51d
- birt: cr-unilever/v20251229-002-64ff20a
Objects:
- avt/avantrade-web-sellingagent.zip
- avt/birt.zip
Scripts:
- avt/ddl-dml/00_ddl_backup.sql
- avt/ddl-dml/01_ddl_table_changes.sql
- avt/ddl-dml/02_dml_modules.sql
- avt/ddl-dml/99_ddl_rollback.sql
- avt/ddl-dml/99_dml_rollback.sql
- avt/dql/dql_export_cif_stg_new.sql
- avt/dql/dql_export_second_ifua.sql
Documents:
- CR Upload Unilever - Release Document v0.1.1-DRAFT.xlsx
Release Note:
- CR Unilever customer personal data & subscription data upload features.
Actions