May 4, 2013

Interview Q & A -2: SYSADMIN and Application Developer

bishnupc / /

SYSADMIN and Application Developer

1.    What is the relation between Responsibility, Menu and Request Group?
Responsibility: - A responsibility is a set of authority in Oracle Apps that lets users access only that functionality of the application appropriate to their roles.

Menu: - A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it.

Request Group: - it is a collection of reports or concurrent programs. A system Administrator defines report groups in order to control user access to reports and concurrent programs. Only a system administrator can create a request group.
  1. What is a function, how to create one?
A function is apart of an application’s functionality that is registered under a unique name for the purpose of assigning to it to, or excluding it from, a menu (and by extension, responsibility). There are several types of functions: - Form Functions, SubFunctions, and
Non-form functions. We often refer to a form function simply as a form.

  1. What is meant by APPL_TOP?
Environment variable
An operating System variable that describes an aspect of the environment in which your application runs. For example, you can define an environment variable to specify a directory path.
$APPL_TOP: An environment variable that denotes the installation directory for Oracle Application Object Library and your other Oracle applications. $APPL_TOP is usually one directory level above each of the product directories (which are often referred to as $PROD_TOP or $PRODUCT_TOP or $<prod>_TOP).

  1. Explain briefly where are the Custom.pll, Forms, Reports, Sql Loader Control files, Shell
     Script source code and executables files kept?
     Custom.pll - $AU_TOP/resource
     Forms       - $PROD_TOP/Forms/US
     Reports     - $PROD_TOP/Reports/US
     SQL Control Files - $PROD_TOP/Bin
     Shell Scripts - $PROD_TOP/Bin

  1. When is Custom.pll used?
Custom.pll is used while making new or customizing standard oracle forms in apps. It contains all the forms libraries for apps.

  1. What are profile options; at what levels can these be set?

     A user profile is a set of changeable options that affects the way the applications run. Oracle
     Applications object Library establishes a value for each option in a user’s profile when the
     User logs on or changes responsibility.
     System Profile: - Profile option can be set for the user community.
     User Profile: - Provide Oracle Apps with standard information which describes a user,
     Application, Responsibility and site. At each profile level user profile options can be set.
  1. How can you know the form (fmb) name when you open a form in Apps?
Helpà About Oracle Apps
  1. Where do you create a table and sequence in Apps? Is it APPS schema?
       In custom schema and then grant privileges on it to APPS schema.

  1. Where are Views and Procedures created?
Views: - Views are to be created only in APPS.
Procedures: - In custom schema and the grant it to APPS schema.
  1. How can you tell who last updated a particular row in a form?
Help à Record History
     11. You have logged onto a Responsibility, how do you know what operating unit are you on?
 Help à Diagonistics à Examine à Blocks à $Profiles$ à Field à Org_id

  1.  Can new profiles be created? If so how?
 Yes. Application Developer.
Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here