Finance Interview Questions and Answers

1.       What are mandatory parameters of Procedures and what the use of those?

·         Errorbuf: It is used to returns the error messages and sent it to the log file.

·         Retcode: It is used to show the status of the Procedure with 0, 1, and 2.

0 for Completed Normal

1 for Completed Warning

2 for Completed Error

2.       What are the levels at which profile option can be set? If answered, ask the priority from lowest to highest of these level.

1. Site

2. Application

3. Responsibility

4. User

3.       What is Exception? What are the two types of exceptions?

Error handling part of PL/SQL block is called Exception. They have two types : user_defined and predefined

4.       List of Pre-Defined Exception.(Expecting a minimum of four)

DUP_VAL_ON_INDEX

ZERO_DIVIDE

NO_DATA_FOUND

TOO_MANY_ROWS

CURSOR_ALREADY_OPEN

INVALID_NUMBER

INVALID_CURSOR

PROGRAM_ERROR

TIMEOUT _ON_RESOURCE

STORAGE_ERROR

LOGON_DENIED

VALUE_ERROR

5.       What are the cursor attributes used in PL/SQL?

%ISOPEN: it checks whether the cursor is open or not.

%ROWCOUNT: returns the number of rows affected by DML operations: INSERT,DELETE,UPDATE,SELECT.

%FOUND: it checks whether cursor has fetched any row. If yes - TRUE.

%NOTFOUND: it checks whether cursor has fetched any row. If no - TRUE.

6.       What are the modes of parameters that can be passed to a procedure?

IN,OUT,IN-OUT parameters

7.       What is difference between a PROCEDURE & FUNCTION?

A FUNCTION is alway returns a value using the return statement.

A PROCEDURE may return one or more values through parameters or may not return at all.

8.       Can we associate a view to a trigger

Yes

9.       When a trigger is associated to a view, Is the base table triggers are normally disabled ?

No

10.   Difference between KFF and DFF
     

11.   What are different report triggers and what is their firing sequence ?

Before Parameter Form

After Parameter Form

Before Report

Between Pages

After Report.

12.   What are Interface table in AP

AP INTERFACE TABLE: 1). AP_INTERFACE_CONTROLS.

                                        2). AP_INTERFACE_REJECTIONS

                                        3). AP_INVOICE_INTERFACE

                                        4). AP_INVOICE_LINES_INTERFACE.

13.   What are Interface table in AR

                                                    1). AR_PAYMENTS_INTERFACE_ALL

                                                    2). AR_TAX_INTERFACE

                                                    3). HZ_PARTY_INTERFACE

                                                    4). HZ_PARTY_INTERFACE_ERRORS

                                                    5). RA_CUSTOMERS_INTERFACE_ALL

                                                    6). RA_INTERFACE_DISTRIBUTIONS_ALL

                                                    7). RA_INTERFACE_ERRORS_ALL

                                                    8). RA_INTERFACE_LINES_ALL

                                                    9). RA_INTERFACE_SALESCREDITS_ALL

14.   What are Interface table in GL

                     1). GL_BUDGET_INTERFACE

                                                  2). GL_DAILY_RATES_INTERFACE

                                                  3). GL_IEA_INTERFACE

                                                  4). GL_interface

                                                  5). GL_INTERFACE_CONTROL

                                                  6). GL_INTERFACE_HISTORY

15.   Difference between Lookups and Value Sets

1.Value sets can be attached to parameters of a concurrent program, whereas Lookups can't.

2.Value sets can contain values that are a result of an SQL Statement.

Hence it is possible to make Value Set list of values dynamic.

On the contrary, Lookup Codes are Static list of values.

16.   What are the differences between FAH and SLA?

FAH

• Deals with external (i.e. non-E-Business Suite) applications.

• No seeded event models – event models need to be build from scratch.

• No seeded accounting rules – accounting rules need to be build from scratch.

• Requires purchasing a separate license.

SLA:

• Deals with the E-Business Suite subledger applications (AR, AP, etc.).

• Seeded event models which cannot be changed (extensions can be build using Custom Sources).

• Seeded accounting methods which can be customized (copied and modified) at will.

• Integral part of E-Business Suite Financials (R12 onwards).

17.   What is transaction object table in FAH

These are the custom staging tables created to map the Third party system data to oracle.

18.   What are the mandatory accounting attributes used in FAH?

Entered Amount, Entered Currency code, First distribution identifier, distribution type ,GL Date

19.   What are supporting references and when can we use?

• To provide additional business information about a sub ledger journal entry at the header or line level

• To establish a sub ledger balance for a particular source value or combination of source values for a particular account

20.   Name few XLA tables

XLA_Events,

XLA_Transaction_entities,

xla_ae_headers,

xla_ae_lines,

xla_distribution_links