Monitor Oracle Database Sessions using SQL Developer
Oracle maintains database runtime statistics related to performance in Dynamic Performance Views i.e v$ and gv$ views. Use Views like…
User Management using FND_USER_PKG API in Oracle Apps
FND_USER_PKG is built-in API in Oracle apps for user management from the back-end. In this article, I will share how…
Query to get current executing statement in concurrent program
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…
XAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Mercury and Tomcat Service
XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. It is local development environment which includes…
Oracle Report Builder Crashes while opening a report
Working on Oracle Apps upgrade (11i–> R12) project and retrofitting Oracle Reports from 6i to 10G. You, Open report builder…
PO_NOTES and PO_NOTE_REFERENCES replacement in Oracle Apps R12
PO_NOTES and PO_NOTE_REFERENCES tables are obsolete in Oracle Applications release 12. If you are upgrading Oracle Apps from 11i to…
Line Termination Character in Unix and Windows and Cntrl-M character
Wondering, why I am writing this post……!!! It is common problem faced during development. Mostly developer work on Windows platform,…
UNIX mailx Command to send Email with Example
“Mailx is an intelligent mail processing system, which has a command syntax reminiscent of ed(1) with lines replaced by messages.…
Connect Cloud Database Service using SSH and Port Forwarding
Oracle Database Client uses port ranges in from 1520-1530 to connect database over TCP/IP, default listener port is 1521. These ports…
Script to Add AUTHID CURRENT_USER to package specification
Oracle recommends creating package in APPS schema. Many of customer creates these objects in custom schema. Though ideally it should…