2011 - Just Know IT Just Do IT

SQL to Check for Locked User Accounts Locked_User

SQL to Check for Locked User Accounts

Cyriel van Schaik November 4, 2011

SQL to Check for Locked User AccountsIn our instance we’re not using the seeded delivered password policies which can be activated by setting...

SQL to Monitor Application Logins User_Logins

SQL to Monitor Application Logins

Cyriel van Schaik November 2, 2011

SQL to Monitor Application LoginsWhen an implementation of Oracle E-Business Suite goes live you might want to monitor the use of...

Synchronize Email Address between User and HR Employee SyncEmail

Synchronize Email Address between User and HR Employee

Cyriel van Schaik October 12, 2011

Synchronize Email Address between User and HR EmployeeWhenever you change the email address of a HR Employee record you will notice that this change...

Extract Full HR Location Info Through SQL HR_LOCATION

Extract Full HR Location Info Through SQL

Cyriel van Schaik October 9, 2011

Extract Full HR Location Info Through SQLIt’s time for a little bit of SQL again. In the past I needed a little dump...

Responsibility not visible in Administer Folders in Forms and default folder in Forms Folder_1

Responsibility not visible in Administer Folders in Forms and default folder in Forms

Cyriel van Schaik October 6, 2011

Responsibility not visible in Administer Folders in Forms and default folder in FormsFor a new requirement we wanted to use the Pre-Approved Batches option within Oracle Projects. As you...