Oracle Apps Interview Questions-15

Oracle Apps Interview Questions,Askhareeshblogspot.com

211) How do you set profile in oracle applications In Application Developer responsibility?  
Open „Profile‟ Function 

212) What is the syntax for loading data through SQL * Loader from multiple files simultaneously?
Sqlldr scott/tiger@orcl control = ctlfile
parfile -- parameter file: name of file that contains parameter specifications
parallel -- do parallel load (Default FALSE) 


213)Give the relation between categories and items table?
MTL_SYSTEM_ITEMS
MTL_CATEGORIES_B
Relation INVENTORY_ITEM_ID 


214)In which tables are the categories of an item stored?
  • MTL_CATEGORIES_B
  • MTL_ITEM_CATEGORIES 
215)Significance of ALL in apps tables?
Tables which are related with Multiorg is suffixed with ALL. 

216) Explain about flexfield in GL.In what way it is useful?
KFF is a set of segments, each segment will identify a unique characterstic of an entity. it can be termed as intelligent key. we can define our business requirements without doing any programming.
A DFF is a set of segments which can be used to capture extra info. without any customisation. 


217) Execution methods?
a. Host 

b. Immediate
c. Java Stored Procedure
d. Java Concurrent Program
e. Multi Language Function
f. Oracle Reports

g. PL/SQL Stored Procedure
h. Request Set Stage Function
i. Spawned
j. SQL*Loader
k. SQL*Plus 


218) What is TCA (Trading Community Architecture)?
Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them. This information is maintained in the TCA Registry, which is the single source of trading community information for Oracle E-Business Suite applications. 


219) Difference between Application Developer and System Administrator? 
Role of Technical Consultant:
  • Designing New Forms, Programs and Reports
  • Forms and Reports customization
  • Developing Interfaces
  • Developing PL/SQL stored procedures
  • Workflow automations
Role of System Administrator:
  • Define Logon Users
  • Define New/Custom Responsibility
  • Define Data Groups
  • Define Concurrent Managers
  • Define Printers
  • Test Network Preferences
  • Define/Add new Modules
Role of an Apps DBA:
  • Installing of Application
  • Upgradation
  • Migration
  • Patches
  • Routing maintenance of QA
  • Cloning of OA 
220) Request Set and where do you define it?
Request sets allow you to submit multiple requests together using multiple execution path. A request set is a collection of reports and /or programs that are grouped together. A stage is a component of a request set used to group requests within the set. All of the requests in a given stage are executed in parallel. Advantages of stages are the ability to execute several requests in parallel and then move sequentially to the next stage.
Responsibility: System Administrator
Nav: Concurrent -> Set


221)Define Request Group?
A request security group is the collection of requests, request sets, and concurrent programs that a user, operating under a given responsibility, can select from the Submit Requests window. 


222)Registration of PL/SQL with parameters?
  • Create the procedure in the module specific schema.
  • Create a public synonym for that procedure in the Apps schema.
  • Create the executable for that procedure.
  • Create a concurrent program.
  • Attach the concurrent program to that procedure.
Note: There are two mandatory parameters 1. Errbuf 2. Retcode. Any parameter which are to be passed should be succeeded with these two parameters and have to be registered. When calling the procedure, these two parameters are not mentioned.

223)Value Sets?
Oracle Application Object Library uses values, value sets and validation tables as important components of key flexfields, descriptive flexfields, FlexBuilder, and Standard Request Submission. When you first define your flexfields, you choose how many segments you want to use and what order you want them to appear. You also choose how you want to validate each of your segments. The decisions you make affect how you define your value sets and your values.
You define your value sets first, either before or while you define your flexfield segment structures. You typically define your individual values only after your flexfield has been completely defined (and frozen and compiled). Depending on what type of value set you use, you may not need to predefine individual values at all before you can use your flexfield.
You can share value sets among segments in different flexfields, segments in different structures of the same flexfield, and even segments within the same flexfield structure. You can share value sets across key and descriptive flexfields. You can also use value sets for report parameters for your reports that use the Standard Report Submission feature.
Navigation Path:
Login – Application Developer -> Application -> Validation -> Set 


224)Value Validation Types?
Dependant
Independent
None
Pair
Special
Table
Translate Independent
Translate Dependent 


225) How to define a value set depending on other value set?
Navigation Path: Login -> AOL -> Application -> Validation -> Set Select the validation type as "Dependant" and click on „Edit Information‟ button. In Dependant value set information screen mention the Independent value set name.



 

*/