Sunday, June 29, 2014

Oracle Payment Process Request statuses–PPR

 

The list below is not a comprehensive list of EVERY possible Status that may appear on a PPR (or on its associated Payment Instruction file(s)), but it does include the statuses most commonly encountered:

      • NEW:
        This status indicates that the PPR has been successfully submitted for processing, and the AutoSelect program is digesting the criteria provided by the user on the header of the PPR in preparation of the automatic selection the invoices and memos related to that criteria.
      • SELECTING INVOICES:
        This status indicates that the AutoSelect program is selecting the eligible invoices/memos for the payment batch based on Due Date, Discount Date, Pay Group, and other criteria provided by the user on the header of the PPR.
      • CANCELLED - NO INVOICES SELECTED:
        If no invoices or memos met the selection criteria provided by the user on the header of the PPR, the PPR is automatically terminated and the status changes to this status.
      • "MISSING..." STATUSES:
        Other statuses may appear at this point in the process if the user failed to included required information on the PPR header, such as "Missing Exchange Rates", etc.
      • INVOICES SELECTED:
        After selecting the documents (invoices/memos), they are locked to prevent other checkruns from selecting the same documents.
      • INVOICES PENDING REVIEW:
        This status will only appear if you selected the Stop Process for Review After Scheduled Payment Selection option on the Processing tab of the PPR header. This status means that the PPR process has stopped, and is waiting for you to review the invoices and memos that were selected for payment (and make any changes to the batch, as needed). Click on the Take Action icon to be taken to the Review Selected Scheduled Payments window.
      • CALCULATING SPECIAL AMOUNTS:
        This status will only appear if you selected the Calculate Payment Withholding and Interest During the Scheduled Payment Selection option on the Processing tab of the PPR header. This status means that interest and withholding tax are being calculated and applied, as necessary, to the invoices and memos selected for this payment batch.
      • ASSEMBLING/ASSEMBLED PAYMENTS:
        An "interim" status, it appears after the calculation for interest and withholding has been completed, and the Build Payments program is starting. It may appear again later after the user provides any required bank account and PPP information for the invoices/memos ("documents") selected.
      • INFORMATION REQUIRED - PENDING ACTION:
        This status appears if you did not provide a default Internal (Disbursement) Bank Account and/or PPP on the header of the PPR. In that case, you need to click on the Take Action icon to be taken to a form where you can decide which internal bank account and PPP should be used for each invoice and memo selected for payment.
      • PENDING PROPOSED PAYMENT REVIEW:
        This status will only appear if you selected the Stop Process for Review After Creation of Proposed Payments option on the Processing tab of the PPR header. In this case, the system is waiting for you to review (and modify, if needed) the proposed payments for this batch. Click on the Take Action icon to be taken to the Review Proposed Payments window.
      • FORMATTING:
        This status indicates that the proposed payments have been turned into payment instruction files. At this point, you will want to click on the Show link to view the new associated payment instruction file(s). Each payment instruction file with have their own PI Reference Number. If you have both electronic and paper ("check") payments involved in this payment batch, you will see a payment instruction file for each type of payment method.
        • PAYMENT INSTRUCTION STATUSES:
          An "electronic" type of payment instruction file will usually be marked as FORMATTED at this stage, which means the PI has been created, (and based on your setups) may also have been transmitted, and even marked as "Complete".
          A "check" type of payment instruction file will (based on your setups) usually be marked as FORMATTED - READY FOR PRINTING, which means the payment instruction file was created, and is waiting to be sent to your printer. Click on the Take Action icon to send the file to the printer.
          Afterward, the Status will change to SUBMITTED FOR PRINTING. Click on the Take Action icon again to "confirm" the payments (Record Print Status). This is also where the user will have an opportunity to "Reprint" the payment instruction file, if there were problems during the first printing process. Once the payment instruction file has been printed, an internal Payment Reference Number is assigned to the payment, along with a Paper Document (Check) Number.
          Once the user clicks on the Record Print Status button (and confirms it), the payment instruction file's Status changes again, this time to PRINTED.
      • CONFIRMED PAYMENT:
        Once the payment instructions have been transmitted/printed and confirmed, the Status of the PPR changes to this status to indicate a successfully completed payment batch (PPR).
      • TERMINATED:
        If the user terminates a PPR anytime prior to confirmation of the payments (using the Terminate icon), the status will change to "Terminated", and the PPR is permanently closed.

Friday, June 27, 2014

Mass Allocation in Oracle General Ledger R12

Steps for generating a Mass Allocation Journal:

1. Pass a Standard Journal – This will identify your “A”
2. Pass a STAT Journal – This will identify your “B” and “C”
3. Define Mass Allocation Formula Batch and Journal.
4. Validate the Formula.
5. Generate the formula for specific accounting period.
Let’s see how we can carry out the process of Mass Allocation in General Ledger.
First let me take a scenario. Consider an organization with 8 divisions or departments:

1. Finance dep (010)
2. Sales dep (020)
3. Marketing Dep (030)
4. Delivery Dep (040)
5. Resourcing dep (050)
6. HR Dep (060)
7. Production dep (070)
8. Management Team (080)

The COA Structure of this organization is Company -Department-Account-Intercompany-Product
100- Total department (Parent) (Child Ranges: 001 – 099)
Let’s allocate the telephone bill expense of Rs. 38950 for the month of June incurred at Karachi branch on the number of employee each department has. The allocation basis in this example is Head Count per Department.

The account code for 01 and the natural Account for expense burden is 7050 and each department has 19, 7, 15,6,24,11,9 and 3 employees respectively.

1. Finance dep (010) >19
2. Sales dep (020) >7
3. Marketing Dep (030) >15
4. Delivery Dep (040) >6
5. Resourcing dep (050) >24
6. HR Dep (060) >11
7. Production dep (070) >9
8. Management Team (080) >3

Now the MassAllocation procedure steps starts.

STEP1: 

We will create a total cost or “A” of the formula. Pass a Standard JV in the period of JUNE-2014 with the following Lines
Line1: 01-000-7050-00-0000 38950 (DR) (Expenses Burden a/c)
Line2: 01-000-1110-00-0000 38950(CR) (Cash Account)

Line Description-1: KS US Operations-Default-Expenses Burden Allocated-Default-Default
Line Description-2: KS US Operations-Default-Cash-Default-Default

This journal entry is equivalent to paying your telephone bill. Ideally this expense entry should be coming from Oracle Payables. We are manually entering this actual journal so that we can created a Cost Pool “A” having an amount of Rs.38950.



 
STEP2:

Now we will create the “B” and “C” or Usage Factor and “Total Usage”. Pass a STAT JV. STAT is short for Statisticaland it can be used by changing the currency from USD to STAT. The STAT journal doesn’t need to be balanced. But they do affect the account balances if we inquire on the currency type of TOTAL but let’s not get there, it is a different topic. Simply pass a STAT JV to create “B” and “C”. Remember the Period of the JV should be JUNE as the Standard JV.
The account code combination for the STAT journals in this scenario will be

Line1: 01-010-7050-00-0000 19(DR)
Account Description: KS US Operations-Finance department-Expenses Burden Allocated-Default-Default
Line2: 01-020-7050-00-0000 7(DR)
Account Description: KS US Operations-Sales department-Expenses Burden Allocated-Default-Default
Line3: 01-030-7050-00-0000 15(DR)
KS US Operations-Marketing department-Expenses Burden Allocated-Default-Default
Line4: 01-040-7050-00-0000 6(DR)
KS US Operations-Delivery-Expenses Burden Allocated-Default-Default
Line5: 01-050-7050-00-0000 24(DR)
KS US Operations-Resourcing-Expenses Burden Allocated-Default-Default
Line6: 01-060-7050-00-0000 11(DR)
KS US Operations-Human resource-Expenses Burden Allocated-Default-Default
Line7: 01-070-7050-00-0000 9(DR)
KS US Operations-Production Department-Expenses Burden Allocated-Default-Default
Line8: 01-080-7050-00-0000 3(DR)
KS US Operations-Management Team-Expenses Burden Allocated-Default-Default




By passing or posting this STAT journal we are creating a basis for expense allocation. We can enable UOM on STAT journal by enabling the profile option JOURNAL:MIX STATISTICAL AND MONETARY to YES. Similarly so on and so forth. Now where are “B” and “C” in this journal? You can see 8 lines with changing Department codes, these four lines individually represent Usage Factor “B” which is 19,7,15,6,24, 11,9, & 3 and collectively they represent Total Usage “C” which is equal to 19+7+15+6+24+11+3=94.


Now moving on with STEP3

STEP: 3

Create a MassAllocation Batch and then a Journal.
When you open the formula entry form you will find the three constant of the Mass Allocation formula A, B, C and two other fields T and O. “T” stands for Target Account and “O” stands for Offset Account. I will explain these Accounts later. Let’s continue with the formula.
Now give the account of the “A” which is 01-000-7050-00-0000 having the value of Rs.38950. On the account entry form you will find that the system prompts or asks for Ledger, it is an optional field. This option of ledger set is used when we are allocating cost from multiple ledgers. And there is another LOV having the value as


C: Constant – The segment is constant and doesn’t need any Loop or Sum. And the balance should be picked against “A” as a constant

L: Looping – The segment needs to loop from first value to last value provided in STAT JV.

S: Summing – The segment needs to sum the value in provided in STAT JV.
Generally the account code in “A” doesn’t not need any kind of looping or summing. So every segment should be given the value of C. The value this account has for the particular period should be picked as a constant. Keep the currency as Entered.

Now move on to enter the code for “B”. The account code for Usage Factor in our example will be
01-100-7050-00-0000. Note that I have given the department code as 100 which is parent of the departments we selected for allocation basis. Give every segment a Constant C but the segment of Department will be having the value as Looping L. Why? Because we need to pick the individual values of 19,7,15,6,24, 11, 9 and 3.

REMEMBER: looping is only done on Parent Value of the Segment. In this example 100 is the Parent department which has the child departments 010, 020, 030,040,050,060,070 and 080.
The system will automatically pick the allocation basis by matching the natural account and the looping segment.
REMEMBER: The currency for “B” and “C” should be STAT.



Now give the account code for the Total Usage “C”. The account code will remain the same as “B” with 100 as the department code. The only difference this time is that instead of Looping we will give the Department segment the value of Summing S. so that we can have the sum of head count which is 94.



It’s time to give the “T” account. No, it’s not the T Account as we see in Ledger. It is the Target Account of the cost pool or these are the Debit Accounts which should hold the allocated expense. In our example these account are the accounts we gave in “B”. Yes the account code combination 01-100-7050-00-0000 with 100 as Looping. IN FACT, usually the accounts given in “B” are repeated in “T” and account given in “A” is repeated in “O”



Let’s proceed further by entering the “O” or the Offset account. This account is same as the account we gave in “A”. This is the credit account. The account code combination given here will 01-000-7050-00-0000 with every segment as Constant.



Now allocation formula has been completed.


Validation is pending, so click validate all (B)


Concurrent completed successfully



 
Generate the Mass allocation, click on submit.
Select the ledger, balancing segment value and period then click on submit




Review the journal once complete the concurrent program




With this step we have completed our allocation formula. The final Journal generated with this formula should be


That it.

Tuesday, June 24, 2014

Order to Cash Cycle (O2C)–In R12

Overview

In this practice, you will learn how to create orders with a standard item. Please note that you will be completing an order to cash cycle with a standard item using all the seeded data available in the environment. Examples of seeded data are: Order Type, Customer, Price List, Item, etc.

Create an order to cash lifecycle

1. Create an order.

2. Save and book the order.

3. Pick Release the order.

4. Ship Confirm the order.

5. Use AutoInvoice to create an invoice for the order.

Practices Steps – Order to Cash life cycle

Responsibility: Order Management Super User, Vision Operations (USA)

Create an Order

1. (N) Orders, Returns > Sales Orders

2. Create an order for Business World:

Field

Value

Customer

Business World (1608)

Order Type

Mixed (defaults)

clip_image002

3. Verify the following on the Main tab and Others tab (if the field is not visible on the window, you can folder-enable it):

Field

Value

Operating Unit

Vision Operations

Shipping Method

DHL

Note: this may be under (T) Others

Warehouse

M1

Price List

Corporate

Ship To Location
Bill To Location

<Both should default depending on the Customer Name/Number selection>

clip_image004

4. (T) Line Items – enter Order Line Information:

Field

Value

Ordered Item

AS54888

Qty

2

clip_image006

5. Save your work. The Status on the line should display as Entered.

clip_image008

6. Click (B) Book Order to book the order. Note your Order Number 66862.

clip_image010

7. Click (B) OK to acknowledge Note.

Note: Ensure you are at the line level prior to checking the workflow. Click (M) Tools > Workflow Status to see the status of the flow. Click (B) View Diagram on the Workflow Status HTML page to see the order processes and activities. A green box around the activity indicates that the activity is in progress. Close the Workflow Status window to return to the Sales Orders window.

clip_image012

8. Close the window.

Pick Release the Order

9. (N) Shipping > Release Sales Orders > Release Sales Orders

10. In the (T) Order tab, the Orders field should show a value of Unreleased.

Enter your order number in the Order Number field.

The Customer and Order Type fields get populated based on the Order Number field value.

clip_image014

11. Click (T) Inventory, enter the following:

Field

Value

Warehouse

M1

Auto Allocate

Yes

clip_image016

12. Click (T) Shipping, enter the following:

Field

Value

Autocreate Delivery

Yes

Auto Pick Confirm

Yes

Ship Confirm Rule

<Clear the field>

clip_image018

13. Click (B) Execute Now to pick release and pick confirm the order.

clip_image020

14. Click (B) OK to acknowledge Note.

15. Close the window.

Ship Confirmation

16. (N) Shipping > Transactions

17. The Query Manager window opens. Enter your order number in the fields From Order Number and To Order Number. Select no value in the Line Status field.

clip_image022

18. Click (B) Find to find your order.

19. The Shipping Transactions window opens to display your order details with the statuses.

clip_image024

20. (T) Delivery

clip_image026

21. Click (B) Ship Confirm and accept defaults.

clip_image028

22. Click (B) OK

23. You will receive a message that the delivery was successfully confirmed. Click (B) OK and close the Shipping Transactions window.

clip_image030

Verifying Status

24. Open the Sales Orders window to check the status of your order. (T) Line Items: the line status should display as Shipped.

clip_image032

25. Click (M) Tools > Workflow Status to see the current status of your order. Click (B) View Diagram to see the diagrammatic representation of the order flow. When a workflow activity is enclosed in a green box, it implies that the activity is in progress.

clip_image034

Viewing the Shipping Details from the Sales Orders window

26. Click (B) Actions > Additional Line Information to view the delivery and trip information and status.

Additional Line Information

Delivery Status: Closed

Picked Status: Shipped

Trip Status: Closed

clip_image036

Interfacing to Receivables using the Workflow Background Process Concurrent Program

Note: These steps may not be necessary if the Workflow Background program is already running on a scheduled basis.

27. From the Sales Orders window, navigate to (M) View > Requests.

· Click (B) Submit a New Request

· Select Single Request

· Request Name: Workflow Background Process.

· Enter the following as parameters in the Parameters window:

Parameter

Value

Item Type

OM Order Line

Process Deferred

Yes

Process Timeout

Yes

Process Stuck

<Clear the default value>

clip_image038

28. Click (B) OK to accept parameters

29. Click (B) Submit to process your request. You will get a request ID that you can track in the Find Requests window. Click (B) No in the Decision pop-up.

Note: Click (B) Find to see your request processed. It should complete as Normal.

clip_image040

30. Return to the Sales Orders window. Query for your order by using the F11 key. Enter your order number and use the Ctrl-F11 keys to get the query results. Though your order status still displays as Booked, the line status should show up as Closed.

clip_image042

31. Close the window.

Run AutoInvoice

32. (N) Receivables > Interfaces > AutoInvoice

· Click (B) OK to Submit a Single Request. The concurrent programs window opens to enable you to run AutoInvoice.

33. In the Name field select the AutoInvoice Master Program and enter the following parameters in the parameters window:

Parameter

Value

Organization

All

Invoice Source

ORDER ENTRY

Date

<current date>

(Low) Sales Order Number

<Look for your Sales Order Number range in the LOV and select it>

(High) Sales Order Number

<Look for your Sales Order Number range in the LOV and select it>

clip_image044

34. Click (B) OK and return to the main window. Click (B) Submit to run AutoInvoice. You will be given a request ID, which you can use to track the status of your request. It should complete as normal.

Viewing your Invoice Details

35. (N) Orders, Returns > Order Organizer

36. Enter your order number and click (B) Find.

37. When your order appears in the result list, click (B) Actions > Additional Order Information > (T) Invoices / Credit Memos.

clip_image046

38. Click (B) Invoice Details to view the invoice autocreated from your order.

clip_image048

39. Click on the invoice print (B) .

clip_image050

40. Close the screen and return to the navigator

Monday, June 23, 2014

Oracle General Ledger FSG Report Fundamentals - Basics

Standard Reports and Listings

 Oracle General Ledger delivers over 70 standard reports. The following categories provide financial and non-financial information for General Ledger data.


Standard Reports and Listings
Oracle General Ledger provides several types of reports and listings to meet your business needs. All of the information in these reports and listings is also available online.
You can obtain account analysis information, budget information, chart of accounts listing, and many other types of data without customization.


When to Use Standard Reports


Use Standard Reports to do the following:
       To view financial and non-financial information in trial balances, journals, account analysis, and other reports
       To group reports into report sets that can be run simultaneously
       To schedule reports to run at regularly scheduled intervals

Financial Statement Generator Features

Financial Statement Generator (FSG) is a powerful report building tool for Oracle General Ledger.
Financial Statement Generator Features
Oracle General Ledger's Financial Statement Generator empowers you to do the following:
          Generate financial reports, such as income statements and balance sheets, based upon data in your general ledger.
          Apply security rules to control what financial information can be printed by specific users and responsibilities in any reports they run using FSG.
          Define your reports with reusable report objects, making it easy to create new reports from the components of reports you've already defined.
          Design custom financial reports to meet specific business needs.
          Print as many reports as you need, simultaneously.
          Print the same report for multiple companies, cost centers, departments, or any other segment of your account structure, in the same report request.
          Schedule reports to run automatically.
          Produce ad hoc reports whenever you need them.
Print reports to tab–delimited files for easy import into client–based spreadsheet programs.



Use Financial Statement Generator Reports to do the following:   
       Create custom financial statements
       Create consolidated reports and perform consolidation for companies sharing the same set of books
       Report on translated and foreign currency amounts
       Report on budget vs. actual and different amount types such as PTD, QTD, and YTD

Preparing Your FSG Report

Plan your report before you begin building your rows and columns.


Preparing Your FSG Report
Before you define a report in Oracle General Ledger, draft your report on paper. Sketching the report in advance helps you plan the format and content of the report and saves you time later.




With FSG you use a fundamental row and column concept to build your own financial reports:
       Decide which rows and columns make up your report
       Define the rows and columns
       Assign attributes to the rows and columns
       Build a report using the rows and columns

Building Basic Reports
Basic reports consist of a few headings to describe the information in the report, followed by the report data, which is often presented in tabular form as a series of intersecting rows and columns. Basic reports are two dimensional, similar to what you might create in a spreadsheet.


Oracle General Ledger's Financial Statement Generator (FSG) is a powerful and flexible report building tool you can use to build your own custom financial reports without programming.

Financial Statement Generator
You can define custom financial reports, such as income statements and balance sheets, online with complete control over the rows, columns, and content of your report. You can control headings, descriptions, format, and calculations in addition to the actual content. The reusable report components make building reports quick and easy. You can copy a report component from one report, make minor edits, then apply the report component to a new report without having to create a new report from scratch.
Row Set
          A required report component that defines the rows of your report. Typically, accounts are assigned to row set definitions. For each row, you control the format and content, including line descriptions, indentations, spacing, page breaks, calculations, units of measure, and precision.
Column Set
          The second required report component that defines the columns of your report. Typically, amount types are assigned to column set definitions. You control the format and content of each column.
Report
          You build a report by defining then combining up to five reusable report components. At a minimum, you must have a row set and column set for every report. Before you define a report using the Financial Statement Generator (FSG), draft your report on paper. Sketching the report in advance helps you plan the format and content of the report and saves you time later.



Steps for FSG Financial Reports

Use a four-step process to create and run customized financial reports.


Steps for FSG Financial Reports
All reports require a row set and a column set. There are three other optional report components that are used to apply special formatting to your reports. For example, you can hide specific rows, rearrange the sort order of your rows, display the account value and/or description, or print reports by any accounting flexfield segment, such as department, on separate pages.
Report Sets
          A report set is a group of FSG reports. Typically, report sets are used to group reports you run together frequently. For example, you can create a month-end report set that includes a balance sheet, an income statement by department, an income statement by company, and a budget vs. actual income statement in a single submission without having to run each report separately.

Defining Row Sets

Define the format and content of rows in financial reports.


Defining Row Sets
          A single row set can be used for many different reports. For example, Row Set A above is used for an Income Statement with current information. It can also be used to produce an Income Statement for any other entity (company, division, group, or cost center), or for the same entity with a yearly comparison column.
          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 or amount type. When you define a row set, you can:
Assign accounts:
          To indicate which general ledger account balances you want to include in the row. You can assign an individual account, parent account, or range of accounts to each row.
Define calculations:
          To perform a variety of complex computations in your report. The calculations can refer to any previous rows in a report, including rows you choose not to display.
Specify formatting:
          To control page breaks, indentation, line spacing, and underline characters. You can define a new row set, or use FSG's AutoCopy feature to copy an existing row set, which you can then modify as needed.
Note: If you have average balance processing enabled in your set of books, you can report on functional, foreign, and translated average balances.
Implementation Note
Row Set:
          When creating a balance sheet, you must include your entire income statement account range for the Current Period Retained Earnings amount. Oracle General Ledger never posts the monthly net income amount to an actual current period retained earnings account. This only happens when the first period of a new fiscal year is opened. Thus, to achieve the figure for current period retained earnings, it is a reporting solution where you enter your Profit and Loss account range in the account assignment.     
          When creating reports, it is a good idea to include check figures at the end of the report to verify that all accounts were properly assigned in the reports. This is particularly useful if you have had to enter account ranges with gaps because of the structure of your chart of accounts.
          For example, when creating a Balance Sheet, add check figures at the end of the report defined as follows:
-          Total Assets 1000-1999
-          Total Liabilities 2000-2999
-          Total Stockholder's Equity 3000-9999. Note: In order to derive the net income amount that is usually posted to current period retained earnings, you must include your income statement account range.
Assigning Line Numbers to Rows:
          You should enter line numbers in increments of 10 to allow for space to add additional rows for future modifications.
Account Assignment Display Option:
          Oracle General Ledger stores debit balances as positive numbers and credit balances as negative numbers. If you want your credit balance accounts, such as liabilities, and revenues to display as positive numbers, select the Change Sign check box. Doing so will have no effect on your calculations.



 Assigning Accounts

You can select the sign and ranges of accounts for each row in your row set.


Assigning Accounts
Select the Account Assignments button to assign accounts for a row set.
Select a numeric operator (+ or -) to add or subtract the totals for the account range.
Enter a Low and High for the range of account combinations. To specify an individual account, enter the same account as the Low and High. You can leave these fields blank to create generic row sets with universal account assignments.
Enter a Display type for each account segment:
          Select "E" to expand the range and display one report line for each segment value.
          Select "T" to total the amounts in the range and display only one total line for the segment values.
          Select "T" for each segment of the range if multiple account ranges are assigned to a row.
          Select "B" to display both the expanded detail and the Total. "B" combines the effects of "E" and "T".
Implementation Note
Account Assignment:
          You should always enter a unique Row Name for every row. The Row Name does not appear in any reports, but it does appear in lists of values when you perform calculations. If the row is simply a label, for example, "Current Assets", that does not have any accounts assigned to it, you should append the row name with the word "label" to let you know that this row contains no accounts and you will not need to include it in your calculations. Also be sure the row name is unique to ensure that calculations yield the correct results. If you use the same row name for two different rows, FSG will not know which row to use.
          Consider creating generic row sets by applying "T" display types for each account segment. You can later define content sets to create more specific reports.



 Defining Calculations in Row Sets

To define formulas, Oracle General Ledger provides the following mathematical operators:

Defining Calculation in Row Sets
Median - The midpoint or the middle value.
Average - The value obtained by dividing the sum total by the number.
Standard Deviation - A value obtained by dividing by one less than the number of squares in the sum of squares.
Absolute Value - Debit and credit values are both displayed as positive numbers.
Note: Because Balance Control and Display Options are usually defined for columns, they are covered in the Defining Column Sets section. However, they may also be defined for rows.
Implementation Note
Row Set Calculations:
          Oracle General Ledger stores credit balances as negative numbers and debit balances as positive numbers. For example, revenue accounts are stored as negative numbers and expense accounts are stored as positive numbers. Therefore, you should define your calculations accordingly. For example, to create a row called Gross Margin that calculates revenues minus costs, you should add (not subtract) your costs row to your revenue row.



 Reviewing Your Row Set Definitions

Review row set component definitions using standard FSG listings requested from the Submit Request window.
       Use the FSG–Row Set Summary Listing to review the name and description of the row sets defined and the report title and the chart of accounts associated with each row set
       Use the FSG–Row Set Detail Listing to review the row sequence, name, description, amount type, period offset, currency, format and display options, account assignment and calculations for each row of a row set

Reviewing Your Row Set Definitions
The main difference between these two reports is that the FSG–Row Set Summary Listing summarizes all row sets while the FSG–Row Set Detail Listing details only one row set.

Defining Ad Hoc Reports

Create financial reports on the fly by defining ad hoc reports in the Run Financial Reports window.


Defining Ad Hoc Reports
To run ad hoc reports, you select report objects and other report parameters during the report submission process. With predefined report, you can run the report with the parameters you saved in the report definition or you can change the parameters at runtime.
Note: If you change the parameters at runtime, FSG will not save them in the stored report definition.


Defining Column Sets


Define the format and content of columns in financial reports.

Defining Column Sets
          Column sets define the format and content of columns in your financial reports. Column sets include headings and subheadings, currency assignments, amount types, exception conditions, and calculation columns for totals.
          You can define columns one by one as you do for row sets, or you can build a column set graphically.
          When you define a column set, you indicate which Oracle General Ledger balance type you want to include in the column.
          Although you normally assign accounts to your rows, you can also assign an individual account combination or range of account combinations to each column.
          You can define calculations to perform a variety of complex computations in your report.
          The calculations can reference other columns in the report.
          You can define a new column set, copy information from an existing column set, or use one of the standard column sets provided by Oracle General Ledger.
Implementation Note
Column Sets:
          When using the Quarter-To-Date (QTD) Amount Type in column sets to perform quarterly reporting, you will need to create four different column sets if you are using a non-standard calendar, such as a 13 period calendar because 13 does not divide evenly into 4 and the period offsets will not give the desired results.
Column Set Amount Types:
          When creating column sets that will be coupled with Balance Sheet Row Sets, be sure to use the Year-to-Date (YTD) amount type. Oracle General Ledger does not store YTD balances. Thus, in order to achieve a cumulative total on balance sheet accounts, you must have FSG calculate the amount for you using the YTD amount type.



Applying Column Set Relative Headings


You can use relative headings to create dynamic column headings which depend on the period you specify. Relative heading you can use are:
       &POI (Period of Interest)
       &BUDGET
       &DOI
       &ENCUMBRANCE
       &CURRENCY

Applying Column Set Relative Headings
&POI:
          Enter &POI, followed by a number from -999 to +999 that refers to the relative period offset of your column.
          For example, enter &POI0 to display amounts for the period you specify at run time, enter &POI-1 to display amounts one period before the period you specify at run time.

&BUDGET:
          Enter &BUDGET, followed by a control value number to print the budget name assigned to the control value number when you define or run your report.

&DOI:
          Date of interest, the date for which you want to run the report.

&ENCUMBRANCE:
          Enter &ENCUMBRANCE, followed by a control value number to print the encumbrance type assigned to the control value number when you define your report.

&CURRENCY:
          Enter &CURRENCY, followed by a control value number to print the currency assigned to the control value number when you define or run your report column.


Standard Column Sets


Oracle provides 14 standard column sets that cover a variety of generic reporting requirements.
       Income Statements
       Balance Sheets
       Other Reports


Standard Column Sets
          Columns containing actual amounts for multiple consecutive periods (trend reports)
          Actual, budget, and variance columns (control reports)
The generic column sets can be used for the following reports:

Income Statements
          Functional: Breaks out expenses by functional area
          Natural Account: Lists expenses by account or groups of related accounts

Balance Sheets
          Detail balance sheet accounts
          Summary balance sheet accounts

Other Reports
          Statement of changes to financial position
          Daily activity reports

You can define these reports at whatever level of detail is appropriate for your business.




Reviewing Your Column Set Definitions


Review column set component definitions using standard FSG listings requested from the Submit Request window.
       Use the FSG–Column Set Summary Listing to review the name and description of the column sets defined in your current set of books
       Use the FSG–Column Set Detail Listing to review the column sequence, name, description, amount type, period offset, currency, format and display options, account assignment and calculations for each column of a column set

Row Set and Column Overrides

A conflict exists if different values are entered for the same option in both the row set and the column set.


Row Set and Column Overrides
Row Overrides Column
          Amount Type
          Period Offset
          Control Value (Must assign same currency or budget type at row and column level)
          Format Mask
          Factor
          Display Zero
          Level of Detail
Column Overrides Row
          Override Row/Column Calculations (Conflict exists only if the same value (Yes or No) is entered at both the row and the column set levels)
          Activity
Other Conflicts
          Accounts: Report uses intersecting accounts.
          Summary: Must assign the same summary option at the row and column level.
          Currency: Must assign the same currency at the row and column level.
          Change Sign: Yes overrides No.
Change Sign on Variance: Yes overrides No.



Defining and Requesting Financial Reports


Mix and match row sets and column sets to create a variety of reports.


Defining and Requesting Financial Reports
          Once you define a report, you can save it and use it whenever you run a financial report or define a report set.
          You can copy a financial report you have already defined and modify the new report as necessary.
          You can also define ad hoc financial reports as necessary to meet special reporting needs.
Caution: If the same Row Set is used in ten different reports and you later modify the Row Set, the ten reports will be affected.
Implementation Note
Ad Hoc Reports:
          All ad hoc reports are saved by FSG to be rerun in the future. You can delete each report individually in the Define Financial Report window or you can delete all of them at once by running the Program – Delete Ad Hoc Reports from the Submit Requests window.
Running Reports:
          If your FSG reports are not producing output or you are having trouble getting a complicated report definition to work correctly, you should view the log file for the Financial Statement Generator in the Requests window. If the error message in the log file is not detailed enough, change the user profile option FSG: Message Detail to full.

Handling Rounding Problems


Oracle General Ledger offers two choices for handling rounding problems.
Example: Format is 99999; Factor is Thousands



Specifying Control Values



Specifying Control Values
You can report on budgets, encumbrance types, and other currencies by using control values. Control values are numbers that you specify in the Control Value field, of the Balance Control options region, on row sets and column sets. When you define a financial report applying the row set or column set containing a control value, you must specify what the control value or number represents in the Define Financial Report window. There is a Control Value button located on the Define Financial Report window which opens the Control Values window. Here, you specify a number and a budget name, encumbrance type, and/or currency. For currencies, you can specify "entered" currencies or "translated" currencies.
Note: You must run translation before you use the "translated" currency type.
For example, if you define a column set and specify a control value of "1", you refer to the same number in the report definition and assign either a budget name, encumbrance type, or currency to associate with the control value.
Notes:
          You must assign the same budget, encumbrance type, or currency to intersecting row and column control values.
          You cannot enter currencies in the report definition if the report does not contain a row and/or column set with a currency control value.
          You must specify a budget or encumbrance when your report includes rows or columns which use related amount types, such as PTD-Budget or PTD-Encumbrance.



Defining Content Sets


Define content sets to override segment values and produce multiple versions of a single report.


Defining Content Sets
Even though content sets are optional, they are the most powerful component of all FSG components.
By assigning a content set to a report request, you can generate hundreds of similar reports in a single run. The content set controls how the numerous reports differ from each other. For example, you can define a departmental content set which prints a separate report for each department or you can apply a content set to an expand row set to print a total report.
Content sets work by overriding the row set definition of an existing report and replacing the row set account assignments and/or display options.
Content sets can be saved as part of a report definition, or can be added dynamically at the time you request an FSG report.
Hint: Consider using content sets exclusively to control the specific output for each report.



Selecting Display Options

Use display options to control if segment range values are totaled and how they are displayed.
       RE - Row/Expand
       RT - Row/Total
       RB - Row/Both
       CT - Column/Total
       PE – Page Expand Report
       PT - Report/Total
       N - No Override
Selecting Display Options
You can enter a display option for each account segment range to designate how you want to display information in a report and whether to print single or multiple reports.
RE - Row/Expand:
          Select RE to expand the range and display a separate line for each segment value in the range. If you are using parent values, enter the same value as the high and low. Oracle General Ledger displays only the children (or grandchildren). This is the same as selecting Expand for row sets.
RT - Row/Total:
          Select RT to total the amounts in the range and display only one line as the Total line. This is the same as selecting Total for row sets.
RB - Row/Both:
          Select RB to expand and total the range. RB will display a separate line for each segment value and display a total for all the segment values. This is the same as selecting Both when defining row sets.
CT - Column/Total:
          Select CT to total the range and display only the total for the segment values. This has no effect on the report display.
PE – Page Expand Report:
          Select PE to expand the range and create a separate report for each segment value in the range. If you are using parent values, enter the same value as the high and low. Oracle General Ledger displays only the children (or grandchildren).
PT - Report/Total:
          Select PT to total the segment value range and display the total on one page.
          N - No override: Select to use display options entered in the row set definition.
Implementation Note
Display Options:
          Page Expand (PE) Report is the most commonly used display option. It allows you to perform consolidation within FSG.




Reviewing Your Content Set Definitions

Review report component definitions using standard FSG listings.
       Use the FSG Content Set Summary Listing to review the names, descriptions, and processing types of the content sets defined in your current set of books
       Use the FSG Content Set Detail Listing to review the segment values and their display types for a content set

Defining Row Orders

Modify the order of detail rows in a report.
Defining Row Orders
You can use a row order with row expand row sets or content sets to control how expanded detail rows are displayed in your report.
You can do the following:
          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 your account segments to fit specific reporting needs.
          Suppress descriptions for particular account segments.



 Ranking Methods

Determine in what order rows are displayed:
       By segment value
       By segment description
       By values within a specified column
       Specify what segment information to display:
       Value
       Description
       Both

Ranking Methods
Oracle General Ledger offers several ways to order and display expanded detail rows. Select a ranking method and to display segment values, segment value descriptions, or both. Alternatives include the following:
          Order by ranking, display description: For example, department number.
          Order by ranking, display both: For example, the name of the department.
          Order by description, display description: For example, department description.
          Order by description, display value
          Order by value, display description
          Order by value, display value



 Reviewing Your Row Order Detail Listing Report

You can use the Row Order Detail Listing to review the ranking and display options of a row order.

  
 Copying Reports and Components

Create new reports and report objects by copying existing objects using AutoCopy, then modifying the copied report objects. Items that can be AutoCopied include:

Copyright Reports and Components
You can copy existing row sets, column sets, content sets, row orders, display sets, reports, and report sets to create new report objects.
After you copy a report object, you can modify the new object instead of recreating a new object from scratch.
Caution: Modifying a report object will affect all reports that use the report object. To avoid affecting all reports that use a report object you want to modify, use AutoCopy to create a copy of the report object, then apply the desired modifications to the copy of the report object.



 FSG Report Prerequisites

Prerequisite for running Financial Statement Generator reports include the following:
       Use the profile option FSG:Allow Portrait Print Style to control print orientation
       Define security rules to limit the financial information a specific user can print
       Include Program - Run Financial Statement Generator in your responsibility to run FSG reports as standard report submissions

FSG Report Prerequisites
          To control the print orientation of reports that are less than or equal to 80 characters wide, set the user profile option FSG:Allow Portrait Print Style.
          To limit what financial information can be printed by specific users on their FSG reports, define security rules and enable them for use with FSG.
          To run reports through standard request submission, your System Administrator must assign Program - Run Financial Statement Generator to the report security group for your responsibility.
Note: We recommend that you run the General Ledger Optimizer program before you run your monthly reports. This will help your financial reporting processes run faster. Program – Optimizer is run from the standard report submission window.

Enabling FSG Security

Use the General Ledger Super User or System Administrator responsibility to define security rules to control what financial information specific users can print when they run FSG reports.

Enabling FSG Security
If you have General Ledger Super User or System Administrator responsibility, you can define security rules to control what financial information specific users can print when they run FSG reports. For example, you can prevent Company 01 users from printing reports for Company 02 and vice versa.



Run FSG Reports from Standard Request Submission



Run FSG Reports from Standard Request Submission
You can 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 you can schedule the reports to run automatically. You can also combine FSG reports with standard reports, listings, and programs. The disadvantage is that you cannot run report sets through standard request submission.




Running Financial Report Sets


       You can include multiple reports in a single financial report set
       You can include multiple financial report sets in a single multiple report set
       You can run all or part of a report set
       You can run several reports with predefined print options and parameter values
       You can include a report more than once if you want to run the same report with different parameter values

FSG Tips and Techniques


To maximize your reporting flexibility and keep report maintenance to a minimum:
       Draft your reports on paper first
       Define a logical chart of accounts and make use of Parent accounts
       Define generic row sets and use existing column sets
       Use the Expand and Both options

FSG Tips and Techniques

To maximize your reporting flexibility and keep report maintenance to a minimum:
       Select the rounding option for your calculations
       Change the order of detail rows
       Use content sets and display sets for your report
       Use AutoCopy
       Transfer report objects from one database to another

Setting FSG Options for General Ledger



Setting FSG Options for General Ledger
FSG: Accounting Flexfield:
          Select the General Ledger application reporting flexfield. The default value for this profile option is account. You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site or application level.
FSG: Allow Portrait Print Style:
          Control the print orientation of your Financial Statement Generator reports that are less than or equal to 80 characters wide. You can print these reports in either portrait style (80 character wide) or landscape style (132 character wide).
FSG: Enable Search Optimization:
          Enhance the performance of reports that contain account assignments with a large number of parent segment values and child segment value ranges. When you set this profile option to Yes, the FSG performance enhancement is applied.
FSG: Enforce Segment Value Security:
          Control whether your defined security rules will apply to reports produced using FSG.
FSG: Expand Parent Value:
          Control whether the rollup group or the summary flag associated with flexfield assignments determine the expansion of parent values when requesting summary balances.
FSG: Message Detail:
          Specify the error message catalogue and level of detail in your error message log file when you request your Financial Statement Generator reports.
FSG: String Comparison Mode:

          Do not change this profile option unless instructed to do so by Oracle World Wide Support. This profile option affects the character language for text-based character sets.