Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, August 12, 2012

Oracle R12 General Ledger Setup


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


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

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)

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


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


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.


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


                 

                                               

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.



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

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.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect