General

General Topics

Query to get current executing statement in Oracle concurrent program

Use below query to get the current executing statement in Oracle Apps concurrent programs. 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 = <request_id>; Table Information fnd_concurrent_requests:- This table holds the history of all submitted program in Oracle Apps like request id, request …

Query to get current executing statement in Oracle concurrent program Read More »

XAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Tomcat, Mercury

This article explains how to use the XAMPP control panel to start/stop, administer/ configure services like Apache, MYSQL, FileZilla, Mercury, Tomcat with just a click of a button. Before moving further, let’s discuss XAMPP in Brief. XAMPP XAMPP is free and easy to install Apache distribution. It acronyms to Cross-Platform (X), Apache (A), MariaDB (M), PHP …

XAMPP Control Panel – Manage/Configure Apache, MySQL, FileZilla, Tomcat, Mercury Read More »

FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output

Emailing concurrent request output is a common requirement in any business. You can email a concurrent request output in Oracle Apps using Delivery Options while submitting the request or using API FND_REQUEST.ADD_DELIVERY_OPTION or FND_DELIVERY. You should use this API when you are submitting a concurrent request from backend using PL/SQL.I will explain how to use fnd_request.add_delivery_option and fnd_delivery option, before that, …

FND_REQUEST or FND_DELIVERY to Email Oracle Concurrent Request Output Read More »

How to Install XAMPP on Windows 10

XAMPP is a completely free, open-source, and easy to install Apache distribution containing Apache HTTP Server, MariaDB, PHP, and Perl and other supporting modules like FileZilla, Tomcat, Mercury, etc. It is released by apache-friends which is a non-profit project to promote the Apache webserver under GNU General Public License. XAMPP provides basic infrastructure like an …

How to Install XAMPP on Windows 10 Read More »

secure-email-feature-image

How to enable and disable 2-Step Verification for Google Account

Your email is one of the most important online assets that you have. Nowadays, you use email for everything, credit card statements, bank statements, etc. It contains a lot of personal and important information. So, how to safeguard your email Account from Hackers? Hackers are in search of information they could exploit to get some …

How to enable and disable 2-Step Verification for Google Account Read More »