Oracle Apps(EBS) Interview Questions and Answers Part 1

Oracle Apps Interview Questions and Answers Part 1:--

QUESTION 1. What procedures must I follow in order to attach reports to Oracle applications?


SOLUTION:





Step 1: Design the Data Template XML File


Step 2:Create the Data Definition in XML Publisher and LINK it with Data Template


go t0 xml publisher responsiblity> home> data definition


give code(xml file name with out extension) , upload xml file under data template.


copy data defintion code to enter into concurrent program short name.


Move xml files to server using winscp.


Step 3: define executable - XDODTEXE(XDO is short name of xml publisher,to find short name of any module,


Nav: system administrator>concurrent>program> Executable


Step 4: Define a Concurrent Program and attach the executable program name to generate the Data XML File.


system administrator-- concurrent--program -–define


enter program name like tesla R1 supplier report


FORMAT:(client name) (rice identifier) (short description of the purpose)


step 5:attach concurrent program to request group From which the program needs to run from the responsibility.


go to system administrator-- security-- responsibility—request group


Example:If you want to run the program from PAYABLES RESPONBILITY Then attach the new program creation to the respective request group of responsibility.


f11- req. gp name= All reports


application= Payables


control +F11


add concurrent program name and save.


Step 4: submit the program from payables responsibility


go to view- request-submit request--single request.


choose your program,submit.


We can see the report of different format using options button


click on view output and save as .xml file





Step 5: Define the RTF Template using the Generated Data XML.


Step 6: Registering the Template with XML Publisher


go to xml publisher administrator- home- templates--create template-- enter all details and upload rtf file.


Step 6:go to payables responsiblity,go to view- request-submit request--single request.


choose your program,submit,view output.





Or,


1.Designing the report. ---data template and layout model creation.


2.Generating executable file related with report.


3.Moving executable and source files to the appropriate folder of the product using winscp


4.Registering the report in the form of concurrent executable.


5.Defining concurrent program for registered that are executable.


6.Adding concurrent program for requesting group of responsibility.


QUESTION 2. Differentiate Apps schema from the other schema?


SOLUTION: A database's logical structure, or schema, includes elements such as tables, functions, triggers, interfaces, and procedures. Ex: scot, applications, AR, AP, etc.


There is no way to create tables in the apps schema. Another schema permits the development of tables as well as includes objects and tables,additionally for giving grants to tables.


QUESTION 3. Explain the meaning of a (custom) top.


SOLUTION:The term oracle custom refers to a top made specifically for clients.


QUESTION 4. What is the method of calling standard – interface program from pl/sql or sql code?


SOLUTION:


FORMAT- FND_REQUEST.SUBMIT_REQUEST(application IN varchar2 default NULL,


program IN varchar2 default NULL,


description IN varchar2 default NULL,


start_time IN varchar2 default NULL,


sub_request IN boolean default FALSE


argument1,


argument2, ..., argument99,


argument100)


EXAMPLE:FND_REQUEST.SUBMIT_REQUEST(PO, EXECUTABLE NAME,,,,,PARAMETERS)


QUESTION 5. What is the significance related of US folder?


SOLUTION:A language specification folder is all that the US folder is. Depending on the installed languages, multiple folders may be maintained for language specification, by default american language.


Only forms and reports have access to the us folder because they both have guis (graphical user interfaces). It is only a language specification because it is written in American English by default. From backend we can get it from fnd_languages table amd installed _flag column like I,B,D i=installed, b=base, d=disable select language_code,nls_language from fnd_languages where installed_flag like 'b’.


QUESTION 6.What are different report triggers?


SOLUTION:


There are primarily five types of report triggers that are available. They are:--


Trigger Name Explanation


-----------------------------


Before Parameter The Runtime Parameter Form appears before the Before Parameter form fires.


After Parameter Following the display of the Runtime Parameter Form, the After Parameter form fires.


Before Report Prior to Report Fires: The report is executed prior to the query being processed.


Between Pages With the exception of the first page, there are spaces between pages before each structured page in the report.


After Report Once you have left the Paper Design view, click Report Fires.


QUESTION 7. In terms of report triggers, what is the firing order?


SOLUTION:The firing sequence is as follows: before the report, between pages, after the report, and before the parameter form.


QUESTION 8. Why are cursors used in PL/SQL?


SOLUTION:A cursor is just a variable that stores the output of a SQL query.


The cursor can be utilized for managing different row queries related to PL/SQL. Implicit cursors can be used to handle every Oracle-related question.

Oracle stores the data that can be utilized with implicit cursors in the memory areas that are not designated.

QUESTION 9. Define record group?


SOLUTION:


An Oracle Forms data structure with a column/row structure akin to a database table is called a record group.


Record groups can be classified into three categories: non-query record groups, query record groups, and static record groups.


collection of query records


A record group with a SELECT statement attached is known as a query record group. Query record groups can be generated and edited during the design or execution phases.


batch of records without a query


A group without a related query is known as a non-query record group. Only during runtime can non-query record groupings be established and altered.


Group of static records


A query is not linked to a static record group. Only during the design process can static record groups be created and altered.