Infolinks

Tuesday 15 May 2012

MULTIORG

Multiorg :

=============
Use a single installation of any Oracle Applications product to
support any number of organizations, even if those organizations
use different sets of books.

    BusinessGroup (HRMS=>Workstructure=>Organization=Description)
    Set of Books  (GL=>Setup=>Financials=>Books=>Define)
    Legal Entity 
    Operating Unit
    Inventory Organization
        Sub Inventory     (Inventory=.Setup=>organizations=>SubInventories)
        Stock Locations   (Inventory=.Setup=>organizations=>Stock locatiors)
        Items   

Major Features
===============
1)Multiple Organizations in a Single Installation

2)Secure Access
    You can assign users to particular organizations. This ensures accurate
    transactions in the correct operating unit.

3)Multiple Organizations Reporting

You can set up your Oracle Applications implementation to allow
reporting across operating units by setting up the top reporting level.
You can run your reports at the set of books level, legal entity level, or
operating unit level

Business Group:
===============
The business group represents the highest level in the organization
structure, such as the consolidated enterprise, a major division, or an
operation company. The business group secures human resources
information. For example, when you request a list of employees, you
see all employees assigned to the business group of which your
organization is a part.

Set Of Books:
============
A financial reporting entity that uses a particular chart of accounts,
functional currency, and accounting calendar. Oracle General Ledger
secures transaction information (such as journal entries and balances)
by set of books. When you use Oracle General Ledger, you choose a
responsibility that specifies a set of books. You then see information for
that set of books only.


Legal Entity:
=============
A legal company for which you prepare fiscal or tax reports. You
assign tax identifiers and other legal entity information to this type of
organization.

Operating unit:
===============
An organization that uses Oracle Cash Management, Order
Management and Shipping Execution, Oracle Payables, Oracle
Purchasing, and Oracle Receivables. 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.

Inventory Organization:
=======================
An organization for which you track inventory transactions and
balances, and/or an organization that manufactures or distributes
products. Examples include (but are not limited to) manufacturing
plants, warehouses, distribution centers, and sales offices. The
following applications secure information by inventory organization:
Oracle Inventory, Bills of Material, Engineering, Work in Process,
Master Scheduling/MRP, Capacity, and Purchasing receiving functions.

Subinventory:
=============
Which is another organization inside of the Inventory oganization will
be used to define the locations under these location items will be placed.


Multiorg Table:
===============
It is a table contains the data which is relted to multiple operating units
all the multiorg table names will be end with '_ALL'.

like  PO_HEADER_ALL
      PO_LINES_ALL
      AP_CHECKS_ALL  and so on

Note: In all these tables we will find one common column called "ORG_ID"
  This column will be populated internally by the system as per the User Operating
  Unit ID

Client_Info:
===========
It is one  the RDBMS vaiabel which contains the User Operating Unit value (ORG_ID)

Multiorg View:
=================
It is a view which is created based on the Multiorg table which contains the WHERE
clause WHERE Org_ID = :Client_Info.

Note: While development of RICE Components we are suppose to Use Multiorg Views
      not Multi Org Tables.

Because if we use Multiorg tables we will get all the operating units data
if we use multiorg view we will get the operating units data which is related for that
perticular user .


1)What is the Diff between ORG_ID and ORGANIZATION_ID?
Ans)ORG_ID              is at Operating Unit Level
    ORGANIZATION_ID     is at Inventory Organization level

2)Why the PO Receipt functionality will come at Inventory organization level?
Ans)user is creating receipt means indirectley he will be receiving the materials from
    suppliers.materials will be received at Gowdons ,Warehouses,manufcaturing plants
    all these organizations will come at Inventory Organization level.

3)how the System Will Identify user is working for so and so operating Unit?
Ans ) By using following Profile called
      MO:Operating Unit

4)What is Multiorg?
5)What is Client_info?
6)how to Implement Multiorg in Reports and at SQL prompt?
7)What is Business group, Legal Entity,Operating Unit,Inventory Organizations?
8)What are the Modules will come at operating Unit level?
9)What is the flow of Multiorg?
10)How to Identify the Multiorg Table?
11)Wat is the Diff between Multiorg Table and Multiorg View?
12)While Developing RICE Components we will use Multiorg Table or Multiorg View?
13)Why there is no _ALL for PO_VENDORS
   and there is    _ALL for PO_VENDOR_SITES_ALL?
Ans)Supplier is global
    Supplier site is Org Specific.
14)How will you findout Multiorg Succesfully Implemented?
Ans)

SELECT MULTI_ORG_FLAG ,RELEASE_NAME FROM FND_PRODUCT_GROUPS

Y - Succesfully Implemented
N - Not Implemented Succesfully.

15) MULTI ORG ACCESS CONTROLE (MOAC)


in 11i 
fnd_client_info.set_org_context('org_id');
example: fnd_client_info.set_org_context('204');

in r12 
MO_GLOBAL.SET_POLICY_CONTEXT('S','204'); ---FOR SINGLE ORG


MO_GLOBAL.SET_POLICY_CONTEXT('M','204','207','208'); --FOR MULTIPLE ORG
HERE ('S' FOR SINGLE MODE MOAC, 'M' FOR MULTI MODE MOAC)
===
1.Question :
------------
Explain about Oracle E-Business Suite ?

Answers:
--------
Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that provides:

&

The Oracle E-Business Suite is a complex Enterprise Resource Planing program consist of many components.The primary components that comprise the E-Business suite are Client,Forms Server,Web Server,Concurrent Process, and Oracle Database.

&


2.Question :
------------
what is workflow with examples?
what are the advantages of workflow with examples?

Answers:
--------
Oracle Workflow provides an infrastructure for the enterprise-wide communication of data related to defined business events,providing the capabilities need to :
* Manage enterprise business processes that may span trading partners.
* Support standard and personalized business rules.
* Streamline and automate transaction flows.
* Manage exceptions without manual intervention.
* Deliver notification emails to any Oracle Applications or Internet user.

3.Question :
------------
How many Flexfields are there in AR and what are they ?

Answers:
--------
Keyflexfeilds is helps to extend/customize the oracle apps functions whith the help of various key fields. we have 2types of flexfields key flexfields & Descriptive Keyflexfields in HRMS: Job,Position,Grade,competency,Personal analysis,Bank details,cost allocation.

No comments:

Post a Comment