We have a requirement wherein we would like to automate the process of unnamed headcount creation in a resource pool. The requirement is to create unnamed headcount at a certain stage in a workflow automatically based on the details on the request form.
We have tried to create the unnamed headcount by inserting rows in the RSC_RESOURCES table. The issue with this is that when we try and create users in the system from the workbench we get a unique constraint error. After certain analysis we found that the issue was that the system creates a resource in the resource table while adding a user in the KNTA-Users table and there the user id which needs to be unique is found to be duplicated.
Is anybody aware of what should be the resource id for creating unnamed headcount? The RSC_RESOURCES table does not have a sequence and hence not sure how do you generate sequence numbers here.
I think both KNTA_USERS and RSC_RESOURCES use knta_users_s as the sequence because in RSC_RESOURCES both resource_id and user_id have the same values, unless it is unnamed headcount...in which case user_id is null.