SQL to retrieve a list of descriptive flexfields with column usages and valueset definitionsFor a little project I needed to retrieve E-Business Suite Descriptive Flexfields for all applications together with...
SQL
Organization Authority in Oracle Projects and the SQL you needWithin Oracle Projects exists a functionality called Organization Authority. With Organization Authority you have the ability to...
Retrieve which Oracle Discoverer workbooks are shared with a specific responsibilityAfter my earlier post regarding the SQL query to extract the shared workbooks with a specific user...
SQL to extract active user list with responsibilitiesToday I got the request to generate an extract with active users together with their active responsibilities....
SQL to Check for Locked User AccountsIn our instance we’re not using the seeded delivered password policies which can be activated by setting...
