Referencing Oracle Fin Doc V 3.1.1
Posted: Thu Sep 20, 2007 7:03 am
<div align="left">Hi,
First of all I must congratulate you for excellent stuff on Oracle
Apps Financials. it is immensly beneficial.
I am a beginner in Oracle ERP (But not new to ERP field). I was
practicing these things mentioned in your boook but have following questions
in GL. Could you pls respond on these and oblige.
1) While creating COA, we have chosen ?001? to be the corporate
Business unit. Is it the right norm? Should not we use ?000? as
Balance Sheet/Corporate Business Unit? If not, then why do we need this ?000?
department in out value for Department Value set?
2) On Pg 29, where Account Segment Values have been shown by
using a template COA, some statistical accounts have also been included
in there like Headcount Etc. Does it make sense to do that? Should not
we have separate COA for statistical accounts? They have also been given
account type as ?Expense? which I fail to understand as these accounts
will not figure in my Profit and Loss account.
3) On Pg 29 COA, why we have not highlighted Control Accounts.
Per my understanding at least AP Creditors and AR Debtors accounts
should have been highlighted as Control Accounts. Pls advice.
4) On Pg 34, an example of data upload is given. I tried to
recreate it but it is not getting through as it is picking incorrect
values in fields where ?dates? should be entered (I mean validity dates for
COA values) ? Attachment.
5) What needs to be done if we want multi level parent child
relationship? For example, if we want to do following roll up grouping ?
Assets ? Fixed Assets ? machineries ? Machinery A etc, what needs to be
done in COA application?
6) On Pg 53 (Document Sequencing), there is a table given which
talks about Levels and Description. I am unable to comprehend that.
How does it work? Why have we entered ?Always Used? below responsibility
column (in the screenshot on Pg 53)? What purpose will it serve? I did
all the settings in the same way as mentioned in the book, but still
getting the error as shown in screenshot on Pg 57 (APP-FND-01702).
7) On Pg 61 (Intercompany setup), there is a small table given
where Field Name and values are given. However, in the very next
screenshot, some other values have been used (Points 1.4 and 1.6
respectively). Do we also have to do the same way or is it a typo?
On Pg 65- unable to comprehend the screenshot for Cross
Validation Rule .What is the main purpose of using a Cross Validation Rule?
9) On Pg 66, short hand aliases, are they used only for Balance
Sheet accounts?
10) On Pg 111 ? Defining Mass Allocation Formula ? I made the
formula in the same way as shown in the manual on Pg 112 but still it does
not validate and throws error ? Zip file attached.
11) What purpose does Step down Allocation Set serves as given on
Pg 114?
12) Topic 17 ? Pg 118 ? Financial Budgeting ? Any document is
there with the help of which I can get more understanding of configuring
and managing Budgeting in Oracle 8.11i? The exercise you have given is
very good and without knowing the main idea/flow of budgeting, this
exercise is actually very difficult to comprehend.
13) On Pg 147 ? Revaluation ? Why do we use Historical Rates as
shown in Pt 3. What purpose do they serve? Also in the example given in
manual, it is being setup only for two accounts ? Capital account and
retained earnings account. Do we set up for other accounts as well? If
yes, for what accounts do we do this?
14) On Pg 148 ? Translation ? Concept and working is not clear. Is
there any other document available on the same? Also in the example
shown in manual, there is no discussion on as to what would be the result
of translation and how would they be analyzed.
15) Pg 151 ? Consolidation Exercise, the example taken uses three
set of books but same value set. Any particular reasons for such
choice? Is it always this way? What other options do we get in practice
generally? How is consolidation different from Translation? What would we
have done had one set of books would have had USD as its functional
currency?
Regards,
Karan
<div align="left"></div id="left"></div id="left">
First of all I must congratulate you for excellent stuff on Oracle
Apps Financials. it is immensly beneficial.
I am a beginner in Oracle ERP (But not new to ERP field). I was
practicing these things mentioned in your boook but have following questions
in GL. Could you pls respond on these and oblige.
1) While creating COA, we have chosen ?001? to be the corporate
Business unit. Is it the right norm? Should not we use ?000? as
Balance Sheet/Corporate Business Unit? If not, then why do we need this ?000?
department in out value for Department Value set?
2) On Pg 29, where Account Segment Values have been shown by
using a template COA, some statistical accounts have also been included
in there like Headcount Etc. Does it make sense to do that? Should not
we have separate COA for statistical accounts? They have also been given
account type as ?Expense? which I fail to understand as these accounts
will not figure in my Profit and Loss account.
3) On Pg 29 COA, why we have not highlighted Control Accounts.
Per my understanding at least AP Creditors and AR Debtors accounts
should have been highlighted as Control Accounts. Pls advice.
4) On Pg 34, an example of data upload is given. I tried to
recreate it but it is not getting through as it is picking incorrect
values in fields where ?dates? should be entered (I mean validity dates for
COA values) ? Attachment.
5) What needs to be done if we want multi level parent child
relationship? For example, if we want to do following roll up grouping ?
Assets ? Fixed Assets ? machineries ? Machinery A etc, what needs to be
done in COA application?
6) On Pg 53 (Document Sequencing), there is a table given which
talks about Levels and Description. I am unable to comprehend that.
How does it work? Why have we entered ?Always Used? below responsibility
column (in the screenshot on Pg 53)? What purpose will it serve? I did
all the settings in the same way as mentioned in the book, but still
getting the error as shown in screenshot on Pg 57 (APP-FND-01702).
7) On Pg 61 (Intercompany setup), there is a small table given
where Field Name and values are given. However, in the very next
screenshot, some other values have been used (Points 1.4 and 1.6
respectively). Do we also have to do the same way or is it a typo?
On Pg 65- unable to comprehend the screenshot for CrossValidation Rule .What is the main purpose of using a Cross Validation Rule?
9) On Pg 66, short hand aliases, are they used only for Balance
Sheet accounts?
10) On Pg 111 ? Defining Mass Allocation Formula ? I made the
formula in the same way as shown in the manual on Pg 112 but still it does
not validate and throws error ? Zip file attached.
11) What purpose does Step down Allocation Set serves as given on
Pg 114?
12) Topic 17 ? Pg 118 ? Financial Budgeting ? Any document is
there with the help of which I can get more understanding of configuring
and managing Budgeting in Oracle 8.11i? The exercise you have given is
very good and without knowing the main idea/flow of budgeting, this
exercise is actually very difficult to comprehend.
13) On Pg 147 ? Revaluation ? Why do we use Historical Rates as
shown in Pt 3. What purpose do they serve? Also in the example given in
manual, it is being setup only for two accounts ? Capital account and
retained earnings account. Do we set up for other accounts as well? If
yes, for what accounts do we do this?
14) On Pg 148 ? Translation ? Concept and working is not clear. Is
there any other document available on the same? Also in the example
shown in manual, there is no discussion on as to what would be the result
of translation and how would they be analyzed.
15) Pg 151 ? Consolidation Exercise, the example taken uses three
set of books but same value set. Any particular reasons for such
choice? Is it always this way? What other options do we get in practice
generally? How is consolidation different from Translation? What would we
have done had one set of books would have had USD as its functional
currency?
Regards,
Karan
<div align="left"></div id="left"></div id="left">