General Ledger FAQ

纵横四海

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
------
You cannot reopen a permanently closed period in the application. This is to prevent issue
occuring where the perid data has been purged. If you have a major problem with this raise a
Service Request on metalink to discuss possible workarounds.
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.