Ans:
Ans:Apps schema is the one that comprises of only synonyms and there is no possibility of creating tables in it. Other schema comprises of tables and objects in it and allows the creation of tables as well as for providing grants to tables.
Ans: Custom top can be defined as the customer top which is created exclusively for customers. According to the requirement of the client many number of customer tops can be made. Custom top is made used for the purpose of storing components, which are developed as well as customized. At the time when the oracle corporation applies patches, every module other than custom top are overridden.
Ans: FND_REQUEST.SUBMIT_REQUEST(PO, EXECUTABLE NAME,,,,,PARAMETERS)
Ans: US folder is just a language specification. Multiple folders can be kept for language specification depending on the languages that are installed.
Ans: There are mainly five different kinds of report triggers available. They are
Ans: The sequence related with firing is as follows before parameter form, after parameter form, before the report, between pages and after report.
Ans: The cursor can be made used for the purpose of handling various row – query associated with PL/SQL. Implicit cursors are available for the purpose of handling all the queries related with oracle. The memory spaces that are unnamed are used by oracle for storing the data that can be used with implicit cursors.
Ans: Record group can be considered as a concept used for the purpose of holding sql query that is associated with list related with values. Record group consists of static data and also can access data inside tables of database through sql queries.
Ans: This is a kind of field associated with oracle apps that are used for capturing information related with the organization.
Ans: You have the provision for having custom schema at the time of creating table.
Ans: Concurrent programs are instances that need to be executed along with incompatibles and parameters.
Ans: Application tops are found when we are connecting to server. There are two types of application tops available they are product top and custom top. Product top is the kind of top that is built in default by manufacturer. Custom top can be chosen by the client, and any number of custom tops can be created as per the requirement of the client.
Ans: There are number of parameters which are mandatory in the case of procedures and each of these parameters has a specific job associated with it.
Ans: Token is used for transferring values towards report builder. Tokens are usually not case – sensitive.
Menu can be defined as a hierarchical arrangement associated with functions of the system.
Ans: Function is the smaller part of the application and that is defined inside menu.
Ans: Sql loader is a utility resembling a bulk loader for the purpose of moving data that are present in external files towards the oracle database.
Ans: There are certain steps that you need to follow for the purpose of registering concurrent program.
Ans: SOB can be defined as the collection of charts associated with accounts, currency and calendars.
Ans: Value set is used for the purpose of containing the values. In the case of a value set getting associated with report parameters, a list containing values are sent to the user for accepting one among the values in the form of parameter values.
Ans: There are various kinds of validation.
Ans: Template is a kind of form that is very much required before the creation of any other type of forms. It is a kind of form that incorporates attachments that are platform independent and associated with a particular library.
Ans: There are several attachments that are part of the template form.
Ans: This is a kind of report that is made used for fulfilling the reporting needs of a particular time.
Ans: Responsibility is the method through which the group of various modules can be made in a format accessible by users.
Ans: This is a kind of transaction that is independent of another transaction. This kind of transaction allows you in suspending the main transaction and helps in performing SQL operations, rolling back of operations and also committing them. The autonomous transactions do not support resources, locks or any kind of commit dependencies that are part of main transaction.
There are various kinds of triggers associated with forms and they are
Ans: These are the kinds of tables that can be used for the purpose of storing intermediate values or data.
Ans: The parameters can be defined inside the form of concurrent program, and there is no need for registering the parameters but you may need to register the set of values that are associated with the parameters.
Ans: You need to make use of the following steps for the purpose of customizing forms.
Ans: Key flexfiled is a unique identifier and is usually stored inside segment, and there are two different attributes associated with this which are flexfiled qualifier and segment qualifier.
Ans: This is a unique identifier for the purpose of storing information related with key. It also helps in entering as well as displaying information related with key.
Ans: This is a kind of flexfield that is mainly used for the purpose of capturing additional information, and it is stored in the form of attributes. Descriptive flexfield is context sensitive.
Ans: This is a kind of flexfield that is mainly used for gathering extra information and also for providing space for you to form and get expanded.
Ans: Multiple – Reporting Currency is a kind of feature that is associated with oracle application and helps in reporting as well as maintaining records that are associated with the transaction level in various forms of functional currency.
Ans: This is a kind of tool that is highly powerful as well as flexible and helps in building reports that are customized without depending on programming. This tool is only available with GL.
Ans: Oracle suite is the one that comprises of oracle apps as well as software associated with analytical components.
Ans: ERP is a software system that is available as a package and can be helpful in automating as well as integrating most of the processes associated with the business.
Ans: Datalink can be made used for the purpose of relating the results that are associated with various different queries.
Ans: Second parameter can be attained by making use of the first parameter by making use of the command $flex$value set name.
Ans: Data group can be defined as the group of applications related with oracle.
Ans: Security attributes can be made used by Oracle for allowing the particular rows containing data visible to the users.
Ans: Profile option comprises of set of options that are helpful in defining the appearance as
Ans: Application can be defined as the set of menus, forms and functions.
Ans: Custom.pll can be used during the process of making customized or new oracle forms.
Ans: Tables can be created at custom schema.
Ans: This is a kind of functionality for data security.
Ans: Request group is assigned with a set of responsibilities.
Ans: This object is used for process associated with executable field.
Related Interview Questions...