Search This Blog

Tuesday, April 23, 2013

Oracle Apps GL Interview Questions



Oracle Apps GL Interview Questions

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
             Note 1062487.6


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. 
    Note 176329.1


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

    Note 148541.1 
    Note 139403.1

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
------

8.  8.  Where is the document sequence number kept when you delete an invoice in AP?

Answer
------

9.  Unable To Create Journal Due To Error APP-FND-0172810. 

Answer
------

Document sequences only apply to actual journal entries. Budget and encumbrance 
journal entries will not work with document sequencing.
Document categories for Journal Entries must be setup in GL.  Following is a
brief explanation of how to set up document sequencing for journal entries.

Note:136633.1
Content Type:
TEXT/PLAIN
Subject:
General Ledger Budgets FAQ
Creation Date:
07-MAR-2001
Type:
FAQ
Last Revision Date:
02-AUG-2004
Status:
PUBLISHED

ORACLE GENERAL LEDGER
------------------------------
BUDGETS
----------------
FREQUENTLY ASKED QUESTIONS
--------------------------
28-JAN-2002

CONTENTS
--------
1) Can you disable budgetary control for a set of books?
2) Is there a limit to the number of periods in a budget year
   or how many years a budget can span?
3) Why don't my Detail budgets roll up to my Master budget?
4) I was able to post a budget journal to a closed period, why?
5) How many 'Current' budgets can you have?
6) Why don't my budget amounts appear on FSGs?
7) What is a funding budget?
8) Why is my budget requiring budget journals? At the set of books
   level that option is not enabled.
9) Why can't I inquire on my budget amounts from INQUIRE/BUDGETS
   navigation path?
10) If I delete my budget org, will the budget amounts be deleted?
11) Can I update/adjust an existing account range in my budget 
    organization?
12) Can I delete a budget?
13) How many times can a budget be purged?
14) Why don't my asset and liability budgets roll forward?
15) Why do you receive an advisory warning during funds reservation
    of a manual journal entry, even though there are sufficient
    funds in the account?
16) Why is there no value in the REQUEST_ID column of GL_BUDGET_INTERFACE
    for rows with data that failed to be uploaded by the Budget Spreadsheet
    Upload program?
17) You are trying to open the next budget year.  After navigating to the form and
    querying the budget, you notice the [Open Next Year] button is grayed out.
18) You find that Account code combinations are not being added to the Budget 
    Organization? 

QUESTIONS & ANSWERS
-------------------
1) Can you disable budgetary control for a set of books?
  
ANSWER
-------
   Yes you can, however existing encumbrances are not cleared 
   from the feeder systems.  Therefore it is not recommended.
   If you do change the budgetary control options for an
   existing set of books, you must do two things for the change
   to be reflected.

   --Run the Period Map Maintenance concurrent request, it must
   complete successfully.
   --Exit Oracle Applications and restart.  You must completely exit
   the application...it is not sufficient to select Sign On Again 
   from the Oracle Applications Special menu.

   Ref: Oracle GL User's Guide, Rel 11, Vol 1, page 2-90

2) Is there a limit to the number of periods in a budget year
   or how many years a budget can span?

ANSWER
-------
   Your budget can include up to 60 periods per year and can span
   an unlimited number of fiscal years.

3) Why don't my Detail budgets roll up to my Master budget?

ANSWER
-------
   Detail budgets do not automatically roll up to the master budget.
   The GL uses summary accounts to maintain master/detail budget
   relationships between hierarchy levels. Summary templates are 
   defined so that accounts in your lower level detail budgets 
   roll up into the same summary accounts as the detail accounts
   in your controlling master budget. A common misconception is that 
   the detail budgets somehow roll up to the master budget by
   definition, this is not true.  You must actually budget to a 
   detail account in the master budget, this then serves as the 
   controlling amount for the detail budgets.
   Master/Detail budgets are used in the budgeting process to control
   authority and identify budgets that exceed control limits.
   They are not intended for reporting purposes.

4) I was able to post a budget journal to a closed period, why?

ANSWER
-------
   A budget journal can be posted to any period that is in an open budget
   year for that budget. This is regardless of the status of that period
   (closed, opened, or future enterable). 
 
5) How many 'Current' budgets can you have?

ANSWER
-------
   You can only have one current budget.  The only distinction between a 
   'current' and an 'open' budget is that the current budget defaults into
   the budget field on several budget related forms.  It can be replaced
   however by any 'open' budget in the field.

6) Why don't my budget amounts appear on my FSG?

ANSWER
-------
   To include budgets (encumbrances or currencies) in a FSG report, your
   report definition must specify a row set of column set that has control
   values specified in the Balance Control options.
   In the report definition itself, you associate budget names with the 
   control values that are assigned to the row or column set.

7) What is a funding budget?

ANSWER
-------
   It is a budget that requires journal entries, and is assigned to a summary
   template or account range in the budget org, where the funds check level
   is set at Absolute or Advisory.  It is the assignment that makes it a
   'funding budget', it is not done at the budget definition level. 
    see note 1044048.6 for details of setting funds check level.

8) Why is my budget requiring budget journals? At the set of books
   level that option is not enabled.
   
ANSWER
-------
   This would happen when the budget itself is defined to require budget
   journals.  This is done at the budget definition level.

9) Why can't I inquire on my budget amounts from INQUIRE/BUDGETS
   navigation path?

ANSWER
-------
   The Budget Inquiry form (GLXIQBUD) is used to perform inquiries about
   master and detail budgets. GL compares summary balances between your
   master and detail budgets, and checks for budget variances and 
   violations.  This form only looks at summary accounts.  To inquire
   on detail accounts you must use the navigation INQUIRE/ACCOUNTS, and 
   choose the 'budget' amount type.

10) If I delete my budget org, will the budget amounts be deleted?

ANSWER
-------
    No. Deleting the budget organization does not remove the budget amounts
    from the GL_BALANCES table.  

11) Can I update/adjust an existing account range in my budget 
    organization?

ANSWER
-------
    No. To update/adjust an existing account range, you must delete the
    old range and create a new range (which incorporates your adjustment).

12) Can I delete a budget?

ANSWER
-------
    No. Budget data can be deleted using the archive and purge functionality,
    but the budget definition itself cannot be deleted.

13) How many times can a budget be purged?

ANSWER
-------
    A budget can only be purged one time.  The archive/purge functionality
    was not designed to be a maintenace tool in the budgeting process.

14) Why don't my asset and liability budgets roll forward?

ANSWER
-------
    This is the current functionality.  An enhancement request has been
    logged.

15)Why do you receive an advisory warning during funds reservation of a manual 
   journal entry, even though there are sufficient funds in the account?

ANSWER
-------
    You are getting the advisory warning because your transaction is
    going against a detail account where no budget has been entered.
    So even though there are sufficient funds on the summary level,
    there are not sufficient funds at the detail level.

    The funds checking/reservation process will look at the funds
    check level for the detail account first, and then the funds
    check level for the summary account.

    The warning is alerting you to the fact that the detail account
    you are entering a transaction against does not have sufficient
    funds available.

    When you know there are sufficient funds at the summary level,
    you must either change your funds check level on your detail
    account to none (to only look at the summary level), or enter
    a sufficient budget to all the detail accounts that you will
    be entering transactions against, if you don't want to see
    the warning.
    Reference-Note 1074915.6

16) Why is there no value in the REQUEST_ID column of GL_BUDGET_INTERFACE
    for rows with data that failed to be uploaded by the Budget Spreadsheet
    Upload program?

    The request_id field is nulled out when the budget upload completes, 
    and errors were found in the data.

17)You are trying to open the next budget year.  After navigating to the form and
   querying the budget, you notice the [Open Next Year] button is grayed out.

  Responsibility = General Ledger Super User
  GUI Navigation = Budgets/Define/Budget
  Short Form Name = GLXBDDEF

  You query up a Budget that has already been defined and the [Open Next Year]
  button is grayed out for that Budget as well.

  You are trying to open the next budget year on February 8, 1998.
  Pertinent fields in the Define Budget Form are displaying the following 
  information:

     Status = Open

     Budget Periods Block-----------------------------------------
                First = JAN-97               Last = DEC-97       

     Latest Open Year = 1997
     -------------------------------------------------------------

  PROBLEM EXPLANATION
  -------------------

  The last day of the Last Period defined in your Budget has already passed.

  SOLUTION DESCRIPTION
  --------------------

  The Define Budget form looks at the periods you have defined as "First"
  and "Last".  Once the "Last" date has passed, you will no longer be
  able to open the next year (The "Open Next Year" button will be grayed out.)
  General Ledger views this Budget as finished since the end date has expired.

  According to the General Ledger User's Guide for Release 10SC, page 2-19,

     "You can change the last period to a later period only if the 
      period you are changing from corresponds to the last period
      of your fiscal year." 

  In many cases you will need to define a new budget.  When defining your
  budget remember that you can span an unlimited number of fiscal years.


18) You find that Account code combinations are not being added to the Budget 
    Organization? 

  PROBLEM DESCRIPTION
  -------------------

 Account code combinations are not being added to the Budget Organization.

 You have added the following range to a budget organization:

    Low                    High
    -----------------      -----------------
    000-13099-000-000      999-13099-000-000

 Responsibility = General Ledger Super User
 GUI Navigation = Budgets/Define/Organization (Form = GLXBDORG)

 Name = use the flashlight icon to find the Budget Organization you are 
       currently working on.

 Click on the [Ranges] button at the bottom of the window.
 Enter the low and high range. Save/Commit the changes. Exit the screen.

 When you go back to the Define Budget Organization window, click on the 
 [Assignments] button, the expected account code combinations have not
 been assigned to that Budget Organization.  You requery to verify.

 You run the Maintain Budget Organization Program, which will also force
 creation of accounts.  To do this, you navigate to the Define Budget 
 Organization window and click on the [Maintain] button. This does not add the 
 account code combinations either.

 You have also tried doing the following (to no avail):
  * Unfreezing, refreezing and compiling the accounting flexfield structure.
  * Running Program Optimizer from the Standard Report Submission Screen.
  * Deleting the assignment and adding the assignment.
  * Added account to parent.
  * Dropped / recreated summary template.



 SOLUTION DESCRIPTION
 --------------------

 Budgeting must be enabled in the Account Combination screen.

 Responsibility = General Ledger Super User
 GUI Navigation = Setup/Accounts/Combinations

 Do a query to pull up the desired combinations (Query Enter/Query Run).

 Make sure the Allow Budgeting box has been checked for all the account code 
 combinations within the range you assigned.

 SOLUTION EXPLANATION
 --------------------

 Assigning budget account ranges will assign accounts within the given range 
 if they have been enabled for budgeting.  Otherwise, they will fail.


Note:135433.1
Content Type:
TEXT/PLAIN
Subject:
General Ledger Open/Close Period FAQ
Creation Date:
12-FEB-2001
Type:
FAQ
Last Revision Date:
02-AUG-2004
Status:
PUBLISHED

ORACLE GENERAL LEDGER
---------------------
OPEN/CLOSE PERIOD
----------------
FREQUENTLY ASKED QUESTIONS
--------------------------
August 2002



CONTENTS
--------
1.  If we open the first period of the new year, can we still process
entries for the prior year(s)?
2.  I opened the first period of the new year without closing the prior year.
Will this cause a problem?
3.  The first period of my new fiscal year was opened and closed. What are
the ramifications to the roll forward process and retained earnings?
4.  We opened a period by mistake and need to set the status back to future
enterable? Can we do this?
5.  We created new periods after the last period defined was opened. Now we 
can not see those new periods on the Open/Close form. 
6.  Can I add a 13th period to my calendar?
7.  How do you open a permanently closed period?
8.  Is there a way to automatically open General Ledger periods?
9.  Open Period program is stuck in module gllock
10. Is there a way to get a Closing Journal


QUESTIONS & ANSWERS
-------------------
1.  If we open the first period of the new year, can we still process
entries for the prior year(s)?

Answer
------
Yes. You can still create entries for any period that has a status of Open
or Future Enterable. You can post to any period that has a status of Open.
If you post in a prior fiscal year, the balanced will be rolled foward and
retained earnings will be updated as needed.

 
2.  I opened the first period of the new year without closing the prior year.
Will this cause a problem? 

Answer
------
No. Closing a period in General Ledger does nothing more than close that
period. There is no processing that goes on behind the scenes when you close 
a period.


3.  The first period of my new fiscal year was opened and closed. What are
the ramifications to the roll forward process and retained earnings?

Answer
------
None. General Ledger will properly maintain the balances for the new year,
regardless of how many times the periods are opened or closed. Retained 
earnings is calculated when the first period of the new year is initially
opened, and thereafter when any posting is done to a revenue or expense
account in a prior year.


4.  We opened a period by mistake and need to set the status back to future
enterable? Can we do this?

Answer
------
No. There is no way within the application to set the period status back
to Future Enterable after the period has been opened. To do so would lead 
to data corruptions on a large scale.


5.  We created new periods after the last period defined was opened. Now we 
can not see those new periods on the Open/Close form. 

Answer
------
When Open Period runs, it sets the status of the next X periods to Future
Enterable. On the Set of Books form, you define the number of Future
Enterable periods. If, when you open a period, there are no subsequent
periods defined, the Future Enterable periods can not be updated. When
you define new periods in the calendar, the status will remain Never 
Opened, until you open the next period. At that time, the program will 
update the status to Open on the next period, and will update the status
to Future Enterable on the next X periods.


6.  Can I add a 13th period to my calendar?

Answer
------
No. You associate a Period Type with a Set of Books. The Period Type
is defined to have a fixed number of periods. That is the number of periods
you must define for your set of books - no more and no less.


7.  How do you open a permanently closed period?

Answer
------
You cannot open a period that has a status of Permanently Closed.


8.  Is there a way to automatically open General Ledger periods?

Answer
------
No. There is no way within General Ledger to do this


9. Open Period program is stuck in module gllock

Answer
------

1. If there is another Open Period program still running for the current set of 
books, let it continue to completion.

2. If there is no other Open Period program running for the current set of 
bookstry the sql suggested Note 134007.1 for cleaning up concurrent requests.

See bug 2954000 - WHEN OPEN PERIOD IS INTERRUPTED, IT DOESN'T RESTART SUCCESSFULLY
Prevented in GL patchset I onwards.
For a fix see Note 134007.1
more details Note 233150.1


10. Is there a way to get a Closing Journal

Answer
------

Closing Journals Income Statement Offset Option (Rel 11.5.2)   (CR 277920  PDF 134 kb) 

http://metalink/cgi-bin/cr/getfile.cgi?p_attid=66935.1:277920


Note:119379.1
Content Type:
TEXT/PLAIN
Subject:
General Ledger Flexfield FAQ
Creation Date:
08-SEP-2000
Type:
FAQ
Last Revision Date:
15-JUL-2004
Status:
PUBLISHED

When investigating problems in this area the solution is often in the relevant
White Paper which also provides a useful insight into the Topic. Please refer to the White
Paper Accounting Flexfield Setup and Usage at Note:124333.1.


ORACLE General Ledger
------------------------------
Flexfields
----------

FREQUENTLY ASKED QUESTIONS
--------------------------------------------------
June 2004


CONTENTS
--------
1. An account code segment value has been disabled but users are still
able to post transactions to these accounts.  How do you disable a segment
value and code combinations so journals will not be created with these accounts?
2. If the Accounting Flexfield structure is not frozen, why does the
Shorthand Alias form (FNDFFMSA) allow updates?  
3. How do you update segment qualifiers or rollup groups for an existing value? 
4. How do you add a new value to an existing segment?
5. How do I know which accounts are inactive?
6. Can you add or delete segments to an existing accounting flexfield 
structure? 
7.  Which table stores the parent value and its' child ranges?  
8.  What tables store segment values and their descriptions? 
9.  Do all segments of your accounting flexfield have to be enabled and 
displayed?
10.  When trying to compile an accounting flexfield, you receive  
APP-00981 and APP-00068 errors. How do you resolve this? 
11.  The View Compilation for the Accounting Flexfield view failed with 
APP-00988 ORACLE error 905 in afuddl. How should you resolve this issue? 
12.  Can a flexfield qualifier be changed after it has been created? 
13.  You receive the message 'APP-00734: Please enter a valid value for the 
Account Type segment qualifier using the Segment Qualifiers pop-up window'
when entering a new value. How do you resolve this? 
14. Can you change the size of a value set used in the accounting flexfield
after it has been created? 
15.  Receive APP-00668 APP-00874 FDFBKS error when compiling accounting 
flexfield.
16.  You receive APP-1564 and ORA-904 when trying to create a new code 
combination. How should this be resolved?
17.   You received APP-00822 when entering  flexfields in set of books form 
GLXSTBKS. How should this be resolved? 
18.  How do you enable the Journals-Captured Information descriptive flexfield?
19.  How do you correct a misclassified account?
20.  You are trying to modify an existing segment value and receive errors
FRM-40735 and FRM-40654: Record has been updated, re-query block to see 
changes. 
21.  Can the Accounting Flexfield Segment name be changed?
22.  Can a parent value be changed to a child value and vice versa?
23.  Can changes be made to segments in an existing accounting flexfield
structure?
24.  How do you enable an existing Future use accounting flexfield segment?
25.  What is the difference between Hierarchical and Non-hierarchical Security
Type?
26.  Why can you update the Segment Values form (FNDFFMSV) when the flexfield
structure is frozen?
27.  Should Rollup Groups be frozen?
28.  Do you need to have an Accounting Flexfield segment that
is flagged with the Intercompany qualifier?  
29.  What is a Reconciliation qualifier and how is it setup?
30.  What is the recommended numbering for the Accounting Flexfield structure 
and why?
31.  Some of the segment separators are displayed as question marks (?),
why?
32.Is there an easier way to create/load account code combinations then to
enter them manually through the forms?
33. Can different sets of books share the same value set?
34. Is there a way to identify overlapping child ranges in a value set?
35.  How do you set up an Accounting Flexfield structure that has a 
dependent segment?
36.  What is the correct way to renable an account value?


QUESTIONS & ANSWERS
-------------------

1. How do you disable a segment value and code combinations so journals will 
not be created with these accounts?
 
You must disable the segment, and disable every code combination that uses
that segment.  In version 11 and prior, you must disable each code combination 
individually. However, in 11i, you can disable a range of code combinations 
using the new Segment Value Inheritance program. See the General Ledger 
User's Guide, Release 11i for more information on this program.  

Note:  There is no supported way to delete a segment value.  Segment values 
should only be disabled not deleted.  General Ledger does not distinguish 
between accounts which have transactions outstanding in order to determine if
these accounts should not be disabled.
  

2. If the Accounting Flexfield structure is not frozen, why does the
Shorthand Alias form (FNDFFMSA) allow updates?   
 
This form should become non-updateable and non-insertable if the flexfield
is not frozen.  Bug 1080345 (Problem 9) has been submitted to address this 
issue. 
 

3. How do you update segment qualifiers or rollup groups for an existing value? 
 
You need to unfreeze all flexfields that use the value set. Then you should
be able to update the values. See note 1015950.600 for detailed steps, and
scripts to find the flexfields that use a particular value set. 


4. How do you add a new value to an existing segment?

On the Segment Values form, insert a new row with your new value. Make sure
the segment qualifiers are set correctly (Allow Posting and Budgeting). If
this is the natural account segment, specify the Account Type also.

 
5. How do I know which accounts are inactive? 

Run the standard report: Chart of Accounts - Inactive Accounts Listing.
This report is new in Release 11i.

 
6. Can you add or delete segments to an existing accounting flexfield 
structure? 

No. This will cause data inconsistencies and data corruption. Development 
and Support do not support changes to the accounting flexfield.  
Changing your flexfield definition once you have used it to acquire data can 
cause serious inconsistencies with existing data, which could cause data 
corruption. See the Oracle Applications Flexfields Guide, Release 11i, page
2-19, and the Oracle Applications Flexfields Guide, Release 11, page 2-18
for more information.

 
7. Which table stores the parent value and its' child ranges?  

FND_FLEX_VALUE_NORM_HIERARCHY

 
8. What tables store segment values and descriptions? 

FND_FLEX_VALUES_TL and FND_FLEX_VALUES.

 

No comments:

Post a Comment