Project

General

Profile

Bug #3268

[ESS-Address]perbaikan pada ess address dimana jika address type nya sama, maka data yang akan masuk ke master data hanya update saja. tetapi jika address type nya berbeda dengan data yang sudah ada di master data address, maka insert dengan data baru.

Added by Muhammad Bintar about 2 months ago. Updated 22 days ago.

Status:
QA Test
Priority:
Normal
Assignee:
Muhammad Bintar
Start date:
12/06/2024
Due date:
12/10/2024 (41 days late)
% Done:

0%

Estimated time:
Spent time:
7.00 h

Description

dear tim developer mohon support nya untuk perbaikan pada ess address dimana jika address type nya sama, maka data yang akan masuk ke master data hanya update saja. tetapi jika address type nya berbeda dengan data yang sudah ada di master data address, maka insert dengan data baru.

contoh regid 1150
employee 00000144


aplikasi remote.minovais.com:61117
database sql 2022
192.168.3.105\MSSQLSERVER2022
MinovaES_BWS_BaseServerBWS_Prod

Files

clipboard-202412061411-7zoj1.png (60.1 KB) clipboard-202412061411-7zoj1.png Muhammad Bintar, 12/06/2024 02:11 PM
clipboard-202412061413-p20cl.png (85.6 KB) clipboard-202412061413-p20cl.png Muhammad Bintar, 12/06/2024 02:13 PM
clipboard-202412091051-kvpqe.png (47.4 KB) clipboard-202412091051-kvpqe.png Muhammad Bintar, 12/09/2024 10:51 AM
clipboard-202412231138-elzqc.png (58.3 KB) clipboard-202412231138-elzqc.png M Azid Wahyudi, 12/23/2024 11:38 AM
#1

Updated by Kezia Pawitra Yulianti about 2 months ago

  • Status changed from New to Assigned
#2

Updated by Muhammad Bintar about 1 month ago

update:

sudah di coba di ganti process type nya dari C ke U, tapi ada error

proc_data_PHRPA0006-Update_PHRPA0006_1 The variable name '@Sequence' has already been declared. Variable names must be unique within a query batch or stored procedure.
Must declare the scalar variable "@EmployeeID_new". - MinovaIS.MinovaES.Business.WorkFlow

#3

Updated by M Azid Wahyudi about 1 month ago

catatan buat developer :
ini di deftask prosestype di NULL aja dan di tambahkan kondisi untuk membuat logic time constrain dan juga update

#4

Updated by Kezia Pawitra Yulianti about 1 month ago

pls cek untuk time constraint nya ya

PCMEPMDCON dan PCMEPMDCONSUB

sesuaikan dgn tipe dari masing2 address type nya

#5

Updated by M Azid Wahyudi about 1 month ago

  • Status changed from Assigned to Revise
  • Assignee changed from M Azid Wahyudi to Regina Tasya

dear tasya , tolong buatkan kondisi timeconstraint sebelum posting dan juga tolong tambahkan field 'DataFlag' seperti contoh2 di ess personal data dll

makasih

#6

Updated by Regina Tasya about 1 month ago

sudah ya kak azid untuk settingan :
settingan penambahan task: cond_timeconstraint : defflow, defftask, taskcon,defbizdata,
dataflag : di sdatatablefield

#7

Updated by Regina Tasya about 1 month ago

  • Assignee changed from Regina Tasya to M Azid Wahyudi
#8

Updated by M Azid Wahyudi 29 days ago

dear tasya , tolong di test yaa kebutuhan product untuk semua client nextnya

package :
custparam (timeconsESS)
fieldpos // untuk yang primarykey di tambahin settingan ori_new_key

makasih

#9

Updated by Regina Tasya 24 days ago

  • Assignee changed from Regina Tasya to Muhammad Bintar

SUdah di test

#10

Updated by Regina Tasya 22 days ago

settingan penambahan task: cond_timeconstraint : defflow, defftask, taskcon,defbizdata, fieldposting
dataflag : di sdatatablefield PDSWFMDADDRESS

Also available in: Atom PDF