Below are some important Oracle AR interview questions which are asked in most MNC company interviews for beginners or professionals.
1. How is the balance of an invoice derived?
Use application rule set to control how Receivable will reduce the balance due of open debit items when you apply payments.
2. What is MRC and what is its use?
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.
mrc means multiple reporting currency,maximam 8 reporting curriences in possible in oracle apps,generely everyone having one fuctional currency, if u want convert the report into diffent currencies that only possible for eight currencies.
3. Describe the main tables involved in AR, and what is the data stored in them?
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
4. What is the importance of Batch Source set up in AR?
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
5. What do you mean by HZ_ in customer tables?
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.
1. How is the balance of an invoice derived?
Use application rule set to control how Receivable will reduce the balance due of open debit items when you apply payments.
2. What is MRC and what is its use?
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.
mrc means multiple reporting currency,maximam 8 reporting curriences in possible in oracle apps,generely everyone having one fuctional currency, if u want convert the report into diffent currencies that only possible for eight currencies.
3. Describe the main tables involved in AR, and what is the data stored in them?
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
4. What is the importance of Batch Source set up in AR?
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
5. What do you mean by HZ_ in customer tables?
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.
More Questions & Answers :-
No comments:
Post a Comment