add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, February 22

General Ledger FAQS

                                  
Details
Question
Integration of General Ledger with other modules
Answer
Oracle General Ledger integrates with other modules. Following is the list of modules along with the details that flow to the General Ledger.
1. Payables sends Invoices, payments, adjustments, realized gain/loss on foreign currency and invoice price variance to GL.

2. Receivables sends invoices, payments, adjustments, debit memos, credit memos, cash, charge backs and realized gain and loss on foreign currency to GL.

3. Assets sends capital and construction in process asset additions, cost adjustments, transfers, retirements, depreciation and reclassifications.

4. Purchasing sends accruals or receipts not invoiced, purchase orders, final closes and cancellations.

5. HRMS sends employee details.

6. Payroll sends salary, deductions and tax information.

7. Inventory sends cycle counts, physical inventory adjustments, receiving transactions, delivery transactions, delivery transactions, intercompany transfers, sales order issue, internal requisitions, sub-inventory transfers and Cost of Goods Sold.
Question
What are the 4cs in GL
Answer
1. Chart of Account
2. Currency
3. Calendar
4. Accounting Method (Convention)
Question
Key Flex Fields
Answer
General Ledger           Accounting Flexfield

Receivables                Territory Flexfield
                                 Sales Tax Location Flexfield

Assets                      Category Flexfield
                                Location Flexfield
                                Asset Key Flexfield
Question
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:

        * Produces reports you can review to verify that your archiving and purging processes complete successfully.
        * Ensures that only archived data can be purged.
Question
Can the Average Balance feature be restricted to a specific range of accounts?
Answer
    No, the average balance processing in General Ledger is enabled for a specific Set of Books.

    Warning: once enabled, the Enable Average Balances check box is protected against update and can no longer be unchecked.
Question
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 the 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 owners equity account at the beginning of the year, i.e. the retained earnings account.
Question
Can a Journal be Double-Posted from the Enter Journals and Post Journals forms?
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.
In case Double Posting has happened then the Balances got corrupted and a datafix is required. Please log a Service Request for support.
Question
How to avoid inconsistencies in GL_BALANCES?
Answer
There are different causes for GL_BALANCES inconsistencies.
The table below shows the most common causes and how you can avoid them.
CAUSE  PREVENTION
Unsupported updates to gl_balances table :
Never update gl_balances table rows, unless recommended by support, as it usually causes gl_balances corruption

Interrupted process updating gl_balances table (for example Add/Delete Summary Templates, Incremental Add/Delete Summary Templates, Maintain Summary Templates, Posting and Open Period programs) :
* Never kill the DB or OS process. If a process needs to be interrupted then use the Concurrent Manager, as it will be allow to do the required rollback.
* Perform the necessary surveillance to the system/database available space to avoid the process to terminate in error.
* Be cautious with other processes that may kill the running process (for example DB backup or DB shutdown).

Double Posting journals when using Autopost :

Problem on Program Incompatibilities definition allowing simultaneous run of incompatible programs (for example Add/Delete Summary Templates, Incremental Add/Delete Summary Templates, Maintain Summary Templates, Posting and Open Period) 

Huge amounts (more than 38 digits) imported from feeder systems into GL. 
Install Patch:2162483 Enhancement to Provide Warning Statuses for Journal Import (included in 11i.GL.G)
Question
How to check for inconsistencies in GL_BALANCES?
Answer
    * For releases over 11.5.2, run the Period Balances Activity Diagnostic Test from Note:222628.1 (this is available as standalone).

    * In case you do not have the Oracle Diagnostics Support Pack installed or your release is under 11.5.2, run the scripts from Note:101579.1 Inconsistent Balances Diagnostic Scripts.
Question
How to correct the ‘number of updated GL_BALANCES rows does not equal the number or rows in gl_posting_interim_xxxxx table’ problem?
Answer
    Please contact Oracle Support for assistance. Most probably a Balances Rollback will be required.

    Refer to Note:137413.1 Balance troubleshooting guide, for general information regarding posting failure.

    Information:
    currently, for releases 11i and 12, there is a script called GLBALFIX, created by development, which can fix almost all the errors and corruptions on Actual Balances and it can be helpful on this case (usually caused by duplicated rows).
Question
Why and How to Roll Back Actual account balances to a particular accounting period for a specific set of books?
Answer
    The Balances Roll Back is required whenever the GL_BALANCES table got corrupted for some reason.

    The process basicaly consists of a series of steps to:
    a) delete the GL_BALANCES rows of the incorrect period and of the periods after it,
    b) reopen the deleted periods
    c) repost the Journal Entries from those periods,

    Please contact Oracle Support for assistance with this.

    For more details please check Note:283588.1 Resolving General Ledger Balances corruptions using rollback

    Information:
    currently, for releases 11i and 12, there is a script called GLBALFIX, created by development, which can fix almost all the errors and corruptions on Actual Balances.
Question
Why and 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
    The Balances Roll Back is required whenever the GL_BALANCES table got corrupted for some reason.

    The process basicaly consists of a series of steps to:
    a) delete the GL_BALANCES rows of the incorrect period and of the periods after it,
    b) reopen the deleted periods
    c) repost the Journal Entries from those periods,

    Please contact Oracle Support for assistance with this.

    For more details please check Note:283588.1 Resolving General Ledger Balances corruptions using rollback
Question
Why journal posting creates rows in gl_balances for the current period, and subsequent periods also?
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 to update each period begining balances accordingly.
If there was no prior balance for the period and account, a row is inserted into GL_BALANCES, otherwise it is just updated.
Question
Will STAT currency numbers aggregate when calculating YTD information, Actual and/or Budget?
Answer
Yes, they roll forward just like other currencies.
Question
What is the management segment and how do you enable it?
Answer
How To Enable Management Segment in Existing Chart Of Accounts

===============================================

The only flexfield qualifier that can be enabled for an existing chart of accounts is the management segment. The management segment can be any segment except the balancing segment, natural account segment, or intercompany segment. Note: You should never use the Flexfield Qualifiers window to enable the management segment for an existing chart of accounts that has been assigned to a ledger. Doing so could cause data corruption issues. To enable the management segment for an existing chart of accounts, you must run the following concurrent programs in the following order:

1. Program – Prepare Journal Batches for Management Segment Upgrade

When you run this program, you select a chart of accounts and designate a segment to be the management segment. This program begins preparing the chart of accounts to assign the management segment. This program should not be run when users are entering journals or updating balances, such as posting journals. This program automatically launches the second program, Process Posted Journal Batches for Management Segment Upgrade. This program selects all posted journal batches that exist for all ledgers that use the chart of accounts and prepares them to be upgraded with the new management segment. This is a longer running program that can be run at the same time users are entering and posting journals. The only programs that are incompatible with this program are the archive and purge programs in General Ledger. You can stop and restart this program at anytime. To restart the program, you must re-run the Prepare Journal Batches for Management Segment Upgrade program. Each time you resubmit the program, the program automatically submits the second program and continues processing the posted journal batches from where it left off when you last canceled the program.

2. Program – Complete Management Segment

This program completes the management segment upgrade by processing any remaining journal batches, both posted and unposted, that were not processed from the first two programs and assigns the management segment qualifier to the chart of accounts. This program should not be run when users are entering or posting journals.

Use of Management Segment

=====================

The management segment is used to secure management values or perform management reporting. The management segment can be any segment, except the balancing segment or natural account segment. Typically, the management segment is a segment that has management responsibility, such as the department, cost center, or line of business. By designating a segment of your chart of accounts to be the management segment, you can secure access to the management segment values with data access sets.

Note: It is recommended that you use data access sets instead of flexfield value security rules to secure read and write access to balancing segment values and management segment values. Flexfield value security rules are still applicable for the other segments.

As of this writing, security of MSVs (i.e., Data Access Set) is supported only in General Ledger.
Question
what are the documents prepared by functional consultant under aim methodology, which document will be prepared in each phase and which is the important phase in aim.
Answer

Question
Whether is it allowed for entering negative amount in Journal lines?
Answer
Yes it is allowed
Question
What is profitability? How do you map 'segment wise profitability' in Oracle?
Answer

Question
Why Retained Earning Account is necessary for the set of book creation while implementing oracle new business.
Answer
Retained Earnings represent the undistributed profits of a company i.e. profits retained. The retained earning account is a mandatory account to be given at the time of defining Set of Books (SOB).
Question
what r issues faced in gl
Answer

Question
what is the use of below profile options while configure multiorg? 1. HR: Security Profile 2. MO: Security Profile 3. GL Set of books name 4. MO: Operating Unit 5. HR: User type
Answer
MO:Security profile gives access to multiple operating units (MOAC features)
If you set MO:Operating unit and don't set MO:Security profile, system provides you access to one OU and all programs can be run for that OU.
If you want to access multiple OU's or Inventory Org's then you have to set up MO:Security profile.


Difference between HR: Security Profile and MO: Security Profile
HR:Security Profile and MO:Security Profile are used for MOAC (Multi-Org-Access-Control).

HR:Security Profile is used to restrict the data in Human Resources according to the Business Group or whatever criteria you define in this security profile. Thus, for HR, it uses this secuity profile in its data exposure to the user.

MO:Security Profile acts the same but is used for Financials and Manufacturing applications. It restricts the access (site level or can be set at responsibility level) to certain operating unit (or whatever criteria defined in the security profile).

If there is no value at MO:Security Profile, then Financials and Manufacturing use the HR:Security Profile option for their data exposure to users.

HR: Business Group
Business Group that is linked to the security profile for a responsibility. This option is used online to control access to records that are not related to organization, position, or payroll.
This option is seeded at Site level with the start-up Business Group. It is view only. Values are derived from the HR:Security Profile user profile option.

HR:User Type
Limits field access on windows shared between Oracle Human Resources and Oracle Payroll. If you do not use Oracle Payroll, it must be set to HR User for all responsibilities.
If you do use Oracle Payroll, you can give each Responsibility one of the following user types, depending on the work role of the holders of the responsibility: HR User, HR with Payroll User, Payroll User
Question
what is value set?
Answer
Value-set is a group of values. It can also be thought of as a container of values. The values could be of any data type (Char, Number etc.) A value set is used in Oracle Applications to restrict the values entered by a user. For example, when submitting a concurrent program, we would like user to enter only valid values in the parameter. This is achieved by associating a value set to a concurrent program parameter.
Question
what is the gap analysis, how do you defined.what are the pre- requisities
Answer
The primary step will be to make a note of the existing business system and list out the flaws and positive aspects. This is an attempt to have an idea of what is currently happening given the scenario in question so as to help in ERP implementation.
Evaluate and decide the additions that need to be made to the business in view of ERP implementation. The aim is to make sure that there is not even a thin line of difference between ERP and the organizations commercial activities. It will be oriented to ERP function.
Rating the existing level of performance to set a benchmark or standards for the business as on date. This will help in finding out the benefit of ERP.
Having an in-depth study of the regulations and statements in the organizations and suggesting modifications. This also will decide ERP implementation.
Clearly defining the roles of individuals in the organization so that the priorities are met and the structure remains undisturbed. This is to make things clear for ERP function.
Checking if the objective in discharging duties are met because it is the ultimate solution to any issue. If they are not met the gaps should be made known and corrected. Only then the organization can achieve the benefit of ERP.
Ensuring that functions are executed properly and if need be personnel can be rewarded to boost up and encourage performance.
Similarly comparisons are to be made for every other factor that draws relation in one way or other. These results are to be complied for ERP gap analysis.
The gap analysis takes into account all the factors of study and gives the results. It either recommends the implementation of an ERP system or rejects the idea in totality.
Question
What r different types of exchange rates?
Answer
Spot: An exchange rate which you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of a currency.

Corporate: An exchange rate you define to standardize rates for your company. This rate is generally a standard market rate determined by senior financial management for use throughout the organization.

User: An exchange rate you specify when you enter a foreign currency journal entry.

EMU Fixed: An exchange rate General Ledger provides automatically when you enter journals (after the EMU effective starting date) using a foreign currency that has a fixed relationship with the Euro.
Question
What is the difference between org_id and organization_id?
Answer
org_id refers to unique identifier for the Operating Units and organization_id refers to the unique identifier for Inventory Organizations.
Question
What is the difference between Key flex field and Descriptive flex field?
Answer
Key Flexfield stores the key Information. They are stored in Segment columns in tables. Descriptive Flexfields are used to store additional inforamtion. They are stored in Attribute fields in tables. They can be context-sensitive.
Question
How do you enable trace/debug in APPS?
Answer

Question
What are global variables ? How they can be used ?
Answer
Global variables are variables with more scope which is at the application level. They can be used in Form personalizations, PL/SQL procedures , reports e.t.c
Question
What are custom events in apps and how to you enable/disable it?
Answer
Custom Events are used to track and see which trigger is fired at what point in oracle forms. This can be enabled by going to Help >> Diagnostics >> Custom Code >> Show custom events
Question
What is ALERT?
Answer
Oracle Alerts are used to monitor unusual or critical activity within a designated database. The flexibility of ALERTS allows a database administrator the ability to monitor activities from tablespace sizing to activities associated with particular applications.
Question
What is difference between concurrent program and concurrent request?
Answer
Concurrent program stores the definition of what needs to be run and what parameters it can accept where as concurrent request is submitting the concurrent program for output.
Question
Tell me about Multi Org?
Answer
Multi-Org is an Oracle Financials feature that lets you identify specific data and financial transactions as belonging to a single organization - classified as an `Operating Unit' within your enterprise. This is essential for large customers with multiple lines of business or divisions where you want to secure access to information and simplify processing and reporting.
Question
What are the steps to register Concurrent Program?
Answer
Define the Executable Define the Program for the above Executable Attach the program to the required Responsibility
Question
What is profile option in APPS?
Answer
Profile options can be used to restrict the access to the applications
Question
What is diagnostics in apps? How do you enable/disable it?
Answer
To see the hidden data from application forms we use diagnostics. It can be enabled from Help >> Diagnostics >> select any sub function. You need to enter database password to enter diagnostics
Question
What are the mandatory segments while defining Chart of Accounts?
Answer
Mandatory/ Min no of segments----2Company--> Balancing segmentAccount---> Natural Account segmentMax----> 30Advised----5/6
Question
Explain Secondary Tracking Segments.
Answer
A segment in the chart of accounts can be designated as a secondary tracking segment, in addition to the balancing segment, to perform more detailed analysis within Oracle General Ledger. The secondary tracking segment is used in the revaluation, translation, and fiscal year-end close processes. The system will automatically maintain unrealized gain/loss, retained earnings, and cumulative translation adjustments by unique pairs of balancing segment and secondary tracking segment values."

Therefore, you can use any segment, except the balancing segment or natural account segment, can be specified as the secondary tracking segment.
Question
What is the additional qualifier in R12 while defing COA?
Answer

Question
What the steps involved in consolidation?
Answer

Question
What is the difference between Revaluation and Translation?
Answer
Revaluation is used to determine the position of foreign currency debtors, creditors etc at the end of month; and it creates revaluation journal entries. 
While Traslation is a functionality used to convert all balances including functional currency (say INR) balances in a given foreign currency (USD). Then, Trial Balance in that currency(USD) can be generated. It is used when of a subsidiary or branch (INR) are required to be merged with another company reporting in different currency (USD).
Question
Can you translate the balances of SOB in GBP currencies into multiple currencies or only in one different currency?
Answer

Question
I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done?
Answer

Question
When we run the translation we can give only one rate type, then how can we run it for two different exchange rates?
Answer

Question
What is the difference between realized gain/loss and unrealized gain /loss?
Answer
Unrealized gains and losses are calculated on unpaid vouchers the open portion of partially paid vouchers at the end of a fiscal period, whereas realized gains and losses are calculated at the time of payment.
Question
What are Ledger Sets, when they are used and how to define them?
Answer
What are Ledger sets?
Ledgers sets allow you to group multiple ledgers together to achieve processing efficiencies. For example, you can open or close periods for multiple ledgers simultaneously, translate balances for all ledgers in a ledger set, run recurring journals that update balances for multiple ledgers, or run consolidated financial reports that summarize balances across multiple ledgers in a ledger set.

All ledgers in a ledger set must share the same chart of accounts and accounting calendar/period type combination. They do not have to share the same currency. This allows you to group the primary or secondary ledgers with their associated reporting currencies to reduce maintenance efforts and streamline processing.

Note: Both the source ledger and its reporting currency (Journal and Subledger level) must have the same open periods to prevent problems during posting in General Ledger.
Question
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.
Question
Is there a way to assign different security rules to a responsibility 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.
Question
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.
Question
Forgot to check the security enabled flag for each segment and it is not updateable. 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.
Question
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.
Question
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.
Question
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.
Question
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.
Question
 What is Hierarchical Security?
Answer
When using ‘Heirarchical Security’. ‘a flex value is secured if one of it’s parent value is secured’.
This feature combines Flex Value Security and Flex Value Hierarchy.
Question
Is there a way to suppress zero amounts on the FSG Report?
Answer
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.
Question
How do you print credit amounts on the FSG Report as positive instead of negative numbers?
Answer
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.
Question
Can I display account descriptions on the FSG Report in addition to the account segment values?
Answer
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.
Question
Is there a limit on how large a FSG Report can be?
Answer
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.)
Question
What is the profile option ‘FSG: Expand parent value’ used for?
Answer
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.
Question
I am trying to display budget amounts in my reports but they are not showing up or are incorrect. What is wrong?
Answer
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.
Also, make sure you have defined your Amount Types, Offsets and Control Values in the Column Set or Row Set, but not both. Typically these are specified in the Column Set.
Question
How do you enable Flexfield Security Rules for FSG?
Answer
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.
Question
How can you add/define/create your own new amount types in FSG reporting?
Answer
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.
Question
Where should the period offset and the amount type be specified?
Answer
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.
Question
On a calculation column, can I enter an amount type?
Answer
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.
Question
Is there a quick and supported method of transferring FSGs between environments, so that users do not have to key them in twice?
Answer
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 nt 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.
Question
What FSG enhancements are introduced in Release 11i ?
Answer
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.
Question
Can I remove the ‘No specific Company requested’ text from the FSG heading?
Answer
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.
Question
Can I remove the segment header descriptions from the top of the FSG reports?
Answer
The accounting flexfield segment headings (CO, REG, etc.) can be removed with the use of a Row Order.
Question
Can I customize or move the 3 heading lines that appear at the top of the FSG (set of books, report name, period)?
Answer
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.
Question
(R12) The Ledger List of Values on the Run Financial Reports form shows all possible ledgers. How can this be limited to only ledgers the responsibility should access?
Answer
The Data Access Set assigned to the Responsibility (via the profile GL: Data Access Set) controls which ledgers you can actually update or view data for.
Even if there is a ledger name in a LOV, you should not be able to see the data for that ledger in the FSG if the Data Access Set does not have that access.
Question
(R12) How can you report on a budget entered in a foreign currency?
Answer
Assign a control value to each of the Budget, Variance and Variance % columns. In the FSG Report Definition, assign the control value to the appropriate budget and currency.
Question
Goal
1. You have defined Sequencing- reporting for both subledger and GL journal entry - event GL period
close.

After closing the period in GL, the ‘Create Reporting Sequence Number’ program is automatically launched  and completed normally but when checking the reporting sequence number for Subledger journals and GL journal entries – only the reporting sequence numbers for GL journal entries are shown and no reporting sequences for Subledger journals are available.

How to view the reporting sequence created and assigned to subledger journals?
Answer
This is the intended functionality.
For subledger journals you can see the reporting sequence in SLA level not in GL. For subledger journals GL can’t transfer the reporting sequence. Only manual journals which are created in GL will get the reporting sequence. For subledger journals you can see the reporting sequence in SLA level only .If however a subledger journal is reversed user will not get a reporting sequence because the reversals do not populate the xla_seq_je_headers_gt table that gets the sequence

In order to see the reporting sequences for subledger journals in SLA:

- Log in with your SLA responsibility;
- Check your setup according to ‘Oracle Subledger Accounting Implementation Guide Release 12′ – Chapter 7 ‘Reporting Sequence’- page 7-4 ‘Reporting Sequence Process Steps’ and following.
- Navigate to Subledger Journal Entries > Lines > make your query and see the transactions retrieved.
- In the ‘Transaction information’ area note the ‘ + Show additional information’ : unhide the information ; at this step you can see your accounting and reporting sequences numbers.

Note: In order to have the assigned reporting sequences used you have to:

- Check the ‘journal entry status’ of ‘Final’; draft entries are not assigned a reporting sequence;
- Check that the transactions are posted in GL;
- Check that the GL period has been closed and the automatically launched process ‘Create Reporting Sequence Number’ has completed normally;
- At the time you check your SLA reporting sequences numbers the period in GL has not been re-opened
(the program erases the sequences that are assigned to the journal entries that belong to the reopened period).
Question
R12 What are the Differences Between Accounting Sequencing and Reporting Sequencing?
Answer
The accounting sequence is assigned to Subledger Accounting journal entries at the time that the journal entry is completed. The sequence is assigned in the completion date order using the GL date as the date criterion for determining the sequence to be used.

The reporting sequence is assigned to both Subledger Accounting journal entries and General Ledger journal entries when the General Ledger period is closed. This sequence is used by most of the legal reports required in some countries as the main sorting criterion to display the journal entries.Reporting sequence is optional.

These two sequences are not mutually exclusive and can coexist in the same journal entry.

Note: for more details
-Oracle
Financials Implementation Guide (Part No. B16386-01) contains a
separate chapter on Accounting and Reporting Sequencing;
-Oracle
Subledger Accounting Implementation Guide chapter on Reporting Sequencing;
Question
Can the preparer of the journal batch approve the journal?
Answer
Yes, preparer can approve the journal when below two conditions are met
1. When the Journals: Allow Preparer Approval profile option is set to ‘Yes’
2. Preparer authorization limit is more than maximum absolute amount of journal batch
Question
Is preparer same as creator of journal batch?
Answer
No, Preparer is the one who initiates the journal batch approval process and he/she need not be the journal
batch creator.
Question
What are different types of approver methods and how to set approver method?
Answer
There are 3 types of approver methods

1.Go Up Management Chain –Goes up in HRMS manager hierarchy
2.Go Direct —Goes directly to the person with authorization limit
3.One Stop Then Go Direct – Goes to the immediate manager then directly to the person with authorization limit

This has to be set using the profile option “Journals: Find Approver Method”
Question
Journal Approval in General Ledger?
Answer
1. Enabled Journal Approval in Ledger Setup (Accounting Setup)
2. Defined journal sources that require journal approval
3. Entered all employees who are involved in preparing and approving journal entries.
4. Create an approval hierarchy:
- If using a shared install of Oracle Human Resources, use the Enter Person form of GL to enter all employees who are involved and preparing and approving journal entries and batches
- If using a full install of Oracle Human Resources, enter employees in the People window from the Human Resources Responsibility (required)
- When entering employee, enter the employee’s supervisor or manager name (this is the default next approver for journal entries and batches)
5. Defined Journal authorization limits

6. Add journals and approve, notifications will sent to next approval (Supervisor)
Question
What are the criteria on which journal import can be run?
Answer
The criteria's are

          - Source Name
          - Group Id
          - Import Desc Flexfield (Y/N)
          - Create Summary Journal ( Y/N)
Question
Can you give segment values or CCID in GL_Interface?
Answer
Both can be given.
Question
How can we identify whether records in GL_INTERFACE are errorred records?
Answer
The status of those records will be other than NEW
Question
If Journal import couldn't import journals because of errors, will Journal Import program end in error?
Answer
No. The Journal Import program doesnt error; but it gives details of the journal batches that have failed to import along with the error code
Question
What are the errors encountered during Journal Import?
Answer
Ans)

- This date is not in any open or future enterable period
- Detail posting not allowed for this Accounting Flexfield
- Disabled Accounting Fledfield
- Invalid Currency code
- The journal entry is unbalanced and susspense posting not allowed in this et of books
Question
In the multi-org structure, at what level does GL operate?
Answer
General Ledger operates at  SOB level.
Question
What are the various statuses of GL Periods? And in which table this information is stored?
Answer
The statuses of GL periods are are below:

Open
Closed
Future - Entry
Permanently Closed
Never Opened 
The information is maintained in GL_PERIOD_STATUSES.
Question
If Journal Approval flag is checked while defining Set of Books (SOB) then all journals will necessarily require approval. Is this statement correct?
Answer
In addition to enabling Journal Approval flag at SOB level; Require Journal Approval flag at Journal Sources level for journals to require approval.
Question
Does GL support Accrual or Cash system of accounting?
Answer
GL is a central repository and all the journal entries from sub-ledger flow to GL. And there is no option to specify which method of accounting is allowed. So, such an option is available only at sub-ledger level; at GL level, users are free to entry either type of entries.  Hence, we can say that GL supports both methods of accounting. 
Question
Journal can be entered only in Open Periods. Is this statement correct?
Answer
No, journals can be entered both in Open and Future-Entry periods. However, journals can be posted only in Open periods.
Question
Can a GL period be opened after the period is being closed? Can the period be opened after the closure of Financial Year? 
Answer
Yes, a GL period can be opened any time after it is closed; even after financial year is closed (though not recommended). However, once a period is permanently closed it cannot be re-opened. 
Question
What happens when the Posted journal are changed?
Answer
Posted Journal cannot be modified. They can only be reversed.
Question
Can the GL period be closed when there are unposted journals in the period? What error will it give?
Answer
Unlike AP and AR, where period cannot be closed unless all transactions are processed; GL period can be closed even if there are unposted journals. So, it gives no error as such.
Question
What are the maximum number of period that can be open in GL?
Answer
There is no limit on number of periods that can be concurrently open GL; however, it is advised to keep the number of GL Open periods to minimum.
Question
What are the key tables of GL module?
Answer
The tables that store the information of GL journals are - GL_JE_BATCHES - GL_JE_HEADERS - GL_JE_LINES While the summary of balances is stored in GL_BALANCES. And the GL interface table is GL_INTERFACE.
Question
What is the difference FSG report and D2k report?
Answer
Financial Statement Generator (FSG) is a functionality GL which can used to develop financial reports based on data in GL only (i.e. sub-ledger details cannot be displayed in the report) and FSG reports can be developed by functional users. However, to develop a D2K report knowledge of table structures and SQL (may be even PL/SQL) would be required. And using D2K report can be build for any module or extract data from multiple modules based on user requirement.
Question
What are the various type of balances supported by GL?
Answer
Oracle GL supports three type are balances which are:
- Actual
- Encumbrance
- Budget
Question
What are the various type of accounts in GL? And at what point is the type of account identified? And explain the nature of accounts.
Answer
Five type of accounts are maintained in GL
 - Expense (E)
 - Revenue (R)
 - Asset (A)
 - Liabiltiy (L)
 - Owner's Equity (O)

While defining the Natual Account segment values, in the segment qualifier we specify the nature of account. The type of account for a Code combination is stored in GL_CODE_COMBINATIONS

Expense and Revenue accounts represent expenses/losses and Revenues/Gains respectively. And these accounts have a ZERO balance at the start of the year. This point has to be taken care of while developing reports where Opening Balance is calculated rather than using GL_BALANCES table.

Owner's Equity represent Share Capital and includes retained earnings and reserves, if any. Owner's Equity along with Asset and Liability Balances are carried forward at the end of year.
Question
Explain the concepts of PTD, YTD, QTD and PJTD in GL?
Answer
All the below are various ways of calculating balances and each indicate the starting point since when the balance is calculated

PTD - Period To date (i.e. from the start of period till date)

YTD - Year to date
QTD - Quater to Date
PJTD - Project to Date (i.e. from the start of the project and it can span multiple years)
Question
What is a funding budget?  And what is its purpose?
Answer
A funding budget is a budget for which 'Require Budget Journals' check box is checked. Funding budget can be used to control expenses if budgeting control is enabled at Set of Books (SOB) level.
Question
What is the maximum number of periods allowed in a year while defining GL calander? Can you two periods in GL calander overlap?
Answer
GL calander allows for 1 to 366 periods per year. And two periods cannot overlap unless one of them is an adjustment period.
Question
When entering a Code Combination in Journals screen, user is getting the error - Please choose an existing combination.
How can this issue be resolved? Can any changes be done so that this issue doenst doesn't arise again? 
Answer
The issue can be instantly resolved by defining the combinations to be used in GL Accounts screen. And to prevent re-occurence of this issue, 'Allow Dynamic Inserts' check-box should be enabled while defining the Chart of Accounts.
Question
If any conflict occurs in FSG who will override; Column Set or Row Set
Answer
The override component is row set. However some times it depend on the column set also.
Question
What is the difference between discounts and adjustments
Answer
iscount refers to the payment terms or on quantity (bulk order discount) ordered. In the invoice received from supplier, discounts term is specifically stated, e.g. “If paid with in 15 days discount @ 2%”, what you need to do is pay 2% less then the original invoice amount, however caution should be taken that the freight amount should not be considered while calculating the discount. Adjustment could be for various reasons- Over priced invoice, short delivery of quantity as per goods received note, poor quality etc. Agreed upon amount will be deducted from the invoice, while making the payments.
Question
What are Summary Accounts and Rollup groups?
Answer
Summary Account is an account whose balance represents consolidation of accounts Rollup group is a collection / consolidation of parent accounts. e.g. Assets is a total of Current assets and Fixed Assets. Current assets / Fixed assets in turn are collection of assets.
Question
      What does set of books comprise of? 
Answer
Chart Of Accounts, Calendar And Currency
Question
      What is a flexfield?
Answer
AFlexfield Is A Flexible Field Which Is Used To Capture Mandatory Or Non Mandatory Business Information.
Question
      What is Flexfield structure?
Answer
Aflexfield structure is collection of segments.
Question
      What is a Value set?
Answer
Value set is container of values that can be assigned to a segment of Flexfield structure.
Question
      How many Flexfields are provided are by oracle applications?
Answer
30
Question
      What is the max no of segments that can be defined for the accounting flexfield structure?
Answer
30
Question
      What are the validation types supported by value sets?
Answer
None, Table, Independent, Dependent, Translatable independent, Translatable Dependent, Special, Pair
Question
      What are the format types supported for a value set?
Answer
Number, Char, Standard date and time, standard time, time, date, date time
Question
      Is there any limitation on the no of flexfield structures that can be defined for the Accounting Flexfield?
Answer
No
Question
.  What are the flexfield qualifiers which are available for accounting flexfield structure?
Answer
Natural account, Cost center, Balancing, Intercompany
Question
.  Which flexfield qualifiers are mandatory?
Answer
Balancing and Natural account
Question
.  Which mandatory account needs to be defined for the set of books definition?
Answer
Retained earnings
Question
.  What are all the accounts that can be defined for the set of books form?
Answer
RETAINED EARNINGS, SUSPENSE, ROUNDING DIFFERENCES, RESERVE FOR ENCUMBRANCE AND NET INCOME ACCOUNTS
Question
.  What is the minimum and maximum no of periods that can be defined for the Calendar?
Answer
AND 366
Question
.  Is the definition of transaction calendar mandatory?
Answer
No
Question
.  What are the period statuses that can be associated with the periods?
Answer
Open, Closed, Perm closed, Never opened, Future entry
Question
.  Can multiple periods have open status at one time?
Answer
Yes
Question
.  How many chart of accounts can be mapped to a set of books?
Answer
ONLY ONE
Question
.  During a financial year can the existing chart of accounts be replaced by new chart of accounts?
Answer
YES
Question
.  Can the calendar be replaced during the financial year for the same set of books?
Answer
NO
Question
.  What is the maximum no of set of books that can be defined in GL module?
Answer
Unlimited
Question
.  What is a responsibility?
Answer
Aresponsibility is collection of forms and programs that a user can access.
Question
.  Can multiple responsibilites be assigned to a single user?
Answer
Yes
Question
.  Can a responsibility be shared by multiple logon users?
Answer
Yes
Question
.  From a general ledger responsibility, how many set of books can be accessed?
Answer
Only one.
Question
.  What are the different currency conversion types?
Answer
Spot, corporate and user
Question
.  What is a corporate conversion rate?
Question
Corporate is a standardized market rate which is applicable to transactions for aperiod of time.
Answer
.  Which table captures conversion rates information?
Question
GL_DAILY_RATES
Answer
.  List the tables which capture the journals information?
Question
GL_JE_BATHCES, GL_JE_HEADERS, GL_JE_LINES
Answer
.  Which column distinguishes the type of journal being entered?
Question
actual_flag (which can be 'A','B','E')
Question
.  Which table captures the balances information of the code combinations?
Answer
GL_BALANCES
Question
.  What is significance of compiling a flexfield structure?
Answer
Itreflects the changes made to a flexfield structure during the unfreezed state.
Question
.  What changes can be enforced on the flexfield structure when it is unfreezed?
Answer
Changing segment names, changing ordering sequence, changing window prompts, adding new segments, changing the enabled and displayed attributes
Question
.  What is Autorate program?
Question
Itis a program which selects all the foreign currency transactions in a module in and applies that day’s currency conversion rate.
Answer
.  Is it mandatory to freeze the flexfield structure before it can be compiled?
Question
Yes
Answer
.  How many views are generated when compiling a flexfield structure?
Question
User Defined View and System View
Answer
.  What is the significance of intercompany flexfield qualifier?
Question
Itallows intercompany transactions to be recorded.
Question
.  How do you setup suspense posting?
Answer
A)Define Suspense Account
Question
B)Specify suspense account code combination in set of books form
Answer
.  Manual tax journals can be recorded if Allow Tax Journals option is not selected in the set of books form?
Question
No
Answer
.  Selection of journal approval option makes it mandatory for every journal tobe approved before a journal is posted?
Question
Yes
Question
.  Where do you specify journal approval limits in Oracle apps?
Answer
InGL module only
Question
.  Can previous conversion rates information be used for current transactions?
Answer
Yes
Question
.  After the batch is posted, journals within the batch can be updated?
Answer
No
Question
.  To reverse an entire batch what is the option available in GL?
Question
Reverse batch option in Journal Batch window.
Answer
.  To reverse only journal within the journal, what steps have to be performed?
Question
           
Answer
A)Navigate to JOURNALS/ENTER
Question
B)Click on FIND
Answer
C)Select the batch whose Journal you want to reverse.
Question
D)Query the Journal within the batch.
Question
E)Click on MORE ACTIONS and then click on REVERSE JOURNAL
Answer
.  What are the categories of budgets available in GL?
Question
REVENUE BUDGETS and EXPENSE BUDGETS.
Answer
.  What are the amount types supported by the applications package?
Question
Qtd, ytd, ptd and pjtd
Answer
.  Can statistical budgets be defined in GL?
Question
Yes
Question
.  What are the modules involved in the encumbrance cycle?
Answer
GL, PO, AP
Question
.  What is encumbrance accounting?
Answer
Encumbrance accounting is the cycle of generation of encumbrance entries for thereservation of funds
Question
.  What is the name of the system generated view when you compile an accountingflexfield structure?
Answer
GL_CODE_COMBINATION_KFV
Question
.  Which Profile option needs to be set for Allowing Mixed journals?
Question
Journals: Mix monetary and Statistical
Answer
.  Which Profile Option should be set to prevent transactions on a non-businessday?
Question
Journals: Allow Non-Business Day Transactions should be set to No.
Answer
.  What is the purpose of Journals: Default Category profile option?
Question
Todefault a journal category in case of manually recorded journal.
Answer
.  What are the journal reversal methods available in GL?
Question
Switch DR/CR
Question
Change Sign
Answer
.  Which profile option is used to map a responsibility to a General ledger setof books?
Question
GL: Set of books name
Answer
.  What are the different Statuses that a budget can have?
Question
Frozen, Open, Default
Answer
.  Only Ten Budget organizations can be defined in a GL set of books?
Question
False
Question
.  Encumbrance balances are maintained for Expense accounts?
Answer
True
Question
.  Encumbrance balances are maintained for Revenue Accounts?
Answer
False

No comments: