Oracle Apps(EBS) Interview Questions and Answers Part 4

Oracle Apps(EBS) Interview Questions and Answers Part 4:--

QUESTION 33. Define Autonomous transaction?


Solution :This is a kind of transaction that is independent of another transaction. This type of transaction helps you do SQL operations, roll back operations, commit operations, and halt the main transaction.


Resources, locks, and other commit dependencies that are a component of the primary transaction are not supported by the autonomous transactions.


QUESTION 34. Which are the types of Triggers?


Solution :There are various kinds of triggers associated with forms and they are


Key triggers


Error triggers


Message triggers


Navigational triggers


Query – based triggers


Transactional triggers


QUESTION 35.What is Trigger in PL/SQL?


Solution :


TRIGGERS are stored procedures that the Oracle engine launches on its own if certain events take place when DML Statements like insert, update, or delete are performed on the table. You can define the code that will run in the event of a trigger according to the specifications. Both the trigger's requirement to fire and when it should be executed are configurable. The trigger's job is to keep the data in the database as accurate as possible.


QUESTION 36.What are Types of Triggers in Oracle?


Solution :


The following criteria can be used to categorize triggers:--


A•) Categorization according to the time o PRIOR to Trigger:


It goes off before the predetermined time.


o AFTER Trigger: It ignites following the completion of the designated event.


o INSTEAD OF Trigger: An unique kind. You'll discover more about the upcoming subjects. (exclusively for DML)


B•) Grouping according to the degree


o STATEMENT level Trigger: For the given event statement, it fires once.


o ROW level Trigger: It activates for every record impacted by the designated event. (exclusively for DML)


C•) Categorization according to the Event


o DML Trigger: It activates upon specification of the DML event (INSERT/UPDATE/DELETE).


o DDL Trigger: It activates upon the specification of the DDL event (CREATE/ALTER).


o DATABASE Trigger: It fires when the database event is specified (LOGON/LOGOFF/STARTUP/SHUTDOWN)


So each trigger is the combination of above parameters.


QUESTION 37.How to Create Trigger?


Solution :Below is the syntax for creating a trigger.


CREATE OR REPLACE TRIGGER


[BEFORE | AFTER | INSTEAD OF ]


[INSERT | UPDATE | DELETE......]


ON


[FOR EACH ROW]


[WHEN ]


DECLARE





BEGIN





EXCEPTION





END;


QUESTION 38. Why are temp tables used in interface programs?


Solution :


These are the kinds of tables that can be used for the purpose of storing intermediate values or data and also used for validation of program.


QUESTION 39.What are interface tables in Oracle Apps?


Solution :The data is first placed into interface tables, which are intermediary tables. Following its insertion into the interface tables, the data is checked for accuracy before being moved to the base tables. Real application tables called base tables are found in the application database.


QUESTION 40. Where to define the parameters in the report?


Solution :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 such as creating a valuesets for the parameters in the program.


QUESTION 41. Define the steps for customizing form?


Solution :The most important thing you have to do is copy the Appsatnd.fmb and template.fmb files from AU_TOP/forms/us and place them into the custom directory.


This causes the library linked to the task to be copied on its own.


Now you can design and alter the forms you desire.


Help > Diagnostics > Custom code > Personalization.


Remember to store the completed forms inside the modules where they should be.


QUESTION 42.What does Key Flexfiled mean?


Solution :The key flexfiled is a distinct identifier that is often placed in a segment along with other information like the account number. There are two distinct segment qualifier and flexfield qualifier properties attached to it.


QUESTION 43. Define uses of Key Flexfield ?


Solution :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.


QUESTION 44. Define Descriptive FlexField ?


Solution :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.


QUESTION 45. Which DFF (Descriptive Flex Field) applications are there?


Solution :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.


QUESTION 46. What does "Multiple Reporting Currency" (MRC) mean?


Solution :Several Reporting is the solution. Currency makes it easier to report on and retain records of transaction-level data in several useful currency formats.


A reporting currency is an entity that is connected to a ledger for the purpose of financial reporting.


We employ reporting currencies and supplementary currency representations of primary or secondary currencies to record ledger transactions in different currencies.


backup ledgers.Oracle Applications Assistance for MRC


Multiple Reporting Currencies are supported by the following Oracle Applications:


Payables · General Ledger · Acquisitions · Debts ·Finances · Work in Progress · Resources · Financial Control


QUESTION 47. Define FSG ( Financial Statement Generator) ?


Solution :For Oracle General Ledger, Financial Statement Generator (FSG) is an effective tool for creating reports.


Using FSG, you may create financial reports from your general ledger data, including balance sheets and income statements.


This is the kind of tool that helps create customized reports without the need for programming. It is quite flexible and powerful. Only GL is needed to use this utility.


Q48: What does Oracle Suite mean?


Solution: The Oracle Suite is made up of software related to analytical components and Oracle applications.