Infolinks

Sunday 13 May 2012

AR Interview Questions & Answers



                                             AR Interview Questions & Answers
                                             ================================

1.Question :
------------
What is the importance of Batch Source set up in AR ?

Answers:
--------
Batch sources control the standard transaction type assigned to a transaction and determine whether Receivables automatically numbers your transactions and transaction batches. You can define two types of transaction batch sources:
Manual
Imported

2.Question :
------------
What do you mean by HZ_ in customer tables?

Answers:
--------
All tables that starts with HZ_ are related to the Trading Community Architechture (TCA). In these table we can find all the information about the Customers, Organization, Person's.
From release 11i TCA came into picture in Accounts Recievable module, where oracle has grouped all the customer information at one place. Most important tables in TCA are HZ_PARTIES, HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_CONTACT_POINTS. few to name.

3.Question :
------------
What is the difference between _all, _tl, _vl, _v tables in Oracle Apps ?

Answers:
--------
_all : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.

_TL : Translation Tables. where we can find the name of the particular field we are referring to. All _TL tables has a unique ID which corresponds the foreign key to other table which is used to store in the database and referenced back to display the name.

_V: are views.

_vl table stores the MultiLingual views

4.Question :
------------
How many Flex fields are there in AR and what are they?

Answers:
--------
There are 3 flix fields are there

1.arta flexfield

2.salestax flexfileld

3.territory flexfield

5.Question :
------------
What is FSG and what is its use?

Answers:
--------
Financial Statment Generation (FSG), we can create different financial statement and we will get finacial reports.


It is a powerful tool or utility provided by oracle corporation using which we can prepare financial reports like profit&loss ac , balance sheet ac etc without any programing or coding .using simple sets like rows, columns

6.Question :
------------
What is the difference between conversions and interfaces ?

Answers:
--------
Conversion is a process by which we transfer legacy data from temporary tables to base tables.
Interfaces also does the same but is a daily process and most of the interfaces are automated by scheduling. Example:AutoInvoice

7.Question :
------------
How many reporting currencies can be attached to Primary Set of Books?

Answers:
--------
For a given currency or primary SOB we can define maximum of 8 reporting SOBs


8.Question :
------------
Describe the main tables involved in AR, and what is the data stored in them

Answers:
--------
RA_BATCHES_ALL
- INFORMATION ABOUT TRANSACTION BATCHES
RA_CUSTOMER_TRX_ALL
- HEADER INFORMATION ABOUT TRANSACTION
RA_CUSTOMER_TRX_LINES_ALL
- LINES INFORMATION ABOUT TRANSACTION
RA_CUST_TRX_LINE_GL_DIST_ALL
- DISTRIBUTION INFORMATION ABOUT TRANSACTIONS
RA_CUST_TRX_LINE_SALESREPS_ALL
- SALES REPS OF TRANSACTIONS INFORMATION
AR_PAYMENT_SCHDULES_ALL
- INFORMATION ABOUT PAYMENT SCHDULES
AR_APPLICATION_PAYABLES_ALL
RA_INTERFACE_ERRORS
- ERRORS IN AUTO INVOCIE INTERFACE DATA
RA_INTERFACE_LINES_ALL
- USE THIS TABLE TO ENTER HEADER AND LINES INFORMATION IN AUTO INVOICE INTERFACE PROGRAM
RA_INTERFACE_DISTRIBUTIONS_ALL
- DISTRIBUTION TABLE IN AUTO INVOICE INTERFACE PROGRAM
RA_INTERFACE_SALESCREDITS_ALL
- SALESCREDITS INFORMATION TABLE IN AUTO INVOICE INTERFACE PROGRAM

9.Question :
------------
Explain Accounting for invoice in Advance and Arrears.

Answers:
--------
Accointing for invoice in advance

a) Receivable A/c .....................Dr.

To Unearned revenue a/c

(when we raise the invoice with invoicing rule as advance)



b) Unearned Revenue A/c .............. Dr.

To Revenue A/c

(when we receive the payment, the number of journal entry (b) is depend upon the accounting rules which can be fixed or variable)



Accounting for invoice in arrear

a) Unbilled receivable a/c ....................Dr.

To Revenue a/c

(when we receive the payment of unbilled invoice, the number of journal entry (a) is depend upon the accounting rules which can be fixed or variable))



b) Receivable a/c .........................Dr.

To Unbilled receivable a/c

(when we raise the invoice, with invoicing rule arrear)

10.Question :
-------------
What is the use of Transaction Flexfield in Autoinvoice ?

Answers:
--------
Transaction Flexfield actually identifies the the uniqueness among the Multiple lines of a single Invoice

11.Question :
-------------
What are value sets?

Answers:
--------
Valuesets r collection of set of Values.

There r six types of value sets available in Oracle Apps.

1) Dependent.

2) Independent.

3) Special.

4) None.

5) Table.

6) Pair.



Valuesets are the sets of valid values that are validate against the flexfields. Valuesets allow you to control the values for a segment or a report parameter. Diffrent Filexfields can share the same valueset. Diffrent segment of the same flexfields can use the same valueset

There r Eight types of value sets available in Oracle Apps.

1) None.
2) Independent.
3) Dependent.
4) Table.
5) Special.
6) Pair.
7) Traslatable Independent
8) Traslatable Dependent

12.Question :
-------------
What are the new features in Release 11I?

Answers:
--------
The main features in Release 11i is

1.Multi Org-To support Multiple organizations.

1.Multi Currency-Defineing the multiple currencies to single organization

2.Multi Lingual-Suporting of multi Languages.

13.Question :
-------------
What is MRC and what is its use?

Answers:
--------
Multiple Reporting Currencies is a unique set of features embedded in Oracle Apps that allows you to maintain and report accounting records at the transaction level in more than one functional currency.

14.Question :
-------------
How is the balance of an invoice derived ?

Answers:
-------
Use application rule set to control how Receivable will reduce the balance due of open debit items when you apply payments.

No comments:

Post a Comment