Case - Hi everyone! I have users in my client environment where the userID of employees from client organisation starts with AA. Now there are a few hundred users from company B who have been uploaded in the sys_user table where for every user from company B there are 2 records in the user table- one with user id as their email id & one with their userID starting from AA (according to client organisation norms).
Note- 1.{All of the company B employees have an email ending with @bb.com which stays same in both versions of their record-only userID is different}
2. [Modifying the user table is not an option].
Requirement : Now my requirement is to ensure all the reports created by employees from B should be updated with their userIDs starting with AA .[Currently reports created by company B users have their created by - with the userIDs which have their emails].
How to implement this requirement ? Can use a script or a business rule.
