Oracle R12 General Ledger Setup

CURRENCY AND EXCHANGE RATES

Currency

All the ISO Currencies have been predefined by Oracle Applications and would    only have to be enabled to be used in Oracle Applications. As part of the initial GL setup all currencies that are being currently used by MKM has been enabled.

However, in case a need arises in future to enable additional currencies or define a new currency the following steps needs to be adopted.

• Navigation      :           Setup>Currency >Define
• Screen             :           Currencies

           

Enter the following information:

Field	Description
Currency Code, Name, Description and Issuing Territory	If the new currency is an ISO Currency, query by the Currency code, Issuing Territory etc. In Case of a Non-ISO currency, enter the Currency Code, Name, Description and other relevant Columns.
Symbol	Enter the relevant symbol for that currency.
Precision	Enter the Precision
Effective Dates	If the currency is to be used only for a specific period of time enter the From and the To effective dates
Enabled	Mark the enabled check box.

Daily Exchange Rates

Daily rates can be entered manually using the Define Rates for each day or it can be entered for a range of days.

• Navigation      :           Setup>Currency >Rates>Daily
• Screen             :           Daily Rates

           

Enter the following information:

Field	Description
Currency From & To	Enter the From and To currency
Conversion Date	Enter the Date for which this rate will be applicable
Conversion Rate Type	Select the Rate type like “Corporate”, “Spot” etc.
Exchange Rate	Enter the conversion exchange rate.
Enter by Date Range	The currency conversion rate can be entered for a particular date range

Historical Rates

Period Rates are used for Currency Revaluation and Translation

• Navigation      :           Setup>Currency >Rates>Historical               
• Screen             :           Historical Rates

Enter the following information:

Field	Description
Target Currency	Choose the Target Currency
Period	Enter the Period for which the historic rate is to be applied. For the succeeding periods, if no historic rates are defined, the system will use the latest available historic rates.
Account,  <Assign by Ranges> button	Enter the Account or the range of accounts fro which this historic rate/amount will be applicable
Rate	Enter the historic rate
Amount	Enter the historic amount, provided the historic rate is not entered
Rate Type	The Rate type will be displayed by the system based on the basis of historic rate calculation

USING CURRENCY RATE MANAGER

Use Currency Rate manager to load the exchange rate using Excel worksheet

• Navigation      :           Setup>Currency >Rates>Currency rate manager                  
• Screen             :           Currency Rate Manager

Click on the create in spreadsheet button

This opens up the  spreadsheet in which the currency conversion rate can be created and uploaded the same to the system

The spreadsheet can be uploaded into oracle application by pressing the Oracle tab in the menu bar.

The same process can be used to create historical rates in the system

CALENDAR

Wafi Industrial LLC would be following an accounting calendar (May to Jun) of Type ‘MKM_Month’ (to facilitate naming convention) with 13 Periods per year comprising of 12 months and 1 adjustment period.

The calendar definition would be as per the format mentioned in the GL    Setup document. To define additional periods in the calendar, the steps given below need to be followed

• Navigation      :           Setup>Financials>Calendar>Accounting                  
• Screen             :           Accounting Calendar

Enter the following information:

Field	Description
Calendar Name & Description	MKM_CAL  & Calendar for MKM Group
Prefix	Enter the first 3 letters period name in French as the prefix in Initcaps
Type	Select the MKM_Month as the calendar type
Year	Enter the Financial year
Quarter	Enter the Quarter to which the period belongs
Period Number	Enter the period number for the financial year
From	Enter the From date for the period
To	Enter the To date for the period
Name	The name will be built by the system, please do not change it
Adjusting Check box	Mark this check box for the adjusting period (The 13th period 31st December)

CHART OF ACCOUNT VALUES

The Chart of Accounts structure (known as Accounting Key Flexfield)  for Wafi Industrail LLC consists of Eight segments. All accounting distributions would have to capture values for all the segments.  The set-up related to Chart of Accounts has been included as part of the Set-up document. However, new values may require to be added to the existing value sets and other activities may have to be performed against the values in Chart of Accounts. The procedure for the same is discussed in detail subsequently. Following are the possible activities that could be performed related to Chart of Accounts

a.         Creation/modification of Segment Values

b.         Other Setups related to Chart of Accounts

Creation/Modification of Segment Values

To define a new segment Value for any of the Segments of the Chart of Accounts             Structure, the following Steps are to be performed. Please note that defining of new Segment Values should be centralized and done only by the General Ledger     Super user Responsibility. 

It is essential to control creation of new values in the Chart of Accounts. The existing values should be reviewed for their adaptability before defining any new value.  Prior to definition of new values, all the prerequisite approvals should have been completed and a valid value should have been allotted.

• Navigation      :           Setup>Financials>Flexfields>Key>Values               
• Screen             :           Find Key Flexfield Segments

Enter the Structure name as “MKM Accounting Flexfield” and enter the Segment name

Click on the <Find> button

• Screen             :           Segment Values

Use the down arrow key to select the correct segment.

Enter the following information:

Field	Description
	Click on the new button to create new segment value. The cursor should on the value region before click the new button.
Value Code & Description	Enter the value code and Description
From and To dates	If the values are to be used for a specific duration, then enter the from and  to dates.
Parent Check Box	Mark the parent check box in case of parents
Rollup Groups and Levels	Enter the Rollup Group and Level for the Parent values
Enter the qualifiers	Allow posting – Yes for child and No for parents Allow Budgeting – Yes for child values and No for parents For Account segment, enter the type of account as Expense, Revenue, Asset, Liability, and Owner’s Equity.
Define Child Ranges	Define child ranges for the Parent Values.

SECURITY RULES

Security Rules govern the access to certain segment values to certain responsibilities.  Security Rules would prevent the responsibilities to which they were assigned from using the controlled segment values in both transaction entry and inquiry where the segment value is the driver for the query. Some of the Standard Reports and also all the FSG Reports would include any restrictions placed by the Security Rules.

While defining these security rules, care should be taken to ensure that a Global include (All values) should be first declared and then specific exclusions are declared. A meaningful message should be provided to ensure that the user get an appropriate message. Post definition, the security rule has to be assigned to all the relevant responsibilities.

Define Security Rules

• Navigation      :           Setup>Financials>Flexfields>Key>Security>Define            
• Screen             :           Find Key flexfield Segment

Enter the Segment details and click on <Find> button

• Screen             :           Define Security Rules.

Click on the find button

Enter the following information:

Field	Description
Value Set > Name	Select the relevant value set
Security Rules > Name	In the Security Rule region, enter a name for your security rule.
Security Rules > Description	Enter the description for the security rule
Security Rules > Message	Enter a message for this security rule. This message appears automatically whenever a user enters a segment value that violates your security rule.
Security Rule Elements> Type	In the Security Rule Elements block, select the type of security rule element. Valid types are: •           Include: The Company in the range could be accessed by the user •           Exclude: The Company in the range can not be accessed by the User.
Security Rule Elements> From and To	Enter the low (From) and high (To) ends of this value range. Your value does not have to be a valid segment value.

Assign Security Rules

• Navigation      :           Setup>Financials>Flexfields>Key>Security>Assign            
• Screen             :           Assign Security Rules

Enter the Segment details and click on <Find> button

Enter the following information:

Field	Description
Security Rules> Application, Responsibility	In the Security Rules block, enter the application and responsibility name that uniquely identifies the responsibility to which you want to assign security rules.
Security Rules> Name	Select the Security Rule names defined for this responsibility.
	Save your changes.

IMP: The security rules apply to a Key flexfield; hence it is applicable to all those Ledger which use same chart of account

CROSS VALIDATION RULES

Cross Validation Rules are defined to prevent creation of invalid combinations and are defined for every chart of accounts structure. As in Security Rules, these cross validation rules should be defined first with a global inclusion and then specific exclusions.

To keep the rules simple, it is suggested that these rules be defined only across two or maximum 3 segments of the accounting structure in a single rule. This would also help in any future modification requirement and also for any verification process for error correction.

• Navigation      :           Setup>Financials>Flexfields>Key>Rules                 
• Screen             :           Cross Validation Rules

Click on the  and find the Relevant Application and Flexfield Title

Enter the following information:

Field	Description
Structure	Select the structure as “MKM Accounting Flexfield”
Name & Description	Enter a unique name and description for your cross-validation rule
Error Message	Enter your error message text for this cross-validation rule. Your flexfield automatically displays this error message on the message line whenever a new combination of segment values violates your cross-validation rule. You should make your error messages as specific as possible so that your users can correct any errors easily.
Error Segment	Enter the name of the segment most likely to have caused this cross-validation rule to fail. Your flexfield leaves the cursor in this segment whenever a new segment combination violates this cross-validation rule to indicate where your user can probably correct the error. If you do not specify an error segment name, your flexfield leaves the cursor in the first segment of the flexfield window following a violation of this rule.
From & To Date	If you want to have the rule effective for a limited time, you can enter a start date and/or an end date for the rule. The rule is valid for the time including the From and To dates.
Cross Validate Rule Elements> Type	Select Include/Exclude
Account From & To	Select the From and To Account Range.

IMP: The cross validation rules apply to a Key flexfield; hence it is applicable to all those Ledgers which use same chart of account.

DEFINE ROLLUP GROUPS

Rollup group is used to identify a group of parent values for reporting purposes.

• Navigation      :           Setup>Financials>Flexfields>Key>Groups  
• Screen             :           Rollup Groups

Enter the following information:

Field	Description
Structure	Select the structure as “MKM Accounting Flexfield”
Segment	Select the relevant Segment
Rollup Groups> Code, Name and Description	Select the code, name and description.

SUMMARY TEMPLATES

Summary Accounts help in storing of balances at parent account levels to facilitate online inquiries and also budgetary controls at parent level. Summary Accounts are created by defining appropriate Summary Templates which would include relevant parent accounts in the form of Roll-up Groups. Care should be taken in defining Summary Templates as a template with ‘D’ (Detail) option in multiple segments would create multiplicity of Summary accounts whose balances has to be updated whenever a transaction is posted resulting in possible degradation of the Posting process performance.

• Navigation      :           Setup>Accounts>Summary   
• Screen             :           Summary Accounts

Enter the following information:

Field	Description
Name	Enter a Name for the summary account template.
Template	Enter the Template. – You could enter ‘T’ to cover all the values in the segment in total, ‘D’ to cover all the values in the segment in detail or a Roll-up Group name defined for the segment. This value should be entered for each of the segment in the Accounting Flexfield Structure.
Description	Enter the description for the Summary Template
Earliest Period	Enter the Earliest Period for which you want General Ledger to maintain your actual, encumbrance and budget summary account balances. General Ledger maintains summary account balances for this accounting period and for subsequent periods
Status	The status is automatically updated by the system.
Budgetary control	Click on budgetary control if the budgets are to be defined at the summary account Level

JOURNAL SOURCES

In Wafi Industrial, apart from the Seeded Journal Sources as provided by Oracle Applications, additional Sources have been defined to distinguish various journals pertaining to Landed Cost

1.      Navigate to the Journal Sources Window ( Navigation Path : Setup > Journal > Sources)

Enter the following information:

Field	Description
Source	Enter the name of the external Source
Description	Enter the description
Import Journal References	Mark the import references check box, if you want to bring in reference information
Freeze Journals	Mark the Freeze journals check box. Once the journal is imported into the general ledger, you cannot modify the journal from these sources.

JOURNAL CATEGORIES

Apart from the Seeded Journal categories as provided by Oracle Applications, additional categories have been defined to distinguish various journals as may be transferred/created from External Systems.

Additional Journal Categories can be defined as may be required by following the steps given below

• Navigation      :           Setup>Journal>Categories     
• Screen             :           Journal Categories

Enter the following information:

Field	Description
Name	Enter the name of the new category
Description	Enter the description

DOCUMENT SEQUENCE

                 

                                               

Define Document Sequence:

Document Sequences are being used to control the numbering the documents that are being generated from the system.  In Wafi Industrial LLC’s context, all Journals that are generated in the General Ledger will be numbered automatically. 

These document sequences are defined as sequences. Hence, whenever a new financial year is opened, fresh set of document sequences should be defined before any entries are passed in the new financial year in case a new series is required in New Year.

The numbering of documents created in Oracle General Ledger either directly or through external systems are controlled by the Profile Option ‘Document Numbering’ whose value would be set to ‘Partially Used’ in General Ledger to ensure that all the documents are numbered properly.  This would also require that all valid Journal Categories have a document sequence assigned to them with appropriate creation method. By ensuring such proper assignment, improper use of Journal Categories in manual transaction creation can also be controlled

           

·         Navigation      : Setup>Financials>Sequences>Define

·         Screen             : Document Sequences

Enter the following information:

Field	Description
Name	Enter the name of the New Sequence .Ensure that the name reflects the nature of transactions and the Financial Year to which the sequence pertains to.
Application	Choose the Application name as Oracle General Ledger.
From & To Dates	Enter the Start date as the first date of the new financial year.  DO NOT SET ANY END DATE
Numbering Type	Set the Generation Method (TYPE) as 'Automatic'
Message Check Box	Enable the Message Check Box for the journal categories entered manually.
Initial Value	Set the initial value appropriately.
	Save the record.

                                               

Assign Document Sequence:

The Sequence defined above will have to be attached to the Journal Category to enable numbering of documents generated in the System. All journals generated in General Ledger will have a Journal category attached to them. The numbering of these Journals will be done based on the Document Sequence assigned to the Journal Category.           

·         Navigation: Setup>Financials>Sequences>Assignment

·         Screen: Document Assignments

Enter the following information:

Field	Description
Application Name	Choose the Application Name as Oracle General Ledger
Category	Choose the Journal Category
Set of Books	Choose the Set of Books name as “WAFI INDUSTRIAL LLC”.
Method	Choose the Method of Document Creation. (Manual or Automatic or Null). This will decide how the documents will be created - Entered Manually or Created automatically or for both. Care should be taken to ensure that all categories are assigned to the appropriate sequence with appropriate method of creation.
Start Date and End Date	Enter the Start date as the First Date of the New Financial Year and end date as the Last day of the Financial Year (say 31-Jun-2008). Pl. note that new assignment to a category can not be done unless old assignments to the category if any have an end date.
Sequence	Attach the Sequence Name as defined in the earlier process.
	Save the record.

NOTE: It is suggested that all the Journal Document Sequences defined in the First period be replicated for every year   along with the assignment to the Respective journal categories.  The initial setups have been done keeping in mind all the   requirements as stated.

ACCOUNT ALIAS

Shorthand Account Aliases can be created to facilitate easy transaction entry.

                 

·         Navigation      : Setup>Financials>Flex fields>Key>Aliases

·         Screen             : Shorthand Aliases

Enter the following information:

Field	Description
	Choose the application and the chart of Accounts
	Enter the description and prompt
Alias	Enter the alias name
Template	Enter the account code combination to which it applies
Description	Enter the Alias description

Profile Option: Flex fields: Short hand Entry is set as ‘Always’ at Site Level.

FINANCIAL STATEMENT GENERATORS (FSGs)

Financial Statement Generator (FSG) is a report building tool for Oracle General Ledger. With FSG, financial reports can be defined and generated, such as income statements and balance sheets, analysis reports, budget vs. actuals, variances etc. based upon data in the general ledger, FSG is basically used to design custom financial reports to meet specific business needs. Run the same report for multiple companies, cost centers, departments, or any other segment of the account structure, in the same report request. Schedule reports to run automatically.

           

Define Row Set

A Row Set defines the format and content of the rows in an FSG report. In FSG, the commonly assumed attribute for a row definition is an account assignment, whereas the attribute for a column definition is a time period (amount type).

           Navigation      :           Reports >Define >Row Set

·         Navigate to the Row Set window.

·         Enter a Name and Description for the row set. Do not use the ampersand (&) symbol in the Row Set name.

·         Choose Define Rows.

·         Enter a Line number for each row of the row set. The line number controls the order in which rows appear in a report. You also use the line number when creating a row calculation.

·         Enter a Line Item description for each row. This appears as the row label on any report you run using this row set.

·         Enter Format Options - to control page breaks, indentation, line spacing, and underline characters

·         Enter Advanced Options – Row Name

·         Enter Display Options – Choose Level of detail as ‘Financial Analyst’

·         To have the row generate account balances on your report, choose Account Assignments to assign             accounts to the row. The accounts are assigned to indicate which general ledger account balances one    want to include in the row. One can assign an individual account or range of accounts to each row. The account may also be a summary account.

·         To create a calculation row (for report totals and subtotals), choose Calculations. - to perform a variety of computations in the report. The calculations can refer to any previous rows in a report.

      Note: A row definition can have account assignments or calculations, but not both.

·         Define additional rows for each of the row set. (steps 4 through 7)

·         Save the work.

           

Define Column Set

A column set defines the format and content of the columns in an FSG report. In FSG, the commonly assumed attribute for a column definition is a time period (amount type), whereas the attribute for a row definition is an account assignment. Therefore, typical column sets include headings and subheadings, amount types, format masks, currency assignments, and calculation columns for totals.

          

            Navigation            :           Reports >Define >Column Set

                       

The following predefined standard column sets are available in the system. New column sets can also be created to meet specific reporting needs.

Note: It is suggested not to modify standard column sets directly, since other reports may depend on the standard definitions. Instead, use Auto Copy to make a copy of the standard column set and change the definition.

Following are the predefined column sets:

PTD Variance: Includes actual, budget, variance, and variance percentage for the current period only.

QTD Variance: Includes actual, budget, variance, and variance percentage for the current quarter only.

PTD, QTD, YTD Variance: Includes actual, budget, variance, and variance percentage for the current period, quarter-to-date, and year-to-date. Amounts are in thousands.

PTD, QTD, YTD Actual: Includes actual current period, quarter-to-date, and year-to-date.

Monthly Actual: Includes monthly actuals for each month of the fiscal year plus a year-to-date total. Amounts are in thousands.

Monthly Budget: Includes monthly budget amounts for each month of the fiscal year plus a year-to-date total. Amounts are in thousands.

Quarterly Actual: Includes quarterly actuals for each quarter of the fiscal year plus a year-to-date total.

Quarterly Budget: Includes quarterly budget amounts for each quarter of the fiscal year plus a year-to-date total.

Rolling Monthly: Includes actual amounts for the current month and the preceding 11 months. Amounts are in thousands.

Rolling Quarterly: Includes actual amounts for the current quarter and the preceding 4 quarters. Amounts are in thousands.

Monthly Comparative YTD: Includes current year-to-date and prior period year-to-date.

Quarterly Comparative YTD: Includes year-to-date balance for the current quarter and the previous three quarters.

Annual Comparative QTD, YTD: Includes actual amounts for the current quarter, prior year same quarter, variance, and variance percentage. Also includes actual amounts for current year-to-date, prior year-to-date, variance, and variance percentage.

Funds Available: Includes year-to-date funds available based on posted actuals, budgets, and encumbrances. Also includes total budget for year and the percentage of total budget remaining. One can use this column set to show the obligations for encumbrance reports.

           

To define a new Column set:

·         Enter a Name and Description for the column set.

·         Enter an Override Segment. (Optional step)

Use the override segments feature to produce "breakdown" reports. For example, say that a report is defined to produce a corporate income statement. Now to create a breakdown version of the same report which shows income statement line items for each department, one report column per department. Department is one of the account segments, and can have one of departments value.

·         Choose Define Columns.

·         Enter the starting Position for each column. This is the number of characters from the left edge of the page that marks where each column starts.

·         Enter a unique Sequence number for each column. One can use the sequence number to define column calculations.

Note: The sequence number does not control the order of the columns on a report like it does for rows in a row set. Instead, column order is determined by the column starting positions.

·         Enter a Format Mask to control the display of values which FSG prints in the column.

·         Enter a Factor (Billions, Millions, Thousands, Units, or Percentiles) that determines how to display numeric values.

    

·         Enter the Balance Control options, Advanced Options, and Display Options for each column. (Optional)

·         To create a calculation column (for variances, percentages, totals and subtotals), choose Calculations. To assign accounts to the column, choose Account Assignments. (Optional step)

      Note: A column definition can have calculations or account assignments, but not both.

·         Define additional columns for the column set (steps 5 through 11).

·         Create the column headings.  Create custom column headings or modify default headings to meet the specific reporting needs.

·         Save the work.

            To change the column set lay out using column set builder

·         Navigate to Reports >Define >Column Set

·         Query a column set.

·         Choose Build Column Set.

·         Use the buttons on the Column Set Builder toolbar to add, move, or delete columns.

·         Modify any column information as needed.

·         Choose Apply to save the work and continue working with the Column Set Builder.

·         Choose OK to save the work and close the Column Set Builder.

Define Reports

A report is defined by specifying the report objects FSG should use to build the report. The simplest reports are defined by a row set and a standard column set. Also, one can add a content set, row order, and/or display set to enhance the report or refine the information in the report. One can also specify the budget, encumbrance types, and currencies to include on a report.
Once a report is defined and saved, one can use it any time -- to run the report, define a report set, or copy and save it as a new report.
Note: One can also define ad hoc financial reports, as necessary, to meet one-time reporting needs. Create ad hoc reports from the Run Financial Reports window.

          

Navigation   :           Reports >Define >Report

        

·         Enter a Name, report Title, and Description for the report. The report title is what FSG will print at the top of the report.

·         Enter the Row Set and Column Set to use for the report.

·         Enter the Content Set, Row Order, and/or Display Set to use for the report. (Optional step)

·         Enter Segment Override values for the account segments one want to override. When one enter a segment override value, FSG produces a report for the specified value. For example, assume one have a report definition which produces a combined assets report for four companies. If one modify the report definition to add a segment override for Product no. 101, then FSG will print a report for Product 101 only. (Optional step)

Note: If a segment value override specified is subsequently disabled, the Segment Override          definition becomes invalid and one must redefine the report.

·         Select a level of detail for the report. There are three options, which correspond to the levels of detail one can assign to rows and columns.

Note: If one does not enter a level of detail for a report, the system will assume the level of detail is Financial Analyst.

·         Enter an Output Option for the report: (default is Text)

à Text: Produces a report in standard text form (no tab-delimited columns). If the report is download spreadsheet, the columns and rows must be manually parsed. The default is Text.

à Tab-Delimited: Produces a report whose columns are delimited by tabs, making it easier to import the report into a spreadsheet.

à Spreadsheet: Produces a report designed specifically for downloading to Applications Desktop Integrator.

·         If the row or column set has control values assigned, one can assign budgets, encumbrance types, and currencies to those values.

·         Save the work.

·         Choose Run Report.

Define Content Set

By assigning a content set to a report request, one can generate hundreds of similar reports in a single run. The content set controls how the numerous reports differ from each other. For example, the organization has 30 departments and it is one of the account segments. If an FSG report for travel expenses is available, by using content set with the existing report definition, the travel expense report for each department, in one report, on separate pages and distribute to the department heads to review the same.
Content sets are similar to row sets and actually work their magic by overriding the row set definition of an existing report. The subtle report variations discussed in the previous paragraph are achieved by the content set altering the row set account assignments and/or display options.

Note: A content set can be saved as part of a report definition, or can be added dynamically at the time one request an FSG report.

          

Navigation   :           Reports >Define >Content Set

·         Enter the content set Name and Description.

·         Choose a processing Type for multiple reports:

                  - Parallel -- FSG processes multiple reports at the same time.

                  - Sequential -- FSG processes multiple reports in sequential order.

                  - Enter a Sequence number for each account range.

·         Enter the Account Range Low and High if one wants to override the segment value ranges specified in the row set. If you enter multiple account ranges, FSG produces a separate report for each range

·         Enter a content set display type if one want to override the row set display type.

·         Choose ‘Yes’ from the Summary poplist if you want to report only Summary account balances in the range. The parent segment values in the range must belong to a rollup group and the rollup group must be used in a summary template. Choose No if one want to report only detail account balances in the range.

If you leave this field blank, the content set will inherit the summary account reporting option from the row set or column set. If the option is set at both the row and column set level, FSG will resolve any conflicts as noted in the Row and Column Overrides table.

·         Save the work.

 

Note to define a content set that generates multiple reports: When you define the content set, assign the Display type PE to the segment for which one want separate reports for each segment value. Optionally, multiple account ranges to the content set can be assigned.

                       

Define Row Order

Use a row order to control how detail rows appear in the report. One can:

- Display account descriptions in addition to or instead of segment values.

- Sort detail rows by amounts displayed in a column.

- Sort detail rows by account segment values or segment value descriptions.

- Rearrange the sequence of the account segments to fit specific reporting needs. For example, one may want to see product segment values displayed before cost center values.

Navigation            :           Reports >Define >Order

·         Enter a Name and description for the row order.

·         Enter Rank by column information. Enter the Name or the Order of the column whose values will be used to sort the detail rows. Order corresponds to the sequence of the sorting column relative to other displayed columns in the column set, where the leftmost column has an Order of 1.

·         Enter Account display information.

                  - Description - will display the segment description on the report.

                  - Value - will display the segment value on the report.

            - Value and Description - will display both the segment value and description on the                        report.

·         Save the work.

Define Report Sets

Use financial report sets to group FSG reports that are run together frequently. One can only assign predefined reports to a report set. One can copy a financial report set that one have already defined, and then modify the new report set as needed.

·         Navigation            :           Reports >Define >Report Set

·         Enter the Name and Description of the report set.

·         Enter a Sequence number for each report one assign to the report set to control the sequence in which reports are submitted at runtime.

·         Enter the Name of each report one want to include in the report set.

·         Save the work.

·         Choose the Run Report button to navigate to the Run Financial Reports window.

                       

Define Display Groups

A display group defines a range of rows in a row set or columns in a column set. Display groups are assigned to display sets to control which rows and columns appear on a report.

·         Navigation            :           Reports >Define >Display >Display group

·         Enter the Name and Description of the display group.

·         Enter the name of a Row Set or Column Set. To create a generic display group, leave these fields blank.

·         Enter the From and To Sequence numbers in the row or column display range.

For example, if one specifies a row set and choose 10 through 40 as the sequence range, the display group will affect rows 10 through 40.

·         Save the work.

                                               

Define Display Set

With display sets and groups one can produce report variations which omit sensitive information or which include information normally not included in a report. To do this, define display set specifying rows or columns that should or should not be displayed.

·         Navigation            :           Reports >Define >Display >Display Set

·         Enter the Name and Description of the display set.

·         Enter the name of a Row Set or Column Set whose row or column display definitions you want to override with the display set.

·         Enter a Sequence number for each display group assignment.

·         Choose a Display option for each display group assignment. If you check the Display checkbox, the values related to the row and/or column ranges specified in the assigned display groups will be shown on the report. If you do not check the Display checkbox, the row and/or column values will not be shown.

Note: Even if one choose not to display the row and/or column values, the row titles and/or column headings will still appear on the report.

·         Enter the display group names in the Row Group and Column Group fields. If desired, you can enter both a row group and a column group.

Note: If display groups do not include all the rows and/or columns defined in the related row sets and column sets, the rows and/or columns not included in the display groups will appear on the report, just as they would if you were not using a display set.

·         Enter a description for the display group assignment. (Optional step)

·         Enter additional display group assignments. (Optional step)

·         Save the work.

                       

Run Financial reports

To generate FSG reports submit request from run financial report window.  Report can be requested as an individual report, all or part of a report set, or several report sets. If an individual report run, it can either run a predefined report or request that FSG run an ad hoc report. For ad hoc reports, select report objects and other report parameters during the report submission process.
When a predefined report is submitted, it can either run the report with the parameters saved in the report definition, or you can change the parameters at runtime. However, if you change the parameters at runtime, FSG will not save them in the stored report definition
Report can be submitted from request reports from the Run Financial Reports window or through standard request submission (Submit Requests window). The advantage of requesting reports through standard request submission is that it can be scheduled to run automatically.

·         Navigation            : Reports >Request >Financial

·         Choose the Individual Reports tab.

·         Enter the Report name.

·         Enter the report parameters.

·         Choose the Submit button.

To run all or part of a report set:

·         Navigate to the Run Financial Reports window.

·         Choose Single Report Set from the pop list.

·         Enter the Report Set name. Each report in the report set appears in the main reports region.

·         Optionally, change the default Report Parameters, Period, effective Date, and Currency, then choose Apply. These defaults will appear for each report listing.

·         Select the reports one want to run by: Checking the checkbox to the left of each report's listing.

Additional Information: To deselect individual reports, uncheck the checkbox to the left of the report listing.

·         Enter the report parameters one need for this run of the report set.

·         Choose Submit.

To run multiple reports sets:

·         Navigate to the Run Financial Reports window.

·         Choose Multiple Report Sets.

·         Enter the Report Set names.

·         Enter the report parameters one need for the report sets.

·         Choose Submit.

                       

To run adhoc report :

One can define ad hoc financial reports as necessary to meet special reporting needs. An ad hoc report is one define at the time of running financial reports. There is no need to assign a name to an ad hoc report. Instead, General Ledger automatically names ad hoc reports as follows: FSG-AD HOC<Sequence Generated Number>.

·         Navigate to the Run Financial Reports window.

·         Choose the Define Ad Hoc Report button.

·         Enter a name for the report Title. If this field is empty, the report title will default to the Row Set Description. If Row Set Description is empty, the report title will default to Row Set Name.

·         Enter the Row Set and Column Set to use for the report.

·         Enter any additional report information, including Budget, Encumbrance, and Currency control values.

·         Choose OK to return to the Run Financial Reports window.

Useful Reports:

1.           Column Set detail listing

2.           Content Set detail listing

3.           Report detail listing

4.           Report set detail listing

5.           Report summary listing

6.           Row order detail listing

7.           Row set detail listing

STANDARD REPORTS

The General Ledger module provides various reports in analyzing the data and also listing out the various master values. The reports that are provided as part of the standard applications can be grouped into following

Ø  Account Analysis Reports

§  Account Analysis Report

The Account Analysis reports list the accumulated balances of a range of accounts and all journal entry lines that affect that range. The same segment security rules defined for your chart of accounts extend to these reports. These rules restrict user access to segment values in your accounting flexfield to those authorised by their responsibility.

This report prints the journal entry lines and beginning and ending balances of the accounts you request. For each journal entry line, the report prints the source, category, batch name, journal entry name, account, description, entry/line/source item reference information, and the debit or credit amount.

§  Account Analysis Report with Payables Detail

This report can be used to reconcile asset additions imported into General Ledger from Oracle Payables. The report prints the beginning balance, journal entry lines, and ending balance of the accounts you request. For each journal entry line, the report prints the batch name, journal entry name, account, line description, vendor name, invoice number, and the debit or credit amount.

§  Account Analysis Report with Subledger Details

The report displays detail amounts for a specific journal source and category, in  functional currency or STAT. This report prints the journal entry lines and beginning and ending balances of the accounts requested. For each journal entry line, the report prints the accounting date, category, journal batch name, header, sequence, number, line, description, and amount. For each journal entry line, the report also prints subledger details, including the vendor or customer name, transaction number, associated transaction, sequence, number, line, and transaction type.

Ø  Chart of Accounts Report and Listings

§  Account Hierarchy Report

This report gives a list of detail accounts that roll up into each summary account for all summary templates. New page is created for each summary template. This report is prints the listing for the current set of books, without prompting you for any parameters.

§  Chart of Accounts Listings

This report gives a list of enabled detail accounts, disabled detail accounts, summary accounts. This report can be run for a range of accounts given in the parameters.

§  Rollup Detail Listing

This gives a list of child segment values for each parent segment value for a specific account segment. GL sorts the listing in ascending order by account parent segment value.

           

§  Rollup Range Listing

Gives a list of all parent segment values for an account segment. This listing includes information about each parent segment value, such as the rollup group to which each parent segment value belongs, whether each parent segment value is enabled and its range of child segment values. General Ledger sorts this listing in ascending order by parent segment value.

                       

§  Inactive Account Listing

Gives a list of disabled and expired accounts. You can specify a date of interest and an account range. Use this report to determine why particular accounts are no longer active. Possible causes:

                       

§  Segment Value Listing

Gives all segment values for a specific account segment. This listing includes information about each segment value, such as whether your segment value is enabled, whether it is a parent, and whether posting and budgeting are allowed. Run this listing for your account segment to verify that your accounts have been assigned the correct account type. General Ledger sorts this listing in ascending order by segment value.

Ø  General Ledger Reports

§  General Ledger Report

Gives journal information to trace each transaction back to its original source. General Ledger prints a separate page for each balancing segment value. For each journal line, the report prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance. Additionally, for each journal line, the report prints journal details including source, category, journal name, and effective date. The report lists accounts in ascending order by account segment value, and it prints a ”CR” next to credit amounts.

Ø  Journal Reports

§  General Journals Report

The General Journals Report is available in three different formats. You can request a report of Posted Journals, Unposted Journals or Error Journals. Each are described below.

Posted Journals: Gives posted journal batches and the journals associated with each posted journal batch. This information allows you to trace your transactions back to the original source. The report prints the line number, account, transaction date, description, line/source item, the debit or credit amount, and the statistical amount for each journal line. Totals are provided for all journal lines within a journal, and all journals within a journal b batch. In addition, totals are provided for your journal source, and a grand total is provided for all of the debit and credit amounts included in your report.

Unposted Journals: Gives Unposted journal batches and the journals associated with each posted journal batch. This information allows you to trace your transactions back to the original source. The report prints the line number, account, transaction date, description, line/source item, the debit or credit amount, and the statistical amount for each journal line. Totals are provided for all journal lines within a journal, and all journals within a journal b batch. In addition, totals are provided for your journal source, and a grand total is provided for all of the debit and credit amounts included in your report

Error Journals: Gives error journal batches and their associated journals. This information allows you to trace   your transactions back to the original source. Journal batches become error journals if posting fails; they do not lose their error status until they are posted successfully. The report prints the line number, account, transaction date, description, line/source item, the debit or credit amount, and the statistical amount for each journal line. Totals are provided for all journal lines within a journal, and all journals within a journal entry batch. In addition, totals are provided for your journal source, and a grand total is provided for all of the debit and credit amounts included in your report.

                       

§  Journal Entry Report

Gives journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values. The report prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal. In addition, a total is provided for each balancing segment included in your report and a grand total is provided for all the activity included in your report.

                       

§  Journals by Document Number Report

Gives detailed information for each journal associated with a specific document sequence. General Ledger prints the journals in ascending order by document number. For each journal, the report prints the creation date, batch name, journal name, category, posting status, and posted date, currency, and journal amounts. The report also indicates which document numbers do not have an associated journal.

§  Journals – Day Book

Gives posted journal entries and journal details chronologically by accounting date for a specified range of dates, journal source, and journal category.

Ø  Trial Balance related Reports

§  Detail Trial Balance Report

Gives your general ledger actual account balances and activity in detail. You can run this report for balances and activity entered in your functional currency or STAT, or translated to a foreign currency. The report prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity, and ending balance for the period you specify. General Ledger reports debits as positive

Amounts and credits as negative amounts.

                       

§  Expanded Trial Balance Report

Gives the beginning, ending and net balances as well as period activity for a set of accounts. You can view your actual balances and activity in your functional currency or translated to a foreign currency. You can also use this report to review your statistical account balances and activity. The report prints a line for each account segment value and sorts them in ascending order. For each account segment value, the report prints the account description, beginning balances, period activity, ending activity, and ending balances for the period you request.

Ø  Other Reports

All details about these reports, their parameters and the data reported by them are available as part of the User Guide provided along with the applications.