Oralce Tutorials and Tips
Perl uses DBI and Excel::Writer::XLSX module to connect Oracle Database and Generate Excel (.xlsx). In this article, let’s see how to use it with an example. Oracle apps use built-in XML Publisher to generate Excel output file. So you create data definition and template and register it as a concurrent program. Mainly below Template Type …
Perl program to connect Oracle Database and generate Excel Read More »
This article explains how to solve User not defined or not assigned to the responsibility – ‘APS COLLECTIONS’ error while submitting “Planning Data Pull” request in Oracle Advanced Supply Chain Planning. Planning Data Pull Planning Data Pull is a starting point while running Oracle ASCP Plan. This request pulls data from source instance. When you …
User not defined or not assigned to the responsibility – ‘APS COLLECTIONS’ Read More »
Oracle SQL* Plus is interactive batch query tool installed with Oracle Database. SQL* Plus has its own commands and environment, and it provides access to the Oracle Database. It enables you to enter and execute SQL, PL/SQL. In this article, let’s see SQL* Plus SET command and how to use it with examples. SET SET commands …
As discussed in last posts, concurrent programs in Oracle Apps allows submitting multiple concurrent programs. You can even submit multiple instances of the same program at the same time. In such case, multiple runs of the same program can interfere with each other if underline logic is not defined to run in parallel. It may …
How to Define Concurrent Program Incompatibility in Oracle Apps Read More »
Oracle Developer Suite provides Oracle Forms Developer, Oracle Designer, Oracle Reports Developer, and Oracle10g JDeveloper tools. This guide describes the installation process for Oracle Developer Suite 10g (10.1.2.0.2) for Windows platforms. Pre-requisite Basic software installation knowledge on Microsoft Windows Operating System. Software/Hardware Microsoft Windows 7/8/10 Oracle Developer Suite 10G (10.1.2.0.2) Download Oracle Developer Suite 10G Oracle …
Oracle Developer Suite 10G Installation Guide [Windows] Read More »
SQL* Plus is one of the executable method available while defining a concurrent program in Oracle Apps. It allows running SQL* Plus script against the Oracle ERP database under Oracle Apps Environment following all security and access control. This method helps to create some ad-hoc script as a concurrent program. Ideally, convert this standalone script …
“Receivable Inquiry is not a valid responsibility for the current user. Please contact your System Administrator.” Got this error. What did I do? I just added this responsibility to my user and tried to navigate Customer OAF page. That’s it. What could be the reason for this, not valid responsibility issue? Just did some research …
How to Clear the OA Framework cache in Oracle Apps Read More »
Oracle apps provide built-in functionality to schedule concurrent programs so that they run at specified time and interval. This leads to effective utilization of hardware, software and human resources. Concurrent Program is one of the most important functionality available in Oracle Apps. It allows users to submit job parallelly. These programs run in the background and …
Concurrent Program/Request Scheduling in Oracle Apps – Guide Read More »
This article explains how to enable trace for Concurrent Programs, Forms, and Reports and generate TKPROF in Oracle Apps. Oracle SQL trace Oracle SQL trace allows you to accurately assess the efficiency of the SQL statements. It can help you identify, pinpoint the exact SQL query or event which is causing the performance problem. The …
Trace for Concurrent Programs, Forms and Reports in Oracle Apps Read More »
Now you installed VirtualBox on your Windows Desktop successfully. What Next…..? Let’s create the first Windows 10 virtual machine using VirtualBox. VirtualBox supports guest operating systems like Windows, Linux Family – Ubuntu, Suse, Solaris, etc., Free BSD, and other operating systems. Here is the official page showing the complete list of the guest operating system …
Creating Windows 10 Virtual Machine (VM) Using Oracle VirtualBox Read More »
