Below are some important Oracle AR interview questions which are asked in most MNC company interviews for beginners or professionals.
6. What is the difference between _all, _tl, _vl, _v tables in Oracle Apps?
_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
7. How many Flex fields are there in AR and what are they?
There are 3 flix fields are there
1.Arta flexfield
2.Salestax flexfileld
3.Territory flexfield
8. What is FSG and what is its use?
Financial Statment Generation (FSG), we can create different financial statement and we will get finacial reports.
9. What is the difference between conversions and interfaces?
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
10. How many reporting currencies can be attached to Primary Set of Books?
For a given currency or primary SOB we can define maximum of 8 reporting SOBs.
6. What is the difference between _all, _tl, _vl, _v tables in Oracle Apps?
_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
7. How many Flex fields are there in AR and what are they?
There are 3 flix fields are there
1.Arta flexfield
2.Salestax flexfileld
3.Territory flexfield
8. What is FSG and what is its use?
Financial Statment Generation (FSG), we can create different financial statement and we will get finacial reports.
9. What is the difference between conversions and interfaces?
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
10. How many reporting currencies can be attached to Primary Set of Books?
For a given currency or primary SOB we can define maximum of 8 reporting SOBs.
More Questions & Answers :-
No comments:
Post a Comment