Oracle Financials Interview Questions – Answers Included

Oracle Financials Interview Questions – Answers Included

Below is a list of 25 Important questions that is asked in almost every financials technical interview question. I have also included some of the functional questions that are asked.Answers are included.

Qns: What is Flex field? What are different types of Flex field?

Ans: Flex field is used to capture information of your Organisations.

Qns: Difference between KFF and DFF.

KFF

Unique identifier

Stored in segment Column

DFF

Is used to capture additional information

Stored in attribute Column

Qns: How many KFF are in GL. AP , AR.

Ans:

Module KFF

GL Accounting FF

AP No KFF

AR Sales tax Location FF

Territory Flexfield.

Qns: What is symbol of DFF in the Forms?

Ans: Square Bracket [ ].

Qns: What is structure of KFF in the Accounting Flexfields.

Ans: Company

Cost center

Account

Product

Future use.

Qns: How many segments are in AFF.

Ans: max 30 segments and min two.

Qns: What are flexfield Qualifiers.

Ans: Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:

a) Balancing Segment Qualifier.

b) Cost Center segment Qualifier.

c) Natural Account Segment Qualifier.

d) Intercompany Segment Qualifier.

Qns: What is Dynamic Insertions?

Ans: u can create Code Combinations at run time.

Qns: In which table Code Cominations id is stored.

Ans: GL_CODE_COMBINATIONS.

Qns: In which table flex values are stored.

Ans: 1. fnd_ flex_Values

2. fnd_ flex_Values_tl

Qns: What is set of Books and in which table set of book is stored.

Ans : Set of Books is a Financial Reporting entity which Consist of three C.

a) Chart Of Accounts

b) Currency

c) Calendar.

Set of Books is stored in GL_SETS_OF_BOOKS

Qns: In which table Currency and Period Type Name are stored.

Currency – FND_CURRENCIES

Period – GL_PERIOD_STATUSES

Qns: In which table Segment Values are stored and concatenated values are stored.

Ans: 1. GL_CODE_COMBINATIONS

2. GL_CODE_COMBINATIONS_KFV.

Qns: What are different types of Currency.

Ans: Functional Currency

Foreign currency.

Qns: What are different types of Calendars .

Ans: Different types of Calendars are listed below

a) Fiscal

b) Accounting

Qns: How will you attach set of Books to the Responsibility?

Ans: through Profile. GL SETS OF Books Name.

Qns: What is Profile and what are different types of Profiles.

Ans: Profile: Profile is the changeable option that affects the way your application runs. There are two types of profile.

1. System defined

2. User defined

Qns: What are different Profiles Level available in oracle apps.

Ans: Below are the Profiles Level available in oracle apps

1. Site(Lowest level)

2. Application

3. Responsibility

4. User.

Qns: Write Name of some Profile options.

Ans:

1. GL Sets of Books Name

2. GL sets of Books id

3. MO:Operating unit (multi org).

4. HR:User type.

Qns: What is cycle of GL.?

Ans: In simple and layman words-

1. Open the period

2. Create Journal Enteries

3. Post the Journals.

Qns: In Which tables Journal entries created.

Ans: Important tables are-

1. Batch: GL_JE_BATCHES

2. Header: GL_JE_HEADERS

3. Lines : GL_JE_LINES

Qns: After Posting data goes in which tables.

Ans: GL_BALANCES.( Column Period_net_cr, period_net_dr).

Qns: What are Important tables in GL.

Ans:

1. GL_JE_BATCHES

2. GL_JE_HEADERS

3. GL_JE_LINES

4. GL_BALANCES

5. GL_SETS_OF_BOOKS

6. GL_CODE_COMBINATIONS

7. GL_PERIOD_STATUES

8. GL_INTERFACE

Qns: In which table Supplier information's is stored.

Ans: Supplier information can be found in following tables

1. PO_VENDORS

2. PO_VENDOR_SITES_ALL

3. PO_VENDOR_CONTACTS

Qns: What is difference org_id and Organization_id.

Ans: Org_id is for operating unit and organization_id is for inventory organization.

Create User and Privillages

CREATE USER nageswar IDENTIFIED BY  nageswar DEFAULT TABLESPACE data_ts QUOTA 100M ON test_ts QUOTA 500K ON data_ts TEMPORARY TABLESPACE temp_ts PROFILE manager; 

GRANT connect TO nageswar;

ORDER MANAGEMENT: interview questions and answers

ORDER MANAGEMENT: interview questions and answers

ORDER MANAGEMENT:

1)    What are the Base Tables and Interface Tables for Order Management?
       Interface Tables    : OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL
                  OE_PRICE_ADJS_IFACE_ALL, OE_ACTIONS_IFACE_ALL
                  OE_CREDITS_IFACE_ALL (Order holds like credit check holds etc)
       Base Tables    : OE_ORDER_HEADERS_ALL: Order Header Information
  OE_ORDER_LINES_ALL: Items Information
              OE_PRICE_ADJUSTMENTS: Discounts Information
  OE_SALES_CREDITS: Sales Representative Credits.
Shipping Tables :WSH_NEW_DELIVERIES, WSH_DELIVERY_DETAILS,  WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERIES.
              
2)    What is Order Import and What are the Setup's involved in Order Import?
A)    Order Import is an open interface that consists of open interface tables and a set of API’s. It imports New, updated, or changed sales orders from other applications such as Legacy systems. Order Import features include validations, Defaulting, Processing Constraints checks, Applying and releasing of order holds, scheduling of shipments, then ultimately inserting, updating or deleting orders from the OM base tables. Order management checks all the data during the import process to ensure its  validity with OM. Valid Transactions are then converted into orders with lines, reservations ,price adjustments,  and sales credits in the OM base tables.
B)    Setups:
•    Setup every aspect of order management that we want to use with imported orders, including customers, pricing, items, and bills.
•    Define and enable the order import sources using the order import source window.

3)    Explain the Order Cycle?
i)    Enter the Sales Order
ii)    Book the Sales Order(SO will not be processed until booked(Inventory confirmation))
iii)    Release sales order(Pickslip Report is generated and Deliveries are created)
(Deliveries – details about the delivery. Belongs to shipping module (wsh_deliveries, wsh_new_deliveries, wsh_delivery_assignments etc)  they explain how many items are being shipped and such details.
iv)    Transaction Move Order (creates reservations determines the source and transfers the inventory into the staging areas)
v)    Launch Pick Release (
vi)    Ship Confirm (Shipping Documents(Pickslip report, Performa Invoice, Shipping Lables))
4)  Explain the Order to Cash Flow?
I.    Enter the Sales Order
II.    Book the Sales Order (SO will not be processed until booked (Inventory confirmation))
III.    Release sales order (Pick slip Report is generated and Deliveries are created)
   (Deliveries – details about the delivery. Belongs to shipping module (wsh_deliveries, wsh_new_deliveries, wsh_delivery_assignments etc) they explain how many items are being shipped and such details.
IV.    Transaction Move Order (Selects the serial number of the product which has to be moved/ shipped)
V.    Launch Pick Release
VI.    Ship Confirm (Shipping Documents (Pick slip report, Performa Invoice, Shipping Labels))
VII.    Auto Invoice  (Creation of Invoice in Accounts Receivable Module)
VIII.    Autolockbox ( Appling Receipts to Invoices In AR)
IX.    Transfer to General Ledger ( Populates GL interface tables)
X.    Journal Import ( Populates GL base tables)
XI.    Posting ( Account Balances Updated).

5.  What are the Process Constraints?
A. Process Constraints prevent users from adding updating, deleting, splitting lines and canceling     order or return information beyond certain points in the order cycle. Oracle has provided certain process constraints which prevent data integrity violations.
    Process constraints are defined for entities and attributes. Entities include regions on the sales order window such as order, line, order price adjustments,    line price adjustments, order sales credits and line sales credits. Attributes include individual fields (of a particular entity) such as warehouse, shit to location, or agreement.
6.  What are Validation Templates?   
A) Validation Templates are used to define the validation conditions in process constraints. A validation template names a conditions and defines the semantic of how to validate that condition. These are used in processing constraints framework to specify the constraining conditions for a given constraint. These conditions are based on
•    Where the entity is in its work flow.
•    The state of attributes on an entity.
•    Any other validation condition that cannot be modeled using the above condition.
 
7.  What are different types of Holds?
•    GSA(General Services Administration) Violation Hold(Ensures that specific customers always get better pricing for example  Govt. Customers)
•    Credit Checking Hold( Used for credit checking feature Ex: Credit Limit)
•    Configurator Validation Hold ( Cause: If we invalidate a configuration after booking)
8. What is Document Sequence?
A) Document sequence is defined to automatically generate numbers for your orders or returns as you enter them. Single / multiple document sequences can be defined for different order types.
Document sequences can be defined as three types Automatic (Does not ensure that the numbers are contiguous), Gapless (Ensures that the numbering is contiguous), Manual Numbering. Order Management validates that the number specified is unique for order type.
9. What are Defaulting Rules?
A) A defaulting rule is a value that OM automatically places in an order field of the sales order window. Defaulting rules reduce the amount of information one must enter. A defaulting rule is a collection of defaulting sources for objects and their attributes.
It involves the following steps
•    Defaulting Conditions  - Conditions for Defaulting
•    Sequence – Priority for search
•    Source – Entity ,Attribute, Value
•    Defaulting source/Value
10. When an order cannot be cancelled?
A) An order cannot be cancelled if,
•    It has been closed
•    It has already been cancelled
•    A work order is open for an ATO line
•    Any part of the line has been shipped or invoiced
•    Any return line has been returned or credited.
11. When an order cannot be deleted?
A) you cannot delete an order line until there is a need for  recording  reason.
12. What is order type?
A) An order type is the classification of order. It controls the order work flow activity, order number sequence, credit check point and transaction type. Order Type is associated to a work flow process which drives the processing of the order.
13. What are primary and secondary price lists?
A) Every order is associated to a price list as each item on the order ought to have a price. A price list is contains basic list information and one or more pricing lines, pricing attributes, qualifiers, and secondary price lists. The price list that is primarily associated to an order is termed as Primary price list.
The pricing engine uses a Secondary Price list if it cannot determine the price of the item ordered in the Primary price list.
14. What is pick slip? Types?
A) It is an internal shipping document that pickers use to locate items to ship for an order.
•    Standard Pick Slip – Each order will have its own pick slip with in each picking batch.
•    Consolidated Pickslip – Pick slip will have all the orders released in the each picking batch.
15. What is packing slip?
A) It is an external shipping document that accompanies the shipment itemizing the contents of the shipment.

16. What are picking rules?
A) Picking rules define the sources and prioritization of sub inventories, lots, revisions and locators when the item is pick released by order management. They are user defined set of rules to define the priorities order management must use when picking items from finished goods inventory to ship to a customer.
17. Where do you find the order status column?
A) In the base tables, Order Status is maintained both at the header and line level. The field that maintains the Order status is FLOW_STATUS_CODE. This field is available in both the OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.
18. When the order import program is run it validates and the errors occurred can be seen in?
A) Responsibility: Order Management Super User
     Navigation: Order, Returns > Import Orders > Corrections

CREATE TABLE AND THAT CONSTRINTS

create tables:

create table LOC (LOCID int,CITY varchar2(16),constraint pk_loc primary key (locid));

create table DEPT (DEPID int,DEPTNAME varchar2(16),LOCID int,constraint pk_dept primary key (depid),constraint fk_dept_loc foreign key (locid) references loc(locid));

create table EMP (EMPID int,EMPNAME varchar2(16),DEPID int,constraint pk_emp primary key (empid),constraint fk_emp_dept foreign key (depid) references dept(depid));

Show constraints:

SQL> select CONSTRAINT_NAME, CONSTRAINT_TYPE,TABLE_NAME,R_CONSTRAINT_NAME from user_constraints;

CONSTRAINT_NAME  C  TABLE_NAME R_   CONSTRAINT_NAME

FK_EMP_DEPT                                     R EMP  

PK_DEPTFK_DEPT_LOC                R DEPT

PK_LOCPK_LOC P                             LOC

PK_DEPT P                                              DEPT

PK_EMP                                                    P

Tablespace free memory Query and to know the path of the Table sapce

Tablespace free-used:

SELECT                  Total.name "Tablespace Name",

                                  Free_space,

                                   (total_space-Free_space) Used_space,

                                    total_space

FROM

(SELECT                  tablespace_name,

                                  sum(bytes/1024/1024) Free_Space

FROM                       sys.dba_free_space

GROUP BY                tablespace_name) Free,

(SELECT                    b.name,

                                   sum(bytes/1024/1024) TOTAL_SPACE

FROM                        sys.v_$datafile a,

                                   sys.v_$tablespace B

WHERE                    a.ts# = b.ts#

GROUP BY              b.name) Total

WHERE                        Free.Tablespace_name = Total.name;

For the tablespaces path Query :

SELECT substr(file_name, 1, 70), tablespace_name FROM dba_data_files;

Backup and Recovery

What is Backup and Recovery?
In general,  backup and recovery refers to the various strategies and procedures
involved in protecting your database against data loss and reconstructing the database
after any kind of data loss.
Physical Backups and Logical Backups:
A backup is a copy of data from your database that can be used to reconstruct that
data. Backups can be divided into physical backups  and logical backups.
Physical backups are backups of the physical files used in storing and recovering y
database, such as datafiles, control files, and archived redo logs. Ultimately, every
physical backup is a copy of files storing database information to some other locati
whether on disk or some offline storage such as tape.
Logical backups contain logical data (for example, tables or stored procedures)
exported from a database with an Oracle export utility and stored in a binary file, f
later re-importing into a database using the corresponding Oracle import utility.

Oracle DBA Qestions

1. What is an Oracle Instance?
2. What information is stored in Control File?
3. When you start an Oracle DB which file is accessed first?
4. What is the Job of  SMON, PMON processes?
5. What is Instance Recovery?
6. What is written in Redo Log Files?
7. How do you control number of Datafiles one can have in an Oracle database?
8. How many Maximum Datafiles can there be in an Oracle Database?
9. What is a Tablespace?
10. What is the purpose of  Redo Log files?
11. Which default Database roles are created when you create a Database?
12. What is a Checkpoint?
13. Which Process reads data from Datafiles?
14. Which Process writes data in Datafiles?
15. Can you make a Datafile auto extendible. If yes, how?
16. What is a Shared Pool?
17. What is kept in the Database Buffer Cache?
18. How many maximum Redo Logfiles one can have in a Database?
19. What is difference between PFile and SPFile?
20.  What is PGA_AGGREGRATE_TARGET parameter?
21. Large Pool is used for what?
22. What is PCT Increase setting?
23. What is PCTFREE and PCTUSED Setting?
24. What is Row Migration and Row Chaining?
25. What is 01555 - Snapshot Too Old error and how do you avoid it?
26. What is a Locally Managed Tablespace?
27. Can you audit SELECT statements?
28. What does DBMS_FGA package do?
29. What is Cost Based Optimization?
30. How often you should collect statistics for a table?

31. How do you collect statistics for a table, schema and Database?
32. Can you make collection of Statistics for tables automatic?
33. On which columns you should create Indexes?
34. What type of Indexes are available in Oracle?
35. What is B-Tree Index?
36. A table is having few rows, should you create indexes on this table?
37. A Column is having many repeated values which type of index you should create on this column, if you have to?
38. When should you rebuilt indexes?
39. Can you built indexes online?
40. Can you see Execution Plan of a statement.
41. A table is created with the following setting

      storage (initial 200k
                   next 200k
                   minextents 2
                   maxextents 100
                   pctincrease 40)

     What will be size of 4th extent?

42. What is DB Buffer Cache Advisor?

43. What is STATSPACK tool?

44. Can you change SHARED_POOL_SIZE online?

45. Can you Redefine a table Online?

46. Can you assign Priority to users?

47. You want users to change their passwords every 2 months. How do you enforce this?

48. How do you delete duplicate rows in a table?

49. What is Automatic Management of Segment Space setting?

50. What is the difference between DELETE and TRUNCATE statements?

51. What is COMPRESS and CONSISTENT setting in EXPORT utility?

52. What is the difference between Direct Path and Convention Path loading?

53. Can you disable and enable Primary key?

54. What is an Index Organized Table?

55. What is a Global Index and Local Index?

56. What is the difference between Range Partitioning and Hash Partitioning?

57. What is difference between Multithreaded/Shared Server and Dedicated Server?

58. Can you import objects from Oracle ver. 7.3 to 9i?

59. How do you move tables from one tablespace to another tablespace?

60. How do see how much space is used and free in a tablespace?