Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-13255

JE Dunn Inbound file of Terminations processed all in the file except for one on 12/20/17 - there should be a 'bad file' for 12/20/17

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      EDI
    • Company:
      JE Dunn
    • Module:
      BenAdmin - Import
    • Severity:
      Simple

      Description

      Company JE Dunn
      Import template: Employee_Ongoing_Terms
      Remote Directory: jedunn/inbound
      Inbound file name: WT_TERMS.csv
      Run Date: 12/20/2017

      The termination for Clyde Rowe was not processed on 12/20/2017, there is no 'bad file' visible for 12/20/2017.
      There is an invalid phone number for Clyde Rowe, a 'bad file' was expected.
      The remaining terminations in the 12/20/2017 file did process successfully in Workterra at the date/time the file processed in workterra on 12/20/2017.

      When the issue was discovered, the record for Clyde Rowe was processed in a new inbound file on 1/25/2018 , and a 'bad file' was created on 1/25/2018 as expected. The 'bad file' for 1/25/2018 processed successfully.

      Please check to see what happened on 12/20/2017 for when the inbound termination was processed. An explanation is needed for the client.

        Attachments

          Activity

          Rochelle.Thomas Rochelle Thomas created issue -
          Rochelle.Thomas Rochelle Thomas made changes -
          Field Original Value New Value
          Summary JE Dunn Inbound file of Terminations processed all in the file except for One on 12/20/17 - why did the One record fail to process JE Dunn Inbound file of Terminations processed all in the file except for one on 12/20/17 - there should be a 'bad file' for 12/20/17
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment -

          The JE Dunn Inbound file of Terminations processed all in the file except for one record on 12/20/17 - there should be a 'bad file' for 12/20/17; What happened during the inbound processing of the Terminations file WT_TERMS on 12/20/2017?

          CC:Andrea Dennis, Kevin Walker, Cindy Wibbing

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - The JE Dunn Inbound file of Terminations processed all in the file except for one record on 12/20/17 - there should be a 'bad file' for 12/20/17; What happened during the inbound processing of the Terminations file WT_TERMS on 12/20/2017? CC: Andrea Dennis , Kevin Walker , Cindy Wibbing
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Satya [ ID10004 ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status New [ 10508 ] In Analysis [ 10008 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment View_BadFile.png [ 72757 ]
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Rochelle Thomas,

          We have checked inbound file of 12/20/17. The termination for Clyde Rowe was not processed on 12/20/2017 and bad file was created for this with reason i'e 'Home Phone: Invalid Length '. Pleas find below snap of bad file which was created on 12/20/2017.

          Please refer Bad_WT_TERMS12_20_2017 12_33_35 PM.csv to download bad file.

          CC-Suraj Sokasane

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Rochelle Thomas , We have checked inbound file of 12/20/17. The termination for Clyde Rowe was not processed on 12/20/2017 and bad file was created for this with reason i'e 'Home Phone: Invalid Length '. Pleas find below snap of bad file which was created on 12/20/2017. Please refer Bad_WT_TERMS12_20_2017 12_33_35 PM.csv to download bad file. CC- Suraj Sokasane Thanks, Ganesh
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Issue Type Analysis [ 10711 ] Support Activity [ 10301 ]
          Status In Analysis [ 10008 ] In Progress [ 3 ]
          Support Task Type Customization [ 11204 ]
          Workflow WorkTerra_Analysis_ver 1.0 [ 63034 ] WT_Support [ 63096 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 02/Feb/18 09:34 AM
          • Time Spent:
            1.5h
             
            <No comment>
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 1.5h [ 5400 ]
          Worklog Id 103211 [ 103211 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Resolution System Behaviour [ 10100 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Rochelle Thomas [ rochelle.thomas ]
          Rochelle.Thomas Rochelle Thomas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Ganesh Sadawarte (Inactive) made transition -
          NEW In Analysis
          10h 52m 1
          Ganesh Sadawarte (Inactive) made transition -
          In Analysis In Progress
          3h 8m 1
          Ganesh Sadawarte (Inactive) made transition -
          In Progress Resolved
          2m 38s 1
          Rochelle Thomas made transition -
          Resolved Closed
          6h 42m 1

            People

            Assignee:
            Rochelle.Thomas Rochelle Thomas
            Reporter:
            Rochelle.Thomas Rochelle Thomas
            Account Executive:
            Andrea Dennis (Inactive)
            EDI Analyst 1:
            Damion M Velasquez
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 1.5h
                1.5h