Techtown

Oracle Application Express is Web Application Development Tool. It enables you to design, develop and deploy beautiful, responsive, database-driven applications using only your web browser. Oracle provides most of the development tool free to download for learning and evaluation purpose. This…

Notepad++ is a text editor. It is available for Microsoft Windows Platform only. In Windows, default text editor is Notepad. But, it is very much primitive. It helps you to create, modify text files. So if you need fast, feature…

Notepad++ Compare Plugin is a diff tool for Notepad++. It shows a difference of two files side by side. In this article, let’s talk about it and see how to download, install and use it to compare two text files.…

Notepad++ Plugin Manager helps to manage all plugins. It helps to Install, Update and Uninstall plugins and make your job super easy. In this article, I will explain Plugin Manager in brief. Plugin Manager Dashboard Notepad++ is text editor. It…

Notepad++  (Notepad Plus Plus) is one of the best text editor available in the market today. It is free, open source and features rich. You can further extend the features by installing the 3rd-party developed plugin. Plugins are actually add-ons to main software…

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 asynchronous manner.  You can submit multiple instances of the same program. A concurrent…

Oracle SQL trace allows you to accurately assess the efficiency of the SQL statements. It can help you identify, pinpoint exact SQL query or event which is causing the performance problem. Trace file as per this article shows below information, Parse, execute,…

Now you installed VirtualBox on your Windows Desktop successfully. What Next…..? Let’s create first Virtual Machine using VirtualBox. It supports guest operating systems like Windows, Linux Family – Ubuntu, Suse, Solaris, etc., Free BSD and other operating systems. Here is…

This article is about BITNAMI which provides application packaging and deployment service. There are free and paid CMS like WordPress, Drupal, Joomla, etc available in Market. This list is big. Which CMS is good for me? Which one should I…

Wanna install multiple operating systems on same Desktop/Hardware? Wow…..!!! How to do that? One option, you can create multiple hard-disk partitions and install Windows, Linux and other Operating System. There is one problem here, you need to restart your desktop…

Pre-Built Developer VMs (for Oracle VM VirtualBox) helps you to import pre-built and ready to use development virtual machines directly to Virtualbox. No need to install an operating system or any other software except, you need Virtualbox Installed on your…

What is XAMPP? Full form of XAMPP is Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is basically the list of Modules/Services it provides. XAMPP is free and easy to install Apache distribution containing MariaDB, PHP, and…

Why should I move a website from HTTP to HTTPS? I also had the same question. There was a good discussion going on Shoutmeloud forum, whether a blog should move to https or not. Is there any advantage moving your blog to…

Oracle Reports is the one of execution method available in Oracle Apps while defining concurrent program executable. Oracle Reports is enterprise reporting tool. It enables businesses to give immediate access to information to all levels within and outside of the…

Opening support request with Oracle Support and looking for Oracle database version? It is 10G, 11G, 12C, but you need to enter complete details like 10.0.1.3.4 while raising a ticket. How to find version? You may ask DBAs to send this…

FND_FILE is built-in package provided in Oracle Apps/E-Business Suite to write log and output file 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…

Started a Blog and dedicatedly working on it, still, your website not getting enough traffic? This is a common question asked on shoutmeloud forum. Everyday new young blogger joins blogging and writes some articles. Most of the time their motivation…

Digital Forensics is regarded as an emerging topic nowadays due to the increasing number of computer crimes. Even though there doesn’t exist a precise definition to “Digital Forensics” it can be defined as the science of capturing, processing and investigating…

Yes, you read it correctly. Google assistant, your personal virtual assistant is going to be available for Android tablets running Android 7.0 Nougat and 6.0 Marshmallow and phones running 5.0 Lollipop. So Lollipop user can also say “Ok, Google “…

Are you looking for free Oracle Apps Instance for learning and practice purpose? Though you can install it on your local desktop, you may need good hardware and expertise to manage/install it. What if you get free Oracle EBS Vision…

MyBB is another free and open source forum software. It is intuitive, extensible, and incredibly powerful forum software. It offers good features like forums to threads, posts to private messages, search for profiles, and reputation to warnings. This forum has…

Apache friends released new version of XAMPP  supporting PHP 7.7.11, 7.0.25 and 5.6.32 as per article published on the site. You can download the latest version from this link. Below are the details given by Apachefriends. v7.1.11 / 7.0.25 /…

phpBB is flat-forum software. It is open source, licensed under Version 2 of the GNU GPL. It is written in the PHP programming language using Symfony framework. In this article, I will show you how to install phpBB forum on…

Vanilla is forum software. It provides a modern community platform to organizations. It helps to improve customer service, increase advocacy, and strengthen brand loyalty. This forum is also available as software-as-a-service (cloud). It is open software, you can download and…

Working on Technical Specifications and looking for a way to interlink sections in Microsoft Word? You are writing a pseudo algorithm and want to link with SQL which are part the of same document as shown in below image. Let’s…

Oracle Multi-org views are not there in Oracle Apps Release 12. Those views are replaced by Secure Synonyms. In R12, data is restricted by assigning a virtual private database (VPD) policy to the synonym. This policy allows the system to…

Oacore is web application services to manage the Oracle Weblogic server. Oacore is used to provide core functionality in Oracle E-Business Suite application tier Java code, including OAF-based functionality for Oracle E-Business Suite products. In Oracle EBS suite you can…

Cloudflare provides Content Distribution Network(CDN), Web Optimization service, DDoS, WAF and SSL service.They have free as well as paid plan. Most of the premium services are available to a paid plan, but the free plan is also good for a…

Larry Ellison, Bob Miner, Ed Oates and Bruce Scott founded Oracle in 1977 with an initial name as Project Oracle. Later renamed Relational Software Inc (RSI), released Oracle Database release 2, 3…8, 8i, 9i, 10g, 11g and 12c which is the…

You might have noticed Executable options field while defining a concurrent program in Oracle Apps. What is the significance of executable options? Introduction Executable options allow passing runtime parameter to executable. Mostly it is used for executable based on Oracle…

In this article, let’s see wc Unix command. This Unix command is used to print newline, word, and byte counts for each FILE, and a total line if more than one FILE is specified. wc syntax Below is syntax wc Unix command wc [OPTION]...…

Host is the one of the execution method available in Oracle Apps while defining concurrent program executable. It allows the concurrent program to execute operating system commands. Host (Operating System) could be Windows, Unix or any supported operating system. UNIX is…

whoami is a Unix command to print the username associated with the current effective user ID. This command is helpful for DBAs/Admins working on multiple instances to know current username they are logged in. whoami is not shell built-in. Executable location…

pwd is Unix command to Print Current Working directory. You may find it referred as Present Working Directory in some books. Syntax: pwd [options]… Below are the options: -L – logical use PWD from environment, even if it contains symlinks…

Are you a blogger and looking for easy to use tool to capture, annotate and share images on your Blog. Then you should definitely try awesomescreenshot browser extension. Awesome Screenshot Awesome Screenshot is easy to use browser extensions to screencast, record screen.…

Want to create a custom form in Oracle Apps? Don’t know where and how to start? Before designing, you need to setup forms development environment on your desktop. In this article, I will cover how to set up forms development environment.…

This Oracle form builder tutorial explains the how to achieve select/unselect all checkbox functionality in Oracle Apps. Select all – when the master checkbox is checked then all child checkboxes on the form should be checked. Unselect All – when…

This method support password-less connection to remote server. An encrypted key is stored both at client and server end which acts as a key to connect. A key stored at the client is called as private Key and Key stored…

Oracle Apps R12 (12.1.3) has significant changes compared to earlier versions let’s say 11.5.10 both in terms of functional and technical changes. In this article, I am going to cover minimum database object level changes done by Oracle in the…

This is the First Edition from Oracle Press on Oracle Database 12c. 12C is latest Oracle Database release. This book explains how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data.   Written by Bob…

Concurrent program is one of the most important features in Oracle Apps. Here I am listing questions and answers on the concurrent program in Oracle Apps. It will definitely help you for Interview preparation. What is a concurrent program and…

English is primary language while working on Computers, Software, etc. Keyboards are also mostly in English, except in some of the countries like Japan, China. These countries use their own language keyboards. Practically, it is not possible to create that…

Outlook, Gmail, Yahoo or any other email application have a size limit for attachments. It is either 10MB or 25MB. Sharing large files using these email applications won’t be possible. Of course, you can send big files using CD/DVD, Pen…

Oracle regularly releases patches to fix code, security, performance and other vulnerability issues in Oracle Apps. Oracle Support formerly known as Metalink maintains all these information. Metalink is a huge repository of knowledge. You get good reference document and knowledge document. Let’s assume you…

Microsoft Excel is a great product. You can use it to do the simple tasks and even create a game. It is one of the most used product in IT Industry for project management and tracking. Here I will share…

“Can you please reset my Oracle Apps Password in a testing environment? I tried changing from Edit->Preferences->Change Password, but it is disabled”   “Okay, sure. Let me reset the password for you”. Navigate to System Administrator->Security->User-> Query the User to…

Log on session is no longer valid. Would you like to log back in so you can continue working? If you do not log in, any outstanding data changes in your forms will not be saved. Getting this message in…

Once a developer asked, “How to combine multiple rows into a single string delimited by comma, or pipe?” The requirement is to get email id from a table, concatenate those by “,” and use it as a parameter while sending an email.…

PL/SQL BULK Processing allows to batch or group number of records and sends in batches to a database for processing. How PL/SQL Works? PL/SQL is procedural language extension for SQL. Each command is executed in sequence. PL/SQL code is executed…

frmcmp_batch or frmcmp_batch.sh is a UNIX level utility available in Oracle Apps to compile custom form(.fmb) and libraries(.pll). Syntax: frmcmp Module= Userid=<userid/password> [Parameters] Optional parameters are (default values given): Parameter Description Module_Type=FORM Module type (FORM, MENU, LIBRARY). Statistics=NO Show statistics.…

SQL Developer or TOAD provides a graphical user interface for monitoring database sessions. It shows Active SQL, Explain Plan, Locks, Wait and lot more information. This feature is very much useful for Database Administrator and even developers. Oracle maintains database…

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…

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…

XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. It also has FileZilla, Mercury and Tomcat. XAMPP Control Panel allows you to manage this services. XAMPP provides you a complete local web development environment which includes…

Sometimes Oracle Reports Builder crashes in Windows environment. Especially when you are working on Apps upgrade (11i–> R12)  project and retrofitting Reports from 6i to 10G. You, Open report builder 10g Connect to database Open a custom report Report builder goes…

What is this Ctrl-M character? Why are those in the file? How to avoid and remove these? These ^m characters are a special character and present in a file because Windows and Unix have different line termination character. Wondering, why I am…

Mailx is an intelligent mail processing system with good features to send and receive email available on Unix OS. In this article, I will cover basics of mailx command by example.  We will use Heirloom mailx utility. Use below command to check…

Oracle Database client uses port ranges in from 1520-1530 to connect database over TCP/IP, default listener port is 1521. These ports are not available on the secure public cloud. So how to connect to cloud database? You need to use secure…

Oracle recommends and creates packages, procedures and views in APPS schema. Some customers create these objects in the custom schema like xxont, xxap, xxinv, etc. It does not impact working of package or procedure. If there are calls to many standard built-in API…

DBAs, Network Admins and Developers can’t imagine a day without Putty while working on UNIX Server. This is what official source says about Putty….http://www.putty.org/ PuTTY is an SSH and Telnet client, developed originally by Simon Tatham for the Windows platform.…

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…

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,…

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…

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…

Oracle apps provide a mechanism called concurrent program to run programs/process in parallel to efficiently use hardware, software and user’s bandwidth. Read:- How to define Concurrent Program in Oracle Applications You can submit concurrent programs using below methods, SRS Window PL/SQL API…

Oracle Apps Concurrent Processing/Programs works on the principle – Work simultaneously, to efficiently use the available resource like hardware, software, etc. You can submit multiple instances of the same or different concurrent program in parallel. A dedicated concurrent manager controls the execution…

Google Drive is online storage solution by Google, Inc. You can use Google Drive to store any kind of files like Photos, Documents, Videos and anything. Google provides free storage 15GB on Google Drive to each user. Yes, you read it…

Updraftplus is WordPress plugin which helps you easily backup your blog. I hope you back up your WordPress Website or Blog regularly? No, then you are doing a mistake and at a big risk. Why should you backup your Website…

Oracle Application Express has a simple Admin Dashboard with the following utilities. App Builder SQL Workshop Team Development Packaged Apps Each of these utilities provides different utilities to a Developer/Admin. Let understand Oracle Apex Dashboard each in brief. APP Builder Create…

In the previous article, we created an application and page. It was a blank page with no functionality. Now let’s create a simple report on that page using Oracle Apex. The report will display data from DEPT table. If you…

In this tutorial, let’s create a simple application with a single page using Oracle Apex. Check below image this is what we are going to create now. An application is like a container or collection objects like page, lov, validation.…

In this article, I am going to cover how to install WordPress on XAMPP. WordPress is software to create a website and you need web hosting account for it. Do you know that you can install WordPress on a localhost using XAMPP?…

XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. It provides basic infrastructure like an HTTP server, database and scripting language for your local WordPress Installation. You can create a testing instance for the production…

SQL Update, Insert and Delete manipulate data in the database. You need to query data set again to see what changed by these commands. What if you do not have to query the database again? What if update, insert and delete…

Looking for an article on How to generate excel output using Oracle PLSQL, me too. Searched on Google, but could not find easy to understand article. So thought of writing one. There is some OWA API/package which can directly write…

This article is a prerequisite for one of my next planned. You may already aware of this, just sharing to make my post complete. In this article, I will cover How Open CSV, PIPE Delimited File in Microsoft Excel You…

SQL* Plus has good reporting commands and features. You can generate a report in text, HTML using SQL* Plus. This HTML report you can directly open in Microsoft Excel as well. In this article let’s see how to generate HTML…

There are many methods available to install a WordPress Plugin. Some are good for beginner and some for expert. WordPress Plugins are add-ons which extend and expand the functionality of WordPress. These also simplify some of the maintenance activities like…

WordPress is core software to design Blogs and Web sites. Plugins are add-ons to WordPress which extend and expand the functionality of WordPress. There is a huge repository of the plugins available at your fingertips. Below are some of the…

Welcome to October 2016 traffic and income report. This is the first traffic report I am going to publish for my Tech Blog. This will help me to track my progress and growth in terms of user, traffic, and income…..:)…

Recently upgraded from Oracle Applications (apps) version 11.5.10 (11i) to 12.1.3. (R12). You observed that your concurrent programs not working, you are not able to see any value in some of the parameters of concurrent programs? Is anything wrong with…

‪‪Multi-factor authentication or 2-step authentication allows you to add additional layer of security to your email account like gmail, yahoo, etc. It safeguards your accounts from unauthorize access or Hacking. Hacking is the biggest threat in today’s online world. Hackers…

Good WordPress theme plays important role success of your Blog. It should be fast and look professional and compliment the topic of the blog. Look at below image of one of the sample blog post and try to answer questions. Do…

Oracle dbms_utility.get_time returns current time in millisecond. Divide it by 100 to get time in seconds. DBMS_UTILITY.GET_TIME The is utility package in Oracle. It provides sub-programs to analyze table, format stack, get CPU time, table to comma and comma to…

DBMS_RANDOM is build-in package in Oracle Database to generate random number/characters. Why I need such package or should use it? Let me share my experience, I was working on assessment project in Oracle APEX. It was a simple question/answer type…

Let’s see how to design concurrent program which spawns multiple child concurrent programs. The master program waits till all child programs are complete.Oracle provides built-in package FND_CONC_GLOBAL and FND_REQUEST to achieve parent-child program using PL/SQL. FND_CONC_GLOBAL.SET_REQ_GLOBALS –  sets the value…

Oracle Application Express (APEX) is rapid web development tool by Oracle. It runs on Oracle Database and easy to use. Most development is using drag and drop wizard. A developer with PL/SQL knowledge can create a good web application. No…

In this article, let’s see what is Oracle Apex and its features. Enterprises generally have a good number of internal applications along with one of the ERP systems like Oracle E-Business Suite well known as Oracle Apps, SAP, JD Edwards,…

Hoping you have successfully installed WordPress. If not, visit the post to read step by step installation guide. Now time to write the first blog post. Login to WordPress Login to your blog using admin username and password specified during…

Hostgator is one of the leading hosting providers. It offers web hosting plans suitable for both individuals as well as big business. Hostgator offers, Web Hosting – Shared Cloud Hosting WordPress Hosting Reseller VPS Dedicated Domain Service. As a beginner, you…

Hostgator is one of the leading Web Hosting Service providers. It has the hosting plan for Beginners as well as big Corporates. We are using Shared Hosting for WordPress. Hostgator provides one-click WordPress installation using Softaculous. Softaculous is Auto-installer tool…

Do you want to start WordPress blog?. It is not a rocket science. Follow this article and BLOG to successfully build WordPress site – your online identity and brand…!!! Content is King. You need content to start a Blog or…

So finally, I decided to write a BLOG. I was thinking for a long time to do something online. Maybe I can create some website, Android app anything. Just wanted to create my own identity. It is not easy as…

Welcome to a Techtown – Technology Township. The purpose of this blog is to share the learning. Hoping this blog will create a good knowledge base which would be helpful for everyone. Mostly I will focus on Oracle domain and…