theonlyalterego

Member since 08/11/2008

17 snippets

2761 profile views

1 Comment(s) Posted

View their favorites

their Tags

Oracle java Bash linux database sql list windows class forms search find unix security

Profile

Achievement

first submission:submitting first snipplet

theonlyalterego's Recent Snippets

All /

« Prev 1 Next »

SQL Oracle Find Profile Values for User

find what profile values are set for a particular user

Oracle
sql

0 636 posted 11 years ago by theonlyalterego

SQL Oracle AP-SLA-GL Link Query

AP-SLA-GL Link Query

Oracle

0 945 posted 12 years ago by theonlyalterego

SQL Oracle - get concurrent program runtime / eval performance

can be used to track Oracle Apps concurrent program performance

Oracle

0 884 posted 12 years ago by theonlyalterego

SQL Query to find Parameters and Value Sets associated with a Concurrent Program

This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name

Oracle
sql

0 952 posted 12 years ago by theonlyalterego

SQL Oracle SQL - get a list of most recent user logins

Query to find the most recent logins for a particular user ( find 1 years worth )

Oracle
sql

0 818 posted 12 years ago by theonlyalterego

SQL Oracle - Find which users have FND Diagnostic profile value set

A slight adaptation on the sql in the Oracle Forum

Oracle
sql

0 874 posted 12 years ago by theonlyalterego

Windows Registry how to compare IE security zone settings

IE Zone Analyzer allows comparing/importing/exporting of IE security zones

security

1 703 posted 12 years ago by theonlyalterego

Bash Oracle - compile report / compile forms on linux

OFP is the database environment

0 837 posted 12 years ago by theonlyalterego

SQL Oracle - Find all responsibilities and concurrent program names based on the executable Name

0 819 posted 12 years ago by theonlyalterego

SQL Oracle - sql to find what responsibility can run a request / report

Very useful sql to find which responsibility has access to a report or request.

Oracle
sql

0 1869 posted 12 years ago by theonlyalterego

PL/SQL Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

Oracle
sql

0 1155 posted 12 years ago by theonlyalterego

SQL Oracle Applications - Find Application (Module) Long Name from Short name

use this SQL query to find out an applications full name (aka long name) and/or application id based on the application short name. This can obviously be re-written to perform the reverse.

Oracle

0 1034 posted 13 years ago by theonlyalterego

Windows PowerShell Windows DIR - List only the filenames of all files in a directory

I found this today and don't want too lose it. In windows the following command will create a text file named fileListing.txt which will contain a list of all the files in the current directory ( including fileListing.txt )

list
windows

1 2881 posted 13 years ago by theonlyalterego

SQL Oracle SQL - Select OAF File version history

This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file....

0 677 posted 15 years ago by theonlyalterego

Bash Linux Rename File to Current Date/Time

Bash
linux

1 709 posted 15 years ago by theonlyalterego

Java OAF - Controller Code to create Javascript popup window

Sample code from processFormRequest to pop up new window via javascript. worth noting: this is not recommended as it can break the OAF page.

java
Oracle

0 1797 posted 15 years ago by theonlyalterego

Other OAF - Retrieve a Region/Page from Oracle MDS

A quick pl/sql command to select from the MDS using the Oracle JDR_UTILS package.

Oracle

0 683 posted 15 years ago by theonlyalterego

« Prev 1 Next »