How to Create, Disable user, Add Responsibility and Reset Password in Oracle Apps from Backend

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 …

How to Create, Disable user, Add Responsibility and Reset Password in Oracle Apps from Backend Read More »

FNDLOAD and XDOLoader to Manage, Download and Upload files

FNDLOAD and XDOLoader are utilities provided in Oracle Apps to download/upload AOL object definition and template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publisher database tables. Oracle XML Publisher Oracle XML Publisher is XML and template-driven tool to design reports in Oracle Applications. You can use Microsoft Word/Excel or Adobe PDF …

FNDLOAD and XDOLoader to Manage, Download and Upload files Read More »

How to Select Multiple Records in Oracle Apps Forms ( Multi-Select Check Box Tutorial)

In Oracle forms, you would have seen a multi-record block with a checkbox. When you click,  Select all – when the master checkbox is checked then all child checkboxes on the form should be checked. Unselect All – when the master checkbox is unchecked then all child checkboxes on the form should be unchecked. This …

How to Select Multiple Records in Oracle Apps Forms ( Multi-Select Check Box Tutorial) Read More »

How to schedule Concurrent Program/Request in Oracle Apps

Oracle apps provide built-in functionality to schedule concurrent programs so that they run at specified times and intervals. This leads to effective utilisation of hardware, software, and human resources. Concurrent Program is one of the most important functionalities available in Oracle Apps. It allows users to submit jobs parallelly. These programs run in the background …

How to schedule Concurrent Program/Request in Oracle Apps Read More »

How to Define Host Concurrent Program in Oracle Apps

The host is one of the execution methods available in Oracle Apps while defining concurrent program executable. It allows the concurrent program to execute operating system commands. Here, the host (Operating System) could be Windows, Unix, or any supported operating system. Here, let’s see how to define a host-based concurrent program. Pre-requisite You should have …

How to Define Host Concurrent Program in Oracle Apps Read More »

What are Concurrent program executable options in Oracle Apps

Executable options allow passing runtime parameter to executable. Mostly it is used for executable based on Oracle Report or XML Publisher. In this article, let’s see the significance of executable options field while defining concurrent program in Oracle Apps. VERSION, ORIENTATION, PAGESIZE Option If you define a concurrent program with the bit-mapped version of Oracle …

What are Concurrent program executable options in Oracle Apps Read More »