Hi
Some interview questions from net.
1.What is the difference between accounting calander & inventory calander?
2.Explain the Business process?
3.What is Business group ,and draw the multi_org structure?
4.How do you implement multi org in oracle apps and at what level you will set up your set of books in it?
5.What is the difference between multi org set up and single org setup explain it genuinely?
6.When do you define keyflexfield in GL,how many segments you can define in a keyflexfield ,if I want more than 30 segments what will I do?
7.Explain whole inventory process upto GL accounting transactions?
8.How inventory is get connected with purchase order explain?
9.Why should I define an item in the master item table only?
10.Explain purchase order process upto payments?
11.When do you raise the purchase order?
12.What are the prerequisites of supplier setup?
13.What is the difference between supplier bank account & customer bank account?
14.Explain the payables process?elobrately
15.How many payment terms are there in payables?
16.How many payment methods are there in payables?
17.When do you raise the debit memo in the payables module?
18.What will I do if I assign one set of book instead of other set of book in payables?
19.Explain the recivables process? Elobrately
20.How do we segregate debit & credit transactions in Receivables and where we will you do it?
Sridhar
Interview questions from Net
-
sridhar_6735
- Posts: 47
- Joined: Thu Apr 20, 2006 9:59 am
- Location: India
-
ahmadbilal
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
also try it
http://teachmeoracle.com/interview.html
http://teachmeoracle.com/interview.html
-
sridhar_6735
- Posts: 47
- Joined: Thu Apr 20, 2006 9:59 am
- Location: India
1. What responsibility should I use when doing the set up for General Ledger?
Use a seeded responsibility like 'Oracle General Ledger Super User'.
You may also need to use the System Administrator responsibility.
2. What are the pre-requisites required to define a new calendar?
According to your business needs you need to decide the calendar
type required i.e. monthly, weekly or biweekly, the number of periods,
adjusting periods and the maximum number of periods within a fiscal year.
3. What are the pre-requisites required to define a new set of books?
Define a Calendar, Chart of Accounts and enable the functional Currency
for the set of books.
4. Why must I check the calendar definition before assigning to a set of books?
The calendar definition cannot be changed once it is assigned to a
set of books so it is very important to check that the calendar
definition is suitable to the specific business needs, has been defined
correctly without any gaps and that the period type is in accordance
with the business requirements.
5. What General Ledger profile options need to be set up for using
a new set of books with a responsibility.
The profile option GL Set of Books Name.
Once this profile option is set, the profile option GL Set of Books ID
will be populated automatically with the appropriate id.
You may also need to set up other profile options as mentioned in the
Oracle General Ledger User's Guide.
6. Can I define more than one set of books?
Multiple sets of books may be defined within Oracle General Ledger,
however for a given installation of Oracle subledgers you can use
only one set of books (unless you are multi-org).
7. What type of set of books do I need: Primary, Reporting or None?
The Primary and Reporting options are used with the MRC feature of
Oracle Applications. If you are not using MRC then you may choose
'None'
8. Are there any mandatory accounts that are required for the Set of
Books definition?
A valid Retained Earnings account needs to be assigned on the set of
books form. Depending on the other options you may choose, such as
Translation, Suspense Accounting, Encumbrance, etc. you need to enter
valid accounts for those as well.
9. What is Dynamic Insertion? Is it required during setup?
Dynamic insertion is an Accounting Flexfield feature whereby you can
allow users to create new combinations upon entering a flexfield
combination.
For every new flexfield combination entered, a unique code combination
id is also created which is used to enter and retrieve data.
You may enable or disable this Accounting Flexfield feature at any time,
on the Key Segments form.
10. Do I need Cross Validation rules set up before entering journals in
General Ledger?
If you plan to restrict certain accounts to be used only with certain
company or cost centers then you have to plan on this and define cross
validation rules before the code combination id is created.
Once the code combination id is created, new cross validation rules
will not restrict the account's usage.
11. Do I need to turn Suspense posting on?
It is not mandatory but if suspense posting is checked, a valid suspense
account must be entered in the set of books form. It is used to balance
journal entries for which the entered amounts are out of balance.
12. Is there an automated tool to load the account segment values
in Oracle General Ledger?
No, the values have to be entered using the Segment Values form in
Oracle General Ledger.
(N) Setup > Financials > Flexfields > Key > Values
References
Oracle General Ledger User Guide
13. Do I need to set up Journal Approval?
It can be set up at any time and is not a mandatory step for completing
the General Ledger setup.
14. What does the check box Balance Intercompany mean on the set of books form?
If journals are created for different balancing segment values, the
journal must be balanced by balancing segment value (debits must equal
credits for a particular balancing segment value). Checking this option
on the set of books form will allow GL to balance these journals by using
the default intercompany accounts set up in Oracle General Ledger.
If it is not checked, the journal must be balanced (by balancing segment
value) before it is imported or posted.
15. Is there any setup at the journal source level to view subledger data in GL?
Check the option 'Import Journal Reference' for each journal source/category
combination for which you wish to transfer the subledger reference data
from the subledgers during the Journal Import process.
Please note that the following may also have to be verified to view subledger
data in GL:
1. Subledger setup.
2. The parameters for the transfer process from the subledgers.
3. Journal import process parameters.
16. What is the option Rounding Differences Account in the Set of Books form?
When transactions are entered in foreign currencies the conversion to
the functional currency may cause rounding differences.
The Rounding Differences account is used to balance any journal entry
for which the converted amounts are out of balance.
When this option is checked, a valid account combination must be
defined to track the rounding differences.
17. Is there any additional maintenannce for Sources and Categories in General
Ledger after these items are initially setup?
Once General Ledger Sources and Categories are setup, there is no additional
maintenance.
18. Is there a script to check each ORG_ID and the associated setting?
The organization ids are stored in HR_ALL_ORGANIZATION_UNITS table.
SELECT distinct (organization_id), (name)
FROM hr_all_organization_units;
19. How to review GL: Set of Books rofile options at all levels ?
Responsibility = System Administrator
Navigation = Profile/System
Use a seeded responsibility like 'Oracle General Ledger Super User'.
You may also need to use the System Administrator responsibility.
2. What are the pre-requisites required to define a new calendar?
According to your business needs you need to decide the calendar
type required i.e. monthly, weekly or biweekly, the number of periods,
adjusting periods and the maximum number of periods within a fiscal year.
3. What are the pre-requisites required to define a new set of books?
Define a Calendar, Chart of Accounts and enable the functional Currency
for the set of books.
4. Why must I check the calendar definition before assigning to a set of books?
The calendar definition cannot be changed once it is assigned to a
set of books so it is very important to check that the calendar
definition is suitable to the specific business needs, has been defined
correctly without any gaps and that the period type is in accordance
with the business requirements.
5. What General Ledger profile options need to be set up for using
a new set of books with a responsibility.
The profile option GL Set of Books Name.
Once this profile option is set, the profile option GL Set of Books ID
will be populated automatically with the appropriate id.
You may also need to set up other profile options as mentioned in the
Oracle General Ledger User's Guide.
6. Can I define more than one set of books?
Multiple sets of books may be defined within Oracle General Ledger,
however for a given installation of Oracle subledgers you can use
only one set of books (unless you are multi-org).
7. What type of set of books do I need: Primary, Reporting or None?
The Primary and Reporting options are used with the MRC feature of
Oracle Applications. If you are not using MRC then you may choose
'None'
8. Are there any mandatory accounts that are required for the Set of
Books definition?
A valid Retained Earnings account needs to be assigned on the set of
books form. Depending on the other options you may choose, such as
Translation, Suspense Accounting, Encumbrance, etc. you need to enter
valid accounts for those as well.
9. What is Dynamic Insertion? Is it required during setup?
Dynamic insertion is an Accounting Flexfield feature whereby you can
allow users to create new combinations upon entering a flexfield
combination.
For every new flexfield combination entered, a unique code combination
id is also created which is used to enter and retrieve data.
You may enable or disable this Accounting Flexfield feature at any time,
on the Key Segments form.
10. Do I need Cross Validation rules set up before entering journals in
General Ledger?
If you plan to restrict certain accounts to be used only with certain
company or cost centers then you have to plan on this and define cross
validation rules before the code combination id is created.
Once the code combination id is created, new cross validation rules
will not restrict the account's usage.
11. Do I need to turn Suspense posting on?
It is not mandatory but if suspense posting is checked, a valid suspense
account must be entered in the set of books form. It is used to balance
journal entries for which the entered amounts are out of balance.
12. Is there an automated tool to load the account segment values
in Oracle General Ledger?
No, the values have to be entered using the Segment Values form in
Oracle General Ledger.
(N) Setup > Financials > Flexfields > Key > Values
References
Oracle General Ledger User Guide
13. Do I need to set up Journal Approval?
It can be set up at any time and is not a mandatory step for completing
the General Ledger setup.
14. What does the check box Balance Intercompany mean on the set of books form?
If journals are created for different balancing segment values, the
journal must be balanced by balancing segment value (debits must equal
credits for a particular balancing segment value). Checking this option
on the set of books form will allow GL to balance these journals by using
the default intercompany accounts set up in Oracle General Ledger.
If it is not checked, the journal must be balanced (by balancing segment
value) before it is imported or posted.
15. Is there any setup at the journal source level to view subledger data in GL?
Check the option 'Import Journal Reference' for each journal source/category
combination for which you wish to transfer the subledger reference data
from the subledgers during the Journal Import process.
Please note that the following may also have to be verified to view subledger
data in GL:
1. Subledger setup.
2. The parameters for the transfer process from the subledgers.
3. Journal import process parameters.
16. What is the option Rounding Differences Account in the Set of Books form?
When transactions are entered in foreign currencies the conversion to
the functional currency may cause rounding differences.
The Rounding Differences account is used to balance any journal entry
for which the converted amounts are out of balance.
When this option is checked, a valid account combination must be
defined to track the rounding differences.
17. Is there any additional maintenannce for Sources and Categories in General
Ledger after these items are initially setup?
Once General Ledger Sources and Categories are setup, there is no additional
maintenance.
18. Is there a script to check each ORG_ID and the associated setting?
The organization ids are stored in HR_ALL_ORGANIZATION_UNITS table.
SELECT distinct (organization_id), (name)
FROM hr_all_organization_units;
19. How to review GL: Set of Books rofile options at all levels ?
Responsibility = System Administrator
Navigation = Profile/System
sreedhar pls send me some faq and ans in finance modules
pls this faq in needful for me
iam starting number and looking for job as a functional cosultent
pls sreedhar and what in full cycle implimenation and supporting roles
and what type of documents using for implimantation
advance thanks
khan
khan003.apps@gmail.com
pls this faq in needful for me
iam starting number and looking for job as a functional cosultent
pls sreedhar and what in full cycle implimenation and supporting roles
and what type of documents using for implimantation
advance thanks
khan
khan003.apps@gmail.com
Who is online
Users browsing this forum: No registered users and 13 guests