be happy and make others to be happy: Oracle Apps Basics Interview Questions & Answers

Oracle Apps Basics Interview Questions & Answers

================================================

1.Question :
------------
What is one full life cycle implementation?

Answers:
--------
Full life cycle is started from scratch to Production which includes mainly

1) Designing Modules.

2)Development of Modules.

3)Testing of Modules.

4)Going to Production.

1.Designing Modules.
2.Development of Modules.
3.Testing of Modules.
4.Going to Production.

&

we have six phases in application implimentation life cycle.
1 definition phase
2 operational analysis phase
3 solution design phase
4 build phase
5 transition phase
6 production phase

2.Question :
------------
How many templates use for oracle reports in oracle applications and what they are ?

Answers:
--------
There are 8 templates in Oracle Reports.

1.Tabular 2.Group Above 3.Group Left 4.Mailing Label 5.Matrix 6.Matrix with Group 7.Form Like 8.Form Letter

3.Question :
------------
What is profile options? what are the types of
profile options in AR / AP ?

Answers:
--------
The profile options are available to every product in Oracle Applications. For each profile option, we give a brief overview of how Oracle Application Object Library uses the profile's setting.

1)User Level

2)Responsibility Level

3)Application Level

4)Site Level.

Profile options will change the behaviour of the application and Profile Options are parameters for applications...
We can setup the Profile Options for four levels...
1) User level
2) Application level
3) Responsibility level
4) Site level
We have two types of Profile Options.
1) System Level
2) Personal level
We never create Profile Options in Personal level.

4.Question :
------------
Which table stores receipts information

Answers:
--------
AR_RECEIPTS_REP_ITF

RCV_SHIPMENT_HEADERS_ALL

RCV_SHIPMENT_LINES_ALL

RCV_DISTRIBUTIONS_ALL

&

IN AR
AR_CASH_RECEIPTS_ALL

AND IN PO
RCV_SHIPMENT_HEADERS_ALL
RCV_SHIPMENT_LINES_ALL
RCV_TRANSACTIONS

5.Question :
------------
Invoice Accounting - TDS entry not generated in service bills

Answers:
--------
For TDS Credit Memo Generation make sure that TDS Type, TDS %age and TAxable amount is entered.

6.Question :
------------
what are the related set ups to be done for AP invoice approval?Can we set the approval heirarchy even for this?

Answers:
--------
For Approving an invoice in AP we have to raise one invoice for raising an invoice we have some mandatory fields like supplier, supplier number, Payment terms, distribution sets, date, payment method, bank, payment document etc.

After defining all the above we can raise a invoice, There s no need of defining the approval group it s not a mandatory,

7.Question :
------------
What is the difference between data conversion and data migration?

Answers:
--------
Data Migration is upgrading from one version to another version fro e.g. from 11.5.9 to 11.5.10.. Data Conversion is receiving data from a legacy system or receiving data from another module ( e.g. PA), validating it and converting it to ur our the target module using the standard import program.

Data migration means moving the data from 1 particular version to another for e.g. migrating data from tally 9 to tally E.R.P 9 and data conversion means converting the format of data for e.g. converting video from avi format to 3gp

8.Question :
------------
What are the setup steps to setup Credit Card Transactions.

Answers:
--------
For the setup of Credit Cards, we have to initally set Credit Card Programs and Code Sets Window.

We are setting credit card programs for our enterprise's credit card and procurement card requirements.Set up Credit Card Program with a card type of Travel for employees to enter credit card transactions on expense reports.Set up Credit Card Program with a card type of Procurement for employees to use procurement cards to purchase items directly from suppliers.

In Code Sets Window, we are setting credit card codes for our Procurement cards.Payables use these codes to create default accounting distributions for transactions that we import from our credit card issuer.

This is upto my knowledge if anything is there let me know.

9.Question :
------------
What is the difference between Organization_id and Org_id ?

Answers:
--------
OrgId: Org Id is an unique ID for the Operating Unit.Organisation Id: The Organisation Id is an ID for the Inventory Organisation which is under an Operating Unit.

Org Id is an unique ID for the Operating Unit.Organisation Id: The Organisation Id is an ID for the Inventory Organisation which is under an Operating Unit.

10.Question :
-------------
What is balancing segment

Answers:
--------
Balancing segment is the level for balancing the accounting entries. For example, the accounting flexfield structure is company-costcenter-project. If you define the balancing segment as company, then both debit and credit should be balanced at the company level when the transactions are posted to GL.

11.Question :
-------------
How will you display message for testing the form you modified?

Answers:
--------
Fnd_message.set_string('test only '); fnd_message.show; --or fnd_message.error; 

12.Question :
-------------
How to implement Flex fields in forms , name the triggers & user exits?

Answers:
--------
The necessary step we have to follow to implement Flexfield in forms: 1. Create a table through which we are going to create the flex field. 2.Registered the table. 3.Registered the column of the table. 4.Insert few data into the table. 5.fire a commit statement after inserting the data. 6.Nevigate to Oracle System Administrator Responsibility->Corresponding flexfield Register. 7.Nevigate to Oracle System Administrator Responsibility->Corresponding flexfield Segment. 8.Create a non-database field in your form where you are going to implement the flexfield. 9.Define the corresponding flexfield in the WHEN-NEW-FORM-INSTANCE trigger of your form. 10.Activate the event like WHEN-NEW-ITEM-INSTANCE and WHEN-VALIDATE-ITEM in the created non-database field item by using FND_FLEX.EVENT procedure. 11. Run your form and text it. 

13.Question :
-------------
Where you will keep the host source code?

Answers:
--------
Host resource is located under AU_TOP/11.5.0/bin 

14Question :
------------
How to register Form , Reports?

Answers:
-------
Registering Oracle Reports: Step 1: Register a concurrent program executable Navigate to the Define Executable form (AOL Reference manual pg 9-84) This determines the type of program being run,ie an Oracle Report. Fill in the executable name, application and execution method. For the Execution File, fill in just the filename. The concurrent manager will look in the appropriate directory under the application's top directory. For spawned programs, the file must be in the bin directory, for Oracle Reports the rdf file must be in the srw directory. For PLSQL concurrent programs, put the name of the stored procedure. Step 2: Define the concurrent program Navigate to the Define Concurrent Program form (AOL Reference manual pg 9-87) This form links a concurrent program to the executable you just defined, as well as defines the programs parameters, incompatibilities, and other options. Enter the concurrent program name, application, short name and description. Check Standard Submission if you want to be able to submit this program from the Standard Report Submission form. Enter the name of the executable you defined and any report information if necessary. Also define any parameters your program needs here and any incompatibilities. Step 3: Add the concurrent program to a Report Group First you will need to find the name of the Report Group to use. Go to Security->Responsibility and query the responsibility you want to run the program with. It should show a Report Group name. Query this name in Security->Responsibility->Report Add your new program to the list of available programs. Now when you go to submit a request with this responsibility, you will be able to submit your custom program. Forms Registration 1. Develop the form in Developer 2000. 2. Save the FORM and move it to UNIX. [Form to be moved to $CUSTOM_TOP/forms/US] 3. Define the FORM in Application Developer 4. Define FORM as FUNCTION. 5. Identify MENU, where the FORM to be attached. [SysadminResponsibilityDefine] 6.Copy the above MENU and go to Application Developer and query on MENU tab 

15.Question :
-------------
What is flex field?

Answers:
--------
A flex field is a place holder set of fields that can be configured by customers for use by their organizations. Once configured, the customer-defined fields (label/widget pairs) may appear in either form or tabular layouts. There are two main types of flexfields: Descriptive flexfields, which are configured as a set of fields that are indistinguishable from core (default) application fields, and key flexfields, which consist of multiple segments for entry of codes, such as a product serial numbers or bank account numbers. 

16.Question :
-------------
What is segment qualifier?

Answers:
--------
Segment qualifiers hold extra information about individual segments such as if the account is an Asset, Liability or Expense, if you can post to the account and more. When we define a segment value in the Segment Values window, we must also assign qualifiers which determine the account type (asset, liability, or expense), whether budgeting is allowed, whether posting is allowed and other information specific to the segment value. Allow Budgeting, Allow Posting, Account Type, Control Account, Reconciliation Flag. 

17.Question :
-------------
What are global segments?

Answers:
--------
Global segment is a type of descriptive flex field. Global Segment: always appears on the customer's application page, regardless of the context please refer to note http://www.oracle.com/technology/tech/blaf/specs/flexfields.html#global_descriptive

18.Question :
-------------
What are context sensitive segments?

Answers:
--------
Context Sensitive Segment is a type of Descriptive Flex Feild. Context Sensitive Segment: only appears when an appropriate selection is made in the context segment (the controlling field) See below for more details. Global and context-sensitive segments may consist of the following widgets: http://www.oracle.com/technology/tech/blaf/specs/flexfields.html#contextual_descriptive view-only label/data pair text box date picker choice list LOV field 

19.Question :
-------------
What is auto reduction?

Answers:
--------
LOV Auto-reduction : Lov Auto-reductions is used in forms. The general idea is to wrie a statement like "Select {name column},{value column} from {table} where {name column} like '%{:Combo_Item}%'" You can create a record group out of this statement ans populate the combo box dynamically. example When the user types in 0208% This list has the following items is displaced 02080006 02080023 02080116 02080222 02080273 02080452 02080705 02080709 02080749 02080800 

20.Question :
-------------
How to debug the form?

Answers:
--------
Forms has features that helps you more easily debug your application, including Debug Messages, which notifies you every time a trigger starts to fire and Debug Mode which allows you to dynamically view the execution of your triggers and variables

21.Question :
-------------
How to attach reports in Oracle Applications ?

Answers:
Design your report

put your file into product_top>version>language>file.name

define executable

define concurrent

add to the request group

run the report respective responsibility.

Once you run create the report you should save the file in .rdf formate after that you shoul move the file to oracle server(if ur in child system) and saave this file into oracel>reports>version>language... this is the path where you have to move the report.

Once you move this file, you hav to create concurrent program for this one.

The navigation for this one is system administrator->concurrent>executable.
you have to copy executable short name for defining this concurrent program.
system administrator->concurrent>define

After that you have to add this concurrent program to request group
system administrator->setup>reuest group

after that u have to submite this reueset in srs window.

this is process how to attach a report to Apps

&

Design Report

Save As .Rdf file

Move to custom Top(oracle>reports>version>language)

Create Executable

Define Concurrent

Add to Request Group...

Run The report in SRS Window

22.Question :
-------------
What is the use of cursors in PL/SQL ? What is REF Cursor ?

Answers:
--------
If you have not used REF cursor, then when you need to open cursors multiple time, it will throw an error. Because in a procedure there is a limitation availe for maximum number of cursors to be open at any point of time.

23.Question :
-------------
What is a FlexField ? What are Descriptive and Key Flexfields ?

Answers:
--------
A flexfield is made up of sub-fields or segments.. A flexfield appers on ur form as a pop-up window that contains a prompt for each segment.Each segment has a name and a set of valid values..

Two types of Flex field..

Key Flexfield: Key flexfield are flexible enough to let any organization use the code scheme they want wothout programming.Key flexfield can be used to represent codes that is made up of meaningful segment to identify GL a/c Part no. and other business entities..Oracle app store these codes in key flexfields..

Descriptive Flexfield: They provide customizable "expansion space" on ur forms. You can use desc flexfields to tract additional information important and unique to ur business that would not otherwise be captured by the form.

I will be piuttng this dazzling insight to good use in no time.

24.Question :
-------------
What is the use of Temp tables in Interface programs ?

Answers:
--------
Interface Table are used to transfer data automatically from legacy System to APPS(e.g. AP/GL). Before running Standard Import program data should be stored in Interface Tables.

25.Question :
-------------
How to pass parameters to a report ? do you have to register them with AOL ?

Answers:
--------
frist of all you have to register the parameters of your repot in AOL.

setps

1.switch to SYSADMIN responsibility.

2 register the executable, navigation is

Concurrent>program>executable

3 register the program for this,navigation is

concurrent>program>define

in this form there is a one button <PARAMETER> click and register your

report parameter.

26.Question :
-------------
What are forms customization steps ?

Answers:
--------
For form customization we need to download the template.fmb in binary format from AU_TOP directory.

Then rename template.fmb to the your form name and start customizing it.

Upload the form into AU_TOP/forms/US

Compile the form.

Copy the form into respective custom top as INV_TOP, PO_TOP etc.

For registering in apps -

Register form --> Register function --> Register Menu -->

1.Get the Template form from AU_TOP.
2.Do all the modifications for that form and rename it
3.Register the form in apps Steps are a)Create Executable file b) Create a form name with that excecutable c)Create a Form Function with that Form name d) attatch that form fuction to repective menu e) add the menu to the Responsibility.
4.Move the excecutable file to the reapective directory.
5.Compile that excecutable without any error.

27.Question :
-------------
What is Key and Descriptive Flexfield.

Answers:
--------
Key Flex Field:

KFF is a Mandatory field which is already driving the functionality and it is the field where atleast first segment is made mandatory.

KFF willbe filled in segments

KFF Is mandatory

KFF Drives functionality

Navigation is Inventory(Navigator)->Setup->FlexField-Key->Segments

then you can search for application and the flex field

Examples : in Oracle Inventory

System Items,Stock Locators,Item Categories,Item Catalogs etc

Descriptive Flex Field :Descriptive flex field is the data which can be entered into the each of the oracle forms which can take extra information,and this option is there for almost all forms in oracle.you find the option of dff in every form that you work

DFF: Is not a mandatory field

DFF Information will go into attributes of the table

DFF does not drive any functionality but you can drive by writing a custom code on the dff fields..

Navigation is Inventory(Navigator)->Setup->FlexField-Descriptive->Segments

then you can search for application and the flex field

Examples : in Oracle Inventory

System Items,subinventories,stock locators any other form

28.Question :
-------------
What happens to the form when u register

Answers:
--------
Registration of Form in Oracle Apps indicates that the form can be accessed from Oracle Application Responsibility. For that you have define the following.

1. Define the form

2. Define the function

3. Attach the funtion to the Menu

4. Attach the Menu to the responsibility.

29.Question :
-------------
Why is FND CURRENCY used in reports

Answers:
--------
FND_CURRENCY is basic foundation class used to format currency.
Ex. 1234556
By using above we can print it as
12,34,556

30.Question :
-------------
What is descriptive flex field and what is the use of them?

What is the procedure for useing the.

Answers:
-------
Descriptive Flexfileds r used to add additional informations.and these values r stored to the column attributes.

go to sysadmin application-flexfields-descriptive-segments

31.Question :
-------------
What are APIs? Can you name a few APIs?

Answers:
-------
In Addition to Following :

In ALL_OBJECTS Query for OBJECT_TYPE = 'PACKAGE'

%PUB Are Public API's, in Short wrapper Over %PKG APIs.

API's are nothing but the interface prgrams which are used to import data from external systems to our apps tables.
eg:lock box,Auto invoice,Sales rep
etc
Difference between conversions and interfaces is conversion is one time process whereas interfaces are daily process.

32.Question :
-------------
What are _ALL tables in Oracle Apps?

Answers:
--------
_ALL tables in oracle applications gives the info about Multiple organizations info about these tables.

Cheers,

THIS TABLE GIVES INFORMATION ABOUT OPERATING UNIT

&

ALL tables in oracle applications gives the info about Multiple organizations info about these tables.

33.Question :
-------------
What is invoicing rule?

Answers:
--------
Invoicing Rule determine when to recognise the receivable for transactions. There are 2 types invoicing rules:Bill in arrears and Bill in advance. Bill in Arrears recognise receivables at the end of the revenue recognistion schedule. Bill in advance recognise receivables as soon as invoice generated. 

Use invoicing rules to determine when to recognize your receivable for invoices that span more than one accounting period. You can only assign one invoicing rule to an invoice.
Receivables provides the following invoicing rules:
1) Bill In Advance: Use this rule to recognize your receivable immediately.
2) Bill In Arrears: Use this rule if you want to record the receivable at the end of the revenue recognition schedule.

34.Question :
-------------
What is accounting rule?

Answers:
--------
Accounting rules detrmine the period in which the revenues were genereated against the transactions. Rules that Receivables AutoInvoice uses to specify revenue recognition schedules for your transactions. You can define an accounting rule where revenue is recognized over a fixed or variable period of time. 

35.Question :
-------------
How to find overdue invoices?

Answers:
--------
Use Past Due Invoice Report. 

36.Question :
-------------
What is set of books?

Answers:
--------
It is similar to the bank passbook, used to record all the financial transactions. There could be one primary set of books and many reporting set of books. Defining COA, currency and calender are pre-requisite to define the SOB.

37.Question :
-------------
What is the link between CM & invoice?

Answers:
--------
The Parent_invoice_id column of the ap_invoice_distributions_all will give you the main invoice# to which this CM/DM has been matched to.

38.Question :
-------------
What Credit memo / Debit Memo?

Answers:
--------
If the original transactions are posted into GL, then the transactions can not be modified in the respective sub-ledgers. If you want to modify the account balances for some reasons, then you have to enter the debit memo or credit memo to adjust the account balances previously entered.

39.Question :
-------------
How AR & OE are related?

Answers:
--------
OE (Order Entry): Once order and shipped to the customer and invoice is sent to the customer. Once the payment for the Invoice is received the information is entered in Oracle Receivables. 

40.Question :
-------------
What is "Finance Charge"?

Answers:
--------
Additional charges that you assign to customers for past due items.Finance charges can be included on your customer?s statements and dunning letters. 

41.Question :
-------------
What is address validation?

Answers:
--------
The type of validation you want the system to use for your address, if you are not using a flexible address format for validation. You can implement address validation at three levels: Error, No Validation, or Warning. 'Error' ensures that all locations exist for your address before it can be saved. 'Warning' displays a warning message if a tax rate does not exist for this address (allows you to save the record). 'No Validation' does not validate the address 

42.Question :
-------------
What is lockbox?

Answers:
--------
lockbox is a services provided by bank to corporate customers to transfers there payables in receviables, so that they can update their balances. here all the cheque or payments are collect by bank and send a dat file to there corporate so that they can directly transfer that file through interface in their modules (ap,ar) 

43.Question :
-------------
What are charge backs?

Answers:
--------
The process of taking back, or debiting, the merchant's credit card funds after the funds have been paid to the merchant. This occurs when a customer disputes a credit card transaction. The merchant must respond to the charge back and provide proof that the product or service was provided to the customer. 

44.Question :
-------------
What all things are stored in RA_CUSTOMER_TRX?

Answers:
--------
The header information about transactions are stored in this view(RA_CUSTOMER_TRX_ALLtable). The RA_CUSTOMER_TRX_ALL table stores invoice, debit memo, commitment, bills receivable, and credit memo header information. Each row in this table includes general invoice information such as customer, transaction type, and printing instructions. One row exists for each invoice, debit memo, commitment, bill receivable, and credit memo that you create in Oracle Receivables. Invoices, debit memos, credit memos, bills receivable, and commitments are distinguished by their associated transaction types, which are stored in the RA_CUST_TRX_TYPES_ALL table. 

45.Question :
-------------
What is customer merging?

Answers:
--------
Customer merging is the process to avoide duplicate bill to and ship to addresses 

46.Question :
-------------
Can you have two accounting Flexfields in AR?

Answers:
--------
No. You cannot have more than one Accounting Flexfields for a Set of Books in AR. Accounting Flexfield defines a Chart of Accounts. Having 2 different Accounting Flexfield structure implies that they should correspong to 2 different SoB's because if any of the 3 C's chage (Currency, Chart of Accounts and Currency), SoB differs. One can have >1 Accounting flexfield if he has >1 SoB created. 

47.Question :
-------------
What is cost center segment?

Answers:
--------
It is one of the segment in the accounting flexfield. It is not necessary that this segment should always be there in the accounting flexfield, but most of the companies include this segment in the accounting flexfield to post the assets and expenses costcenter wise and get the report accordingly.

48.Question :
-------------
What is balancing segment?

Answers:
--------
Balancing segment is the level for balancing the accounting entries. For example, the accounting flexfield structure is company-costcenter-project. If you define the balancing segment as company, then both debit and credit should be balanced at the company level when the transactions are posted to GL.

49.Question :
-------------
After which stage can not cancel the order

Answers:
--------
Yes Once the Order is Booked We cannot Cancel the order.

When the order is in Entered Status we can change whatever information we wish to.

You can not cancel the order after ship confirm. You can cancel the order until that point.

50.Question :
-------------
What is pick release

Answers:
--------
Pick release is the process by which the items on the sales order are taken out from inventory. The flow is as follows:
1) When an order is booked, based on the setups, the lines are scheduled and they are ready to release. This means the inventory is informed that there is requirement of certain quantity of certain items on certain date.
2) The inventory person ,according to availability allocates the items to those SO Lines and reserves them. 3) Then on the day of delivery or somewhere between these items are taken out of inventory and moved to staging subinventory. This means that the items are now ready for shipping and are out of inventory.
When the items reach staging subinventory, they are said to be picked and shipping execution can now ship these items.

51.Question :
-------------
What is dunning letter?

Answers:
--------
It is an over due letter to the customer which talks about customer over due amount and due date.

52.Question :
-------------
List the key flexfields in AR?

Answers:
--------
There are 2 Kff's are there in AR1.Sales Tax Location FF-this is a mandatory one to implement2.Territory- its an optional one.

There are 3 KFF in AR.
1.ARTA Receipt prof ident.
2.Sales Tax Location Flexfield.
3.Territory Flexfield.

53.Question :
-------------
What is auto invoice?

Answers:
--------
It is a program that imports invoices,credit memos, debit memos, on account credits from other system to Receivables.

54.Question :
-------------
what is auto invioce in OM module?what is use of it?

Answers:
--------
An auto invoice program in OM module is a concurrent program to generate transactions or invoices in receivables for all the shippped orders.

55.Question :
-------------
Give the complete process cycle for OE / AR

Answers:
--------
Order EnteredOrder BookedDispatch EligibleDispatchedPick Release EligiblePick ReleasedShip ConfirmInvoicedPosted in GL

order entered > order booked > pick release > ship confirm > Run WBP (must be successful)>invoiced (either manually or auto invoiced)>receive transaction > transfer account to GL > post.

56.Question :
-------------
Name important tables from OE /AR

Answers:
--------
Tables for OM: 1> oe_order_headers_all

2> oe_order_lines_all

57.Question :
-------------
What is order cycle

Answers:
--------
The order cycle is as follows:

Order entry
Book the order
Schedule the order
Pick release
Ship confirm
Close the order

Question :
----------
After which stage can not cancel the order

Answers:
-------
Yes Once the Order is Booked We cannot Cancel the order.

When the order is in Entered Status we can change whatever information we wish to.

You can not cancel the order after ship confirm. You can cancel the order until that point.

be happy and make others to be happy

Infolinks

Wednesday 16 May 2012

Oracle Apps Basics Interview Questions & Answers

Oracle Apps Basics Interview Questions & Answers

================================================

No comments:

Post a Comment