GL FAQ By Avinash
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.
9.
Do all segments of your accounting flexfield have to be enabled and
displayed?
Yes.
This is true for all applications versions.
All
segments must be enabled and displayed. Any other configuration is
not
supported. From the Oracle Applications Flexfields Guide:
'If you are defining the Accounting
Flexfield, you MUST
display ALL segments. Hiding segments will
adversely affect
your application features, such as Mass
Allocations'.
The
only supported solution therefore, is to have all segments
displayed
from the start, and for them to remain that way.
10.
When trying to compile an accounting flexfield, you receive
APP-00981
and APP-00068 errors. How do you resolve this?
Remove
any spaces in the View Name and replace them with underscores.
Verify
the segment qualifiers have been assigned. See Note
1053770.6
for
more information.
11.
The View Compilation for the Accounting Flexfield view failed with
APP-00988
ORACLE error 905 in afuddl. How should you resolve this issue?
The
View Name on the Define Key Flexfield Segments form can only
contain
letters, numbers or underscores. For more information, see Note
1022367.6.
12.
Can a flexfield qualifier be changed after it has been created?
No.
Once
a segment qualifier has been designated for a specific segment and has
been
saved, it will permanently have the attributes with that qualifier.
For
example, you accidentally designate the cost center segment as the
natural
account segment. Even though you do not
compile this, the system
saves
the changes. And once it has been saved,
it will have all the attributes
designated
for the natural account qualifier, even after it has been changed
back,
resaved with the correct qualifier and compiled.
This
is the inherent functionality of the software.
Unfortunately,
there is no real easy solution for this issue.
The only
option
is to create a new chart of accounts and attach a new set of books.
You
may be able to just create a new chart of accounts if you haven't created
the
set of books yet. See Note
107448.1, for more information.
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?
You
need to make sure that segment qualifier values have been entered. If
you
plan on choosing the default values, you must tab to the segment qualifier
popup
window and click the OK button. See Note
1071883.6 for more information.
14.
Can you change the size of a value set used in the accounting flexfield
after
it has been created?
No.
Once the value set is created, you should not change the size of
a
value set used in an accounting flexfield. We recommend that you set
Right-justify
Zero-fill Numbers to Yes for value sets you use with the
Accounting
Flexfield. You should never change to a value set with a
larger
(or smaller) maximum size if your value set is Right-justify
Zero-fill,
since 001 is not the same as 0000001, and all of your
existing
values would become invalid.
15.
You receive APP-00668, APP-00874 FDFBKS error when compiling accounting
flexfield.
Make
sure you have created the segments for your accounting flexfield
structure.
Also verify that you have assigned the Balancing Segment and
Natural
Account segment qualifiers to the appropriate segments.
16.
You receive APP-1564 and ORA-904 errors when trying to create a new code
combination.
How should this be resolved?
This
issue is corrected in patch 656683. Apply patch 656683 or
FND
Patchset F (1155774)
17.
You received APP-00822 and APP-00730 errors when entering flexfields
in
Set of Books form GLXSTBKS. How should this be resolved?
Make
sure your segment qualifiers have been assigned (Balancing Segment and
Natural
Account). Verify that value sets have been assigned to all segments.
Re-sign
on to the application.
18.
How do you enable the Journals-Captured Information descriptive flexfield?
Define
context values for each of the account values you want to capture
information
for. Then define context-sensitive segments that will hold
the
desired information. See Note
108331.1 for detailed setup steps.
19.
How do you correct a misclassified account?
Note
1050920.6 contains detailed steps for correcting Misclassified Account
Types.
The steps must be followed in the exact order if the misclassified
account
is to be corrected in its entirety.
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.
These
errors are probably due to trailing spaces in a text field. The
script,
$FND_TOP/sql/afchrchk.sql can be run to find and optionally
remove
the trailing spaces. Note
1016277.102 contains more information.
21. Can the Accounting Flexfield Segment name be
changed?
Development's
recommendation is this ...
Nothing
about a flexfield structure should be changed since this could
seriously
impact your existing data and cause inconsistencies.
22. Can a parent value be changed to a child
value and vice versa?
An
account should never be changed from a child to a parent or vice a versa.
This
may cause corruption in the chart of accounts at the table level and is
not
recommended or supported by development.
23. Can changes be made to segments in 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.
24. How do you enable an existing Future use
accounting flexfield segment?
There
are no extra steps to follow except the following:
1) Unfreeze the accounting flexfield
2) Change the segment name to a proper name
(if necessary)
3) Change the value set value type from
constant to char and default value (if necessary)
4) freeze the accounting flex field and
recompile
25. What is the difference between Hierarchical
and Non-hierarchical Security
Type?
Hierarchical
Security: This feature combines Flex
Value Security and Flex
Value
Hierarchy. The end result is 'a flex value is secured if one of it's
parents
is secured'. With non-hierarchical security, the child values do not
inherit
the parent security.
26. Why can you update the Segment Values form
(FNDFFMSV) when the flexfield
structure
is frozen?
You
do NOT need to Unfreeze Flexfields to amend Segment Qualifiers from
FNDFFMSV
11.5.28 (FND patchset C) onwards, for Release 11i.
Due
to customer requests, patch 1081772 introduced this change for FNDFFMSV.fmb
115.28,
and it is included in R11i FND patchset C onwards. This is now standard
functionality.
Documentation bug
1377482 has been raised to reflect this change
to
functionality, since the 11i User's Guide does not advise of the change.
27. Should Rollup Groups be frozen?
It
is recommended that Rollup Groups be frozen unless they are being modified.
However,
if they are not frozen, there should not be any effects on General
Ledger
reports, functions, or other processes.
28. Do you need to have an Accounting Flexfield
segment that
is
flagged with the Intercompany qualifier?
The
intercompany segment is an optional Intercompany feature for the
Intercompany
Segment Balancing. It is NOT required in order to do intercompany
balancing.
It
is just another way to do the intercompany balancing, instead of using
different
natural accounts to track intercompany
balances, you can use the
intercompany
segment in the Chart of Accounts to record the same detail.
It
is more just a matter of preference of how you want to track the intercompany
transactions. Refer to Note
151130.1 to see additional information regarding
How
Intercompany Journal Lines are Created in General Ledger 11i. Also see the
Oracle
General Ledger Users Guide, Chapter 5: Accounting for Multiple
Companies
Using a Single Set of Books.
29. What is a Reconciliation qualifier and how is
it setup?
This
Reconciliation flag is a localization feature used primarily by European
customers.
When the flag is set to YES, the account is set up to be
reconciled.
GL
Entry Reconciliation is a set of forms and reports that enable the user to
selectively
cross-reference transactions in the General Ledger. Once the
balance
of a group of transactions is zero, the user can mark them as
reconciled. This functionality enables the transactions
in any account that
should
balance to zero (for example, an Inter-company suspense account) to be
reconciled.
For
information regarding the setup of this option, please refer to Note:
1041211.6.
30. What is the recommended numbering for the
Accounting Flexfield structure
and
why?
The
Accounting Flexfield structure requires consecutive segment numbers beginning
with
1, such as 1,2,3..... Gaps in numbering
like 10, 20, 30 could cause
errors
when compiling and with other General Ledger functions.
31. Some of the segment separators are displayed
as question marks (?),
why?
Check
the descriptions of the Segment Values. If the same segment separator
value
(ie: dash) is used in the segment value description, the actual segment
separator
on the chart of accounts will appear at times as a "?"
Do
not use the segment separator in the description and this should resolve the
issue.
32.
Is there a way to load values for a specific segment outside of the form?
For
loading segment values thru API, iSetup needs to be installed. The
functionality
"Chart of Accounts Companion" allows users to define segment
values
in a spreadsheet and import the segment value through the loader. This
functionality
is available only in iSetup product. Outside of manually creating the
code
combinations, ADI may be used to load zero dollar journals to create new
code
combinations. Please be aware that
Dynamic Insertion should be enabled and
all
account segment values need to exist before the new account code combinations
will
be dynamically created. Enhancement Request 2974057 has been logged to
provide
an API to load account code combinations.
33.
Can different sets of books share the same value set?
If
there is a set of books that uses a particular value set and a new book is
created,
it can use the existing value set. When
the Account Flexfield Structure
is
created, simply choose the existing value set from the List of Values. However,
if
you use an existing value set, the new structure will also inherit the
existing
values in the value set. It does not create an empty value set to be
populated.
34.
Is there a way to identify overlapping child ranges in a value set?
Note
143175.1 explains this issue and a script to identify these overlapping
ranges.
35. How do you set up an Accounting Flexfield
structure that has a
dependent
segment?
Define
the accounting flexfield structure in two steps. On the Key Flexfields
Segments
form, you have to Save the flexfield structure after you define
the
segment with the independent segment (for example account). Then leave
the
form and come back. Now add your dependent segment (for example
subaccount).
You
should see the dependent value set in the list of values.
36. What is the correct way to renable an account
value?
In
order to re-enable an account value or remove an end date, do the following..
1. Unfreeze the accounting flexfield structure
2. Re-enable the account value or remove the end
date of the segment value.
3. Re-freeze the accounting flexfield structure
and recompile.
4. Log out of the applications and log back in.
The
account value should now be once more
available for use.
Note:108236.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
FSG Functional FAQ
|
Creation Date:
|
10-MAY-2000
|
Type:
|
FAQ
|
Last Revision Date:
|
14-JUL-2004
|
Status:
|
PUBLISHED
|
||
PURPOSE
-------
To
aid users and support analysts in problem resolution.
SCOPE
& APPLICATION
-------------------
External
users and internal support analysts.
FREQUENTLY
ASKED QUESTIONS
--------------------------
May
2004
1.
How do I find the latest FSG patch that is available?
2.
Is there a way to suppress zero amounts on the FSG Report?
3.
How do you print credit amounts on the FSG report as positive, instead of
negative
numbers?
4.
Can I display account descriptions on the FSG Report?
5.
Is there a limit on how large a FSG Report can be?
6.
What is the profile option "FSG: Expand Parent Value" used for?
7.
I am trying to display budget amounts in my reports but they are not
showing
up. What is wrong?
8.
How do you enable FSG security?
9.
How can you add/define/create your own new amount types in FSG reporting?
10.
Where should the period offset and the amount type be specified?
11.
On a calculation column, can I enter an amount type?
12.
Is there a quick and supported method of transferring FSGs between
environments,
so that users do not have to key them in twice?
13.
What FSG enhancements are introduced in Release 11i ?
14.
Can I remove the 'No specific Company requested' text from the FSG
heading?
15.
Can I remove the segment header descriptions from the top of the FSG
reports?
16.
Can I customize or move the 3 heading lines that appear at the top of
the
FSG (set of books, report name, period)?
17.
How can I display USD and STAT amounts on the same FSG report?
18.
How can I report on a multiple level account hierarchy in an FSG?
19.
How can I define an FSG percentage calculation Column such as
percent
of sales?
20.
Can an FSG output be created in PDF format?
21.
What is the meaning of 'n/m' on my FSG?
22.
I used column set builder to set the width of the last column in my report.
After
saving and requerying the column set, the width has changed. Why?
23.
Can FSG reports and components be secured/protected so only certain
people
can modify or run them?
24.
How do segment overrides, content sets, account assignment ranges
and
display types work together?
25. When hiding data using Display Group/Set in
FSG the underline under
that
data still appears.
26. I'm using a Content Set with a range of cost
centers. There are some
inactive
cost centers within that range. How can I suppress the creation
or
printing of the reports for those inactive cost centers, or for disabled
or
inactive accounts?
27. How can I define a column to be for a
specific or constant period,
such
as January of the current year, or dynamically change the period?
28. Why can some column sets be viewed/used with
different sets of books
and
others cannot?
29. How do I see the SQL code behind the FSG
report?
30. How do I show the YTD amount for the end of
the fiscal year on an FSG?
31. Can I create an FSG in html format?
32. How can I run an FSG from the Standard
Request Submission form?
33. When using a content set, sometimes the
amounts are duplicated
(doubled
or tripled).
1.
How do I find the latest FSG patch that is available?
For
the General Ledger Patch List, on MetaLink, click on
Top
Tech Docs...General Ledger...Patchset Information (Note 159239.1).
2.
Is there a way to suppress zero amounts on the FSG Report?
You
cannot suppress individual zero amounts in FSG.
However, when all the
values
in a row or column are zero, you can have FSG suppress them all. To
do
this, make sure the Display Zero option is unchecked on the appropriate
Rows
or Columns window.
3.
How do you print credit amounts on the FSG Report as positive instead of
negative
numbers?
For
a related row or column definition, check the Change Sign checkbox.
Credit
amounts for this row or column will now print as positive numbers.
Negative
credits will print as negative numbers. Note that this changes
the
sign for display purposes only.
4.
Can I display account descriptions on the FSG Report in addition to the
account
segment values?
Yes. You simply have to define a Row Order, then,
assign it to your report.
In
your Row Order, set the Account Display options of the account segments
for
which you want to print descriptions.
Select Value and Description as
your
segment display method. Also, make sure
that you set the printing width,
so
there is enough room to print both the segment value and the description.
5.
Is there a limit on how large a FSG Report can be?
Yes. The column set width of an FSG report cannot
exceed 255 characters.
In
release 11i, the column set width can exceed 255 characters. (However,
while
printing, there is still a limit of 255 characters.)
6.
What is the profile option 'FSG: Expand
parent value' used for?
This
profile option controls the expansion of parent values when requesting
summary
balances. The following values are available to you:
Yes:
FSG uses the rollup group to determine whether to expand a parent value
into
its child ranges. If the parent value belongs to a rollup group, FSG
does
not expand the parent value into its child ranges. If the parent value
does
not belong to a rollup group, FSG expands the parent value into its
child
ranges.
No:
FSG uses the summary flag associated with the flexfield assignment to
determine
whether to expand a parent value into its child ranges. If the
summary
flag is set to Yes, FSG does not expand the parent value into its
child
ranges. If the summary flag is set to No, FSG expands the parent
value
into its child ranges.
The
default value for this profile option is No.
Note
1012620.102 provides more information regarding this profile option.
7.
I am trying to display budget amounts in my reports but they are not
showing
up. What is wrong?
Since
Oracle GL allows you to define multiple budgets, you must indicate
what
budget you want displayed in the row or column. You do this by first
assigning
a Control Value in the Balance Control section of the Row or
Column
window. The control value is any numeric
value. Next, you must
tell
FSG what budget relates to the Control Value.
You do this in the
Define
Report form. When you define a control
value for either your Row
Set
or Column Set in your report, the Control Value button will be activated.
By
selecting the Control Value button you can assign budgets to your control
values.
Another
reason you may not be seeing your amounts is if you are using the
YTD-Budget
(FY End) amount type, but have not budgeted to every period in
the
fiscal year. See Note
1036437.6.
8.
How do you enable FSG security?
First,
you define security rules for specific account segment values.
Then,
you assign your security rules to specific responsibilities. Lastly,
you
set the profile option 'FSG: Enforce
Segment Value Security' to YES.
Flexfield
value security has been enhanced in Release 11.5, with hierarchical
security.
Instead of having to create security rules for a range of segment
values,
you can assign security rules at the parent level and have the rules
automatically
apply to all of the child values within the parent hierarchy.
To
use this, choose the Security Type of Hierarchical for the value set,
on
the Value Sets form. See Note
138143.1 for more information.
9.
How can you add/define/create your own new amount types in FSG reporting?
Oracle
comes with seeded amount types, which can be specified in the
Balance
control region of a FSG row or column definition. You cannot create
your
own.
10.
Where should the period offset and the amount type be specified?
The
period offset and amount type must both be specified in the row set or
both
be specified in the column set. You cannot have a period offset in the
row
set and an amount type in the column set, or vice versa.
11.
On a calculation column, can I enter an amount type?
You
should not define rows or columns that contain both calculation
information
and an amount type. If you do, the amount type will override
and
this may cause errors.
12.
Is there a quick and supported method of transferring FSGs between
environments,
so that users do not have to key them in twice?
Run
the FSG Transfer program (under Report/Request/Standard) to copy
report
objects from one General Ledger database (or instance) to another.
You
can copy row sets, column sets, reports, report sets, content sets,
row
orders, display sets, and display groups.
Prerequisites
-
You or your System Administrator must define database links.
-
The chart of accounts in the set of books in your source database must
be identical to the chart of accounts in the
set of books in your target
database.
-
Any currencies and sets of books referred to by the row sets and column
sets being copied must exist in the target
database.
-
Report details, such as budgets and encumbrance types, referred to by
copied reports must exist in the target
database.
-
You must be logged into General Ledger and connected to the target database.
-
The target and source apps releases must be the same. See Note
1083689.6
for more information.
If
any of the prerequisites are not met, you will not be able to use FSG
Transfer
to copy the report objects. You will have to enter them manually
in
the target set of books.
13.
What FSG enhancements are introduced in Release 11i ?
Unlimited
Width Reports
Oracle
General Ledger now allows you to create FSG reports with an unlimited
number
of columns. FSG will pick the widest of the column set header or the
total
width of all the columns to determine the width of the report. However,
while
printing, there is still a limit of 255 characters.
Absolute
Value Function in Reports
To
ease reporting, you can now use the absolute value function in row set
definitions
to display amounts as positive numbers, regardless of their
debit
or credit balances. This function is helpful for defining income
statements,
balance sheets, and other financial reports in which amounts
are
generally displayed as positive numbers.
14.
Can I remove the 'No specific Company requested' text from the FSG
heading?
The
text 'No specific Company requested' will appear as long as no
content
set is used for the report. A content set must be specified
for
this text not to appear. Depending on the content set parameters
the
actual segment value description or the text 'No specific Company
requested'
will appear. For example, when Display is set to 'PE' a
separate
report is generated for each value and the specific value's
description
is displayed, rather than 'No specific Company requested'.
This
text will also change if you enter a Segment Override for Company
(segment)
at runtime on the Run Financial Reports form. By doing this,
you
are running the FSG for only the Company value you specified.
15.
Can I remove the segment header descriptions from the top of the FSG
reports?
The
accounting flexfield segment headings (CO, REG, etc.) can be
removed
with the use of a Row Order. See Note
1037253.6 for instructions
on
how to do this.
16.
Can I customize or move the 3 heading lines that appear at the top of
the
FSG (set of books, report name, period)?
The
first line of the FSG report heading contains the set of books
name.
This information can not be changed.
The
second line of the FSG report heading contains the report name.
For
Release 10, this is the Row Set name that is used in the FSG.
For
Release 11 and 11i, this report name is defined in the Report definition
(Navigation
= Reports/Define/Report).
The
third line contains the period that the FSG is being run for. This
can
not be changed.
The
date and time in the upper right corner indicates when the report
was
created. The page number appears here also. This can not be changed.
ADI
can be used to publish the FSG report, using a theme that you
customize
to make some of these changes. See the Application Desktop
Integrator
User's Guide for more information.
17.
How can I display USD and STAT amounts on the same FSG report?
On
the Define Rowset form:
Make
sure you have the following set up:
STAT
Accounts
--
Set the 'Currency' field to STAT for accounts that are STAT only.
--
Set the 'Control Value' field to 1 for accounts that are STAT.
USD
Accounts
--
Set the 'Currency' field to USD.
--
Leave the 'Control Value' field blank for USD accounts.
On
the Define Column Set form:
Under
Balance Control Option - Do not input any Currency or Control values
(i.e.
leave fields blank). (If you enter a Currency on the Column also,
FSG
will report 0 in intersection of the row and column.)
18.
How can I report on a multiple level account hierarchy in an FSG?
To
report on Multiple Hierarchy levels (child, parent, grandparent, etc.)
in
FSGs you have to have as many sequences in the row set as the number of
parents/grandparents/great-grandparents
that you wish to report on.
You
can not report on all levels by defining a single row sequence.
See
Note
1014255.102 for more information on how to do this.
19.
How can I define an FSG percentage calculation Column such as
percent
of sales?
When
defining a row, you can enter a value in the 'Percent of Row' field.
The
value entered in this field is the sequence number of the row, that will
be
used as the denominator in the calculation of the percentage column.
See
Note
1014921.6 for detailed instructions.
20.
Can an FSG output be created in PDF format?
No.
That functionality is not available. Enhancement Request 1569021 has been
logged
for this.
21.
What is the meaning of 'n/m' on my FSG?
The
means 'no meaning'. FSG displays this when there is a calculation
that
is attempting a divide by zero. You cannot remove this, or change
it
to any other value (other than changing the calculation itself so
it
doesn't result in a divide by zero).
22.
I used column set builder to set the width of the last column in my report.
After
saving and requerying the column set, the width has changed. Why?
The
width of the last column can only be controlled through the format mask.
Define
the format mask of the last column to be as wide as the desired width
of
the column.
23.
Can FSG reports and components be secured/protected so only certain
people
can modify or run them?
No.
You can only restrict/protect the data that is reported on in the
report.
You cannot restrict access to the reports and components themselves.
24.
How do segment overrides, content sets, account assignment ranges
and
display types work together?
For
a detailed explanation, see Note
207779.1.
25. When hiding data using a Display Group/Set in
FSG the underline under
that
data still appears.
The
underline character is part of the format option and is not affected
by
the display set definition, which only hides the actual data.
The
work around is to remove the underline from the row definition
prior
to running the report.
26. I'm using a Content Set with a range of cost
centers. There are some
inactive
cost centers within that range. How can I suppress the creation
or
printing of the reports for those inactive cost centers, or for disabled
or
inactive accounts?
There
is no way to exclude particular values that are included in the range
you
defined in the content set, or in an account assignment range in a
row
or column set. You must define new
ranges that do not include those
inactive
cost centers or accounts.
27. How can I define a column to be for a
specific or constant period,
such
as January of the current year, or dynamically change the period?
This
functionality is not available.
FSG
uses the period Offset, and the runtime period you enter, to determine
which
periods to report on. Use a negative number to report on periods
prior
to your runtime period, and a positive number to report on periods
after
your runtime period. For example, a column with an offset of 0 will
contain
amounts for the period you entered at runtime. A column
with
a -1 offset will contain amounts for the prior period, a -2 will
contain
amounts for a period 2 earlier than the runtime period. An offset
of
1 will give you amounts for the period following the runtime period
(providing
that period has been opened before).
28. Why can some column sets be viewed/used with
different sets of books
and
others cannot?
If
account assignments have been defined in the column set, then that
column
set is only available to sets of books that use that same chart
of
accounts. If there are no account
assignments in them, and the same
chart
of accounts (accounting flexfield structure) is used between sets
of
books, then they should be available to all of those sets of books.
29. How do I see the SQL code behind the FSG
report?
The
FSG reports are created from a program written in 'C' code, not
from
Oracle Reports, as is the case with standard reports.
Many
modules and tables are used to create reports based on the definition
and
component of a particular FSG. This would make looking at code for an
FSG
report (as you would a standard report) almost impossible. One approach
is
to turn the profile FSG: Message Detail to FULL and run the report. The
logfile
will contain some of the SQL. A session level trace will provide
all
of the SQL. See Note
141278.1 for information on how to get the trace.
30. How do I show the YTD amount for the end of
the fiscal year on an FSG?
In
Release 11i, there is a patch available (2650861) that will allow
you
to use an amount type called YTD-Actual (FY End). Used without a
period
offset, FSG will give you the YTD balance for the fiscal year the
report
is run for. This amount type only pertains to the very last
period
of the current fiscal year and the status of that period must
be
Open or Closed. Current fiscal year means the year the period you
are
running the FSG for falls into.
If
you use a period offset with the YTD-Actual (FY-End) amount type, and
the
resulting period falls into another fiscal year, it will get the year
to
date balance for that year.
In
release 11.0 and 10.7, you must still use the YTD-Actual amount type and
the
offset for the last period of the year.
31. Can I create an FSG in html format?
Not
from the standard application. In the applications you have a choice
of
3 output options: 1) Text, 2)
Tab-delimited - for importing into a
spreadsheet,
or 3) Spreadsheet - for downloading to
ADI.
You
can create an FSG in html format in ADI (Applications Desktop
Integrator).
32. How can I run an FSG from the Standard
Request Submission form?
Add
the program 'Program - Run Financial Statement Generator' to your
Request
Group. See Note
1060806.6 for detailed instructions.
33. When using a content set, sometimes the
amounts are duplicated
(doubled
or tripled).
The
values defined in a content set override the values defined in the
row
set account assignments. Depending on how your account assignments
are
structured, this may result in duplication of the account assignment
ranges.
See Note
147218.1 for an explanation and workaround.
Note:121769.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
Global Consolidation FAQ
|
Creation Date:
|
10-OCT-2000
|
Type:
|
FAQ
|
Last Revision Date:
|
15-JUN-2004
|
Status:
|
PUBLISHED
|
||
ORACLE
GENERAL LEDGER Global Consolidation
------------------------------
FREQUENTLY
ASKED QUESTIONS
--------------------------
May
2003
CONTENTS
--------
1. Can you drilldown to subsidiary subledger
details?
2. What do the consolidation Run options
mean?
3. GLXCAR:
Shows a difference in December Consolidation.
4. Consolidation of translated balances caused
wrong numbers for misclassified
account.
5. How do you keep from doubling the data when
re-running Consolidation?
6. When Consolidating for the first time choose
YTD Amount.
7. Consolidation of Two Master Organizations
into One.
8. Consolidation List of Values for Period
contains no entries.
9. Clarification of Journal Type and Average
Balance Processing.
10.
How to get Net Change when running Consolidation?
11.
How do you select Subsidiary Calendar from GLXCORST?
12.
You ran a consolidation and the accounts do not appear to be mapped as
you expect?
13.
How do you select the range of accounts to be consolidated?
QUESTIONS
& ANSWERS
-------------------
1. Can you drilldown to subsidiary subledger
details?
You
have run consolidation successfully. You
want to know if you can
perform
drilldown to your subsidiary subledger details.
From
your consolidated parent set of books, you can drilldown to account
balances,
review consolidation journal entries, drilldown further to
subsidiary
sets of books, review subsidiary account balances, then drilldown
even
further to subsidiary journal entries and even to your subsidiaries'
subledger
details.
Responsibility
= General Ledger SuperUser
Navigation
= Inquiry/Account
a. Perform an account inquiry in your
consolidated parent set of books.
b. Click on the Show Journal Details button to
drilldown to the Journals
window.
c. Select a consolidation journal batch whose
details you want to review.
(The source of the batch should be
Consolidation).
d. Click on the Drilldown button to view the
Consolidation Drilldown window.
The window displays information about the
subsidiary balance that was
consolidated to the parent.
e. To view the subledger detail information,
Click on the Journal Details
button.
You see the batch name, journal entry name, source, currency,
line and entered debits and credits for
journals that effected the selected
detail balance.
However
we cannot drilldown to subledger data if you maintain multiple sets of books in
multiple application instances
Note:
106742.1
2. What do the consolidation Run options
mean?
The
function of each of the 3 Consolidation Run Options is listed below:
Run
Journal Import:
If
you select 'Run Journal Import' option by checking the check box [X],
the
system will automatically start the journal import process.
Audit
Mode:
If
you select the 'Audit Mode' option, a report of the consolidation
Process
will be generated.
Create
Summary Journals:
If
you select 'Create Summary Journals' option, only summary amounts will be
created
for each account. If this option is not
checked, it will import in
detail
mode.
Note:
1048373.6
3. GLXCAR:
Shows a difference in December Consolidation
You
executed the consolidation process and an unbalanced journal is generated.
If
you look at the Consolidation Audit Report, there is a difference.
The
problem is that the consolidation rules were defined with overlapping
account
ranges. Review consolidation rules and fix the overlapping ranges:
a.
Navigate to Consolidation/Define.
b.
Query up the consolidation.
c.
Press [Account Rules] Button
d.
Look for the rules with overlapping ranges and update them.
e.
Repeat 3 and 4 for the "Segment Rules" Button
When
you have overlapping ranges in the consolidation rules, the same
information
is consolidated more than once and it can generate an unbalanced
journal.
Note:
1082973.6
4. Consolidation of translated balances caused
wrong numbers for misclassified
account.
You
had an ASSET account that was classified as an expense, thereby causing it
to
close out into retained earnings at the end of the fiscal year. You chose
only
to correct the account type and just make a journal entry to correct the
balances
in the first period of the new year. You
then ran translation for the
First
period of the new year. Then you ran the
consolidation program, and
posted
the entry in the consolidated set of books.
The balance the above
mentioned
account did not appear to be correct.
The
problem is that you did not make the entry to correct the balances in the
first
period in the consolidated set of books, thereby getting only period to
date
activity in the account. After you made
the entry the year to date
balance
was correct.
5. How do you keep from doubling the data when
re-running Consolidation?
You
ran Consolidation once, then you ran it again.
The
data has doubled.
If
you ran Consolidation a second time and re-posted the data, it would be
doubled. You need to reverse out the previous
Consolidation Journal as
follows:
Responsibility
= General Ledger Super User
GUI
Navigation = Journals/Enter
a. Query up the Consolidation Journal
b. Click on the [More Actions] button
c. Click on the [Reverse Journal] button to
reverse.
You
need to reverse out the previous Consolidation Journal.
Usually
Consolidation is rerun because there is a problem/error in the first
run. In this case, the previous posted batch needs
to reversed.
Note:
146209.1
6. When Consolidating for the first time choose
YTD Amount.
When
running consolidation for the first time, it is best to run a YTD
consolidation
instead of a PTD consolidation. PTD
consolidation will only
consolidate
the period net activity. If you want to
consolidate the subsidiary
book's beginning balances, you will need to
run a YTD consolidation.
Also,
if you are consolidating a first-ever translated period, the using PTD
consolidation
is probably a bad idea -- due to a lack of history you cannot
really
distinguish the translated begin balances from the translation
adjustment
for the new rate. Both get clumped into
the begin balance.
7. Consolidation of Two Master Organizations
into One
You
would like to know if there is any documentation that discusses the
consolidation
of two master organizations into one.
You would like to know
how
to migrate from multiple master organizations to a single master and
3
children.
See
the Oracle Applications Release 10.7 for UNIX, Upgrade Preparation Manual,
p.11-22
through 11-24 for instructions on consolidation two master
organizations
into one.
8. Consolidation List of Values for Period
contains no entries
You
have recently created a new set of books.
You are trying to run a
Consolidation
for the first time using your new set of books as follows:
Responsibility
= General Ledger Super User GUI
GUI
Navigation = Consolidation/Run
GUI
Form Name = GLXCOSUB (Consolidate Set of
Books)
1.
Navigate to Consolidation/Run.
2.
With your cursor in the Consolidation field, click on your list
of values (LOV) from the toolbar and
select a consolidation name.
Populate the following fields as listed
below:
a. Balance Type = Actual
b. Method
= Balances
c. Currency
= <functional currency>
d. Amount Type
= <PTD> or <YTD>
3.
In the 'From Subsidiary' region:
a. Set of Books = <new set of books>
b. In the Period field, when you click on the
LOV icon,
you receive the following
error:
FRM-41830 List of
values contains no entries
c. When you try to type in the period name, you
receive the
following error:
FRM-40212 Invalid value
for STANDARD_TO_PERIOD_NAME
You
need to open the first period of the subsidiary set of books as follows:
Responsibility
= General Ledger Super User GUI
GUI
Navigation = Setup/Open/Close
GUI
Form Name = GLXOCPER (Open and Close
Periods)
This
will spawn a concurrent process. Once
this completes successfully,
your
list of values will include the Open and Future Enterable periods.
This
was a newly defined set of books. No
periods were opened, they were all
Future
Enterable. A period needs to have a
status of 'Open' in order to be
consolidated.
Note:
1035827.6
9. Clarification of Journal Type and Average
Balance Processing
You
need clarification on the Journal Type and Average Balance Processing
information
that is documented.
General
Ledger has two tables that store balances, GL_BALANCES and
GL_DAILY_BALANCES.
For
a non-consolidation set of books:
-
You do not select a Journal Type.
-
Posting will update the GL_BALANCES.
-
Posting will update GL_DAILY_BALANCES if average balance processing is
enabled
For
a consolidation set of books:
-
The link exists between GL_BALANCES and GL_DAILY_BALANCES
(i.e.,
causing a post to update both tables)
-
You can specify the Journal Type (Standard or Average)
-
The Standard Journal Type usage will cause GL_BALANCES only to be updated.
-
The Average Journal Type usage will cause GL_DAILY_BALANCES only to be updated.
-
In a consolidation set of books, with Average Daily Balance enabled you would
want more control over average balances
maintained by date. Hence the
option
was provided to allow posting using a journal
type of Average which affects
only the GL_DAILY_BALANCES.
When
does the calculation of averages occur?
Data
is stored in the GL_DAILY_BALANCES table and information is
calculated
and output at run time based on the query or report being run.
Note:
1072012.6
10. How to get Net Change when running
Consolidation?
You
are running YTD Balance Consolidation. You notice that the journal entries
created
by the consolidation process is :
Debit = Begin_balance_dr +
period_net_dr
Credit = Begin_balance_cr +
period_net_cr
You
were expecting to see the net change.
How does YTD Balance Consolidation
work?
What is it used for?
When
running consolidation by YTD Balances, the journal entry created by
consolidation
is based on:
Debit = Begin_balance_dr + period_net_dr
Credit = Begin_balance_cr + period_net_cr
YTD
balance consolidation does not produce the net change. To get the net
change,
run consolidation using PTD for each of the periods or QTD for each
of
the quarters. Thus, QTD would be the
amount type and they would need to
run
it for Q1, Q2, Q3, and Q4.
YTD
consolidation is used when you want to create a new set of books from an
old
one.
Note:
1018113.102
11. How do you select Subsidiary Calendar from
GLXCORST
You
are using Oracle General Ledger version 11.XX and are trying to
consolidate
several subsidiaries into one parent using a data set where the
children
do not share the same calendar as follows:
Responsibility
= General Ledger Super User
GUI
Navigation = Consolidation/Transfer/Data Set
GUI
From Name = GLXCORST (Transfer
Consolidation Data Set)
1.
Navigate to the Transfer Consolidation Data Set window by
clicking on Consolidation/Transfer/Data
Set.
2.
Query the Data Set by placing your cursor in the Mapping Set
and clicking the list of values icon on
your toolbar.
3.
When you enter the Subsidiary Default Parameters Period, the
only calendar displayed in your list of
values is the Parent
calendar.
This does not match the calendar for one or more of
the subsidiaries you want to
consolidate.
In
order to select from your list of values, a calendar for the subsidiaries
which
do not share the same calendar as the parent, you will need to do the
following:
Responsibility
= General Ledger Super User
GUI
Navigation = Consolidation/Transfer/Data Set
GUI
From Name = GLXCORST (Transfer
Consolidation Data Set)
1. Navigate to the Transfer Consolidation Data
Set window by
clicking on Consolidation/Transfer/Data
Set.
2. Query the Data Set which has the mapping you
would like to consolidate
by placing your cursor in the Mapping Set
field and clicking on the
list of values icon on your toolbar.
3. Select the Subsidiary Default Parameters
'Period' you would like to
consolidate from the list of values.
4. Select the Parent Period 'Standard' value you
would like to consolidate
from the list of values.
5. Click on the [Query Mappings] button to query
the mappings in the
mapping set.
6. Click on the [Apply Defaults] button to apply
the defaults
for these mapping sets.
7. You should now be able to select the
mapping(s) which contain the
subsidiary with the calendar that is
different than the Parent calendar.
8. Once you select the Subsidiary Period for
that mapping set, the
subsidiary calendar should be displayed in
your list of values.
9. You can then save these settings and the
calendars will be set up for
the Data Set.
Note:
1016557.102
12.You
ran a consolidation and the accounts do not appear to be mapped as
you expect?
You defined your Consolidation mapping:
Responsibility = General Ledger Super User
GUI Navigation = Consolidation/Define/Mapping
GUI Form Name = Consolidation Mapping
(GLXCODEF)
Click on the [Segment Rules] button and
define the mapping as follows:
Parent Action Subsidiary
--------------------------------------------
Segment 1 Copy Value Segment 1
Segment 2 Copy Value Segment 2
Segment 3 Not assigned
Segment 4 Copy Value Segment 4
Segment 5 Copy Value Segment 5
Click the [Account Rules] button and assign
a range of subsidiary
accounts to be mapped to a parent account
code combination in the parent set
of books.
When
you run the consolidation, the range of subsidiary accounts map to
that
specific parent account code combination you defined in the Account
Rule,
not the value you were intending.
Solution
Description
--------------------
To
correctly map your subsidiary accounts, Segment 3 Action should be
'Use
Rollup Rules From', instead of 'Not Assigned'. Then under the
Rollup
Rules section, map a range of detail values from your subsidiary
set
of books into one detail value in your parent set of books.
You
can enter multiple rollup rules for a single segment as long as the
segment
values specified in each rule do not overlap.
You
can enter more than one subsidiary segment range as long as the
segment
values included in the ranges do not overlap.
Account
rules override segment rules if there is any conflict.
13.
How do you select the range of accounts to be consolidated?
On
the Transfer Consolidation Data form, after you display or define
your
consolidation, click the Select Accounts button. Define the
ranges
of accounts to be consolidated.
.
Note:138138.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
Oracle General Ledger Intercompany Journals FAQ
|
Creation Date:
|
28-MAR-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
19-MAY-2004
|
Status:
|
PUBLISHED
|
||
ORACLE
GENERAL LEDGER
---------------------
INTERCOMPANY
JOURNALS
---------------------
FREQUENTLY
ASKED QUESTIONS
--------------------------
May
2004
CONTENTS
--------
1. What is the Intercompany Segment in 11i? Is
it backported?
2. How do I define Intercompany Accounts in
Release 11i?
3. Is a separate value set required for the
Intercompany Balancing Segment?
4. How does the new Intercompany Segment improve
intercompany accounting?
5. Can Intercompany Segments be used with
clearing companies?
6. How are Intercompany journal lines created in
General Ledger 11i?
7. Is it possible to implement Intercompany
Balancing Segment in an existing
Set of Books?
8. In Rel 11i with the intercompany segment, is
it possible
to have a security rule on the balancing
segment without it
affecting the intercompany segment, since
they share the same value
set?
9. How are lines identified that are created by
automatic intercompany
balancing? How do you determine which rows
in the GL_JE_LINES table
have been created by the automatic
intercompany balancing process?
10.
Is it possible to balance an intercompany journal not only within
the balancing segment but within other
segments of the accounting
flexfield?
QUESTIONS
& ANSWERS
-------------------
1. What is the Intercompany Segment in 11i? Is it
backported?
Answer
------
The
Intercompany Segment Flexfield Qualifier can be used with the Intercompany
Balancing
feature in Release 11i. The user can assign a segment to be
the
intercompany segment. When a journal entry that affects multiple
balancing
segment values is posted, the Intercompany Balancing feature
will
automatically create journal lines to ensure each balancing segment
value
is balanced, and the balancing segment value of the appropriate
trading
partner will be automatically entered as the intercompany segment
value
for each journal line. The Intercompany Balancing feature is only
available
in Release 11i, and has not been backported to Release 11.
References
----------
See
Note
100326.1 for more information.
2. How do I define Intercompany Accounts in
Release 11i?
Answer
------
-
Navigate to the Intercompany Accounts form (Setup/Accounts/Intercompany).
-
Specify the Source and Category that apply to the intercompany
account(s) you are defining.
-
Select Summary or Detail Balance.
-
Complete the Clearing Company Usage and Default Options tabs.
-
Define your specific balancing segments and accounts in the
Intercompany Detail region.
References
----------
See
Note
119506.1 and Note
132288.1 for more information.
3. Is a separate value set required for the
Intercompany Balancing Segment?
Answer
------
The
intercompany segment shares the same value set as the balancing
segment
and is used in the account combination that Oracle General
Ledger
creates to balance intercompany journals. They can use separate
values
sets, but they must be identical.
References
----------
See
Note
110450.1 for more information.
4. How does the new Intercompany Segment improve
intercompany accounting?
Answer
------
-
Specified intercompany accounts means quicker reconciliations.
-
Maintain granularity for due-to and due-from companies tracking, even
for multicompany transactions.
-
You can now balance intercompany journals based on multiple parameters,
including:
Journal Source
Journal Category
Balancing Segment Value
-
Your intercompany accounting rules may also include different accounts based
on whether the balancing amount should be
posted to a credit account
(due to) or debit account (due from). At the
journal source and category
level, you can choose a default clearing
company against which all
trading partners balance. You can also specify whether intercompany
journal balancing is performed at a
summarized level for each trading
partner or at the journal line level.
References
----------
See
Note
110440.1 for more information.
5. Can Intercompany Segments be used with
clearing companies?
Answer
------
Yes.
You can designate one company to act as the trading partner for all
subsidiary
companies in the organization for certain types of intercompany
transactions.
References
----------
See
Note
110336.1 for more information.
6. How are Intercompany journal lines created in
General Ledger 11i?
Answer
------
Using
Intercompany functionality there are four options to automatically
account
for intercompany transactions in a single set of books.
Standard
Intercompany Balancing
Automatic
Intercompany creates generic balancing lines against the
intercompany
accounts that are defined for specific sources and categories.
Enhanced
Intercompany Balancing
This
allows definition of separate intercompany accounts to record more
detail
for the intercompany journals and track the intercompany balances.
Intercompany
Segment Balancing
Instead
of using different natural accounts to track intercompany
balances,
it is possible to use an intercompany segment in your chart
of
accounts to record the same detail as enhanced intercompany
balancing.
Clearing
companies
It
allows to define one company to act as the trading partner for
all
subsidiary companies in the organization for certain types of
intercompany
transactions.
References
----------
See
Note
151130.1 - How Intercompany Journals Are Created in General Ledger 11i.
7.
Is it possible to implement the Intercompany Balancing Segment in an
existing
Set of Books?
Answer
------
Oracle
General Ledger does not have a process to change the accounting
flexfield
structure of an existing set of books. It is not supported
or
recommended to add a new segment to an accounting flexfield
structure
that is being used. In this case, it is necessary to define
a
new set of books that includes the new Intercompany segment.
References
----------
See
Note
110461.1 Implement Intercompany Balancing Segment to
an
Existing Set of Books.
8. In Rel 11i with the intercompany segment, is
it possible
to have a security rule on the balancing
segment without it
affecting the intercompany segment, since
they share the same value
set?
Answer
------
Yes
it is possible. Enable security on the
value set. Enable security on
the
balancing segment in the accounting flexfield strucutre. Do not enable
security
on the intercompany segment in the accounting flexfield structure.
9. How are lines identified that are created by
automatic intercompany
balancing? How do you determine which rows in
the GL_JE_LINES table
have been created by the automatic
intercompany balancing process?
Answer
------
The
ONLY way you will be able to distinguish such transactions is from
the
entry in the DESCRIPTION column.
The
description column contains-> "Intercompany line added by
Posting".
10.
Is it possible to balance an intercompany journal not only within
the balancing segment but within other
segments of the accounting
flexfield?
Answer
------
It
is not possible. The Due From Account and Due To Account fields in
the
Intercompany Account screen are a template/skeleton where
the
only segment that can have different values, as required for balancing
purposes,
is the balancing segment.
The
Oracle General Ledger User's Guide, Release 11i, provides the following
information.
Chapter:
Accounting for Multiple Companies Using a Single Set of Books,
Section:
Intercompany Accounting for Multiple Companies with a Single
Set
of Books
Note: The balancing segment value you
define in the template
behaves dynamically in the resulting
balancing lines. It will
change based on the balancing segment
value of the trading
partner. The other segments in the
template remain unchanged
in the resulting balancing lines.
These account templates are used when
a transaction is
balancing against a specific company.
For example, if a
transaction is balancing against
company 01, then the accounts
defined for Company 01 in the Due
From and Due To Account
fields are used.
.
Note:50430.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
General Ledger FAQ
|
Creation Date:
|
05-JAN-1998
|
Type:
|
FAQ
|
Last Revision Date:
|
21-APR-2004
|
Status:
|
PUBLISHED
|
||
ORACLE
FINANCIALS
-----------------
General
Ledger
----------------
FREQUENTLY
ASKED QUESTIONS
--------------------------
28-JAN-02
CONTENTS
--------
1. Is EXCEL Version 7 supported with GLDI?
2. How do I change the current account code
combination structure?
3. How do I correct misclassified account types?
4. How do I run Journal Import using the consub
command?
5. Will the 32-bit version of the GLDI interfere
with 16-bit Oracle
Applications?
6. Can I reverse a budget upload?
7. Can I reopen a permanently closed period?
8. Can I drop the gl_posting_interim_xx tables?
9. What should I check before opening a new
period?
10.
How can I change the header of my FSG report?
QUESTIONS
AND ANSWERS
---------------------
1. Is EXCEL Version 7 supported with GLDI?
Answer
------
Yes
it is. EXCEL 7 has been supported since
ADI release 2.1.
2. How do I change the current account code
combination structure?
Answer
------
You
cannot change the current account code combination structure.
A
set of books consists of a Chart of Accounts, Calendar and Currency.
If
you must change any one of these three components, then a new set of books
must
be setup.
3. How do I correct misclassified account types?
Answer
------
Refer
to the section of the General Ledger Users Guide that
discusses
Misclassified Account Types. There are 9 steps required to correct
misclassified
account types and it is important to complete them in order.
Also
see Note
1050920.6 in MetaLink for more information.
4. How do I run Journal Import using the CONCSUB
command?
Answer
------
This
is sometimes used by support to diagnose problems. You need to
get
the request_id of the failed request or sometimes you will be asked to
run
the request and cancel it through the concurrent manager to get the
request
id.
The
syntax for running the concurrent submission for General Ledger
Journal
Import is:
$
CONCSUB <apps user>/<apps pw> SQLGL '<gl responsibility>'
<user> \
CONCURRENT
SQLGL GLLEZL <run_id> <set of books id> '<suspense>' \
'<start
date>' '<end date>' '<summary>' '<desc. flexfield>'
where: <run_id> : interface_run_id
<set_of_books_id> : set of books
id
<suspense> : (Y or N) Use suspense
<start date> :
"" Start
Date
<end date> :
"" End
Date
<summary> : (Y or N) Create Summary Journal
<desc. flexfield> : (Y or N) Import Descriptive Flexfields
N - No
W -
With Validation
O -
Without Validation
2 : This parameter is added to run
Journal
Import in debug
mode.
If you do not to
run in debug mode eliminate
the final
parameter.
5. Will the 32-bit version of the GLDI interfere
with 16-bit Oracle
Applications?
Answer
------
No,
because they have difference Oracle Homes.
6. Can I reverse a budget upload?
Answer
------
No,
however, you can override the previous budget amount.
To
do so, populate the gl_budget_interface table with the new
budget
amounts, set field update_logic_type to 'R', then run Budget Upload
again
to replace the old budget amounts.
7. Can I reopen a permanently closed period?
Answer
------
No,
you cannot open a permanently closed period.
8. Can I drop the gl_posting_interim_xx tables?
Answer
------
Yes,
you can. However, before doing so, you
should check the posting,
translation,
open period, or summarization processes that created these files.
The
gl_posting_interim_xx tables are temporary files and are normally erased
after
the process has completed successfully.
TIP: Wait a week or so before you delete the table
manually, just in case
your processes did not complete.
WARNING:
Do NOT delete the GL_POSTING_INTERIM and GL_SUMMARY_INTERIM tables
(i.e., the tables without the numbers at
the end of their name),
as these tables are used by the
General Ledger system.
9. What should I check before opening a new
period?
Answer
------
If
the open period program fails in module GLOIRE, then there is a problem
with
the
retained earnings account.
(a)
check each balancing segment value
(b)
check that the retained earnings account has been defined
(c)
if dynamic insertion has been turned on, check that the
creation of this account will not violate
any cross validation rules
10.
How can I change the header of my FSG report?
Answer
------
For
Release 10, this is the Row Set name that is used in the FSG.
For
Release 11 and 11i, this report name is defined in the Report definition
(Navigation
= Reports/Define/Report).
See
Note
1050469.6 for more information.
Note:136028.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
General Ledger MRC-FAQ
|
Creation Date:
|
21-FEB-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
02-FEB-2004
|
Status:
|
PUBLISHED
|
||
General
Ledger - MRC
----------------
FREQUENTLY
ASKED QUESTIONS
--------------------------
MAY-2002
CONTENTS
--------
FAQ
General ledger - Multiple Reporting Currencies
1. What is MRC?
2. Can MRC be used with the Multiple
Organization feature of Oracle
Applications?
3. What Applications support MRC feature?
4. When do the transactions entered in
subledgers get converted to the
reporting currency?
5. When Can I inquire on these reporting
currency transactions in the subledger
6. Can I use the same responsibility for
both Primary and Reporting sets of books?
7. Does opening the period in the Primary set
of books also open it in the
Reporting set of books?
8. Can I use a different chart of accounts
for my reporting set of books?
9. When
budgets are defined in the Primary set of books do they get recorded
in
Reporting set of books?
10. Do all journals entered or created in the
primary set of books get
recorded in the reporting set of books?
11. Can I assign more than one reporting set of
books to one Primary?
12. Does posting journals in the Primary set
of books also post them
in reporting set of books?
13. Do I
have to define conversion options for each set of books?
14. Can I change the effective date once I
start using MRC?
15. In what waysdoes the Profile option MO:
Operating Unit affect MRC?
16. How do document numbers get assigned to
journals?
17. When subledger posting is done for the
primary set of books does it
also occur for the reporting set of
books?
18. When revaluation is run in the primary set
of books does it also
revalue the balances in the reporting
set of books?
19. How does MRC handle journal import from
non-Oracle feeder systems?
20. How is the translation process in General
ledger used with MRC?
21. What is the difference between the
translation feature of
General Ledger and MRC?
22. How does reversing a journal in the
primary set of books affect the
reporting set of books?
23. Do the primary set of books and reporting
set of books calendars
have to be the same in General Ledger
(i.e. have the same first
ever period)?
QUESTIONS
& ANSWERS
-------------------
1. What is MRC?
MRC is a feature that allows for
transactions to be recorded in more
than one set of books/functional
currency by way of assigning reporting
set of books to a primary set of books .
The chart of accounts and calendar
have to be the same for the primary and
reporting set of books .
2. Can MRC be used with the Multiple
Organization feature of oracle
applications?
Yes , the operating unit/organization
must be the same for both the
primary and reporting sets of books.
3. What Applications support the MRC feature?
Assets
Cash management
Cost Management
General Ledger
Payables
Projects
Purchasing
Receivables
***Inventory does not support MRC.***
4. When do the transactions entered in
subledgers get converted to the
reporting currency?
The transactions are converted to the reporting currency at the
time
of original entry
5. When Can I inquire on these reporting
currency transactions in the
subledger?
They are available immediately in the
sub-ledgers as the transactions are
converted at the time of original entry
in the subledger.
6. Can I use the same responsibility for both
Primary and Reporting set of books?
No, two responsibilities have to be set
up, one for the primary and
reporting set of books
respectively.
7. Does opening the period in the Primary set
of books also open it in
the Reporting set of books?
No, periods have to be opened in both
sets of books individually.
8 Can I use a different chart of accounts
for my reporting set of books?
No, both primary and reporting sets of
books must use the
same chart of accounts and
calendar.
Only the functional currency can be
different .
9. When
budgets are defined in the Primary set of books do they get
recorded
in Reporting set of books?
No,
budgets have to be defined separately in the reporting set of books.
10. Do all journals entered or created in the
primary set of books get
recorded in the reporting set of books
?
The following journals get created in
the reporting set of books when
they are posted in the primary set of
books.
Manual
Recurring
Mass allocations
Journals that are imported from non
oracle applications.
11. Can I assign more than one reporting set
of books to one Primary?
Yes, up to eight reporting books can be
assigned to a Primary.
12.
Does posting journals in Primary books
also post them in reporting?
No,
Posting has to be done in the reporting sob.
13 Do I have to define conversion options for
each set of books?
In release 11 and 11iconversion options
are defined for each combination of
Oracle Application and operating unit
for which you want to convert
transactions to your reporting set of
books.
14
Can I change the effective date once
I start using MRC?
No, it is strongly recommended not to
change the effective date.
15. In what way does the profile option MO -
Operating unit affect the MRC?
If a reporting set of books is assigned
to a primary set of books then
this profile option should be set to
the same operating unit for both
the Primary and Reporting set of books
.
16. How do document numbers get assigned to
journals?
When a journal is entered in the
primary set of books the document
number assigned is determined by the
primary set of books and it will
be the same number in the reporting set
of books also .
17. When sub ledger posting is done for the
primary set of books does it
also occur for the reporting set of
books?
Subledger posting process to General
ledger must be done multiple times
once for the primary set of books and
then repeated for each reporting
set of books assigned to the primary
set of books .
Note: The one step subledger posting
feature is available by applying
the relevant patch .
18. When revaluation is run in the primary set
of books does it also
revalue the balances in the reporting
set of books?
No, revaluation must be run in the
primary set of books and in each
of the reporting set of books .
19. How does MRC handle journal import from
non-Oracle feeder systems?
After journal import is done for you
primary set of books from
non-Oracle feeder system and the
journals are posted successfully
in the primary set of books General
ledger creates converted journals
in the reporting set of books .
20. How is the translation process in General
ledger used with MRC?
If you use MRC you may not need to
translate your account balances,
as you can record your transactions in
multiple currencies by
assigning the required reporting sets
of books as per your business
needs.
21. What is the difference between the
translation feature of
General Ledger and MRC?
The translation feature of General
ledger is used to translate amounts
from the functional currency of the
primary set of books to another
currency at the account balances level,
but MRC in General ledger
is used to convert the functional
currency to another currency at the
transaction level.
22. How does reversing a journal in the primary
set of books affect the
reporting set of books?
When a journal is reversed in the
primary set of books General ledger
will also reverse the corresponding
journal in the reporting set of books.
The reporting journal uses the same
conversion rate that was used
to create the original entry .
23. Do the primary set of books and reporting
set of books calendars
have to be the same in General Ledger
(i.e. have the same first
ever period)?
No. The first ever calendar period in
the primary set of books
does not have to be the same as the
associated reporting book.
The 1st MRC Period is used by our
historical transactions/balances
conversion programs and does not need
to be entered if you are not
going to be using them.
The replication of data from the
primary book to the reporting book
is controlled by the From/To Effective
dates in the Assign Set of
Books form, Conversion Options
window.
You can further control the
sources/categories to convert or not
to convert in the GL Conversion Rules
window.
Note:105541.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
Oracle General Ledger 11i Drilldown Features FAQ
|
Creation Date:
|
14-APR-2000
|
Type:
|
FAQ
|
Last Revision Date:
|
20-OCT-2003
|
Status:
|
PUBLISHED
|
||
ORACLE
GENERAL LEDGER/SUBLEDGERS
--------------------------------
----------------
FREQUENTLY
ASKED QUESTIONS
--------------------------
QUESTIONS
& ANSWERS
-------------------
1.
What Subledgers does Oracle General Ledger 11i Drilldown support?
Answer
------
Drilldown
from Oracle General Ledger 11i is supported for Oracle Payables,
Oracle
Receivables, Oracle Assets (except depreciation), Projects, Purchasing,
Inventory,
and Work in Process (WIP).
See
Note
208756.1 for details.
2.
What are the application objects that support View Accounting and
Drilldown?
Answer
------
GL_Import_Reference_Table
(modified)
GL_SL_LINK_ID
GL_SL_LINK_TABLE
GL_JE_LINES
(modified)
GL_SL_LINK_ID
GL_SL_LINK_TABLE
New
views in the database:
FA_AEL_GL_V
FA_AEL_SL_MRC_V
FA_AEL_SL_V
3.
Where in Oracle General Ledger 11i can Drilldown be accessed?
Answer
------
You
can drilldown from GL Account Inquiry window and the GL Journal Entry
and
GL Journal Inquiry windows.
Nav: Tools -- Drilldown
4. What are the Release 11i subledger drilldown
features?
Answer
------
-
Expanded subledger drilldown, to other subledgers.
-
View Accounting Lines window.
See
Note 108369.1
for details.
5.
Get the following message on Drilldown - Function not available to this
responsibility.
Change responsibility or contact your system administrator.
Answer
------
Make
sure you have the Correct Menu attached to the Responsibility you are
using
to drill down.
6.
When you drill down to AX Payables or Receivables from GL, you get the
message
FRM-40350 Query caused no records to be retrieved.
Answer
------
Make
sure you set the Profile Option AX: Application Name to Null.
.
Note:137346.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
Mass Allocations FAQ
|
Creation Date:
|
22-MAR-2001
|
Type:
|
FAQ
|
Last Revision Date:
|
08-AUG-2004
|
Status:
|
PUBLISHED
|
||
ORACLE
GENERAL LEDGER
------------------------------
MASS
ALLOCATIONS
----------------
FREQUENTLY
ASKED QUESTIONS
--------------------------
21-MAR-2001
CONTENTS
--------
1.
Does the MassAllocation program check cross validation rules?
2.
Can you copy a MassAllocation to a MassBudget Allocation?
3.
Are Mass Allocation/Budget formulas specific to sets of books?
4.
Can you use the Constant (C) segment type with parent segment values?
5.
How are MassAllocation entries calculated: Full vs. Incremental?
QUESTIONS
& ANSWERS
-------------------
1.
Does the Mass Allocation program check cross validation rules?
Answer
------
The vaidation portion of the program does
NOT check for violations
of account cross validation rules. Invalid lines will be created and
you will have to correct the resulting
journals in the Enter Journals
Window before you post.
References
----------
Oracle General Ledger User's Guide Rel 11i,
Vol 1, page 1-79.
2.
Can you copy a Mass Allocation to a Mass Budget Allocation?
Answer
------
No, it is not possible to make a copy from
one to the other.
3.
Are Mass Allocation/Budget formulas specific to sets of books?
Answer
------
They are specific to the accounting
flexfield structures, not to sets of
books.
If you have two sets of books using the same flexfield structure
you could run a MassAllocation defined in
one or the other set of books.
The responsibility you are in would
determine which set of books the
journal entry would be created for.
4.
Can you use the Constant (C) segment type with parent segment values?
Answer
------
Yes, but you can only do so if there is a
summary account associated
with the parent. To use summary accounts in the formula, all
segments in the formula must be assigned a
segment type of Constant (C).
5.
How are MassAllocation entries calculated: Full vs. Incremental?
Reference
---------
Please review Note:1042232.6
Note:182047.1
|
Content Type:
|
TEXT/PLAIN
|
|
Subject:
|
General Ledger Summary Template FAQ
|
Creation Date:
|
27-MAR-2002
|
Type:
|
FAQ
|
Last Revision Date:
|
26-AUG-2002
|
Status:
|
PUBLISHED
|
||
ORACLE
GENERAL LEDGER
------------------------------
SCOPE
& APPLICATION
-------------------
External
users and internal support analysts.
FREQUENTLY
ASKED QUESTIONS
--------------------------
28-Mar-2002
CONTENTS
--------
1.
Is there a limit on the number of summary accounts that can be created per
the
Summary Template process?
2.
How should you address the maintenance of summary templates when new values are
added?
3.
Can the "Deleting" status in the Summary Templates screen be reset
back to
"Current" without actually
deleting and reading all the summary account templates?
4.
What does 'Unfreezing Rollup Groups' do?
5.
Does Add/Delete Summary Program dynamically create accounts that meet the
summary
template criteria?
6.
How many concurrent requests are generated when you run the Add/Delete Summary
Program?
7.
Will the history of an old summary template be in Summary Account Inquiry?
QUESTIONS
& ANSWERS
-------------------
1.
Is there a limit on the number of summary accounts which can be created per
the
Summary
Template process?
There
are no limits on the amount of accounts which can be created by the
Summary
Template
process however, the more templates created/maintained, the slower the
performance
of the concurrent programs.
2. How should you address the maintenance of
summary templates when new values are added?
Redefining
summary templates can be confusing at times.
Note:61272.1
addresses this process.
3.
Can the "Deleting" status in the Summary Templates screen be reset
back to "Current"
without actually deleting and reading all
the summary account templates?
You
cannot update the status via SQL*Plus to "Current". These must be deleted and the
summary
accounts recreated.
4.
What does 'Unfreezing Rollup Groups' do?
When
this is done, you will be able to quick pick on the Rollup Group name on the
Define
Segment
Values form.
5.
Does Add/Delete Summary Program dynamically create accounts that meet the
summary
template criteria?
NO,
It just groups the existing accounts to meet the summary template criteria.
6.
How many concurrent requests are generated when you run the Add/Delete Summary
Program?
Example:
4 requests: 1 for the parent and 3 for
child accounts.
7.
Will the history of an old summary template be in Summary Account Inquiry?
NO. When you drop a summary template, and
reassign the child values, Summary Account
Inquiry
does not save the history of the previous accounts.
No comments:
Post a Comment