ORACLE APPS TECHNICAL INTERVIEW QUESTIONS

ORACLE APPS TECHNICAL INTERVIEW QUESTIONS

APPS TECHNICAL

1) What is SET-OF-BOOKS?

Collection of Chat of Accounts and Currency and Calendars is called SO.

2) How can u call a standard interface program from sql or pl/sql code?

FND_REQUEST.SUBMIT_REQUEST („PO‟,‟EXECUTABLE NAME‟,,,,PARAMETERS)

3) API‟s FOR CUSTOMER INTERFACE?

HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C

HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C

FND_PROFILES

FND_APPLICATIONS

FND_GLOBAL

FND-FILE

FND_CONCSUB(can submit conc program in host environment)

4) PL/SQL stored procedure parameters? or what are the two parameters that are mandatory for pl/sql type concurrent program?

Procedure/function (ERRBUF OUT RETCODE OUT ………………….)

ERRBUF :- Used to write the error message to log or request file.

RETCODE :- Populate log request file with program submission details info.

5) What is Value Set?

--The value set is a collection (or) container of values.

--When ever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value.

-- If the list of values needed to be dynamic and ever changing and define a table based values set.

6) What r the validation types?

1) None -------- validation is minimal.

2) Independent ------input must exist on previously defined list of values

3) Dependent ------input is checked against a subset of values based on a prior value.

3) Table ----- input is checked against values in an application table

4) Special ------values set uses a flex field itself.

5) Pair ------ two flex fields together specify a range of valid values.

6) Translatable independent ----- input must exist on previously defined list

of values; translated values can be used.

7) Translatable dependent ------- input is checked against a subset of values

based on a prior values; translated value can be used.

7) What is template?

a) The TEMPLATE form is the required starting point for all development of new Forms.

b) The TEMPLATE form includes platform–independent attachments of several Libraries.

APPSCORE :- It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS.

APPSDAYPK :- It contains packages that control the oracle applications CALENDER FEATURES.

FNDSQF :- it contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.

CUSTOM :- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)

8) What are ad-hoc reports?

Ans.: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a

particular purpose. For example, ad hoc tax codes or an ad hoc database query

9) What is responsibility? 3

Is collection of menus, request security groups and data groups

Menus: collection of forms is nothing but menus

Request security groups: collection of programs.

Data groups: is a group of modules to be made accessible by the user through Responsibility

System admin

10) What are different execution methods of executabls?

FlexRpt The execution file is wrnitten using the FlexReport API.

FlexSql The execution file is written using the FlexSql API.

Host The execution file is a host script.

Oracle Reports The execution file is an Oracle Reports file.

PL/SQL Stored Procedure The execution file is a stored procedure.

SQL*Loader The execution file is a SQL script.

SQL*Plus The execution file is a SQL*Plus script.

SQL*Report The execution file is a SQL*Report script.

Spawned The execution file is a C or Pro*C program.

Immediate The execution file is a program written to run as a subroutine of the concurrent manager. We recommend against defining new immediate concurrent programs, and suggest you use either a PL/SQL Stored Procedure or a Spawned C Program instead.

Composite Datatypes :

PL/SQL TABLES / PL/SQL RECORDS / Nested TABLE / VARRAY

What is the sequence of functions – group by,having,orderby in a select statements ?

Select…..Group by…Having…Orderby..

Difference between User and Super User? 4

User : login user or front end user

Super user : it has full access of particular module

11) Oracle E-Business suite?

Oracle apps + analytical components software.

(Oracle discover) (Oracle sales analyzer) (Oracle financial analyzer) (Oracle marketing analyzer)

12) What is multi org?

“Legal entity has more than one operating unit is called as multi org”

a) Business group --- Human resources information is secured by Business group

b) Legal entity. --- inter-company and fiscal/tax reporting.

operating unit.

c) Operating unit --- secures AR, OE, AP, PA and PO Information.

d) Organizations --- is a specialize unit of work at particular locations

13) What is ERP? Architecture of apps?

A packaged business software system that lets a company automate and integrate the majority of its business processes; share common data and practices across the enterprise; [and] produce and access information in a real-time environment.

. 14)What is invoice? Send you a request for payment

15 Data Link

- Data links relate the results of multiple queries.

- A data link (Parent - Child Relation Ship) causes the child query to be executed once for each instance of its parent group.

16 In which tables FF are stored?

A) FND - ID - FLEXS

B) FND-ID-FLEX-STRUCTURES 5

17)Oracle Applications Architecture

- Internet computing Architecture is a frame work for 3-tired, distributed computing that supports Oracle Applications products.

- The Three tiers are

1 Data Base Tier

2 Application Tier

3 Desk Top Tier

- Database tier manages Oracle 8i database.

- Application tier manages Oracle Applications and other tools.

- Desktop tier provides the user interface displace.

- With internet computing architecture, only the presentation layer of Oracle Applications is on the Desk Top tier in the form of a plug-in to a standard internet brows

18) List of some API‟S

FND_PROGRAM.EXECUTABLE

FND_PROGRAM.REGISTER

FND_PROGRAM.PARAMETER

FND_PROGRAM.ADD_TO_GROUP

FND_REQUEST.SUBMIT_REQUEST

FND_PROFILE.VALUE

FND_PROFILE.GET

19)How to get second parameter value based on first parameter?

$fle x $ value setname.

20)How to call WHO columns into the form

By using FND_STANDARD API‟S

1. FND_STANDARD.FORM_INFO 6

Provides information about the form.

Should be called form when_new_form - instance - instance trigger.

2. FND_standard.set_who

loads WHO columns with proper user information.

Should be called from PRE_UPDTE and PRE_INSERT

Triggers for each block with WHO fields

If this is used FND-GLOBAL need not be called. (FND_GLOBAL.WHO)

3. FND_STANDARD.SYSTEM_DATE

This is a function which returns date.

Behave exactly like SYSDATE built-in.

4. FNID_STANDARD.USER

This is a function which returns varchar2

Behaves exactly like built in USER.

21) APPCORE API‟S

APP_COMBO

APP_DATE

APP_EXCEPTION

APP_FIELD

APP_FIND

APP_ITEM

APP_ITEM_PROPERTY

APP_NAVIGATE

APP_RECORD

APP_REGION 7

APP_STANDARD

APP_WINDOW

22)FNDSQF API‟S

FND_CURRENCY

FND_DATE

FND_GLOBAL

FND_ORG

FND_STANDARD

FND_UTILITIES.OPEN_URL

FND_UTILITIES. PARAM_EXISTS

23)How to call flex fields in the form?

By using FND_FLEX.EVENT (EVENT varchar 2)

How to register an executable and define a concurrent program through backend?

By using concurrent processing API‟S

1. FND_CONC_GLOBAL.REQUES_DATA

.SET_REQUEST_GLOBALS

2. FND_CONCURRENT.AF_COMMIT

.AF_ROLLBACK

.GET_REQUEST_STATUS

.WAIT_FOR_REQUEST

.SET_COMPLETION_STATUS

3. FND_FILE . PUT

. PUT_LINE

.NEW_NAME 8

.PUT_NAMES

.CLOSE

4. FND-PROGRAM . MESSAGE

. EXECUTABLE

. REGISTER

. PARAMETER

. IN COMPATIBILITY

. EXECUTABLE_EXISTS

5. FND_REQUEST . SET-OPTIONS

.SET_REPEAT_OPTIONS

.SET_PRINT_OPTIONS

.SUBMIT_REQUEST

.SET_MODE

6. FND_REQUEST_INFO . GET_PARAM_NUMBER

. GET_PARAM_INFO

. GET_PROGRAM

. GET_PARAMETER

7. FND_SET . MESSAGE

.ADD_PROGRAM

.ADD_STAGE

.IN COMPATIBILITY

8. FND_SUBMIT . SET_MODE

.SET_REQUEST_STATUS

.SUBMIT_PROGRAM 9

.SUBMIT_SET

* FND_PROGRAM.EXECUTABLE

- is used to define a concument program executable

- it takes 8 parameters ( all are IN mode )

syntax procedure FND_PROGRAM.EXECUTABLE

(executable IN varchar2,

(Full name)

description IN varchar2 default null

execution_method IN varchar2,

execution_file_name IN varchar2 default null,

icon_name IN varchar2 default null,

language_code IN varchar2 default (VS)

* FND_PROGRAM.REGISTER

- this procedure no used to define a concument program.

- It has 30 IN paranmeters. Out of which 9 are mandatory, the remaining are default.

(program IN varchar2,

application IN varchar2,

enabled IN varchar2,

short_name IN varchar2,

description IN varchar2, default null, 10

executable_application IN varchar2,

mls_function_shelt_name IN varchar2,

mls_function_application IN varchar2,

inerementor IN varhcar2);

24. How to register a table and columns through back end?

* by using AD_DD package

- for registering a table

-

- AD_DD BPI doesn‟t check for the existence of the registered table or column in the data base schema, but only updates the required SQL tables.

- It should be ensured that, all the tables and columns registered exist actually and have the same format as that defined using AD_DD API.

- Views need not be registered.

25. How to write to a file through concurrent program.

* By using FND_FILE package and it can be used only for log and output files.

1. FND_FILE.PUT

- this is used to write text to a file with out a new line character

- Multilane calls to FND_FILE.PUT will produce consummated text.

Procedure FND_FILE.PUT (which IN Number, Buff IN varchar2);

- can be FND_FILE.LOG or FND_FILE.OUTPUT.

2. FND_FILE.PUT_LINE 11

- this procedure as used to write a line of text to a file followed by a new line character.

Procedure FND_FILE.PUT_LINE (which IN number, buff IN varchar2);

EX:- FND_FILE.PUT_LINE( FND_FILE.LOG, find_message_get);

3. FND_FILE.NEW_LINE

- this procedure is used to write line terminators to a file

procedure FND_FILE.NEW_LINE (which IN number LINES IN NATURAL:=1);

Ex:- to write two newline characters to a log file

Fnd_file.new_line (fnd_file.log,2);

4. FND_FILE.PUT_NAMES

- this procedure as used to set the temporary log file and output filenames and the temporary directory to the user specified values.

- This should be called before calling my other FND_FILE procedure and only once per a session.

26)Function 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 bookan default False,

argument1,

arguemnt2,

argument 100) return number;

* If this is submitted from oracle forms, all the arguments ( 1 to 100 ) must be specified. 12

27. How to submit concurrent programs through OS?

- From the operating system the utility .CONCSUB is used to submit is concurrent propgram.

- This is basically used to test a concurrent program .

- By using the WAIT token. The utility checks the request status every 60 seconds and returns the OS prompt upon completion of the request.

- Concurrent manager doesnot abort, shutdown or start up until the concurrent request completes.

* If the concurrent program is compatible with it self, it can be checked for data integrity and dead locks by submitting it many times so that it runs concurrently with it self.

*PL/SQL procedures can submit a request to run a program as a concurrent process by calling.

FND_REQUEST. SUBMIT_REQUEST.

* Before submitting a request, the following functions also should be called optionally.

FND_REQUEST.SET_OPTIONS

FND_REQUEST.SET_REPEAT_OPTIONS

FND_REQUEST.SET_PRINT_OPTIONS

FND_REQUEST.SET_MODE

28. How to checks the request states?

- A PL/SQL procedure can check the status of a concurrent request by calling.

FND_CONCURENT.GET_REQUEST_STATUS

FND_CONCURRENT.WAIT_FOR_REQUEST

- FND_CONCURRENT.GET_REQUEST_STATUS

- This function returns the status of a concurrent request

- If the request is already computed, it also returns the completion message.

- This function returns both user friendly (translatable) phase and status values as well as developer phase and status vales that can drive program logic. 13

( request_id in out number,

application in varchar2 default null,

program in varchar2 default null,

phase out varchar2,

status out varchar,

dev_phase out varchar2,

dev_status out varchar2,

message out varchar2) return BOOLEAN;

- when application and program are specified, the request_id of the last request for the specified program should be returned to request_id.

- Phase, and status values should be taken from

FND_LOOKUPS

dev_phase dev_status

pending normal, standby, scheduled, paused

running normal, waiting, resuming, terminating.

Complete normal, Error, warning, cancelled, terminated

Inactive disabled, on-hold, No-manager, supended

- FND_REQUEST.WAIT_FOR_REQUEST

- This function waits for request completion, then returns the request phase/status and completion message to the caller.

- Goes to sleep between checks for request completion.

Syntax

( request_id in number default null,

interval in number default 60,

max_wait in numbe default 0, 14

phase out varchar2,

status out varchar2,

dev_phase out varchar2,

dev_status out varchar2,

message out varchar2) return BOOLEN;

* FND_CONCURRENT.SET_COMPLETION_STATUS

- this function should be called from a concurrent program to set its completion states.

- This function returns TRUE on success, other wise FALSE.

ENT.SET_COMPLETION_STATUS

( status in varchar2,

message in varchar2) return BOOLEAN;

normal

status warning

Error

29. What is the reason for not getting any data when a multi org view is quired?

- to get the data correctly, the xxx-ALL must be referenced and the ORG_ID value should be specified to extract portioned data.

- Multiorg views are partitioned by using ORG_ID.

- So access through multiorg views will not return any roes, as the CLIENT_INFO Value is not set

- Use HR_OPERATING UNITS to identify the organization _id of the OU on which query is based.

- Use FND_CLIENT_INFO package to set the value in CLIENT INPO using set_org_contest.

- Execute fnd_client_info. Set_org_context („<org_id>‟);

- Now qurying of multiorg views can be done. 15

30. How do you find that muliorg is installed?

- multi organization architecture is meant to allow muliple companies or subsidiaries to store their records with in a single data base.

- Multiple organization Architecture allows this by partitioning data through views in APPS schema.

- Implementation of Multi org generally includes more than one business group.

* To know whether multiorg is existing or not

select multi_org_flag

form fnd_product_groups)

- if the result is „Y‟ means the database is group for multiorg