Category Archives: Oracle AR Interview Questions

Explain Accounting for invoice in Advance and Arrears? | Oracle AR Questions

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 … Continue reading

Posted in Oracle AR Interview Questions | Leave a comment

What is the use of Transaction Flexfield in Autoinvoice? | Oracle AR Questions

Transaction Flexfield actually identifies the the uniqueness among the Multiple lines of a single Invoice.

Posted in Oracle AR Interview Questions | Leave a comment

What are value sets? | Oracle AR Questions

Valuesets are collection of set of Values: There are six types of value sets available in Oracle Apps. 1) Dependent. 2) Independent. 3) Special. 4) None. 5) Table. 6) Pair.

Posted in Oracle AR Interview Questions | Leave a comment

What are Different types of transactions in AR? | Oracle AR Questions

I know 6 of them in total: 1) Charge back 2) Credit memo 3) Debit memo 4) Invoice 5) Guarantee 6) Deposit

Posted in Oracle AR Interview Questions | Leave a comment

How many reporting currencies can be attached to Primary Set of Books? | Oracle AR Questions

For a given currency or primary SOB we can define maximum of 8 reporting SOBs.

Posted in Oracle AR Interview Questions | Leave a comment

What is the difference between conversions and interfaces? | Oracle AR Questions

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

Posted in Oracle AR Interview Questions | Leave a comment

What is FSG and what is its use? | Oracle AR Questions

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

Posted in Oracle AR Interview Questions | Leave a comment

How many Flex fields are there in AR and what are they? | Oracle AR Questions

There are 3 flix fields are there: 1.Arta flexfield 2.Salestax flexfileld 3.Territory flexfield

Posted in Oracle AR Interview Questions | Leave a comment

What is the difference between _all, _tl, _vl, _v tables in Oracle Apps? | Oracle AR Questions

_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 … Continue reading

Posted in Oracle AR Interview Questions | Leave a comment

What do you mean by HZ_ in customer tables? | Oracle AR Questions

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 … Continue reading

Posted in Oracle AR Interview Questions | Leave a comment