R12 Account Analysis Report from Subledger Accounting Is Now Available

 

IMPORTANT NOTICE

The Account Analysis Report from Subledger Accounting is now available in Oracle Financials.  The Account Analysis Report provides drill-down information about the movement on a range of accounts and displays all journal entry lines that affect that range for a period or range of periods. The report only includes journal entries transferred to and posted to General Ledger.

INSTRUCTIONS FOR RUNNING THE ACCOUNT ANALYSIS REPORT

1)      Login to R12 Oracle EBS Financials

2)      Select GL Reporting – COSD responsibility

3)      Navigate to Reports > Request > Standard

4)      Select Single Request

5)      Enter ‘Account Analysis Report’

6)      Enter your parameters.

Account Analysis Report Selection Parameters:

• Ledger/Ledger Set
  Required: Yes
  Valid Values: COSD
  
  
• Period From/Period To
  Required:  Yes
  Valid Values: All periods for the accounting calendar
  
  
• Balance Type
  Required: No
  Valid Values:  Actual, Encumbrance, Budget
  
  
• Budget Name
  Required:  No
  Valid Values:  All enables budgets for COSD ledger
  
  
• Encumbrance Type
  Required:  No
  Valid Values:  Commitment, Obligation, Invoice*, Invoices**, Manual
  *  These are invoice encumbrances generated from R11
  ** These are invoice encumbrances generated from R12
  
  
• Account Flexfield From/To
  Required:  Yes
  Valid Values:  All enabled accounting code combination from the ledger's chart of accounts
  

   
• Include Zero Amounts Lines
  Required:  No
  Valid Values:  Yes or No; controls whether journal entry lines with both entered and accounted amounts equal to zero are included in the report.

 

 

 If you have any questions, please contact the Oracle and Kronos Support Center at (619) 515-4377.