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
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
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 :
Navigation
General
Ledger Vision Operations ( USA
Enter the Issuing Territory
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
Calendar : It defines the financial year calendar
Navigation :
General Ledger Vision
Operations ( USA
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
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