Siebel Business Process & Functionality (MOSC)

MOSC Banner

how to disable employee from backend

edited May 7, 2015 10:01AM in Siebel Business Process & Functionality (MOSC) 6 commentsAnswered

Hi,

Can you please let me know how to disable employee from backend temporarily?

We would like to use certain flags on S_CONTACT OR S_USER, but could not make it work.

We tried with the each of the below one (and three flags in conjunction too), but no luck.

Can you please advice?

UPDATE SIEBEl.S_CONTACT SET EMP_FLG='N' WHERE  PAR_ROW_ID = '<>';

COMMIT;

UPDATE SIEBEL.S_USER SET USER_FLG='N' WHERE PAR_ROW_ID='<>';

COMMIT;

UPDATE SIEBEL.S_CONTACT SET ACTIVE_FLG='Y' WHERE PAR_ROW_ID='<>';

COMMIT;

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