Medium Current Implementation : While exporting data for change file scenario, if there is any retro changes,then that needs to be pulled out on the file. If From date/To date is not provided while exporting file, then it considers from date as 1st day of previous month and to date as last day of previous month.
New Implementation : In this case, from date should set to fiscal year start date. To achieve this user should give input of from date as fiscal year start date.If this date is blank ,then in that case from date should automatically consider the date of fiscal year start date.
While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this user should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date.
- relates to
-
WT-12019 ACA: While exporting ACA files,user is not provided "From Date" and "To Date", should consider fiscal year as from date based on last exported date.
-
- In LB Testing
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Nandkumar [ satyap ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Description | While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this use should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date. |
| Description | While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this use should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date. | While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this user should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date. |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Remaining Estimate | 30h [ 108000 ] | |
| Original Estimate | 30h [ 108000 ] |
| Remaining Estimate | 30h [ 108000 ] | 26h [ 93600 ] |
| Time Spent | 4h [ 14400 ] | |
| Worklog Id | 71629 [ 71629 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Attachment | TechSpec_WT-10365_ACA Export In case of from date of export is blank should refer fiscal year start date.doc [ 58823 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
| Dev Due Date | 18/Aug/2017 |
Manually code reviewed due to code review portal is not working.
| Code Review Date | 17/Aug/2017 | |
| Code Reviewed By | Yogesh Chaudhari [ 13000 ] |
Affected files:
\App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
\App\BusinessLogic\ImportExportDTS\ExecuteExportDTS.vb
| Attachment |
TechSpec_ |
IMPACT: Once this patch is deployed on Production, must modify schedule of export files for the monthly files to that month end day midnight if missed out to do the same it will fetch the records till
whatever date is set date considered as todate.
For ex. To export the July month files is scheduled as on dated 08/10/2017
if not changed schedule as 07/31/2017 11:59:59
it will consider from date-01/01/2017, todate as 08/10/2017
If changed
It will consider from date-01/01/2017, todate as 07/31/2017
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
Hi Smita Pawar,
Please confirm the stage date.
Thanks,
Revan
Yogesh Chaudhari Nandkumar Prabhakar Karlekar Sachin Hingole Rakesh Roy
Smita Pawar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Smita Pawar (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Smita Pawar (Inactive)
made changes -
| Code Review Date | 17/Aug/2017 | 17/Aug/2017 |
| Dev Due Date | 18/Aug/2017 | 18/Aug/2017 |
| Production Due Date | 28/Sep/2017 | |
| Stage Due Date | 25/Sep/17 [ 2017-09-25 ] |
Smita Pawar (Inactive)
made changes -
| Stage Due Date | 25/Sep/17 [ 2017-09-25 ] | 18/Oct/17 [ 2017-10-18 ] |
Smita Pawar (Inactive)
made changes -
| Production Due Date | 28/Sep/2017 | 26/Oct/2017 |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 26h [ 93600 ] | 24h [ 86400 ] |
| Time Spent | 4h [ 14400 ] | 6h [ 21600 ] |
| Worklog Id | 83433 [ 83433 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 24h [ 86400 ] | 23.25h [ 83700 ] |
| Time Spent | 6h [ 21600 ] | 6.75h [ 24300 ] |
| Worklog Id | 83660 [ 83660 ] |
-
- Time Spent:
- 1.5h
-
Internal discussion & Testing
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 23.25h [ 83700 ] | 22h [ 79200 ] |
| Time Spent | 6.75h [ 24300 ] | 8h [ 28800 ] |
| Worklog Id | 84564 [ 84564 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 22h [ 79200 ] | 20h [ 72000 ] |
| Time Spent | 8h [ 28800 ] | 10h [ 36000 ] |
| Worklog Id | 84963 [ 84963 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 20h [ 72000 ] | 0h [ 0 ] |
| Time Spent | 10h [ 36000 ] | 41h [ 147600 ] |
| Worklog Id | 87548 [ 87548 ] |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | 29.5h [ 106200 ] |
| Time Spent | 41h [ 147600 ] | 11.5h [ 41400 ] |
| Worklog Id | 87548 [ 87548 ] |
| Remaining Estimate | 29.5h [ 106200 ] | 28.5h [ 102600 ] |
| Time Spent | 11.5h [ 41400 ] | 12.5h [ 45000 ] |
| Worklog Id | 87698 [ 87698 ] |
Smita Pawar (Inactive)
made changes -
| Attachment | WT-10365.doc [ 66179 ] |
-
- Time Spent:
- 1h
-
Discussion for not exporting the change file issue.
-
- Time Spent:
- 6h
-
Scenario analysis, Internal discussion on finding.
Yogesh Chaudhari (Inactive)
logged work - 02/Nov/17 12:11 AM -
- Time Spent:
- 2h
-
Analysis and discussion with Revan and nandu.
discussion to write the Test cases
Yogesh Chaudhari (Inactive)
made changes -
| Remaining Estimate | 28.5h [ 102600 ] | 26.5h [ 95400 ] |
| Time Spent | 12.5h [ 45000 ] | 14.5h [ 52200 ] |
| Worklog Id | 88794 [ 88794 ] |
| Remaining Estimate | 26.5h [ 95400 ] | 20.5h [ 73800 ] |
| Time Spent | 14.5h [ 52200 ] | 20.5h [ 73800 ] |
| Worklog Id | 88804 [ 88804 ] |
Smita Pawar (Inactive)
made changes -
| Company | All Clients/Multiple Clients [ 18434 ] | |
| Developer | Revansiddha Gaur [ revansiddha.gaur ] | |
| Environment | LB [ 18444 ] | |
| QA | Smita Pawar [ smita.pawar ] |
Smita Pawar (Inactive)
made changes -
| Attachment | WT-10365.xls [ 67077 ] |
We have verified above mentioned enhancement on LB.
Its working fine,
PFA test case document for further details
Smita Pawar (Inactive)
added a comment - We have verified above mentioned enhancement on LB.
Its working fine,
PFA test case document for further details Smita Pawar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Ramya Tantry (Inactive)
made changes -
| Description | While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this user should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date. |
Current Implementation : While exporting data for change file scenario, if there is any retro changes,then that needs to be pulled out on the file. If From date/To date is not provided while exporting file, then it considers from date as 1st day of previous month and to date as last day of previous month. New Implementation : In this case, from date should set to fiscal year start date. To achieve this user should give input of from date as fiscal year start date.If this date is blank ,then in that case from date should automatically consider the date of fiscal year start date. While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this user should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date. |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Smita Pawar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Smita Pawar (Inactive)
made changes -
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Smita Pawar (Inactive)
made changes -
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Smita Pawar (Inactive)
made changes -
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
-
- Time Spent:
- 2h
-
Discussion with smita.
Stage testing.
| Remaining Estimate | 20.5h [ 73800 ] | 18.5h [ 66600 ] |
| Time Spent | 20.5h [ 73800 ] | 22.5h [ 81000 ] |
| Worklog Id | 91061 [ 91061 ] |
| Worklog Id | 91061 [ 91061 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
Gaurav Sodani (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Production Due Date | 26/Oct/2017 | 25/Nov/2017 |
| Stage Due Date | 18/Oct/17 [ 2017-10-18 ] | 11/Nov/17 [ 2017-11-11 ] |
Gaurav Sodani (Inactive)
made changes -
| Approval status | Approved for production deployment [ 18457 ] | |
| Epic/Theme | ACA | |
| Labels | ACA |
Hi All,
Attaching production deployment approval email for reference:
!Re Request for Production deployment - 25 Nov 2017.msg
Regards
Gaurav
Gaurav Sodani (Inactive)
added a comment - Hi All,
Attaching production deployment approval email for reference:
!Re Request for Production deployment - 25 Nov 2017.msg
Regards
Gaurav Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Smita Pawar (Inactive)
made changes -
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Smita Pawar (Inactive)
made changes -
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Smita Pawar (Inactive)
made changes -
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Smita Pawar (Inactive)
made changes -
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Verified this fix on stage. It is working as expected.
Thanks,
Yogita
CC - Prajakta Belhe | Smita Pawar
Smita Pawar (Inactive)
logged work - 29/Nov/17 01:28 PM -
- Time Spent:
- 1h
-
Production testing
Internal discussion
We have verified above mentioned change request on production company [Metso for Hspl].
We have exported change and full file without giving form date and to date,
PFA screen shot for additional information,
Smita Pawar (Inactive)
added a comment - We have verified above mentioned change request on production company [Metso for Hspl] .
We have exported change and full file without giving form date and to date,
PFA screen shot for additional information,
Smita Pawar (Inactive)
made changes -
| Attachment | Fiscal year.png [ 68801 ] |
Smita Pawar (Inactive)
made changes -
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Smita Pawar (Inactive)
made changes -
| Remaining Estimate | 18.5h [ 66600 ] | 17.5h [ 63000 ] |
| Time Spent | 22.5h [ 81000 ] | 23.5h [ 84600 ] |
| Worklog Id | 93617 [ 93617 ] |
Smita Pawar (Inactive)
made changes -
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Smita Pawar (Inactive)
made changes -
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
13d 18h 53m | 1 |
|
2s | 1 |
|
2d 22h 22m | 1 |
Smita Pawar (Inactive)
made transition
-
|
21d 1h 25m | 1 |
Smita Pawar (Inactive)
made transition
-
|
65d 4h 15m | 1 |
Smita Pawar (Inactive)
made transition
-
|
4s | 1 |
Smita Pawar (Inactive)
made transition
-
|
5s | 1 |
Smita Pawar (Inactive)
made transition
-
|
14d 47m | 1 |
Smita Pawar (Inactive)
made transition
-
|
3s | 1 |
Smita Pawar (Inactive)
made transition
-
|
3s | 1 |
Smita Pawar (Inactive)
made transition
-
|
4d 2h 8m | 1 |
Smita Pawar (Inactive)
made transition
-
|
4s | 1 |
Hi Smita Pawar,
Please find the technical documentation.
Attachment: TechSpec_WT-10365_ACA Export In case of from date of export is blank should refer fiscal year start date.doc
Thanks,
Revan
Yogesh Chaudhari Nandkumar Prabhakar Karlekar Kumar Chhajed