Search This Blog

Thursday, 28 May 2015

Overview of General Ledger:

General Ledger.


Oracle General Ledger is the collection point for all financial transactions. Its tool to integrate the sub ledger activities [AP, AR, and FA] and consolidating accounts. General ledger will be used for financial reporting. It is the central repository of all subledger activity, maintaining the highest summary level of financial information from the transaction details supplied by its sub ledgers. If a company does business in many regions across the world. Oracle General Ledger provides financial management solution like currency conversion rates, tracks and reports the balances in multiple currencies.

Oracle General Ledger provides the rich set of reporting tools like: –
1. FSG [Financial Statement Generator]
2. Application Desktop Integrator – Web ADI Report Manager
3. Oracle Financial Analyzer
4. Business Intelligence system with OBIEE
  – Oracle Business Intelligence Enterprise Edition tool.
5. Oracle Enterprise Planning and Budgeting.

The balance sheet summarizes accounts and financial activities in three broad categories: 

Assets
Which represent everything the company owns?
Liabilities
Which show how much money the company owes to others
Capital and Retained earnings
Which show the total cash invested in the business by the owners or 
Shareholders. 
Profit and loss (P&L) statement:
Income statement, represents the performance of a 
Company over time. 

In addition, accounts are kept for all the revenues and expenses of the company.

The chart of accounts determines how accounting information is collected, categorized, and stored for reporting purposes. Across the entire EBusiness Suite, all accounts are identified by a unique Accounting Flexfield (AFF) combination.

The Accounting Flexfield consists of multiple segments, such as those for company, cost center, and account. One full Accounting Flexfield is called a combination. Each journal entry line is tagged with an Accounting Flexfield combination. For expense transactions, the AFF usually identifies who incurred the cost (for example, which company or department) and what the cost was for (for example, travel expense). If you want more detailed information, such as which region, cost 
center, and product incurred the cost, you can design your AFF structure to include that information as well. Because total debits must always equal total credits in every transaction, Oracle General Ledger requires that all journals balance.



Multiple Charts of Accounts:
  1. Company operating in global environment, requires the multiple COAs.
  2. A company with subsidiaries in different geographical regions might have to adapt to different account structures based upon various laws for that region or base currency requirements.

Accounts and Periods:
  1. Transactions only entered in Open periods.
  2.  Two or three periods are open at once to allow for prior period transactions and future period transactions.
  3.  The accounting periods in Oracle Financials can start and finish on any day of the year, and the start and end days can differ from year to year; but the number of periods each year must remain constant. This limitation is required in order to produce year­to­year comparisons.

Common Accounting Calendars and their Usage.


Account Closing Balance = Opening Balance + Total (debits) − Total (credits)

Account Opening Balance for One Period = Closing Balance for the Previous Period 

Trail Balance Report: It ensures that total debits equal the total credits. This is a basis of double-entry bookkeeping system. Total grand total does not have any significance for the company or managers.

Balance Sheet: It’s a snapshot of company’s financial position. This report is extensively used by external purposes by investors, customer and creditors.  The balance sheet is prepared by following accounting principle.

Asset = Capital + Liabilities


The Profit n Loss report [Income statement] :  Used by accountants, prepared by following formula.

Profit = Total Revenues − Total Expenses 

Accounting Methods:


There are 2 main accounting methods:

Accrual method: In this type the transactions records, the revenue and expenses when they occurred, not when the payment is received.
For example: A sale on account would be recorded as revenue even though the customer has not paid the bill.

Cash Method: In this type the transactions records, when payment occurs, regardless of when the 
Transaction takes place.
For example:
when the company receives the customer's check, revenue is recorded even though the goods were shipped two months earlier. 

The Organizational Model within Oracle E­Business Suite R12.

The Organizational Model in EBS R12.


What is Organization in E-business R12?
The term organization serves a double purpose:  It is everyday meaning refers to a company, corporation, government agency, or charity, 2nd one is the Oracle E­Business Suite model, organizations in Oracle E­Business Suite can be Ledgers, legal entities, operating units, or inventory organizations.
Following levels of hierarchy followed to setup Multi Org Access Control [MOAC].
  • Business groups
  • Primary ledgers (as defined in Accounting Setup Manager)
  • Legal entities / GRE
  • Operating units
  • Inventory organization
Example 1 in Organization in R12:
In below picture,
  1. Business group: 1
  2. Ledgers: 2 [ Canada, India]
  3. Legal entities: 2 [Canada & India]
  4. Operating units:  2 in Canada, 1 in India.
  5. Inventory Organizations:2 in Canada, 1 in India
What is Business Group?
  1. A Business Group is the highest level in the organization hierarchy structure, usually representing the consolidated enterprise, an operating company, or a major division.
  2. The business group secures the employee information in all applications except for HR.
Example: Total number of employees working in organization.  If there is a Group of Companies and they all are using a single instance of Oracle Apps then every employee in each company will be defined at BG level. Each employee will then be assigned a responsibility. That responsibility determines which company that employee belongs to and what type of transaction can be carried out.
What is Ledger?
  1. Formerly called Set of Book in R11i. Ledger is an accounting book.
  2. There are 4C’s concepts in Ledger.
    1. Chart of Account (Particulars of Goods)
    2. Currency (Amount)
    3. Calendar (Date)
    4. aCcounting convention  [Sub ledger Accounting Convention (Cash / Accrual)]
  3. Oracle General Ledger resides at this level.
What is Legal Entity?
  1. A legal entity is a company for which, by law, you must prepare fiscal or tax reports, including a balance sheet and a profit­and­loss report.
  2. In accounting terms, the legal entity is the smallest business unit for which you need to be able to produce a balanced set of accounts. For nonprofit organizations the legal entity is equivalent to a fund.
  3. In R12, you assign a Legal Entity to a Ledger. In R11i I Legal entities consist of one or more operating units.
  4.  In Oracle EBS a company is also referred to as GRE – Government Reporting Entity.
  5. Oracle says anything can be your legal entity. Your manufacturing plant can be your legal entity, your departments can be your legal entity. Your inventory can be your legal entity. A legal entity is the one for which you want a Balance Sheet and Income statement.
What is Operating Unit?
  1. Operating units represent buying and selling units within your organization. The operating unit concept is most apparent in Oracle Order Management, Oracle Receivables, Oracle Purchasing, and Oracle Payables. The transaction data that these modules hold—purchase orders, invoices, payments, and receipts—are partitioned by operating unit. That is to say that one operating unit cannot see the purchase orders, invoices, payments, and receipts for another operating unit, even if the same vendor or customer is involved.
  2. A ledger can have many operating units assigned to it.
  3. All the transactions for an operating unit must appear on the balance sheet of only one legal entity. There is no reason to split the liabilities and receivables of one operating unit across two legal entities. 
What is Inventory Organizations?
  1. Inventory organizations are defined to manage stock levels and perform inventory stock movement transactions.
  2. The capability to stock materials, manage availability levels, ship to external parties, and account for all of these is an inherent Inventory Management task.
  3. The inventory organization is a unit that has inventory transactions and balances, and possibly manufactures or distributes products. The inventory of an organization consists of the finished products that are ready for sale, all parts that are in stock waiting to be assembled into finished products, and all the assemblies of parts that are currently being assembled in the factory.
  4. You must have a location (address) when creating an inventory organization, or any other organization. E-Business Suite does not intrinsically distinguish between a physical and a logical location. This means that it is not a one-to-one relationship and more than one organization can have the same location.
  5. In R12 an inventory organization can point to only one operating unit
What is Sub-inventory Organization?

  1. Sub inventories are sub locations within an inventory organization. Typically an inventory organization reflects a physical location of a warehouse or storage facility. Sub inventories on the other hand are logical locations within that physical location that help identify specific areas where materials are stored. This is purely a logical definition.

Wednesday, 20 May 2015

STEP 12: Post Installation steps of Oracle BI Applications 11.1.1.8.1


Post Installation Steps

How to set Business Analytics Warehouse Connection in Oracle Data Integrator.


When you open the the Oracle Studio, click on ‘Connect to Repository’. It will show as




Click on Edit, will show by default following screen:




Change the connection details as per your ODI Schemas created using OBI Apps 11.1.1.8.1 RCU.

Note : jdbc:oracle:thin:@//localhost:1521/ORCLDB







Modify as below.

NOTE: The User in ‘Oracle Data Integrator Connection’, should be the same as while installing BIAPPS RCU – there was step – ‘BI Applications Administrator Username’. Same username should be provided.

In My case, its ‘BIAPPS’.




Possible Errors:





If the same Administrator username is not provided then, may face error : WORKREP not found.


While editing the following line in the file “ODI.CONF”. Please verify is the line correct, may be 2 equal signs, spelling mistakes. May cause

AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml











Click on the Search Icon of - WORK REPOSITORY, Following pop up window will show with the name of ‘BIAPPS_WORKREP’




Final Connection to ODI repository should be as follows :




In the navigation pane, go to Topology, and expand Technologies, and then expand File.


Double-click BIAPPS_DW_FILE.


In the Definition pane, for the Directory (Schema) and Directory (Work Schema) properties, specify the directory where you copied source files ; to a location that ODI Agent deployed in WebLogic Server can access but that is outside of the Oracle Home directory. otherwise, when the Oracle BI Applications environment is upgraded or patched, these files will be overwritten.

Example : <source file home>/biapps/etl/data_files/src_files/BIA_11


Registering Source Systems and Propagating Connection Details to Oracle Data Integrator





Launch Oracle BI Applications Configuration Manager using the URL

http://localhost:9704/biacm




Login with BI Application Administrator User, created by BIAPPS RCU.

STEP 11: How to Start the BI and Oracle Data Integrator Managed Servers

How to Start the BI and Oracle Data Integrator Managed Servers


  • Note that Oracle BI Applications requires the BI and Oracle Data Integrator Managed
Servers (bi_server1 and odi_server1) to be started using Node Manager.
  • This is very important to properly set the following:
  1. Parameters
  2. JVM Arguments
  3. Memory.
Q: What will happen if we not follow the above mentioned step?
Ans: If you do not start the BI and Oracle Data Integrator Managed Servers, functionality loss and
memory issues can occur in Oracle BI Applications Configuration Manager, Functional
Setup Manager, and Oracle Data Integrator.

To ensure that the BI and Oracle Data Integrator Managed Servers are started using Node Manager, start them using the WebLogic Administration Console user interface.

Example :
1) Navigate to Start Menu -> CMD -> Open as 'Run as administrator'.
2) Change Oracle BI Domain directory.
 Example: CD C:\MW11G\user_projects\domains\bifoundation_domain\bin.
3) To start the Admin server. Right click on 'startWebLogic.cmd' start as 'Run as administrator'.
4) Login to Weblogic Admin Console. [http://localhost:7001/console].
5) Clicl on ‘Lock & Edit’ Button and navigate to ‘Environment’ -> ‘Servers’  As shown below :
5). Click on ‘CONTROL’ Tab.
6). Click on Check boxes of  ‘bi_server1’  and  ‘odi_server1’.
7). Click the ‘START’ Button.

NOTE: Do not start the BI and Oracle Data Integrator Managed Servers using the Managed Server start scripts.


Configuring User Access for ODI Studio


To configure user access for ODI Studio:
1. Copy cwallet.sso and jps-config-jse.xml from:
<MW_Home>/user_projects/domains/bifoundation_domain/odi-client-config/embedded
To:
<ODI_Home>/oracledi/client/odi/bin
2. Edit <ODI_Home>/oracledi/client/odi/bin/odi.conf by updating the JPS configuration file name as follows:
Change to
AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml

STEP 10: Configuring Oracle BI Applications 11.1.1.8.1

Configuring Oracle BI Applications
  1. Before starting the configuration process, please ensure, WLS Admin Server, Node Manager, and BI Services are running.
  2. Go to path C:\OBIEE_HOME\Oracle_BI1\bin
  1. Oracle Business Analytics Application Suite installer starts.
Click on Next button.
Username : weblogic    Password: Admin123.
Provid the RPD password: Admin123
Specify a user name for the Oracle BI Applications Administrator.
Note:
  1. Do not enter "Administrator," "Admin," "Sadmin," or "Supervisor" in upper case, lower case, or mixed case letters. These user names are reserved. Also, do not use the WebLogic Server administrator user name.
  2. Please make a Note these credentials because
    1. This user will be used to perform system setups, login to Config manager and FSM.
    2. This user is used for communications between the Oracle BI Applications Configuration Manager and Oracle Data Integrator.
    3. This user has full access privileges in Configuration Manager and access to Oracle Data Integrator with the Supervisor role.

Example :
Username : biapps
Password : Admin123

To know the schemas created by BIApps RCU and OBIEE RCU. You can run the following query. You will get to know what is username for different components like ODI, MDS, OBI Apps DW [data warehouse] schemas.


Configuration Manager          : http://localhost:9704/biacm
Functional Setup Manager : http://localhost:9704/setup/faces/TaskListManagerTop Oracle Data Integrator                  : http://localhost:15001/odiconsole
You can login the above URLs with :
username : biapps
password : Admin123.
As provided in this installation.