API to add the responsibility to the user

bEGIN

fnd_user_pkg.addresp(username => 'VINOTH'

,resp_app => 'SYSADMIN'

,resp_key => 'SYSTEM_ADMINISTRATOR'

,security_group => 'STANDARD'

,description => 'Auto Assignment'

,start_date => SYSDATE - 1

,end_date => SYSDATE + 1000);

COMMIT;

END;

Phases of a Concurrent Program

When we run concurrent programs in Oracle applications. It follows the below phases to complete a program
1) Pending
2)Running
3)Completed
4)InActive

There are more status for each phases. Find it below

Phase	Status	Description
PENDING	Normal	Request is waiting for the next available manager
	Standby	Program to run request is incompatible with other program(s) currently running
	Scheduled	Request is scheduled to start at a future time or date.
	Waiting	A child request is waiting for its Parent request to mark it ready to run. For example, a request in a request set that runs sequentially must wait for a prior request to complete
RUNNING	Normal	Request is running normally
	Paused	Parent request pauses for all its child requests to finish running. For example, a request set pauses for all requests in the set to complete.
	Resuming	All requests submitted by the same parent request have completed running. The Parent request resumes running.
	Terminating	Request is terminated by choosing the Cancel Request button in Requests window
COMPLETED	Normal	Request completed successfully.
	Error	Request failed to complete successfully
	Warning	Request completed with warnings. For example, a request is generated successfully but fails to print
	Cancelled	Pending or Inactive request is cancelled by choosing the Cancel Request button in the Requests window.
	Terminated	Request is terminated by choosing the Cancel Request button in the Requests window.
Inactive	Disabled	Program to run request is not enabled. Contact your system administrator.
	On Hold	Pending request is placed on hold by choosing the Hold Request button in the Requests window.
	No Manager	No manager is defined to run the request. Check with your system administrator. A status of No Manager is also given when all managers are locked by run-alone requests.

Query to find Request group name from Concurrent Program Name

Here's the query to find the request group name by passing concurrent program name as parameter

SELECT
    FRG.REQUEST_GROUP_NAME,
    FRG.DESCRIPTION,
    CP.CONCURRENT_PROGRAM_ID,
    CP.CONCURRENT_PROGRAM_NAME,
    CPT.USER_CONCURRENT_PROGRAM_NAME,
    FRV.RESPONSIBILITY_NAME
FROM
    FND_REQUEST_GROUPS FRG,
    FND_REQUEST_GROUP_UNITS FRGU,
    FND_CONCURRENT_PROGRAMS CP,
    FND_CONCURRENT_PROGRAMS_TL CPT,
    FND_RESPONSIBILITY_VL FRV
WHERE
    FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
    AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
    AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID
    AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'XX Conc Pgm Name';

Terminologies We Should Know

As a Oracle apps Technical Consultant, These terminologies are often used by everyone.
Listing the terminologies over here

MIDDLEWARE:
Software provides services beyond those provided by OS.
It is integral modern information technology based on XML,SOAP,Web Services and SOA.
Middleware sits "in the middle" between application software . Middleware enables interoperability between applications that run on different OS.
example : EAI

EAI : Enterprise Application Integration
SCM, CRM, BI and other type of applications cannot communicate with one another in order to shared data or business rules.EAI is the process of linking such applications within single organization together in order to simplify and automate business process.
for 'N' application
N*(N-1)
------    connections are required.
  2   

EDI: Electronic Data Interchange
Structured transmission of data between organizations by electronic means. It is used to transfer electronic documents or business data from one computer system to another computer system, i.e. from one trading partner to another trading partner without human intervention.

TIBCO:
People tell TIBCO is a Software/Company name/Middleware. Which one is correct?
Everything is correct.They are leading provider of business integration solutions delivering infrastructure software that enables to seamlessly integrate business systems in real time.
They call the technology as "Information Bus" or TIB middleware.

SOAP: Simple Object Access Protocol
A better way to communicate in internet is using HTTP becoz HTTP is supported by all browsers and servers.SOAP provides a way to communicate between applications running on different operating systems, with different technologies and programming languages in distributed systems.

SOAP Message Structure
A SOAP message is an ordinary XML document containing the following elements
<?xml version="1.0"?>
<soap:Envelope
xmlns:soap="http://www.w3.org/2001/12/soap-envelope"
soap:encodingStyle="http://www.w3.org/2001/12/soap-encoding">

<soap:Header>
...
</soap:Header>

<soap:Body>
...
  <soap:Fault>
  ...
  </soap:Fault>
</soap:Body>

</soap:Envelope>

Yet to update this post.

Orders Autobook

There could be certain case where client require to book the orders in bulk just by running single concurrent program. There's a public API provided by oracle to perform various operations in the sales order in the order management system.

Public API Name is : OE_ORDER_PUB
There are record type to hold the order header, line level informations.
Header_Rec_Type
Header_Tbl_Type
Header_Val_Rec_Type
Header_Val_Tbl_Type
Header_Adj_Rec_Type
Header_Adj_Tbl_Type
Line_Rec_Type
Line_Tbl_Type
Line_Val_Rec_Type
Line_Val_Tbl_Typ

Procedure Name : PROCESS_ORDER

Process Order supports action requests that allow users to execute a variety
of actions such as booking, hold application and removal.

OE_ORDER_PUB.PROCESS_ORDER
   (
      p_api_version_number      =>   1.0,
      p_init_msg_list           =>   FND_API.G_TRUE,
      p_action_commit           =>   FND_API.G_FALSE,
      x_return_status           =>   x_return_status,
      x_msg_count               =>   v_msg_count,
      x_msg_data                =>   v_msg_data,
      p_header_rec              =>   p_header_rec,
      p_header_val_rec          =>   p_header_val_rec,
      p_header_scredit_tbl      =>   p_header_scredit_tbl,
      p_line_tbl                =>   p_line_tbl,
      p_line_adj_tbl            =>   p_line_adj_tbl,
      p_line_scredit_tbl        =>   p_line_scredit_tbl,
      p_action_request_tbl      =>   p_action_request_tbl,
      x_header_rec              =>   x_header_rec,
      x_header_val_rec          =>   v_header_val_rec,
      x_header_adj_tbl          =>   v_header_adj_tbl,
      x_header_adj_val_tbl      =>   v_header_adj_val_tbl,
      x_header_price_att_tbl    =>   v_header_price_att_tbl,
      x_header_adj_att_tbl      =>   v_header_adj_att_tbl,
      x_header_adj_assoc_tbl    =>   v_header_adj_assoc_tbl,
      x_header_scredit_tbl      =>   v_header_scredit_tbl,
      x_header_scredit_val_tbl  =>   v_header_scredit_val_tbl,
      x_line_tbl                =>   x_line_tbl,
      x_line_val_tbl            =>   v_line_val_tbl,
      x_line_adj_tbl            =>   v_line_adj_tbl,
      x_line_adj_val_tbl        =>   v_line_adj_val_tbl,
      x_line_price_att_tbl      =>   v_line_price_att_tbl,
      x_line_adj_att_tbl        =>   v_line_adj_att_tbl,
      x_line_adj_assoc_tbl      =>   v_line_adj_assoc_tbl,
      x_line_scredit_tbl        =>   v_line_scredit_tbl,
      x_line_scredit_val_tbl    =>   v_line_scredit_val_tbl,
      x_lot_serial_tbl          =>   v_lot_serial_tbl,
      x_lot_serial_val_tbl      =>   v_lot_serial_val_tbl,
      x_action_request_tbl      =>   v_action_request_tbl
   );

Oracle E-Business Suite Home Page

To access a public oracle E-business suite follow this link have the username and password need to login into the applications.I am using R12 instance.(http://vis1200.solutionbeacon.net/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE)
To access R-12 Vision Instance
User Name : GR8866 / GR2023
Password : 8866GR / 2023GR

After login to the application your home page looks like this

This is the home page.Left panel will have all the responsibility which user have
and the right panel shows the functions of each responsibility.
Once you enter into the applications the first thing both technical and functional consultant should know is Application Developer.
Refer oracle's application developers guide to know more about application developer responsibility and its functions

Initial Steps To be a Technical Consultant

To be a  oracle apps technical consultant
Mandatory skills to be known
SQL(Mandatory)
PL/SQL
Basic UNIX commands(to move the file from local system to server)

Downloads

SQL Basics Material

SQL Advanced Material

PL/SQL Basics Material

Softwares To be installed

1)  Toad
Toad is a software which communicates with database and provides you the result...similar to SQL plus but SQL plus has got less features whereas toad provides you all the needs from database in quick and sufficient way.Toad can view the Oracle data dictionary-tables, indexes , Stored Procedures - and do various other tasks through multi-tabbed browsers.
you can download toad free ware from here

2)  Oracle Application Development Suite
This software contains Forms developer,Reports builder,J Developer,Oracle designer, Oracle business intelligence beans.
Refer to this link to know more details

3)  Filezilla,Winscp softwares to move the files from local system to unix server
just by drag and drop.you can google it out for more details

Important Links To Learn Oracle Apps

To learn Oracle apps there are many online resources and blogs but few are oftenly used links...These are the important links
1) Oracle Apps Release 12 Documentation Library
http://download.oracle.com/docs/cd/B40089_10/current/html/docset.html 
2) Oracle E-TRM(Technical Reference Manual) contains all the tables,packages,procedures details in this link
http://etrm.oracle.com/pls/etrm/etrm_search.search  
3) Oracle E-Delivery https://edelivery.oracle.com/  
Solution Beacon(Access VIS 12 Instance) http://www.solutionbeacon.com/ 
4) This blog is very helpful to learn the oracle apps from basicshttp://oracle.anilpassi.com/  and 
http://apps2fusion.com/
5)Oracle Forums http://forums.oracle.com/forums/main.jspa?categoryID=84 

6) For DBA's http://appsdbastuff.blogspot.com
7) Public E-Business Suite Instance http://neilghosh.com/2010/05/30/free-public-oracle-application-demo-instance-e-buisness-suite/

How to Install Oracle apps

Many of you might have doubt how to learn this oracle apps..How to install this software?..how to configure and where to install it?

This post answer all  the above questions..Oracle apps or Oracle E-Business Suite(EBS) software release 11i/12 (R12) — a bundling of several  Applications  — in February 2007.
Refer this two links to install Oracle Apps software in you own PC
http://download.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf
 Install Oracle Apps in your own system
but you should have some background knowledge in UNIX and the system hardware requirement should be high configuration.
To learn Oracle apps without installing it in your system you can use the Online Oracle apps software(Internet Connection is Mandatory)..Its working under cloud computing technology providing Software as a service(SaaS).Solution Beacon is a oracle registered website for learning oracle apps..While registering it will ask for CSI(Customer Support Identification) number if you have just enter that CSI number else refer to this link don't have CSI no.Solution beacon provides access to Vis12 instance

You can learn E-business suite using this public e-business suite instance

What is Oracle apps?????

Before i start with what is oracle apps i will tell you what is ERP?

ERP(Enterprise Resource Planning) is more of a methodology than a piece of software, incorporates several software applications, brought together under a single, integrated interface.To say it as shortly it's Integration of all the modules.In olden days for each module(Manufacturing,Financials, CRM, SCM, HRMS) they maintained individual software but as the business and technology grows there will be a circumstance need to communicate  between the modules which not possible using olden technology since each module is a different softwares.But now the oracle corp created a software by integrating all the modules together is called Oracle E-Business Suite otherwise called as Oracle apps.The main competitor of oracle E-Business suite is SAP ( System Applications Products). There are few more ERP systems like Infor,Epicor, Microsoft Dynamics.

Organization of the application modules in Oracle E-Business Suite