Basic elements of Oracle Application

Application
-An Application is a collection of Forms,Reports and PL/SQL objects to meet a particular business objectives
-Oracle Applications like 11.0,11i,R12 is a collection of predefined inter linked applications
-A custom application can be designed and integrated with Oracle Applications
-Any custom application has to be registered with Oracle Applications
- Custom application can be defined using the

Responsibility: System Administration
Navigate to Application-->Register

Application = XPROD Custom
Short Name = XPROD
Basepath = XPROD_TOP
Description = XPROD Custom Application

- The below query can be used to query application information through sqlplus
select a.application_id,
a.application_short_name,
a.basepath,
at.application_name
from fnd_application a,
fnd_application_tl at
where at.application_id = a.application_id
and at.language='US'
group by a.application_id,a.application_short_name,a.basepath,at.application_name,at.language
order by a.application_id
/

- The following are the components of an application
Forms
Function
Menu
Concurrent program
Request Group
Request Set
Standard Report Submission

Forms
-form is a user interface to insert ,update and delete data into and from database
-While developing Oracle Applications form , we follow some development standard
-After development , a form must be registered with Oracle Application Object Library
-FND_FORMS is a table in APPLSYS schema that stores information about forms
-Custom forms needs to be registered in Application
-Custom Form can be defined using the

Responsibility:- System Administrator
Navigation Path ->Application ->Forms

Function
-Form Function:A function that invokes an Oracle Forms form
-Sub Function:A non form function is a securable subset of forms functionality , which means a function executed from within a form
-One can navigate to a form function ( form) using the navigate window
-A sub function can only be run from a form
-FND_FORM_FUNCTIONS is a table in APPLSYS schema that stores information about function grouping in forms. Each row includes a function identifier, the function name,and the application identifier. Each row also includes the form identifier and the parameters for calling the form. You need one row for each function. Oracle Application Object Library uses this information to implementation the subdivision of forms into different functionality groups using the existing menu system. This view is only used for Oracle Applications in GUI mode.
Important Columns in FND_FORM_FUNCTIONS
· FUNCTION_ID - Function identifier
· FUNCTION_NAME - Function name
· WEB_AGENT_NAME - Name of Oracle Web Agent. Defaults to the last agent used
· WEB_HTML_CALL - Contains the URL to activate this function. It may be either a static page or a procedure. If the value here is incorrect then users will not be able to launch those form functions from Self Service Web Applications.
-Custom Functions can be defined using the

Responsibility:- System Administrator
Navigation Path ->Application ->Functions