Oralce Tutorials and Tips
As per Redhat, Virtualization is a technology that allows you to create multiple simulated environments or dedicated resources from a single, physical hardware system. There are many software available like, VMWare Oracle VirtualBox QEMU Microsoft Hyper-V KVM This article mainly focuses on VirtualBox and explains how to download and install it on Windows 10 64 …
FND_FILE is a built-in package provided in Oracle Apps/E-Business Suite to write log and output files in PL/SQL concurrent program. This is actually a wrapper on UTL_FILE to write files on the Unix server. You can open the log and output file using navigation View -> Requests -> Find. Select the respective request on the …
FND_FILE – create log and output file in Oracle Apps Concurrent Program Read More »
FND_USER_PKG is built-in API in Oracle apps for user management from the back-end. In this article, I will share how to use this API for common user management task like user creation, reset password, adding and deleting responsibility. There are many methods available, but mostly we will focus on common methods. create_user Use this API …
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 »
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 »
Business users sometimes need functionality to email output of the concurrent program as soon as it completes. Let’s see how to email concurrent request output in Oracle Apps You can achieve this using another custom concurrent program based on Unix, PL/SQL so send an email of a concurrent program. Unix provides mailx and in PL/SQL …
In this article, let’s see how to submit a concurrent program from UNIX operating system using CONCSUB utility. CONCSUB CONCSUB is UNIX operating system command prompt utility in Oracle Apps to submit concurrent program. Syntax CONCSUB <APPS username>/<APPS password> \ <responsibility application short name> \ <responsibility name> \ <username> \ [WAIT=N|Y|<n seconds>] \ CONCURRENT \ <program …
How to submit concurrent program using CONCSUB utility Read More »
