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