Tuesday, 10 September 2019

Basic Terms and concepts in Ledger.

Legal Entities:

 An organization that represents a legal company for which you prepare fiscal or tax reports. You assign tax identifiers and other relevant information to this entity.



Operating Units:

 An organization that partitions data for subledger products (AP, AR, PA, PO, OE). It is roughly equivalent to a single pre-Multi-Org installation.



Ledgers :

 The accounting system which tracks the journal entries that affect each account.



Reporting Currencies:

 The currency you use for financial reporting. If your reporting currency is not the same as your functional currency, you can use foreign currency translation to restate your account balances in your reporting currency.





Subledger Accounting:

 A subledger is a ledger containing all of a detailed sub-set of transactions. The total of the transactions in the subledger roll up into the general ledger. For example, a subledger may contain all accounts receivable, or accounts payable, or fixed asset transactions



Intercompany Balancing:

 Intercompany Balances means the intercompany accounts receivable and accounts payable between any member of the ABC Group, on the one hand, and any member of the XYZ Group, on the other hand.



Intercompany account:

 A general ledger account which you define in an Accounting Flexfield to balance intercompany transactions. You can define multiple intercompany accounts for use with different types of accounts payable journal entries.



Intercompany journal entry:

 A journal entry that records transactions between affiliates. Oracle General Ledger keeps your accounting records in balance for each company by automatically creating offsetting entries to an intercompany account you define.



Sequencing (Accounting and Report Sequencing):

 When the journal entries recorded manually we usually assign unique sequence number for each entry and transfer the entries to GL.

 Sequence numbering the JE simplifies this cumbersome task of tracing the journal entires.

Foreign Currency Concepts in GL

Foreign Currency Concepts

Below are the three key foreign currency concepts in GL

Conversion
• When foreign currency transactions that are immediately converted at the time of entry to the ledger currency of the ledger in which the transaction takes place refers as Conversion of currency.
Revaluation
•There might be fluctuation in the Exchange rate between the time when the transaction was entered & the end of the period, in this scenario Revaluation concept of Currency helps to adjust the liability or asset accounts that may be understated or overstated at the end of the period.
Translation
• Translation refers to reset an entire ledger or balances for a company from the ledger currency to a foreign currency.

General Ledger Accounting Cycle

General Ledger Accounting Cycle
Below are the steps for the Accounting Cycle of GL
1. Open period
2. Create/reverse journal entries
3. Post
4. Review
5. Revalue
6. Translate
7. Consolidate
8. Review/correct balances
9. Run accounting reports
10. Close accounting period

We will study each step in coming posts... :) 

Monday, 9 September 2019

Oracle General Ledger Overview

Oracle General Ledger Overview.


  • GL is the Central repository of accounting information.
  •  All accounting information in oracle application is centrally stored in General ledger module
  •  Main purpose of a general ledger system is to record financial activity of a company.
  •  GL is also widely used to produce financial and management reports.

Oracle General Ledger is a comprehensive financial management solution that enables you to:
  • Record and Review Accounting Information
  • Import data from subsidiary ledgers, or enter journals to record actual or budget transactions directly into Oracle General Ledger.
  • Enter encumbrance journals to track encumbrances through the purchase process and to control spending against budgeted amounts.
  • Review account balances online or through reports.
  • Manipulate Accounting Information
  • Correct actual, budget, and encumbrance information.
  • Revalue and translate balances denominated in foreign currencies.
  • Consolidate balances from multiple sets of books.
  • Analyze Accounting Information
Function & Features of GL

Information Access
• Access information stored in the GL through online reporting and analysis tools.
Financial Controls
• Use security features to control access to specific areas and functions of General Ledger.
Data Collection
• Collect data from Oracle subledgers and non-Oracle feeder systems.
Financial Reporting and Analysis
• Select from a variety of Standard Reports and Listings.
• Use the Financial Statement Generator to build customized reports with reusable report objects.
• Use Web ADI (Web Applications Desktop Integrator) Report Manager to build reports and drilldown on balances within a spreadsheet environment.

Query to find the Project and Task details.

SELECT ppa.project_id                                    ,
  ppa.name project_name                                   ,
  ppa.segment1 project_number                             ,
  ppa.project_type                                        ,
  ppa.carrying_out_organization_id                        ,
  hou.name   Organization              ,
  ppa.project_status_code                                 ,
  ppa.description                                         ,
  ppa.start_date                                          ,
  ppa.completion_date                                     ,
  ppa.closed_date                                         ,
  ppa.summary_flag                                        ,
  ppa.enabled_flag                                        ,
  ppa.org_id                                              ,
  hou1.name Operating_Unit                                      ,
  ppa.project_currency_code                               ,
  ppa.allow_cross_charge_flag                             ,
  ppa.project_rate_type                                   ,
  ppa.projfunc_currency_code                              ,
  ppa.long_name                                           ,
  pt.task_number                                          ,
  pt.task_id                                              ,
  pt.task_name                                            ,
  pt.top_task_id                                          ,
  pt.wbs_level                                            ,
  pt.chargeable_flag                                      ,
  pt.billable_flag                                        ,
  pt.limit_to_txn_controls_flag                           ,
  pt.start_date Task_start_date                           ,
  pt.completion_date task_completion_date                 ,
  pt.allow_cross_charge_flag tasks_allow_cross_charge_flag,
  pt.long_task_name,
  hou.attribute6,
  ppa.pm_project_reference
   FROM apps.pa_projects_all ppa    ,
  apps.pa_tasks pt                  ,
  apps.hr_all_organization_units hou,
  apps.hr_all_organization_units hou1
  WHERE 1               =1
AND hou.organization_id =ppa.carrying_out_organization_id
AND hou1.organization_id=ppa.org_id
AND ppa.project_id      =pt.project_id
AND ppa.segment1        =  &project_number
ORDER BY task_number

Query to find Active user Responsibilities.

SELECT
       DISTINCT fu.user_name USER_NAME,
       fu.description  Description,
       pf.Employee_Number,
       fr.responsibility_name, furg.start_date,
       to_char (furg.end_date, 'DD-MON-YYYY HH:MI:SS'),
       fu.email_address,
      fa.application_name,
      hou.NAME
FROM
      APPS.fnd_profile_option_values fpov,
       APPS.fnd_profile_options fpo,
       APPS.hr_operating_units hou,
       APPS.fnd_responsibility_tl fr,
       APPS.fnd_application_tl fa,
       APPS.fnd_user_resp_groups_direct furg,
       APPS.fnd_user fu,
       APPS.per_all_people_f pf
 WHERE
   fpov.profile_option_id = fpo.profile_option_id
   AND fpov.application_id = fpo.application_id
   AND fpo.profile_option_name = 'ORG_ID'
   AND fpov.profile_option_value = TO_CHAR (hou.organization_id)
   AND fpov.level_value = fr.responsibility_id
   AND fa.application_id = fr.application_id
   AND fpov.level_value = fr.responsibility_id
   AND furg.user_id = fu.user_id
   and fu.employee_id=pf.person_id
   AND furg.responsibility_id = fr.responsibility_id
  and ((furg.end_date is null) or (furg.end_date >=sysdate))
  and( fu.end_date >= sysdate or fu.end_date is null)
    order by fu.user_name asc