Shivmohan – Oracle E-Business Suites

Just to thought how to define Oracle E-business Suite term.

What is Oracle E-Business Suite


Oracle’s E-Business Suite is a fully integrated system package that provides access to Oracle’s business applications in a database environment. The suite is available in internet format and provides strong flexibility in integrating Oracle systems across applications. The E-Business Suite includes multiple products, such as Oracle Financials (Oracle General Ledger, Oracle Payables, Oracle Receivable), Oracle Logistics, Oracle HR, and Oracle Sales. The most current E-Business Suite release is edition 12, which debuted in January 2007

 The suite is comprised of a three-tiered hardware architecture. The tiers are database, application and PC. Sometimes referred to as Oracle’s “E-Business Suite”, Oracle Applications (currently Release 12, released 31st January 2007), contains several product lines.


Thanks – Shivmohan Purohit 


Shivmohan – Perspective on Mentoring

A Perspective on Mentoring

Hello Friends,

In my past organization it was very important to use high jargons even for small things or activities, even for giving help to juniors or bit of guidance used to consider as mentoring. Coaching was very common word. Recently i am reading one book on mentoring, now realizing that mentoring is not just a bigger coverage areas but it is important as well in order to build and keep a successful team/ group and to make them grow in order to achieve your own and their success. Once i get more thoughts i like to share it, here i just putting very high agenda on what mentoring is… i also more from your side as well as feedback.

as per some of thought i gather i can say do
  – Set high expectations of performance.
  – Offer challenging ideas.
  – Help to build self-confidence.
  – Encourage professional behaviour.
  – Offer friendship.
  – Confront negative behaviour & attitudes.
  – Listen to personal problems.
  – Teach by example.
  – Provide growth experiences.
  – Offer meaningful sayings or quotations.
  – Explain how the organization works.
  – Coach their mentorees.
  – Stand by their mentorees in critical situations.
  – Offer wise counsel.
  – Encourage winning behaviour.
  – Trigger self-awareness.
  – Inspire their mentorees.
  – Share critical knowledge.
  – Offer encouragement.
  – Assist with their mentoree’s career.

Thanks – Shivmohan Purohit

KnowOracle – A Quick Intro

  • KnowOracle, One of the Leading and fast growing Oracle EBS Blog
  • 8000+ visits /week, Visitors from 150+ countries and Top Oracle EBS Blog in USA and India.
  • 450+ articles, covering Functional, Technical areas in Oracle Applications, Financials, Distributions, Project and Oracle Database for Beginners and for Experts.
  • FREE Monthly Web-Seminars & PDF newsletter, One-2-One Direct help & Coaching
  • 1000+ Subscription ( 810+ through feedburner , 220+ through WordPress )

All Documents Videos

Download Latest PDFs – Created exclusively for our reader.

Exclusive PDFs for KnowOracle Readers  — click here

Direct Link – ,  Also there are lot many regular and useful file  — Know Oracle Files

Download | Print | Read Offline | Share with Others |


Need Help to understand anything ? Put your question here , I receive your comment in my email and I will reply on that email directly to you.

What is Oracle Apps (ERP)?

Here i am sharing one of article on introduction on oracle apps 11i, though it is not written by me, still i thought to share with all to bring this quite simplified way to explain 11i or ERP etc.

What is Oracle Apps (ERP)?

(Also known as e-business suite)

Lets take an example. Suppose you are running a small grocery shop named “Janata Grocery”, so the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and stocked it in your shop.
Ocassionally you may not be carrying items or run out of stock that people ask for so you make a note of it and promise the person to come back tomorrow and they will get their item. So far so good, now lets name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor, the people who come to your shop to buy things are known as customers, the stock in your shop is known as inventory.

So far we have identified few entities that play an active role in your day-to-day operations. As time goes by, your business expands and now you take orders over the phone and provide service to deliver the items to your customers, so you hire people to help you out in maintaining the inventory, do the delivery part and all the necessary stuff to keep the business running smoothly. The people you hire are known as employees.
So in this small shop, you typically manage the bookkeeping activities by hand using a notepad or something similar. Now imagine the same setup on a larger scale where you have more than 10,000 customers, have more than 1000 vendors, have more than 1000 employees and have a huge warehouse to maintain your inventory. Do you think you can manage all that information using pen and paper? Absolutely no way! Your business will come to a sudden stop sign.

To facilitate big businesses, companies like Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications. Now coming to think of it, Oracle Apps is not one huge software, instead it is a collection of software known as modules that are integrated and talk to each other.


Now what is meant by integrated? First let us identify the modules by entities. For e.g Purchasing and Account Payables deal with the vendors since you typically purchase from vendors and eventually have to pay the dues. Oracle Purchasing handles all the requisitions and purchase orders to the vendors whereas Oracle Accounts Payables handles all the payments to the vendors.


Similarly Oracle Inventory deals with the items you maintain in stock, warehouse etc. Dealing with customers is handled collectively with the help of Oracle Receivables and Oracle Order Management. Order Management helps you collect all the information that your customer is ordering over the phone or webstore etc whereas Receivables help you collect the money for the orders that are delivered to the customers.

Now who maintains the paychecks, benefits of the 1000 employees? right! it is managed by Oracle Human Resources. So you get the idea by now that for each logical function there is a separate module that helps to execute and maintain that function.

So all the individual functions are being taken care but how do I know if I am making profit or loss? That’s where integration comes into play. There is another module known as Oracle General Ledger. This module receives information from all the different transaction modules and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc.

Just to simplify the explaination, when you pay your employees that payment is reported back to General Ledgers as cost i.e money going out, when you purchase inventory items the information is transferred to GL as money going out, and so is the case when you pay your vendors. Similarly when you receive items in your inventory it is transferred to GL as money coming in, when your customer sends payment it is transfered to GL as money coming in. So all the different transaction modules report to GL (General Ledger) as either “money going in” or “money going out”, the net result will tell you if you are making a profit or loss.

All the equipment, shops, warehouses, computers can be termed as Assets and they are managed by Oracle Fixed Assets. Initially Oracle Applications started as bunch of modules and as time passed by they added new modules for different and new functions growing out of the need for today’s internet world.

So if you come across a module that you are trying to learn and work on, first try to understand what business need is it trying to fulfill and then try to understand what the immediate modules that it interacts with. For e.g lets say you come across Oracle Cost Management module, you will learn that it helps to maintain the costs of items in your inventory and the immediate modules that it interacts with are Oracle Inventory (ofcourse), Oracle Bills of Material, Order Management and so on..

Working with CONCSUB

The CONCSUB is a utility which allows you to submit a concurrent program to the concurrent manager from the operating system level without having to log on to Oracle Applications.
The CONCSUB executable is located at $FND_TOP/bin/CONCSUB.

The functionality of the CONCSUB can be categorized into the following

  • Submitting Concurrent Requests
  • Controlling Concurrent Managers

Submitting Concurrent Requests
You can use the CONCSUB to execute both seeded and custom programs in Oracle Applications. In case of custom programs they must first be registered in Oracle Applications before you can execute them with CONCSUB.

The following can be used in Oracle Applications to run the active users report from the command line without logging in the  applications

Submitted request 2866136 for CONCURRENT FND FNDSCURS PROGRAM_NAME=”Active Users”

The log and out file for this program is also created at the location defined by your $APPLCSF/$APPLLOG and $APPLCSF/$APPLOUT respectively.

The WAIT=Y/N is used to specify weather to wait for the first concurrent request to be completed before the second is submitted or not.

You can also use various printing parameters with the COCNCSUB to directly print the output of your concurrent request.

PRINTER=<printer name>
NUMBER_OF_COPIES=<number of reports to be printed>
PRINT_STYLE=<printer style to be used>    
LANGUAGE=<language to be used>

Also you could specify the start date and completion options along with CONCSUB by using the following parameters

START=<Requested Start Date>
REPEAT_DAYS=<Repeat Interval>
REPEAT_END=<Request Resubmission End Date>

Controlling Concurrent Managers
Apart from submitting concurrent request the CONCSUB can also be used to shutdown your concurrent managers


Sometimes the shutdown of the concurrent managers via the CONCSUB utility using the SHUTDOWN clause hangs and you may want to terminate your concurrent managers, in such a case you can use the ABORT clause with CONCSUB to do a force shutdown of your concurrent managers.


In this case a concurrent request to terminate the concurrent managers is fired with a -75 priority. In case of the shutdown  the priority is 0 and default priority is of a concurrent request 50, by assigning a -75 priority the CONCSUB ensures abort is executed before shutdown.

Needless to say that the shutdown would fail in case the SYSADMN user or the System Administrator responsibility is inactive.

However to start the concurrent managers the CONCSUB is not used instead the startmgr executable is used.(Though possible)
This is located at $FND_TOP/bin/startmgr.

$startmgr sysmgr=apps/apps@sam
Starting icm@sam Internal Concurrent Manager
Default printer is

By default if no manager name is specified the ICM or the Internal Concurrent Manager is started. You can also start a specific manager by using the mgrname clause

To use CONCSUB to start the concurrent managers the STARTUP clause is used

Submitted request 2849496 for CONCURRENT FND STARTUP

UNIX / Shell Programming Basic – Beginner Questions Answers



What is $*?

Its mainly used for showing up all params. This show all parameter values passed in shell script


What does $# stand for?

# will return the number of parameters that are passed as the command-line arguments.


What does $? Return?

$? will return exit status of command .0 if command gets successfully executed ,non-zero if command failed.


What are Different types of shells?

sh : the oldest shell 
csh : C shell 
ksh : Korn Shell 
bash : bourne again shell



How do you read arguments in a shell program – $1, $2?

Shell script accepts parameters in following format… 
$1 would be the first command line argument, $2 the second, and so on 
$0 is the name of the script or function

If your script has more than 9 params then accept in following way… 
${12} : 12th param 
${18} : 18th param


What are the different kinds of loops available in shell script?

for, if, while, case


What is the difference between a shell variable that is exported and the one that is not exported?

The Shell variable which is exported would available to all the programs outside the Shell also. And the shell variable which is not exported, would available for that shell or for the shell program only, in which the variable is declared.


Export LANG=C 
will make the variable LANG the
global variable, put it into the global environment. All other processes can use it. 
will change the value only in the current script. 



If you have a string “one two three”, which shell command would you use to extract the strings?

echo $string | cut -d” ” -f1 
echo $string | cut -d” ” -f2 
echo $string | cut -d” ” -f3 


How will you list only the empty lines in a file (using grep)?

grep “^$” filename.txt


How would you get the character positions 10-20 from a text file?

cat filename.txt | cut -c 10-20


cut -c10-20 <filename.txt>


How would you replace the n character in a file with some xyz?

sed ‘s/n/xyz/g’ filename > new_filename


We can replace n characters by using the following command:
where 1 shows that the search string will start searching patterns from first line of the file.
           ‘.’ for any character.

            g for global replacemet.



What is the difference between a ‘thread’ and a ‘process’?

A process is a collection of virtual memory space, code, data, and system resources. A thread is code that is to be serially executed within a process. A processor executes threads, not processes, so each application has at least one process, and a process always has at least one thread of execution, known as the primary thread. A process can have multiple threads in addition to the primary thread

Thread – is stream of executable code within process. They are light weight process. All thread with in a process  share process instruction,code & data segment,open file descriptor,signal handler,userID and GroupID. Thread has its own set of register including program counter,stack pointer 


What is this line in the shell script do ?#!/bin/ksh?

To invoke the shell indirectly this line is added as the first line in the file.This particular line invokes korn shell



What is use of “cut” command? Give some examples.

Cut – Utility used to cut/Strip out the required data/text from the source.

Cut can be used in three modes,

  Stripping by Character

     cut -c 1-3

  Striping by Byte length

     cut -b -1-72

Stripping by delimiter and fields.

     cut -d “|” -f1


-d “|” -> Delimiter used in input text to separate columns

-f1 -> Field/Column number  

While processing huge input files, Cut’s performance is far better than awk



thanks – shivmohan purohit 








ERP Schools – Latest Articles Updates

Hello Friends, Here we like to showcase one of the most enrich and comprehensive site , full of articles with detail demos and explaination for your day-to-day problems. Hope you will find it useful. for full list of articles , you can visit …

We recommned all who like to have indepth documents, articles with full details along with demo/ screen shot, erpschools will be your top choice.