26 Feb 2011

concurrent program auto commit

If the program completes successfully, it's retcode will be '0' and that session committed automatically i.e., you need not to put explicit commit in the PL/SQL procedure.If your PL/SQL procedure is being called from a concurrent program NO explicit commit is required. 

Which means you need not to put commit at the end of the procedure if your procedure is registered as concurrent program

14 Feb 2011

Overview on Multi-Org Structure

Overview on Multi-Org Structure


What is Multi-Org

Multi-Org is an enhancement to Oracle applications that enables you to model multiple business units in an enterprise using a single installation of Oracle applications. In a multi-org architecture you can keep data secure and separate from each business unit.

The following are the benefits of multi-org:

            •          You can use a single installation of any Oracle Applications product to support any
          number of business units, even if those business units use different set of books.

            •          Secure access to data so that users can access only information that is relevant to them.

            •          You can define an organizational model that best suits your business requirements.

Organization Model



The multi-org model provides a hierarchy that dictates how transactions flow through different business units and how those business units interact. You define the organizations and the relationships between them.

Business Group
 This is an Organization that represents the consolidated enterprise, a major division, or an operation company and has no accounting impact. The Business Group partitions Human Resources information and the Purchasing Approval Hierarchy. If you request a list of employees (in any module) you will see only those employees in the Business Group of which your Operating Unit is a part. Multiple Legal Entities can relate to a single Business Group.
You must have at least one Business Group. For a new installation, Oracle Applications provides a default business group called Setup Business Group. You can define additional business groups as required for your enterprise.

Set of Books
 A set of books (SOB) is a financial reporting entity that shares the three Cs: a particular chart of accounts (accounting flexfield structure), functional currency, and financial accounting calendar. You create sets of books using the Set of Books window in Oracle General Ledger. You define all other types of organizations using the Organizations window.

Legal Entity
 A legal entity represents a legal company for which you prepare fiscal or tax reports. You assign tax identifiers and other legal entity information to these types of organizations.

Operating Unit
 An operating unit represents an organization that uses any Oracle sub ledger application, for example, Order Management, Payables. It may be a sales office, a division, or a department. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications. Each user sees information only for their operating unit. Responsibilities are linked to a specific operating unit by the MO: Operating Unit profile option.

Multi-Org Access Control (MOAC)
     Multi-Org Access Control, or MOAC, enables users to access multiple operating units from a single application responsibility.

    Operating unit security will be preserved such that companies can effectively implement security and shared services at the same time.

   Enhanced Multi-Org Reporting provides the ability to process and report critical financial information at different levels of the enterprise.
      
Prior to Release 12, each responsibility could access only one operating unit.  Therefore, users who had to manage multiple operating units had to log in and log out of multiple responsibilities to perform their tasks. In Release 12, users can perform tasks for multiple operating units without changing responsibilities and its achieved by setting up MO: Security profile.

Usage Example:


In 11i, If a company had three operating units Belgium, Holland, and Denmark, the company would have to create three responsibilities, one for each operating unit.  And users, who had to enter invoices into all 3 operating units, had to log into each one of the EMEA responsibilities separately.

With Multi-Org Access Control in R12, each application responsibility can access multiple operating units. The company can create a single EMEA responsibility for all three operating units and users would only have to log in once to perform tasks such as: entering payables invoices, viewing consolidated requisitions, performing collections, and processing receiving and drop shipments.

It is required to set up either the MO: Operating Unit or MO: Security Profile profile option for each application responsibility to use Multiple Organizations context sensitive applications. If the MO: Security Profile is set, then the MO: Operating Unit profile is ignored.

Data security is maintained using security profiles that are defined for a list of operating units and determine the data access privileges for a user When drilling down on balances from Oracle General Ledger, General Ledger ignores the operating unit profile setting to allow you to drill down to your subledger details, regardless of which operating unit originated the transaction.

The OU field visible for all relevant transactions and relevant setups.  On data entry, the system will derive the OU, when possible.  E.g. if user enters a PO default invoice, the supplier site determines OU.

·         Create Security Profile
·         Run Security List Maintenance program
·         Setup profile option MO: Security Profile
·         Setup profile option MO: Default Operating Unit


Note: If a responsibility has to access only one operating unit, then set the profile option - MO: Operating Unit. If a responsibility has to access multiple operating units, then define a security profile with multiple operating units assigned and assign it to the MO: Security Profile profile option