Wednesday, March 23, 2016

FUNCTIONAL MODULES Multi Orgs Multiple Organizations,Multiple Organizations in Oracle Application

FUNCTIONAL MODULES
Multi Orgs ( Multiple Organizations ) :-

It is a process of storing multiple organizations information in a single server with single
Installation. It is like a MNC.

Multiple Organizations in Oracle Applications

The Oracle Applications organization models define organizations and the relationships among them in arbitrarily complex enterprises. This organization model serves as the cornerstone for all of the Oracle Applications products. It dictates how transactions flow through different organizations and how those organizations interact with each other.

Generally, a complex enterprise has several organization structures, such as Internal, Accounting, and Human Resources. You are able to define different structures to customize Oracle Applications according to your business needs.
Organization can be a Company / Branch / Dept / Area / Unit
Basic Business Needs

Oracle Applications provides you with the features you need to satisfy the following basic business needs:

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

• Define different organization models

• Support any number of legal entities within a single installation of Oracle Applications.

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

• Sell products from a legal entity that uses one set of books and ship them from another legal entity using a
    different set of books, and automatically record the appropriate intercompany sales by posting intercompany
    accounts payable and accounts receivable invoices.

• Purchase products through one legal entity and receive them in another legal entity.

Major Features

Multiple Organizations in a Single Installation
You can define multiple organizations and the relationships among them in a single installation of Oracle Applications. These organizations can be sets of books, business groups, legal entities, operating units, or inventory organizations.

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

Sell And Ship Products From Different Legal Entities
You can sell from one legal entity and ship from another, posting to each organization’s set of books.

Receive Goods Into Any Inventory Organization
You can enter purchase orders and assign for receipt any inventory organization that uses the same set of books. Your purchase order operating unit and receiving inventory organization must share the same set of books to receive against a purchase order.

Automatic Accounting for Internal Requisitions
You can create an internal requisition (sales order) in one organization, then ship from another organization, with correct intercompany invoicing.

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

Multiple Organizations in a Single Installation:

You can support multiple organizations running any Oracle Applications product with a single installation. When you run any Oracle Applications product, you first choose an organization—either implicitly by choosing a responsibility, or explicitly in a Choose Organization window. Each window and report then displays information for your organization only.

Organizations that share the same functional currency, Accounting Flexfield structure, and calendar can post to the same set of books.

It is in seven levels.
1)      Business Group
2)      Set Of Books
3)      Legal Entity
4)      Operating Unit
5)      Inventory Organization
6)      Sub Inventory
7)  Stock Location




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. Employment will also be created.
            Eg : Head Office , Regional Level Head Quarter

Note: This is true in all applications except the HR applications, which support more granular security by a
lower–level organization unit, the security profile. Multiple sets of books can share the same business group if they share the same business group attributes, including HR flexfield structures.

Set of Books
It is a logical entity. 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 and submitted to the government. 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. To run any of these applications, you choose a responsibility associated with an organization classified as an 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. To run any of these applications, you must choose an organization that has been classified as an inventory organization.

Business group at the top of each hierarchy. When you define new organizations, they are automatically assigned to the business group associated with your current session. Each organization is part of a business group. The business group is usually the top box on an enterprise organization chart.



The business group is the largest organization unit you set up in Human Resources to represent your enterprises as an employer. After defining one or more business groups for your enterprise, you set up one or more government reporting entities (GREs) within each business group. The GRE is the organization that federal, state, and local governments recognize as the employer.

Below this level, you represent the groupings in which employees work, such as branches, departments, or sections, by means of internal organizations. To enable the assignment of employees to an internal organization, you classify the internal organization as an HR organization.

You can define external organizations in the same way as internal organizations, so that you can represent organizations that are not part of your enterprise (such as training vendors or tax offices). The major difference between internal and external organizations is that you cannot assign people to an external organization.

Accounting / Distribution / Materials Management Organization Model

Using the accounting, distribution, and materials management functions in Oracle Applications, you define the relationships among inventory organizations, operating units, legal entities, and sets of books to create a multilevel company structure, as shown in Figure
Multilevel Company Structure Example

Legal Entities Post to a Set of Books
Each organization classified as a legal entity identifies a set of books to post accounting transactions.

Operating Units Are Part of a Legal Entity
Each organization classified as an operating unit is associated with a legal entity.

Inventory Organizations are Part of an Operating Unit
Each organization classified as an inventory organization references an operating unit.

Inventory Organization Determines Items Available to Order Management
The Item Validation Organization parameter specifies which Oracle Manufacturing organization is used to validate inventory items. You must define all transactable items in this organization. Some inventory item attributes for Receivables and Order Management, including Tax Code and Sales Account, are specific to an operating unit or an
accounting flexfield structure. Therefore, you should define an item validation organization for each operating unit.

Inventory Organization Determines Items Available to Purchasing
The inventory organization you specify in the financial options for each operating unit determines the items available in Purchasing. You can only choose an inventory organization that uses the same set of books as your operating unit.



C C C :  Currency, Calendar, Char Of Accounts ( Set Of Books )

Currency   à INR, USD, EUR, POUND, RNG
Calendar   à Yearly, Quarterly, Monthly, Weekly
Chart Of Accounts à Bank account details

Calendar   à Yearly, Quarterly, Monthly, Weekly
Eg: Quarterly = 13 weeks ( 91 Days )
            Month1                        Month2                        Month3
                4 weeks           4                     5  ( 91 days )
                5                        4                   4  ( 91 days )



Checking for weather the System supports Multi Orgs  Concept :

SELECT MULTI_ORG_FLAG    FROM FND_PRODUCT_GROUPS 
If  MULTI_ORG_FLAG  value is Y,  then the System supports the Mutli Orgs concept

Creation of a Business Group

It involves two steps 1) create the location ( address )  2) create the business group

1) Creation of a Location :

Login : Operations

Navigation steps :
Inventory Vision Operations ( USA ) à Setup à Organizations à Location



Scope : Global à It can be accessed by all levels of organization
Name : REG10_SRNAGAR ( registration / location name )
Desc : Location of the the company ( as desired )
Inactive date : it is required when the location is not in use

Name, Desc  and Inactive Date, Address Style, Address, Time Zone will be stored into the table called :
                                                                                                                        HR_LOCATIONS_V

LOCATION_ID is a Key filed
select * from HR_LOCATIONS_V where trunc ( creation_date)= trunc(sysdate)

select * from HR_LOCATIONS_V where LOCATION_CODE='REG10_SRNAGAR'
                                                                           ( or )
select * from HR_LOCATIONS_V   WHERE ADDRESS_STYLE='India'


Address Details ( tab ) :

Fill the address as desired

Address: when click in the Address filed it shows the following





The above address information will be stored into the table called 

Shipping Location:   location of Raw Material Storage.








2) Creation of a Business Group :
Navigation steps :
Inventory Vision Operations ( USA ) à Setup à Organizations à Organizations  à New


Save the above details and enter the Organization Classification Name as Business Group
Select enabled  
Save the above and select Others for Additional Organization Information.

Business Group Info à OK

Additional Organization Information

Pres Tab [ - ]  shows the following

Click on OK à OK
Do you want to save the changes à yes

The Business Group information will be stored into the table called  : HR_ORGANIZATION_UNITS_V

select * from HR_ORGANIZATION_UNITS_V where trunc ( creation_date)= trunc(sysdate)

select * from HR_ORGANIZATION_UNITS_V where NAME ='REG10_BG'
                                                                           Here key field is àORGANIZATION_ID


Business Group Classification, Others information will be stored into the table called  : HR_ORGANIZATION_INFORMATION_V


select * from HR_ORGANIZATION_UNITS_V where NAME ='REG10_BG'
                                                                                    obtain the ORGANIZATION_ID
and check the following

select * from HR_ORGANIZATION_INFORMATION_V where ORGANIZATION_ID = 5128











Set Of Books :  It is a combination of Currency, Calendar and Chart Of Accounts

Currency :
Depending on the territory it will be changed .

Eg :

            India                :           INR      :                       : Indian Rupee            

            United States    :           USD     :           $          : US dollar
            United States    :           USN     :           $          : US dollar (next day )
            United States    :           USS     :           $          : US dollar (same day )

            United Kingdom:         GBP     :                       : Pound Sterling

            Australia          :           AUD    :                       : Australian Dollar

Navigation

            General Ledger Vision Operations ( USA ) à Setup à Currencies à Define
Enter the Issuing Territory and Query for currency details



Currency Information will be stored into the table called : FND_CURRENCIES

  select * from FND_CURRENCIES where trunc(creation_date) = trunc(sysdate)
            it shows today’s data

The above one is a predefined currency. We can define our own currency.

Eg:
            Code : XX_CUR          name : Test_Currency Desc : Test Currency  Territory : India Symbol : #


Calendar :       It defines the financial year calendar

Navigation :
General Ledger Vision Operations ( USA ) à Setup à Financial à Accounting Calendar à Types
Shows the types of Calendars




Calendar Type Information will be stored into the table called :

GL_PERIOD_TYPES


Indian Calendar :

Navigation :

General Ledger Vision Operations ( USA ) à Setup à Financial à Calendar à Accounting

Query it ( Ctrl + F11 )  use arrow key



Indian Calendar  information will be stored into the table called :

GL_PERIODS_V

Calendar is different type :

                                      Yearly :         
Month1                        Month2                        Month3             ………..Month12


                                    Quarterly :      
Qrt1                 Qrt2                 Qrt3                 Qrt4
Mon1   Month2  Month3         
W1 W2 W3

M1       M2       M3

4          5          4          ( 13 weeks ) = 91 days / 7
5          4          4
4          4          5









Chart of Accounts :
                        It is a bank account details
Eg :

LG Company has following Structure

                                                LG

            AP                               INV                             PO                   GL

INDap  USap UKap           INDinv USinv       INDpo  USpo  UKpo

1001     1004   1008           1002        1005     1003    1006    1007

Complete Code  Is :  Company_Country_Dept_Account
Eg:
LG_IND_AP_1001
LG_US_INV_1005
LG_IND_PO_1003
LG_UK_AP_1008
The information is to stored in the Key cols of the table
Navigation steps to create the key flex fields for the above data.
System Administrator à Application à  Flex Fields à Key Flex à Segments
Application : General Ledger    ( query with this ) ( as it is a creation of Chart Of Accounts )
Flex Field Title : Accounting Flexfield
( Note : for Currency, Calendar  and Chart Of Accounts , the application name is : General Ledger )
Go to Code column  place the cursor any where and select New( + )  for the New filed

Eg:
Code : TEST_27_APR_ACFF
Title : TEST_27_APR_ACFF  ( auto )
Desc : TEST_27_APR_ACFF  ( as desired )

Segment Separator :  Period ( . )      ( as desired )

Select Segments


After entering the above information save it
The above  flex fields information will be stored into the table called : FND_ID_FLEX_SEGMENTS_VL
Deselect   Freeze Flexfield Definition  à OK à Save à ( compiling ) OK à OK

Select  Company  à Felxfiled Qualifier à Intercompany Segment ( enable ) save it
            Country à Felxfiled Qualifier à     Cost Center Segment ( enable )
            Dept     à Felxfiled Qualifier à Balancing Segment  ( enable )
            Account à Felxfiled Qualifier à Natural Account Segment ( enable )

           
Select   Freeze Flexfield Definition  à  OK
compile à OK à OK
on compilation it will be submitted for flex filed generation   ( Name of the Request : Flexfield View Generator )


No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...