Oracle regularly releases patches to fix code, security, performance and other vulnerability issues for Oracle Apps. https://support.oracle.com formerly known as Metalink maintains all these…
Microsoft Excel is a great product. You can use it to do the simple tasks and even create a game.…
“Can you please reset my Oracle Apps Password in a testing environment? I tried changing from Edit->Preferences->Change Password, but it…
Log on session is no longer valid. Would you like to log back in so you can continue working? If…
Once a developer asked, “How to combine multiple rows into a single string delimited by comma, or pipe?” The requirement is…
PL/SQL BULK Processing allows to batch or group number of records and sends in batches to a database for processing.…
frmcmp_batch or frmcmp_batch.sh is a UNIX level utility available in Oracle Apps to compile custom form(.fmb) and libraries(.pll). Syntax: frmcmp…
SQL Developer or TOAD provides a graphical user interface for monitoring database sessions. It shows Active SQL, Explain Plan, Locks,…
FND_USER_PKG is built-in API in Oracle apps for user management from the back-end. In this article, I will share how…
SELECT va.sql_text ,va.module FROM APPS.fnd_concurrent_requests fcr ,V$SESSION vs ,V$SQLAREA va WHERE fcr.oracle_session_id = vs.audsid AND vs.sql_hash_value = va.hash_value AND fcr.request_id…