Human Capital Management - EBS (MOSC)

MOSC Banner

EBS users differences - audit

Hi team,

I have tried to compare differences between regular database and provided EBS schemas/users in our 12.1.3. environment (database 12.1). I need this information in order to implement password change, so I'm not sure which user passwords I can alter by using FNDCPASS, and which by using "alter user" statement.

I have used this statement to see differences between these two groups of users :


select username from dba_users

where username not in (select oracle_username from FND_ORACLE_USERID)

and default_tablespace='APPS_TS_TX_DATA'

order by username;


Now my problem is that I have around 26 EBS schemas which do not exist in FND_ORACLE_USERID like ABM, AHM, AMF, CSS, CUE, CUN, EAA etc. And I have read documentation where those schemas are part of EBS.

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