How do I resolve this reference attribute problem? RRS feed

  • Question

  • We have an Oracle HR table.

    EmployeeNumber is unique and is the one we want to use as a base reference.

    There is a ReportsTo attribute which contains the EmployeeNumber of the user's manager.

    However, To make sense of the data in the table we have to invent an Anchor in our CS consisting of 3 attributes:

    EmployeeNumber + OperationType + LastModifiedTime

    Having set this anchor, how can I make FIM/MIM use ReportsTo as a reference? Normally I would have set EmployeeNumber as the anchor but is impossible with the table supplied by HR.

    I would like to Sync the OracleHR MA ReportsTo attribute to person.MV attribute manager. But How??

    Tuesday, January 24, 2017 1:38 PM

All replies

  • I think your approach needs to be this: Why do you have to invent such a complex anchor? An anchor should not change. This anchor will definitely change, as the LastModifiedTime of the records surely will vary.

    But as long as you update the Manager Reference attribute in the agent accordingly when the anchor changes for the manager, you should be fine....

    If not, you could build a custom workflow in the FIMService/Portal to set the manager (last resort).

    Did my post help? Please use "Vote As Helpful", "Mark as answer" or "Propose as answer". Thank you!

    Tuesday, January 24, 2017 2:03 PM