Oracle Apps GL Interview Questions
1. Will STAT currency numbers aggregate when calculating YTD information,
1. Will STAT currency numbers aggregate when calculating YTD information,
actual and/or budget?
2. How are the PTD, QTD and YTD balances I see on reports and forms calculated?
3. When I post transactions to a particular period, I see rows created in
GL_BALANCES for that period, and subsequent periods also. Why?
4. How to roll back all actual account balances to a particular accounting period for
a specific set of books?
5. How to roll back encumbrance budget balances based on the encumbrance_type_id
for a particular accounting period for a specific set of books?
6. What is stored in the quarter_to_date_dr and quarter_to_date_cr columns in the
gl_balances table?
7. Where can I find clarifying information on Journal Types and Average Balance
Processing?
8. How do I correct situation(s) where the number of updated GL_BALANCES rows
does not equal the number or rows in GL_POSTING_INTERIM_XXXXX table?
9. Will misclassified accounts affect account balances. If so,
how can this be fixed?
10. Can the Average Balance feature be restricted to a specific range of
accounts?
11. Can average balance transactions be archived and purged?
12. Can duplicate journals be created from the Enter Journals and Post
Journals forms which may result in overstated balances during Account Inquiry?
QUESTIONS & ANSWERS:
====================
1. Will STAT currency numbers aggregate when calculating YTD information,
actual and/or budget?
Answer
======
Yes, they roll forward just like other currencies.
2. How are the PTD, QTD and YTD balances I see on reports and forms calculated?
Answer
======
The PTD balance for a period is the activity that has occurred in that period.
It does not contain the activity of previous or subsequent periods.
QTD balance for a period is the activity that has occurred in that period and
all of the periods before it that are in the same quarter. It does not
contain the activity of periods in previous quarters or the activity of
subsequent quarters.
For actuals, the meaning of YTD balance for a period depends upon the type of
account. For balance sheet accounts, the YTD balance for a period is the total
activity for that period and all of the periods before it, regardless of what
fiscal year they are in. For income statements accounts, the YTD balance for
a period is the activity that has occurred in that period and all of the
periods before it that are in the same fiscal year.
Income statement balances are moved to a special owner's equity account at the
beginning of the year, i.e. the retained earnings account.
3. When I post transactions to a particular period, I see rows created in
GL_BALANCES for that period, and subsequent periods also. Why?
Answer
======
When Posting runs, it will insert or update rows in GL_BALANCES for the period
and accounts you are posting to. It will also insert or update rows in
GL_BALANCES for every subsequent period for those accounts, for every period
that has ever been opened. If there was no prior balance for the period and
account, a row is inserted into GL_BALANCES.
4. How to roll back all actual account balances to a particular accounting period for
a specific set of books?
Answer
======
Please contact Oracle Support for assistance with this.
5. How to roll back encumbrance budget balances based on the encumbrance_type_id
for a particular accounting period for a specific set of books?
Answer
======
Please log a tar or service request with Oracle support.
6. What is stored in the quarter_to_date_dr and quarter_to_date_cr columns in the
gl_balances table?
When you look at the gl_balances table for a particular account it looks like this:
1st quarter = Jul, Aug Sept.
GL_BALANCES
July $50 invoice posted PTD $50dr QTD = $0
Aug no posting PTD $0 QTD = $50dr
Sept $1,000 invoice posted PTD $1,000 QTD = $50dr
Answer
======
The quarter_to_date_dr and quarter_to_date_cr columns in gl_balances do not
contain the activity for the current period, they only contain the activity for
previous periods.
To get the true QTD DR balance,you must add quarter_to_date_dr to period_net_dr.
7. Where can I find clarifying information on Journal Types and Average Balance
Processing?
Answer
======
Please refer to Note 1072012.6 for more information.
8. How do I correct situation(s) where the number of updated GL_BALANCES rows
does not equal the number or rows in GL_POSTING_INTERIM_XXXXX table?
Answer
======
Please contact Oracle Support for assistance.
Refer to Note:137413.1 - Balance troubleshooting guide
for general information regarding posting failure.
9. Will misclassified accounts affect account balances. If so,
how can this be fixed?
Answer
======
Yes, misclassified accounts will definately affect you account balances.
Refer to the Misclassified Accounts FAQ, Note 136260.1.
10. Can the Average Balance feature be restricted to a specific range of
accounts?
Answer
======
No, if you want to use average balance processing in General Ledger, you
must enable
the functionality for a specific set of books. Once enabled, the Enable
Average Balances
checkbox is protected against update.
11. Can average balance transactions be archived and purged?
Answer
======
Sure. In fact, when you use average balancing processing, a large volume of
data accumulates
in your General Ledger database (GL_DAILY_BALANCES table). You can archive
and purge
any information you no longer need. General Ledger also provides some
related safety and security
features. For example, the system: 1.) Produces reports you can review to
verify that your
archiving and purging processes complete successfully, 2.) Ensures that only
archived data can be
purged.
12. Can duplicate journals be created from the Enter Journals and Post
Journals forms which may result in overstated balances during Account Inquiry?
Answer
======
No, not any longer! The AutoPost program has been modified so that now the
Enter Journals form and the Posting form can detect when a batch has been
submitted for posting by AutoPost and the posting request has not yet completed.
The following patches are required. These patches are available through
Metalink:
Release Patch
10.7 2525393
11.0 2487959
11.5 252539
Note:177596.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
Oracle General Ledger Setup - FAQ
|
Creation Date:
|
25-FEB-2002
|
Type:
|
FAQ
|
Last Revision Date:
|
15-JUL-2004
|
Status:
|
PUBLISHED
|
When investigating problems in this area the solution is often in the relevant
White Paper which also provides a useful insight into the Topic. Please refer to
the White Paper Enabling Secondary Tracking Segment for an Existing Set of Books
at Note:261961.1 and Variable Format Reports at Note:225818.1.
General Ledger Setup - FAQ
--------------------------
FREQUENTLY ASKED QUESTIONS
--------------------------
July 2003
1. What responsibility should I use when doing the set up for General Ledger?
2. What are the pre-requisites required to define a new calendar?
3. What are the pre-requisites required to define a new set of books?
4. Why must I check the calendar definition before assigning it to a set
of books?
5. What General Ledger profile options need to be set up?
6. Can I define more than one set of books?
7. What type of set of books do I need: Primary, Reporting or None?
8. Are there any mandatory accounts that are required for the Set of
Books definition?
9. What is Dynamic Insertion? Is it required during setup?
10. Do I need Cross Validation rules set up before entering journals in
General Ledger?
11. Do I need to turn Suspense posting on?
12. Is there an automated tool to load the account segment values
in Oracle General Ledger?
13. Do I need to set up Journal Approval?
14. What does the check box Balance Intercompany mean on the set of books form?
15. Is there any setup at the journal source level to view subledger data in GL?
16. What is the option Rounding Differences Account in the Set of Books form?
17. Is there any additional maintenance for Sources and Categories in General
Ledger after these items are initially setup?
18. Is there a script to check each ORG_ID and the associated setting?
19. How to review GL: Set of Books profile options at all levels?
20. Can I change the functional currency for an existing set of books?
QUESTIONS & ANSWERS
-------------------
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
1. Check the desired display boxes: Site, Application, Responsibility and User
2. In the Profile field, enter GL Set of Books% and click on the
[Find] button.
20. Can I change the functional currency for an existing set of books?
It is neither recommended nor supported to change the currency of a
Set of Books that is currently in use.
.
Note:134362.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
General Ledger Calendar FAQ
|
Creation Date:
|
05-FEB-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
02-AUG-2004
|
Status:
|
PUBLISHED
|
When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White
Paper General Ledger Calendar Setup and Usage at Note:130539.1.
PURPOSE
-------
To aid users and support analysts in problem resolution.
SCOPE & APPLICATION
-------------------
External users and internal support analysts.
FREQUENTLY ASKED QUESTIONS
--------------------------
November 2003
CONTENTS
--------
1. You want to change the period dates because of a change in business
needs or a mistake was made when it was set up. How can you fix this?
2. Can I add an adjusting period to my calendar?
3. You defined a Period Type and now have decided that you want
to change the periods per year that are associated with the Period Type.
How can you do this?
4. What are the year types 'Fiscal' and 'Calendar' used for ?
5. You are setting up a new set of books and a calendar and are not
sure how much of the first year you need to define in the calendar.
Do you need to define an entire year for the first year in your
calendar if you are only going to open the last period in that year?
6. Your calendar year is changing from a fiscal year to a calendar
year, and you already have a set of books that is using the fiscal year
calendar. How can you change your calendar in GL?
7. You opened a period by mistake and want to set the status back to
Future Enterable. How can you do this?
8. The year was specified incorrectly on your calendar periods. How can
you fix this?
9. The Year Type in your Period Types form is not what you want.
You used Fiscal instead of Calendar or visa versa. Can it be changed?
10. Can you change a period name after the calendar is defined?
11. What is the function of GL_DATE_PERIOD_MAP table and how is it populated?
QUESTIONS & ANSWERS
-------------------
1. You want to change the period dates because of a change in business
needs or a mistake was made when it was set up. How can you fix this?
Answer: You can change a period's specifications, except for the period
type, as long as the period has not been used in a set of books.
You cannot change a calendar period that is open, closed, future
enterable, or permanently closed in any set of books, or is
included in an open budget or encumbrance year.
If it is difficult to use the periods as is, the best solution is to
create a new set of books that uses a new calendar with the correct
period dates. You can run Consolidation to move the General Ledger
balances from the old set of books to the new set of books. For step
by step instructions on the Consolidation process, refer to the
Oracle General Ledger User's Guides.
This may also mean that you need to re-install your subledgers so they
will use the new set of books. To avoid this see NOTE:157642.1
References: Note 76503.1 - Scripts to check calendar setup
2. Can I add an adjusting period to my calendar?
Answer: You can only define the number of periods that is specified by
the Period Type you are using for your set of books. For example,
if, for your set of books, you are using a Period Type of Month,
and Month is defined to have 12 periods per year, you can only
define 12 periods of Period Type Month for any one year, on the
Calendar form.
3. You defined a Period Type and now have decided that you want
to change the periods per year that are associated with the Period Type.
How can you do this?
Answer: Once you define a Period Type and save it, you cannot change it.
If you need to change the number of periods then you have to define
a new Period Type and a new Set of Books to use that new Period Type.
4. What are the year types 'Fiscal' and 'Calendar' used for?
Answer: The Year Type (Fiscal or Calendar), is used only to determine which
two digits to append to the system generated period name.
Regardless of which Year Type is used, the 'Year' entered on the
Calendar form must be the same for all periods in your fiscal year -
whether it is a calendar year or a fiscal year.
If Year Type = Calendar:
The last 2 digits of the 'From' date for the period are used.
If Year Type = Fiscal:
The last 2 digits of the value in the 'Year' are used.
References: Note 134362.1
5. You are setting up a new set of books and a calendar and are not
sure how much of the first year you need to define in the calendar.
Do you need to define an entire year for the first year in your
calendar if you are only going to open the last period in that year?
Answer: No, you do not have to define the entire year. You only define
the periods you need, but of course without gaps between periods.
Remember to define one prior period if you will be translating.
Example: You want to start entering transactions for
January 2001, but you will be doing translations for January
2001 also, then you will need to define and open a period before
that. In this example, December 2000.
References: General Ledger User's Guide
6. Your calendar year is changing from a fiscal year to a calendar
year, and you already have a set of books that is using the fiscal year
calendar. How can you change your calendar in GL?
Answer: There are 2 possible solutions. See Note 102460.1 for a full
explanation.
Example:
- Your current fiscal year runs from April 1 through March 31.
- Your new year will run from January 1 through December 31.
- You will transition to the new year beginning on January 1 of
the next year, so you will have a short year from April 1
through December 31.
1) Create a new calendar and set of books
--------------------------------------
Create a new calendar, with the correct periods, and define
a new set of books that uses that calendar. Run Consolidation
to move your balances from the existing set of books to the
new set of books.
You may also need to re-install your subledgers so they will
use the new set of books.
OR
2) Update the existing calendar
----------------------------
a) Define the periods for your short year (April through December).
You must define the number of periods that are expected for
the Period Type you are using. In this example, it is 12.
So you will need to define 9 regular periods, and 3 adjusting
periods. The Year must be defined as the next sequential year.
b) Define the periods for the next year. This is the first year
that runs from January through December. The Year must be
defined as the next sequential year.
References: Note 102460.1 - How to change GL Calendar from a Fiscal to
a Calendar year?
7. You opened a period by mistake and want to set the status back to
Future Enterable. How can you do this?
Answer: This is NOT supported. You can not set a period status
back to future enterable after it has already been opened.
If you do, it will cause corruption in the gl_balances table.
8. The year was specified incorrectly on your calendar periods. How can
you fix this?
Answer: You cannot make changes to calendar periods in the form if the
period is in an open budget year, open encumbrance year, or the
status is Open, Future Enterable or Closed. The solution is to
create a new set of books that uses a new calendar with the correct
period dates. You can run Consolidation to move the General Ledger
data from the old set of books to the new set of books. For step
by step instructions on the Consolidation process, refer to the
Oracle General Ledger User's Guides.
This may also mean that you need to re-install your subledgers so they
will use the new set of books.
9. The Year Type in your Period Types Form is not what you want.
You used Fiscal instead of Calendar or visa versa.
Answer: The Year Type (Fiscal or Calendar), is used only to determine which
two digits to append to the system generated period name.
References: Note 1013624.102 - What are the year types 'Fiscal' and
'Calendar' used for?
10. Can you change a period name after the calendar is defined?
Answer: If the Calendar form lets you make the change, you can do it.
Otherwise, it means the period is in use, and you can not make
the change.
11. What is the function of GL_DATE_PERIOD_MAP table and how is it populated?
Answer: The GL_DATE_PERIOD_MAP table stores the correlation between dates
and non-adjusting periods for each accounting calendar and period
type combination. There is always a one-to-one correspondence between
dates and non-adjusting periods since your accounting calendar must not
have any gap or overlap between non-adjusting periods.
.
Note:138143.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
Segment Security Rules FAQ
|
Creation Date:
|
28-MAR-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
08-AUG-2004
|
Status:
|
PUBLISHED
|
ORACLE GENERAL LEDGER
------------------------------
SEGMENT SECURITY RULES
----------------------
FREQUENTLY ASKED QUESTIONS
--------------------------
June 2004
CONTENTS
--------
1. I have defined a security rule and assigned it to my responsibilty,
but is still does not work, why?
2. My security rules don't work for the Account Analysis and General
Ledger reports in Release 11.0.3.
3. In Release 11i with the intercompany segment being used, is it possible
to have a security rule on the balancing segment (company) without it
affecting the intercompany segment, since they share the same value
set?
4. Is there a way to assign different security rules to a responsibility
based on the User ID?
5. Can security rules be used to control the posting of journal entries?
6. Security rules don't seem to work on all forms when performing
a query.
7. Can Security Rules prevent users in one organization, in the same set of
books from adding Cross Validation Rules to another organization?
8. Every Country has a Global Manager or User Responsibility to access Global
SOB but it is supposed to limit users to their own Legal Entities. However,
an Argentian journal can be posted by the Chilian user. How is this possible?
9. Forgot to check the security enabled flag for each segment and it is not
updatable. How do I correct this?
10. In General Ledger,a security rule of a parent with children, was setup
to include the parent and assigned to a responsibility however, it is
not functioning properly.
11. Is it feasible to delete an Exclude statement in order to resolve a Security Rule
issue?
12. What standard reports have security enabled in Release 11i?
13. Is it recommended to use a universal Include when setting up rules?
14. What functions do security rules apply to?
15. What is Hierarchical Security?
QUESTIONS & ANSWERS
-------------------
1. I have defined a security rule and assigned it to my responsibilty,
but is still does not work, why?
Answer
--------
Make sure that you have enabled security at both the segemnt and
value set levels, it must be enabled at both these levels to work.
Also make sure you have switched out and back into the
responsibility.
2. My security rules don't work for the Account Analysis and General
Ledger reports in Release 11.0.3.
Answer
--------
This functionality is available starting in Release 11i. In Releases 11 and
lower, one cannot set security for standard reports. Security Rules will
only limit users from a few functions (e.g. Account Inquiry, Budgets,
Journal Entries, and FSGs). In addition,in Release 11i there is limited
use of the security rule functionality for running standard reports.
It appears that you're the goal to restrict users from submitting reports for a particular company cannot be accomplished using security rules.
3. In Rel 11i with the intercompany segment being used, is it possible
to have a security rule on the balancing segment (company) without it
affecting the intercompany segment, since they share the same value
set?
Answer
--------
Yes it is possible. You would enable security on the value set, but then
on the flexfield segment (intercompany) you would not enable security.
4. Is there a way to assign different security rules to a responsibily
based on the User ID?
Answer
---------
You cannot apply different security rules to the same responsibility
for different users based on the user ID. You will have to create a new
responsibility and define its own security rules. Then you can assign the
new responsibility to one of the users.
5. Can security rules be used to control the posting of journal entries?
Answer
--------
Security rules apply only with regards to creation/modification of lines
within a journal. They do not apply when the journal is posted.
6. Security rules don't seem to work on all forms when performing
a query.
Answer
--------
Flexfield Value Security gives you the capability to restrict the set of
values a user can use during data entry. With easy-to-define security
rules and responsibility level control, you can quickly set up data entry
security on your flexfield segments and report parameters.
Flexfield Value Security lets you determine who can use flexfield
segment values and report parameter values. Based on your
responsibility and access rules that you define, Flexfield Value Security
limits what values you can enter in flexfield pop-up windows and
report parameters.
Security rules for the Accounting Flexfield also restrict query access to
segment values in the Account Inquiry, Funds Available, and Summary
Account Inquiry windows. In these windows, you cannot query up
any combination that contains a secure value. However in all other forms,
you will be able to query up a value even if it is restricted to the user.
Reference
-----------
Oracle Applications Flexfield Guide Release 11, page 5-10.
7. Can Security Rules prevent users in one organization in the same set of books
from adding Cross Validation Rules to another organization?
Answer
--------
There is not a way in the same set of books, to prevent users from one
operating unit via security rules, from changing cross validation rules
for another operating unit. The only way to do this would to be create
a separate set of books for each operating unit. Since security rules
prevent users from either viewing data or entering data in general, they do
not pertain to set up issues such as creating cross validation rules.
Therefore, the only other way to prevent one user from one organization
from creating cross-validation rules to the other organization, when in
the same set of books, would be to completely remove that menu function
from the user.
8. Every Country has a Global Manager or User Responsibility to access Global
SOB but it is supposed to limit users to their own Legal Entities. However,
an Argentian journal can be posted by the Chilian user. How is this possible?
Answer
--------
This is working as intended. Security rules will prohibit a responsibility
from being able to ente certain values as well as prohibit the viewing
of those values. However security rules will not prohibit the
actions above because they are in the same set of books. The system does
not determine if a journal has values in it that are blocked by security
rules. If it did that, the journal would appear as unbalanced.
There would have to be an incredible amount of logic involved, which would
further reduce performance, for the posting program to scan the journal for
security rules first before posting. Posting does not take into consideration
the rules, this is done at the time of journal entry.
9. Forgot to check the security enabled flag for each segment and it is not
updatable. How do I correct this?
Answer
--------
Check your Accounting Flexfield structure to see if it is frozen. Unfreeze
the structure, then you should be able to enable Security for the
Segment.
10. In General Ledger, a security rule of a parent with children was set up
to include the parent and assigned to a responsibility. However it is
not functioning properly.
Answer
--------
The system allows the account the customer wanted but doesn't disallow
the ones that are children of the parent values excluded.
Review note OSS177300 Titled: Key Flexfield Rollup Hierarchical Security
not Working Properly.
11. Is it feasible to delete an Exclude statement in order to resolve a
Security Rule issue?
Answer
--------
The Security rule should not be modified by deleting an exclude or include
as it may corrupt the rule. Instead, delete all rule lines
(include and excludes), save and redefine the include and excludes.
If the rule still doesn't work, create a new rule and assign it to the
responsibilities in place of the original rule.
12. What standard reports have security enabled in Release 11i?
Answer
--------
Trial Balance, Account Analysis and General Ledger are the only
standard reports in Release 11i for which security rules apply.
13. Is it recommended to use a universal Include when setting up rules?
Answer
--------
It is recommended to start each security rule
with a universal Include statement and then eliminate each value
using Exclude statements.
14. What functions do security rules apply to?
Answer
--------
Security rules apply to Account Inquiry, budgets, FSG's and journal entry
functions. In Release 11i, this also applies to several standard reports
(listed previously). Please note, they do not apply to the posting
of journals or the review of journals. When reviewing a journal with
security rules, the totals are still displayed, it is only the
individual lines that are not visible. This is standard functionality.
15. What is Hierarchical Security?
Answer
--------
Please see Note:164769.1 for information regarding this new
feature. For addition information go to Metalink:
1. Logon to Metalink.
2. Select Top Tech Docs ->
Top Tech Docs button (it says 'Click for the original Top Tech Doc pages') ->
ERP Applications -> Financials -> General Ledger
-> Documentation -> Release 11i General Ledger Product Documentation ->
Doc Update Oracle General Ledger User's Guide, Hierarchical Security
(Rel 11.5.6).
Note:136719.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
General Ledger Journal Entry FAQ
|
Creation Date:
|
08-MAR-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
02-AUG-2004
|
Status:
|
PUBLISHED
|
ORACLE GENERAL LEDGER
---------------------
JOURNAL ENTRY, REVERSING, RECURRING
-----------------------------------
FREQUENTLY ASKED QUESTIONS
--------------------------
August 2002
CONTENTS
--------
Journal Entry
-------------
1. How to delete a Journal Batch? The delete icon is greyed out.
The journal batch does not have journals associated and it is unposted.
2. Why does an accounting period not appear in the accounting
periods list of values on the journal entry form?
3. Why can not a journal batch be deleted or modified?
4. Which report shows details of a posted journal batch?
5. Is there a report that displays information on one specific
journal entry - unposted/posted?
6. Can a posted journal batch be deleted?
7. Is possible to restrict users from entering negative amounts
in journal lines?
8. How to set up journal approval in General Ledger?
9. How do you attach an Excel spreadsheet to a journal entry in Oracle General
Ledger?
10. How to easily copy a journal entry from one set of books to another?
Reversing Journals
------------------
11. An entire batch was reversed and posted, while trying to reverse and post
just one journal entry in the batch. How can this be corrected?
12. Why is there a reversed posted journal in the next accounting period
of a non posted journal?
13. Why is the reversal period of a journal being cleared out after
the period is changed?
14. A journal entry with a source set up for automatic reversal
is not reversed.
15. Does the reversal program generate separate reversal batches-journals
for each journal in a batch that is reversed?
16. How do you reverse a journal entry that was already reversed, but its'
reversed journal was deleted?
17. How do you restrict the ability to reverse unposted journals?
18. How do you automatically generate a reversal journal entry for a journal
category in the previous accounting period?
Recurring Journals
------------------
19. How does the application determine the default period when a recurring
journal is generated?
20. How do you insert an additional adjusting journal entry into an
unposted recurring journal batch? The journal was added to the
journal on the Enter Journals form, but it was not included in the
recurring journal batch as expected.
21. Is it possible to generate recurring journals automatically?
22. How do you create a credit line for a debit balance account?
QUESTIONS & ANSWERS
-------------------
Journal Entry
-------------
1. How to delete a Journal Batch? The delete icon is greyed out.
The Journal Batch does not have journals associated and it is unposted.
Answer
------
The journals/enter first popup form looks only for batches with journals.
a. Go to Journals > Enter.
b. When the Find Journals window appears, click on the 'X' in the upper
right corner to close the window.
c. Click the Review Batch button on the Enter Journals form. This will
bring up the Find Batches window to query the batch.
d. Enter the batch Name and the Period.
e. Click the Find button and the batch should be displayed on the Batch
window now.
f. Now it is possible to click on the delete icon to delete the unposted
journal batch.
2. Why does an accounting period not appear in the accounting
periods list of values on the journal entry form?
Answer
------
The accounting period list of vlaues displays periods that have a closing
status of Open (O) or Future Enterable (F). New journal entries can be
defined in open and future enterable accounting periods. New journal entries
can be posted only in open accounting periods.
3. Why can not a journal batch be deleted or modified?
Answer
------
A journal batch can not be deleted or modified under the following
circumstances:
a. The source is frozen
b. Funds have been reserved for the batch
c. Funds are in the process of being reserved for the batch
d. The batch is in the process of being posted
e. The batch is posted
f. The batch is approved
g. The batch is in the process of being approved
A journal batch should not be updated if it comes from a sub-ledger.
Changing accounting information in a journal that originated in a
sub-module will unsynchronize the accounting information between the
ledger and the sub-ledger. Instead of changing the sub-ledger
journal, define a new journal to adjust the accounting information
if necessary.
A journal batch that has funds reverved can not be updated because
the funds would not be re-reserved appropriately.
4. Which report shows details of a posted journal batch?
Answer
------
Journals - General(180 Char) and Journals - General(132 Char)
reports display information relating to a particular journal batch.
5. Is there a report that displays information of one specific
journal entry - unposted/posted?
Answer
------
No. General Ledger reports display information of journal batches that
are posted or unposted. Note 200787.1 gives a workaround solution.
6. Can a posted journal batch be deleted?
Answer
------
No, a posted jounal batch can not be deleted. Reverse it to nullify
the accounting effects of the posted journal batch.
See Note 135532.1.
7. Is possible to restrict users from entering negative amounts
in journal lines?
Answer
-------
Unfortunately, it is not possible to restrict users from entering negative
amounts in journal entry lines.
8. How to set up journal approval in General Ledger?
Answer
------
This is set up using Oracle Worflow Builder. The complete procedure is
explained in Note 176459.1
9. How do you attach an Excel spreadsheet to a journal entry in Oracle General
Ledger?
Answer
------
Please refer to Note 1074918.6.
10. How do you easily copy a journal entry from one set of books to another?
Answer
------
There is no standard feature to copy journal entries between sets
of books. However, there are some alternatives. See Note 204082.1.
Reversing Journals
------------------
11. An entire batch was reversed and posted, while trying to reverse and post
just one journal entry in the batch. How can this be corrected?
Answer
------
When you reverse an entire batch, one reversal batch is created for each
journal in that batch. To correct your problem, reverse the reversal batches
that contained the journals you reversed by mistake, then post them.
12. Why is there a reversed posted journal in the next accounting period
of a non posted journal?
Answer
------
This is the current funcionality. Reversing journals can be posted before
the original journal is posted.
13. Why is the reversal period of a journal being cleared out after
the period is changed?
Answer
------
This is the expected functionality in Release 11i. When you change the
period of a journal, the application can not determine what you want to
do with the reversal period, so it is cleared.
14. A journal entry with a source set up for automatic reversal
is not reversed.
Answer
------
General Ledger automatically submits the AutoReverse program when a period
is opened if the profile option, GL: Launch AutoReverse After Open Period,
is set to Yes. If a journal is created after the period has already been
opened, then the AutoReverse program will need to be submitted manually.
15. Does the reversal program generate separate reversal batches-journals
for each journal in a batch that is reversed?
Answer
------
Yes. When a batch is reversed, General Ledger creates a reversing
journal entry for each journal entry in the batch. Note that this
also generates a separate reversal batch for each reversed journal.
16. How do you reverse a journal entry that was already reversed, but its
reversed journal was deleted?
Answer
------
General Ledger does not allow you to reverse a journal entry twice.
Confirm that the first reversed journal entry does not exist in the system.
Contact Oracle Support for the solution to Note 145043.1.
17. How do you restrict the ability to reverse unposted journals?
Answer
------
Unposted journals can be posted, this is the intended functionality.
Additional information can be found in Note 172016.1.
18. How do you automatically generate a reversal journal entry for a journal
category in the previous accounting period?
Answer
------
Automatic Journal Reversal is a feature that is included in Release 11i.
Additional information can be found in Note 151920.1.
Recurring Journals
------------------
19. How does the application determine the default period when a recurring
journal is generated?
Answer
------
The default period is only determined for non Average Daily Balance (ADB)
sets of books.
The period that appears in the period field, will default to the first
period following the last run period which statisfies the following:
a. The period status is 'Open' or 'Future Enterable'.
b. There is at least one formula header within the batch that is valid
within this period. The start and end effective dates must be
valid.
20. How do you insert an additional adjusting journal entry into an
unposted recurring journal batch? The journal was added to the
journal on the Enter Journals form, but it was not included in the
recurring journal batch as expected.
Answer
------
To generate an additional journal in a recurring batch you must update
the definition of the recurring batch.
When you create a manual journal entry on the Enter Journals form, the
Source is set to Manual and a new batch with a Source of Manual is
created. The Source for the recurring journal(s) is Recurring. This new
journal will not be combined with the original recurring journal batch
since they have different sources.
However, you can update the unposted recurring batch with additional
lines and amounts.
See Note 93764.1.
21. Is it possible to generate recurring journals automatically?
Answer
------
In Release 11i, the automatic journal scheduling feature enables you to
automatically generate journals for:
a. Recurring Journals
b. Mass Allocations/Mass Budgets
c. Step-down allocation sets
d. Parallel Allocation sets
22. How do you create a credit line for a debit balance account?
Answer
------
To create a line in a recurring journal with a balance which is
opposite the natural account type, you will need to create
the formula and include a line item that multiplies the account
by -1 as indicated in Note 1053106.6.
.
Note:136685.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
General Ledger Document Sequencing FAQ
|
Creation Date:
|
08-MAR-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
02-AUG-2004
|
Status:
|
PUBLISHED
|
ORACLE GENERAL LEDGER
---------------------
DOCUMENT SEQUENCES
------------------
FREQUENTLY ASKED QUESTIONS
--------------------------
16-Jan-2004
CONTENTS
--------
1. Is Document Sequencing valid for budget journals?
2. Where do you setup the GL document sequencing so you can see the categories?
3. How is the profile option 'Sequential Numbering' used?
4. Can you set up document sequences for Journal Categories in the
System Admin Responsibility?
5. Can document sequencing be used for some categories in a set of books,
but not all?
6. Will a reversed journal have the same sequence as the original journal.
7. How To Make Document Transaction Numbering Gapless in AR?
8. Where is the document sequence number kept when you delete an invoice in AP?
9. Unable To Create Journal Due To Error APP-FND-0172810.
QUESTIONS & ANSWERS
-------------------
1. Is Document Sequencing valid for budget journals?
Answer
------
Document sequences only apply to actual journal entries. Budget and encumbrance
journal entries will not work with document sequencing.
2. Where do you setup the GL document sequencing so you can see the categories?
You have created document categories for each of your companies and have linked
these categories to an assignment in the Sequence Assignment form.
Navigation= Setup:Financials:Sequences:Assign (FNDSNASQ). When you go into
the journals entry form and try to select the new category that you have
created, you do not see the new category. You have the same setup in AP
and it works fine. Is there somewhere else they need to setup the categories?
Answer
------
Document categories for Journal Entries must be setup in GL. Following is a
brief explanation of how to set up document sequencing for journal entries.
In System Administrator Responsibility, you need to set the profile option
'Sequential Numbering' to Partially Used at the Application (OGL) and
Responsibilty (your GL responsibility) levels and commit.
In your GL responsibility:
a. Journal categories - create a new record and set the reversal method to
Switch Dr/Cr and commit. (Setup:Journal:Categories)
b. Document Sequences - create a new record as follows:
Application=OGL; From=<start date>; Type=manual; Dist... Access=GL and
commit.
(Setup:Financials:Sequences:Define).
c. Sequence assignments - create a new record with:
Application=OGL; Category= Testxyz; SOB=<your set of books name>;
Method=manual; Start Date=<start date>; Sequence=Testxyz and commit.
(Setup:Financials:Sequences:Assign)
Enter a new journal and tab through Document No. and do not enter a number.
This should result in the following error:
APP-1738 - "The sequence Testxyz is type manual. You must enter a value."
By entering a number you should be able to save the Journal Entry.
GL document categories are not available to the System Administration
responsibility and cannot be setup there. Creation of document categories
in SysAdmin updates FND_DOC_SEQUENCES_CATEGORIES but when created in GL
the record is inserted into GL_JE_CATEGORIES. Thus, categories must be
setup through a GL responsibility (e.g. GL Superuser) with the required
GL setup forms/menu functions enabled.
NOTE: This above example is not a complete setup of document sequences.
In order to use document sequences with programs such as journal
import that will automatically assign a sequence number, you must
set up an automatic sequence and create an assignment with an
automatic method.
See the Oracle General Ledger Users Guide for more information.
3. How is the profile option 'Sequential Numbering' used?
Answer
------
Sequential Numbering assigns numbers to documents created by forms in Oracle
financial products. Sequential numbering provides a method of checking
whether documents have been posted or lost. Not all forms within an
application may be selected to support sequential numbering. Sequential
numbering has the following profile option settings:
Always Used - You may not enter a document if no sequence exists for it.
Not Used - You may always enter a document.
Partially Used - You will be warned, but not prevented from entering a
document, when no sequence exists.
Users can see this profile option, but they cannot update it. This profile
option is visible and updatable at the site, application and responsibility
levels. The internal name for this profile option is UNIQUE:SEQ_NUMBERS.
4. Can you set up document sequences for Journal Categories in the
System Admin Responsibility?
Answer
------
No you have to set up document sequencing for Journal Categories in the
General Ledger responsibility as this updates an extra table in GL.
see Note:106469.1
5. Can document sequencing be used for some categories in a set of books,
but not all?
Answer
------
Yes. Document sequencing is specific to to the combination of set of
books/category. So yes you can have some categories within a set of books
that have document sequencing while other categories in the same set of
books do not have document sequencing.
6. Will a reversed journal have the same sequence as the original journal.
Answer
------
It can do if an automatic method is assigned to the sequence as well as
a manual method.
Reversals are generated by the system, so the system considers them to
be automatic transactions. For document sequences to be applied to
automatic transactions, the category must have a document sequence
assignment with a method of automatic.
Manual method refers to journal entries that you enter manually on
the Enter Journals form.
Automatic method refers to transactions that are generated automatically
by General Ledger.
7. How To Make Document Transaction Numbering Gapless in AR?
Answer
------
See Note:197212.1
8. 8. Where is the document sequence number kept when you delete an invoice in AP?
Answer
------
See Note:120043.1
9. Unable To Create Journal Due To Error APP-FND-0172810.
Answer
------
Document sequences only apply to actual journal entries. Budget and encumbrance
journal entries will not work with document sequencing.
Document categories for Journal Entries must be setup in GL. Following is a
brief explanation of how to set up document sequencing for journal entries.
Note:136633.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
General Ledger Budgets FAQ
|
Creation Date:
|
07-MAR-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
02-AUG-2004
|
Status:
|
PUBLISHED
|
ORACLE GENERAL LEDGER
------------------------------
BUDGETS
----------------
FREQUENTLY ASKED QUESTIONS
--------------------------
28-JAN-2002
CONTENTS
--------
1) Can you disable budgetary control for a set of books?
2) Is there a limit to the number of periods in a budget year
or how many years a budget can span?
3) Why don't my Detail budgets roll up to my Master budget?
4) I was able to post a budget journal to a closed period, why?
5) How many 'Current' budgets can you have?
6) Why don't my budget amounts appear on FSGs?
7) What is a funding budget?
8) Why is my budget requiring budget journals? At the set of books
level that option is not enabled.
9) Why can't I inquire on my budget amounts from INQUIRE/BUDGETS
navigation path?
10) If I delete my budget org, will the budget amounts be deleted?
11) Can I update/adjust an existing account range in my budget
organization?
12) Can I delete a budget?
13) How many times can a budget be purged?
14) Why don't my asset and liability budgets roll forward?
15) Why do you receive an advisory warning during funds reservation
of a manual journal entry, even though there are sufficient
funds in the account?
16) Why is there no value in the REQUEST_ID column of GL_BUDGET_INTERFACE
for rows with data that failed to be uploaded by the Budget Spreadsheet
Upload program?
17) You are trying to open the next budget year. After navigating to the form and
querying the budget, you notice the [Open Next Year] button is grayed out.
18) You find that Account code combinations are not being added to the Budget
Organization?
QUESTIONS & ANSWERS
-------------------
1) Can you disable budgetary control for a set of books?
ANSWER
-------
Yes you can, however existing encumbrances are not cleared
from the feeder systems. Therefore it is not recommended.
If you do change the budgetary control options for an
existing set of books, you must do two things for the change
to be reflected.
--Run the Period Map Maintenance concurrent request, it must
complete successfully.
--Exit Oracle Applications and restart. You must completely exit
the application...it is not sufficient to select Sign On Again
from the Oracle Applications Special menu.
Ref: Oracle GL User's Guide, Rel 11, Vol 1, page 2-90
2) Is there a limit to the number of periods in a budget year
or how many years a budget can span?
ANSWER
-------
Your budget can include up to 60 periods per year and can span
an unlimited number of fiscal years.
3) Why don't my Detail budgets roll up to my Master budget?
ANSWER
-------
Detail budgets do not automatically roll up to the master budget.
The GL uses summary accounts to maintain master/detail budget
relationships between hierarchy levels. Summary templates are
defined so that accounts in your lower level detail budgets
roll up into the same summary accounts as the detail accounts
in your controlling master budget. A common misconception is that
the detail budgets somehow roll up to the master budget by
definition, this is not true. You must actually budget to a
detail account in the master budget, this then serves as the
controlling amount for the detail budgets.
Master/Detail budgets are used in the budgeting process to control
authority and identify budgets that exceed control limits.
They are not intended for reporting purposes.
4) I was able to post a budget journal to a closed period, why?
ANSWER
-------
A budget journal can be posted to any period that is in an open budget
year for that budget. This is regardless of the status of that period
(closed, opened, or future enterable).
5) How many 'Current' budgets can you have?
ANSWER
-------
You can only have one current budget. The only distinction between a
'current' and an 'open' budget is that the current budget defaults into
the budget field on several budget related forms. It can be replaced
however by any 'open' budget in the field.
6) Why don't my budget amounts appear on my FSG?
ANSWER
-------
To include budgets (encumbrances or currencies) in a FSG report, your
report definition must specify a row set of column set that has control
values specified in the Balance Control options.
In the report definition itself, you associate budget names with the
control values that are assigned to the row or column set.
7) What is a funding budget?
ANSWER
-------
It is a budget that requires journal entries, and is assigned to a summary
template or account range in the budget org, where the funds check level
is set at Absolute or Advisory. It is the assignment that makes it a
'funding budget', it is not done at the budget definition level.
see note 1044048.6 for details of setting funds check level.
8) Why is my budget requiring budget journals? At the set of books
level that option is not enabled.
ANSWER
-------
This would happen when the budget itself is defined to require budget
journals. This is done at the budget definition level.
9) Why can't I inquire on my budget amounts from INQUIRE/BUDGETS
navigation path?
ANSWER
-------
The Budget Inquiry form (GLXIQBUD) is used to perform inquiries about
master and detail budgets. GL compares summary balances between your
master and detail budgets, and checks for budget variances and
violations. This form only looks at summary accounts. To inquire
on detail accounts you must use the navigation INQUIRE/ACCOUNTS, and
choose the 'budget' amount type.
10) If I delete my budget org, will the budget amounts be deleted?
ANSWER
-------
No. Deleting the budget organization does not remove the budget amounts
from the GL_BALANCES table.
11) Can I update/adjust an existing account range in my budget
organization?
ANSWER
-------
No. To update/adjust an existing account range, you must delete the
old range and create a new range (which incorporates your adjustment).
12) Can I delete a budget?
ANSWER
-------
No. Budget data can be deleted using the archive and purge functionality,
but the budget definition itself cannot be deleted.
13) How many times can a budget be purged?
ANSWER
-------
A budget can only be purged one time. The archive/purge functionality
was not designed to be a maintenace tool in the budgeting process.
14) Why don't my asset and liability budgets roll forward?
ANSWER
-------
This is the current functionality. An enhancement request has been
logged.
15)Why do you receive an advisory warning during funds reservation of a manual
journal entry, even though there are sufficient funds in the account?
ANSWER
-------
You are getting the advisory warning because your transaction is
going against a detail account where no budget has been entered.
So even though there are sufficient funds on the summary level,
there are not sufficient funds at the detail level.
The funds checking/reservation process will look at the funds
check level for the detail account first, and then the funds
check level for the summary account.
The warning is alerting you to the fact that the detail account
you are entering a transaction against does not have sufficient
funds available.
When you know there are sufficient funds at the summary level,
you must either change your funds check level on your detail
account to none (to only look at the summary level), or enter
a sufficient budget to all the detail accounts that you will
be entering transactions against, if you don't want to see
the warning.
Reference-Note 1074915.6
16) Why is there no value in the REQUEST_ID column of GL_BUDGET_INTERFACE
for rows with data that failed to be uploaded by the Budget Spreadsheet
Upload program?
The request_id field is nulled out when the budget upload completes,
and errors were found in the data.
17)You are trying to open the next budget year. After navigating to the form and
querying the budget, you notice the [Open Next Year] button is grayed out.
Responsibility = General Ledger Super User
GUI Navigation = Budgets/Define/Budget
Short Form Name = GLXBDDEF
You query up a Budget that has already been defined and the [Open Next Year]
button is grayed out for that Budget as well.
You are trying to open the next budget year on February 8, 1998.
Pertinent fields in the Define Budget Form are displaying the following
information:
Status = Open
Budget Periods Block-----------------------------------------
First = JAN-97 Last = DEC-97
Latest Open Year = 1997
-------------------------------------------------------------
PROBLEM EXPLANATION
-------------------
The last day of the Last Period defined in your Budget has already passed.
SOLUTION DESCRIPTION
--------------------
The Define Budget form looks at the periods you have defined as "First"
and "Last". Once the "Last" date has passed, you will no longer be
able to open the next year (The "Open Next Year" button will be grayed out.)
General Ledger views this Budget as finished since the end date has expired.
According to the General Ledger User's Guide for Release 10SC, page 2-19,
"You can change the last period to a later period only if the
period you are changing from corresponds to the last period
of your fiscal year."
In many cases you will need to define a new budget. When defining your
budget remember that you can span an unlimited number of fiscal years.
18) You find that Account code combinations are not being added to the Budget
Organization?
PROBLEM DESCRIPTION
-------------------
Account code combinations are not being added to the Budget Organization.
You have added the following range to a budget organization:
Low High
----------------- -----------------
000-13099-000-000 999-13099-000-000
Responsibility = General Ledger Super User
GUI Navigation = Budgets/Define/Organization (Form = GLXBDORG)
Name = use the flashlight icon to find the Budget Organization you are
currently working on.
Click on the [Ranges] button at the bottom of the window.
Enter the low and high range. Save/Commit the changes. Exit the screen.
When you go back to the Define Budget Organization window, click on the
[Assignments] button, the expected account code combinations have not
been assigned to that Budget Organization. You requery to verify.
You run the Maintain Budget Organization Program, which will also force
creation of accounts. To do this, you navigate to the Define Budget
Organization window and click on the [Maintain] button. This does not add the
account code combinations either.
You have also tried doing the following (to no avail):
* Unfreezing, refreezing and compiling the accounting flexfield structure.
* Running Program Optimizer from the Standard Report Submission Screen.
* Deleting the assignment and adding the assignment.
* Added account to parent.
* Dropped / recreated summary template.
SOLUTION DESCRIPTION
--------------------
Budgeting must be enabled in the Account Combination screen.
Responsibility = General Ledger Super User
GUI Navigation = Setup/Accounts/Combinations
Do a query to pull up the desired combinations (Query Enter/Query Run).
Make sure the Allow Budgeting box has been checked for all the account code
combinations within the range you assigned.
SOLUTION EXPLANATION
--------------------
Assigning budget account ranges will assign accounts within the given range
if they have been enabled for budgeting. Otherwise, they will fail.
Note:135433.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
General Ledger Open/Close Period FAQ
|
Creation Date:
|
12-FEB-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
02-AUG-2004
|
Status:
|
PUBLISHED
|
ORACLE GENERAL LEDGER
---------------------
OPEN/CLOSE PERIOD
----------------
FREQUENTLY ASKED QUESTIONS
--------------------------
August 2002
CONTENTS
--------
1. If we open the first period of the new year, can we still process
entries for the prior year(s)?
2. I opened the first period of the new year without closing the prior year.
Will this cause a problem?
3. The first period of my new fiscal year was opened and closed. What are
the ramifications to the roll forward process and retained earnings?
4. We opened a period by mistake and need to set the status back to future
enterable? Can we do this?
5. We created new periods after the last period defined was opened. Now we
can not see those new periods on the Open/Close form.
6. Can I add a 13th period to my calendar?
7. How do you open a permanently closed period?
8. Is there a way to automatically open General Ledger periods?
9. Open Period program is stuck in module gllock
10. Is there a way to get a Closing Journal
QUESTIONS & ANSWERS
-------------------
1. If we open the first period of the new year, can we still process
entries for the prior year(s)?
Answer
------
Yes. You can still create entries for any period that has a status of Open
or Future Enterable. You can post to any period that has a status of Open.
If you post in a prior fiscal year, the balanced will be rolled foward and
retained earnings will be updated as needed.
2. I opened the first period of the new year without closing the prior year.
Will this cause a problem?
Answer
------
No. Closing a period in General Ledger does nothing more than close that
period. There is no processing that goes on behind the scenes when you close
a period.
3. The first period of my new fiscal year was opened and closed. What are
the ramifications to the roll forward process and retained earnings?
Answer
------
None. General Ledger will properly maintain the balances for the new year,
regardless of how many times the periods are opened or closed. Retained
earnings is calculated when the first period of the new year is initially
opened, and thereafter when any posting is done to a revenue or expense
account in a prior year.
4. We opened a period by mistake and need to set the status back to future
enterable? Can we do this?
Answer
------
No. There is no way within the application to set the period status back
to Future Enterable after the period has been opened. To do so would lead
to data corruptions on a large scale.
5. We created new periods after the last period defined was opened. Now we
can not see those new periods on the Open/Close form.
Answer
------
When Open Period runs, it sets the status of the next X periods to Future
Enterable. On the Set of Books form, you define the number of Future
Enterable periods. If, when you open a period, there are no subsequent
periods defined, the Future Enterable periods can not be updated. When
you define new periods in the calendar, the status will remain Never
Opened, until you open the next period. At that time, the program will
update the status to Open on the next period, and will update the status
to Future Enterable on the next X periods.
6. Can I add a 13th period to my calendar?
Answer
------
No. You associate a Period Type with a Set of Books. The Period Type
is defined to have a fixed number of periods. That is the number of periods
you must define for your set of books - no more and no less.
7. How do you open a permanently closed period?
Answer
------
You cannot open a period that has a status of Permanently Closed.
8. Is there a way to automatically open General Ledger periods?
Answer
------
No. There is no way within General Ledger to do this
9. Open Period program is stuck in module gllock
Answer
------
1. If there is another Open Period program still running for the current set of
books, let it continue to completion.
2. If there is no other Open Period program running for the current set of
bookstry the sql suggested Note 134007.1 for cleaning up concurrent requests.
See bug 2954000 - WHEN OPEN PERIOD IS INTERRUPTED, IT DOESN'T RESTART SUCCESSFULLY
Prevented in GL patchset I onwards.
For a fix see Note 134007.1
more details Note 233150.1
10. Is there a way to get a Closing Journal
Answer
------
Closing Journals Income Statement Offset Option (Rel 11.5.2) (CR 277920 PDF 134 kb)
http://metalink/cgi-bin/cr/getfile.cgi?p_attid=66935.1:277920
Note:119379.1
|
Content Type:
|
TEXT/PLAIN
| |
Subject:
|
General Ledger Flexfield FAQ
|
Creation Date:
|
08-SEP-2000
|
Type:
|
FAQ
|
Last Revision Date:
|
15-JUL-2004
|
Status:
|
PUBLISHED
|
When investigating problems in this area the solution is often in the relevant
White Paper which also provides a useful insight into the Topic. Please refer to the White
Paper Accounting Flexfield Setup and Usage at Note:124333.1.
ORACLE General Ledger
------------------------------
Flexfields
----------
FREQUENTLY ASKED QUESTIONS
--------------------------------------------------
June 2004
CONTENTS
--------
1. An account code segment value has been disabled but users are still
able to post transactions to these accounts. How do you disable a segment
value and code combinations so journals will not be created with these accounts?
2. If the Accounting Flexfield structure is not frozen, why does the
Shorthand Alias form (FNDFFMSA) allow updates?
3. How do you update segment qualifiers or rollup groups for an existing value?
4. How do you add a new value to an existing segment?
5. How do I know which accounts are inactive?
6. Can you add or delete segments to an existing accounting flexfield
structure?
7. Which table stores the parent value and its' child ranges?
8. What tables store segment values and their descriptions?
9. Do all segments of your accounting flexfield have to be enabled and
displayed?
10. When trying to compile an accounting flexfield, you receive
APP-00981 and APP-00068 errors. How do you resolve this?
11. The View Compilation for the Accounting Flexfield view failed with
APP-00988 ORACLE error 905 in afuddl. How should you resolve this issue?
12. Can a flexfield qualifier be changed after it has been created?
13. You receive the message 'APP-00734: Please enter a valid value for the
Account Type segment qualifier using the Segment Qualifiers pop-up window'
when entering a new value. How do you resolve this?
14. Can you change the size of a value set used in the accounting flexfield
after it has been created?
15. Receive APP-00668 APP-00874 FDFBKS error when compiling accounting
flexfield.
16. You receive APP-1564 and ORA-904 when trying to create a new code
combination. How should this be resolved?
17. You received APP-00822 when entering flexfields in set of books form
GLXSTBKS. How should this be resolved?
18. How do you enable the Journals-Captured Information descriptive flexfield?
19. How do you correct a misclassified account?
20. You are trying to modify an existing segment value and receive errors
FRM-40735 and FRM-40654: Record has been updated, re-query block to see
changes.
21. Can the Accounting Flexfield Segment name be changed?
22. Can a parent value be changed to a child value and vice versa?
23. Can changes be made to segments in an existing accounting flexfield
structure?
24. How do you enable an existing Future use accounting flexfield segment?
25. What is the difference between Hierarchical and Non-hierarchical Security
Type?
26. Why can you update the Segment Values form (FNDFFMSV) when the flexfield
structure is frozen?
27. Should Rollup Groups be frozen?
28. Do you need to have an Accounting Flexfield segment that
is flagged with the Intercompany qualifier?
29. What is a Reconciliation qualifier and how is it setup?
30. What is the recommended numbering for the Accounting Flexfield structure
and why?
31. Some of the segment separators are displayed as question marks (?),
why?
32.Is there an easier way to create/load account code combinations then to
enter them manually through the forms?
33. Can different sets of books share the same value set?
34. Is there a way to identify overlapping child ranges in a value set?
35. How do you set up an Accounting Flexfield structure that has a
dependent segment?
36. What is the correct way to renable an account value?
QUESTIONS & ANSWERS
-------------------
1. How do you disable a segment value and code combinations so journals will
not be created with these accounts?
You must disable the segment, and disable every code combination that uses
that segment. In version 11 and prior, you must disable each code combination
individually. However, in 11i, you can disable a range of code combinations
using the new Segment Value Inheritance program. See the General Ledger
User's Guide, Release 11i for more information on this program.
Note: There is no supported way to delete a segment value. Segment values
should only be disabled not deleted. General Ledger does not distinguish
between accounts which have transactions outstanding in order to determine if
these accounts should not be disabled.
2. If the Accounting Flexfield structure is not frozen, why does the
Shorthand Alias form (FNDFFMSA) allow updates?
This form should become non-updateable and non-insertable if the flexfield
is not frozen. Bug 1080345 (Problem 9) has been submitted to address this
issue.
3. How do you update segment qualifiers or rollup groups for an existing value?
You need to unfreeze all flexfields that use the value set. Then you should
be able to update the values. See note 1015950.600 for detailed steps, and
scripts to find the flexfields that use a particular value set.
4. How do you add a new value to an existing segment?
On the Segment Values form, insert a new row with your new value. Make sure
the segment qualifiers are set correctly (Allow Posting and Budgeting). If
this is the natural account segment, specify the Account Type also.
5. How do I know which accounts are inactive?
Run the standard report: Chart of Accounts - Inactive Accounts Listing.
This report is new in Release 11i.
6. Can you add or delete segments to an existing accounting flexfield
structure?
No. This will cause data inconsistencies and data corruption. Development
and Support do not support changes to the accounting flexfield.
Changing your flexfield definition once you have used it to acquire data can
cause serious inconsistencies with existing data, which could cause data
corruption. See the Oracle Applications Flexfields Guide, Release 11i, page
2-19, and the Oracle Applications Flexfields Guide, Release 11, page 2-18
for more information.
7. Which table stores the parent value and its' child ranges?
FND_FLEX_VALUE_NORM_HIERARCHY
8. What tables store segment values and descriptions?
FND_FLEX_VALUES_TL and FND_FLEX_VALUES.
No comments:
Post a Comment