SQL Language (MOSC)

MOSC Banner

Oracle EBS users responsibility end date update

edited Mar 9, 2021 3:40PM in SQL Language (MOSC) 2 commentsAnswered

Hi team,


I discovered that the end date of some responsibilities had not been set when the user was deprovisioned.

There is a separate end date at the user level and at the responsibility level.

To tidy up this data for future reviews how can I run a script that updates the responsibility end date for users where (the user end date is not null or forward dated) and the responsibility end date is null ?

We should not update responsibility end dates that are not null.

The responsibility end date should be set to the end date of the user (not the current date) so it reflects the fact that the responsibility ended when the user was deactivated.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center