AOL and SYSADMIN

FNDLOAD Scripts to Migrate AOL Entities

by Shailender Thallam
August 31, 2011May 11, 2017
1 Comment

To know what is FNDLOAD Utility? and how to use it?, do read this article Here are the FNDLOAD Scripts to Migrate 15 different AOL… Read More »FNDLOAD Scripts to Migrate AOL Entities

SQL Query to list Active Responsibilities of a Active User

by Shailender Thallam
August 17, 2011June 14, 2013
2 Comments

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 /************************************************************************** *PURPOSE:… Read More »SQL Query to list Active Responsibilities of a Active User

SQL Query to list out Responsibilities assigned to a Request Group

by Shailender Thallam
August 17, 2011January 17, 2013

1 2 3 4 5 6 7 8 9 10 11 12 13 14 /************************************************************************** *PURPOSE: To list out Responsibilities assigned to a Request Group… Read More »SQL Query to list out Responsibilities assigned to a Request Group

SQL Query to list all Oracle Reports assigned to a Responsibility

by Shailender Thallam
August 17, 2011September 25, 2011

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to list all Oracle Reports assigned to a Responsibility

[Decrypting User Password]How to find password of a User in Oracle Apps R12?

by Shailender Thallam
July 28, 2011July 19, 2020
4 Comments

THIS WORKS WITH ORACLE R12 Here is a wonderful oracle seeded Procedure fnd_web_sec.get_guest_username_pwd which will help us to find out user password. This will be… Read More »[Decrypting User Password]How to find password of a User in Oracle Apps R12?

[TOAD Error] Specified Plan Table not Found while trying to see Explain Plan of a Query

by Shailender Thallam
July 27, 2011July 30, 2011

TOAD can report error “ORA-02404: specified plan table not found” when trying to display execution plans To come out of this problem In TOAD, Navigate… Read More »[TOAD Error] Specified Plan Table not Found while trying to see Explain Plan of a Query

Disable Password Prompt for Examine, Trace, Debug, Properties, Forms Personalization and Custom Code

by Shailender Thallam
July 9, 2011December 15, 2016
2 Comments

Set the profile option “Utilities: Diagnostics” to “Yes” which will disable password prompt while accessing Examine, Trace, Debug, Properties, Forms Personalization and Custom Code Note:… Read More »Disable Password Prompt for Examine, Trace, Debug, Properties, Forms Personalization and Custom Code

« Previous
1
…
4
5
6