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

Ledcor Beneficiary Load - Trust record

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 35 - Bugs

      Description

      Hi,
      For the import template Bene_No DOB_Trust the Trust Record imported is kicking out with the error Dependent Date of Birth is required. The record being imported (see bad file) has a relationship type of Trust so do not understand why this is not loading. I thought if the relationship is defined as Trust then the Beneficiary Trust Name field is populated and the Beneficiary First Name, Beneficiary Last Name, Beneficiary Date of Birth are not required.
      Can you please take a look at this import and let me know what is missing.
      I did try to map the Beneficiary Date of Birth field but received an Import Failed error.
      Thanks!
      Cindy

        Attachments

        1. customization.jpg
          customization.jpg
          222 kB
        2. Date of birth load.jpg
          Date of birth load.jpg
          174 kB
        3. employee history.jpg
          employee history.jpg
          198 kB
        4. QNI_5_Beneficiaries_2017-07-20.zip
          0.5 kB
        5. QuincyImport.jpg
          QuincyImport.jpg
          98 kB

          Issue Links

            Activity

            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on LB
            Company - Wheaton

            Verified below scenario for beneficiary import :
            1)Not given Date of birth in beneficiary template - Import is done successfully for "Trust","Business associate", and "Other" , "Spouse","Child","Domestic partner","Employee","Friend","Other Relative","Parents","Sibling"
            3)When DOB is given for spouse, child etc , its uniqueness has been removed - not necessary to mark DOB field unique(Without uniqueness import is done successful)
            4)For Trust","Business associate", and "Other" ,"Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" - Date of birth is inserted in beneficiary page.
            5)If spouse/child no exists in system - file wents to bad with proper error message("No such child/spouse exists")
            6)When DOB is mapped but not given in File or given as "~" - Import done successfully
            7)For Unique DOB field - Import done successfullu
            8)For Uniquee DOB Field - DOB is blank(File wents to bad)

            Working fine as expected,
            Marking item state as Ready for stage

            Thanks,
            JAyshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on LB Company - Wheaton Verified below scenario for beneficiary import : 1)Not given Date of birth in beneficiary template - Import is done successfully for "Trust","Business associate", and "Other" , "Spouse","Child","Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" 3)When DOB is given for spouse, child etc , its uniqueness has been removed - not necessary to mark DOB field unique(Without uniqueness import is done successful) 4)For Trust","Business associate", and "Other" ,"Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" - Date of birth is inserted in beneficiary page. 5)If spouse/child no exists in system - file wents to bad with proper error message("No such child/spouse exists") 6)When DOB is mapped but not given in File or given as "~" - Import done successfully 7)For Unique DOB field - Import done successfullu 8)For Uniquee DOB Field - DOB is blank(File wents to bad) Working fine as expected, Marking item state as Ready for stage Thanks, JAyshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Stage
            Company - Asml for hspl

            Verified below scenario for beneficiary import :
            1)Not given Date of birth in beneficiary template - Import is done successfully for "Trust","Business associate", and "Other" , "Spouse","Child","Domestic partner","Employee","Friend","Other Relative","Parents","Sibling"
            3)When DOB is given for spouse, child etc , its uniqueness has been removed - not necessary to mark DOB field unique(Without uniqueness import is done successful)
            4)For Trust","Business associate", and "Other" ,"Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" - Date of birth is inserted in beneficiary page.
            5)If spouse/child no exists in system - file wents to bad with proper error message("No such child/spouse exists")
            6)When DOB is mapped but not given in File or given as "~" - Import done successfully
            7)For Unique DOB field - Import done successfully
            8)For Unique DOB Field - DOB is blank(File wents to bad)

            Marking item state as Ready for Production

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage Company - Asml for hspl Verified below scenario for beneficiary import : 1)Not given Date of birth in beneficiary template - Import is done successfully for "Trust","Business associate", and "Other" , "Spouse","Child","Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" 3)When DOB is given for spouse, child etc , its uniqueness has been removed - not necessary to mark DOB field unique(Without uniqueness import is done successful) 4)For Trust","Business associate", and "Other" ,"Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" - Date of birth is inserted in beneficiary page. 5)If spouse/child no exists in system - file wents to bad with proper error message("No such child/spouse exists") 6)When DOB is mapped but not given in File or given as "~" - Import done successfully 7)For Unique DOB field - Import done successfully 8)For Unique DOB Field - DOB is blank(File wents to bad) Marking item state as Ready for Production Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Company - Asml for hspl

            Verified below scenario for beneficiary import :
            1)Not given Date of birth in beneficiary template - Import is done successfully for "Trust","Business associate", and "Other" , "Spouse","Child","Domestic partner","Employee","Friend","Other Relative","Parents","Sibling"
            3)When DOB is given for spouse, child etc , its uniqueness has been removed - not necessary to mark DOB field unique(Without uniqueness import is done successful)
            4)For Trust","Business associate", and "Other" ,"Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" - Date of birth is inserted in beneficiary page.
            5)If spouse/child no exists in system - file wents to bad with proper error message("No such child/spouse exists")
            6)When DOB is mapped but not given in File or given as "~" - Import done successfully
            7)For Unique DOB field - Import done successfully
            8)For Unique DOB Field - DOB is blank(File wents to bad)

            Marking item state as Production complete

            Thanks,
            Jayshree

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Company - Asml for hspl Verified below scenario for beneficiary import : 1)Not given Date of birth in beneficiary template - Import is done successfully for "Trust","Business associate", and "Other" , "Spouse","Child","Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" 3)When DOB is given for spouse, child etc , its uniqueness has been removed - not necessary to mark DOB field unique(Without uniqueness import is done successful) 4)For Trust","Business associate", and "Other" ,"Domestic partner","Employee","Friend","Other Relative","Parents","Sibling" - Date of birth is inserted in beneficiary page. 5)If spouse/child no exists in system - file wents to bad with proper error message("No such child/spouse exists") 6)When DOB is mapped but not given in File or given as "~" - Import done successfully 7)For Unique DOB field - Import done successfully 8)For Unique DOB Field - DOB is blank(File wents to bad) Marking item state as Production complete Thanks, Jayshree
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Hi Jayshree Nagpure
            Were you able to test with the attached zip file on Quincy in Stage?
            Just need to know so I can let BCC know whether we tested the file or not.
            Thanks!
            Cindy

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Hi Jayshree Nagpure Were you able to test with the attached zip file on Quincy in Stage? Just need to know so I can let BCC know whether we tested the file or not. Thanks! Cindy
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Cindy Wibbing,

            Yes, We tested the attached zip file on Quincy for hspl on stage.
            Import done successfully -
            Also verified on beneficiary page

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Vishal Bajad

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Cindy Wibbing , Yes, We tested the attached zip file on Quincy for hspl on stage. Import done successfully - Also verified on beneficiary page Thanks, Jayshree cc : Rakesh Roy Prasad Pise Vishal Bajad

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              Cindy.Wibbing Cindy Wibbing (Inactive)
              Developer:
              Vishal Bajad (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 10h Original Estimate - 10h
                  10h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 34.75h
                  34.75h