Skip to main content
Question

How can I completely delete a service resource in 26R1?

  • September 3, 2026
  • 3 replies
  • 36 views
Do Gooder (Customer)
Forum|alt.badge.img+4

Hi,

The service resource was never used. I don’t wand to hide or block this resource.

The URL: main/ifsapplications/projection/v1/ResourceIndividualsHandling.svc/ResourceSet(ResourceSeq=6403)

Method: POST

returns:

{
    "error": {
        "code": "DATABASE_ERROR",
        "message": "Database error occurred. Contact administrator.",
        "details": [
            {
                "code": 20116,
                "message": "ORA-20116: Resource.CONSTRAINT: The Resource \"6403\" is used by 592 rows in another object (Resource Base Schedule)."
            }
        ]
    }
}

Which API-Call do I have to use to remove the entries in Resource Base Schedule?

 

Best Regards

Michael

    3 replies

    Do Gooder (Customer)
    Forum|alt.badge.img+4
    • Michael_B
    • Author
    • Do Gooder (Customer)
    • September 3, 2026

    Sorry, please change method to: DELETE.

     

    With this API-Call it is possible to show the entries:

    “int/ifsapplications/entity/v1/ResourceBaseScheduleEntity.svc/ResourceBaseScheduleSet?$filter=(ResourceId eq '{ResourceId}')”
    Do Gooder (Employee)
    Forum|alt.badge.img+3
    • danhse
    • Do Gooder (Employee)
    • September 4, 2026

    Hi Michael, I imagine you’d have to delete all generated shifts for that resource, and you could try this:

    “int/ifsapplications/projection/v1/ResourceShiftService.svc/DeleteResourceShift”

    {
      "DeleteResourceShift": [
        {
          "ResourceId": "It is a Text",
          "ResourceType": "MACHINE",
          "ResourceSeq": 1,
          "Company": "It is a Text",
          "EmployeeId": "It is a Text",
          "RegularShift": [
            {
              "AccountDate": "2019-10-10",
              "ShiftPeriod": 1
            }
          ],
          "OnCallShift": [
            {
              "AccountDate": "2019-10-10",
              "ShiftPeriod": 1
            }
          ]
        }
      ]
    }

     

     

    Let me know if you still get an error!

    MFW-58
    Sidekick (Former Employee)
    Forum|alt.badge.img+5
    • MFW-58
    • Sidekick (Former Employee)
    • September 4, 2026

    Do you have to do the delete of the shifts via an API? There is a routine in IFS Cloud that allows you to select the Resource you want to delete Shifts for which is likely a cleaner way to do it. I am not sure if you can call this routine from API; I suspect you probably could. 

    Search for Remove Resource Schedules and Capacity
     


    Using the assistant is pretty self explanatory. Once all the related information is removed against the Resource then I expect you should be able to delete them.

    Terms & ConditionsAccessibility statement