Oracle

R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Why Oracle R12?

Obtaining a more robust & scalable architecture: It provides Advance Database

capabilities & better integration, newer extensions & personalization.
Enhance Efficiency: Can lay shared service model and enable easy design of multiple tax
models.
Streamline compliance: Upgrading compliance with industry standards is simplified and
new alternate accounting representations.
Enabling more efficient Collaboration: It serves a larger platform to collaborate with
trading partners with greater efficiency in procurement, inventory & logistics.
Facilitating better reporting: It allows business to create user friendly tax reports.
Decommissioning Legacy systems: help to migrate legacy systems to greater extent
with many new integration and administration capabilities.

R12 Architecture:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Changes in R12:

APPMGR
Top Details

OLD

NEW

APPL_TOP

$HOME/<SID>appl

$HOME/apps/apps_st/appl

COMMON_TOP

$HOME/<SID>comn

$HOME/apps/apps_st/comn

ORACLE_HOME

$HOME/<SID>ora/8.0.6

$HOME/apps/tech_st/10.1.2

IAS_ORACLE_HOME

$HOME/<SID>ora/iAS

$HOME/apps/tech_st/10.1.3

ORACLE
Top Details

OLD

NEW

ORACLE_HOME

$HOME/<SID>db/10.2.0

$HOME/db/tech_st/10.2.0

ORADATA

$HOME/<SID>data

$HOME/db/apps_st/data

INST_TOP (New Addition)

OLD

INST_TOP

N/A

NEW

$HOME/inst/apps/<context_name>

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Multi-Org Structure / hierarchy:

Example:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Types of Organizations:
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.

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. 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.
The following applications secure information by inventory organization: Oracle
Inventory, Bills of Material, Engineering, and 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.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

R12 Multi Org Structure:

Note** in R12 Set of Book concept is obsolete. Its been replaced by Primary ledger.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Ledger Concept

Primary Ledger:

The core of companies financial records where every transaction flow through legal
Entity accounts.
It is defined by 4Cs Chart of Account, Accounting Calendar, Primary Currency and Sub-
ledger Accounting Method.

Subledger:

An application which manages operational transactions.

It stores accounting at transaction level.
It posts summarize activity information to GL periodically to maintain centralized
account balance.

Types of Ledgers:
There are 3 types of ledgers,
1) Primary Ledger (PL): Main ledger which contains all information and can have any
number of secondary ledger.

2) Secondary Ledger (SL): It provides additional accounting representation of primary
ledger and comply with legal requirements. It is optional. It can be assigned to only one
Primary ledger.

3) Reporting Currency (RC): When the currency is different [Multiple currency reporting]
then reporting currencies will be defined. When an RC is not assigned to PL (or) SL when
translation is run RC will automatically added to the Primary Ledger.

When to use Secondary Ledger (SL) and Reporting Currency (RC) with Primary
Ledger (PL)?

If Multiple Currencies to be supported in your organization structure Reporting

Currencies are used.
If your organization structure uses different Chart of Account (COA), Calendars,
Accounting methods (SLA) other than currencies Secondary Ledger is used.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Ledger Sets:

It Groups multiple ledgers that shares same COA and Calendar combination.
It treats multiple ledgers into one.
Usually when we want to open Calendar periods, we need to open it seperately for
every ledger, instead if we open / close the calendar periods for a Set automatically it
will open for all ledger associating with the set.

Data Access Sets:

The Ledger permissions are defined here like Read only, Read and Write access.
We can set permission for Legal entity, Ledgers , Balancing (or) Management Segment
values.

Subledger Accounting (SLA):

It is a rule based engine for generating accounting entries across applications.

The sub ledger captures the accounting information in OU level modules like Payables,
Receivables, Projects, Assets, Cash Management, Purchasing, Cost Management &
Process Manufacturing.
All accounting entries will be recorded or validated before posting it into General Ledger
(GL).

Subledger Accounting Methods (SLAM):
If Subledger Accounting is used, the method needs to be defined for both primary and
secondary ledgers.
The accounting methods can be changed anytime and the changes wont have major impact, it
will affect only the new journals.
There are 5 Subledger Accounting Methods:

Standard Accrual (Default)

Standard Cash
Accrual with Encumbrance Accounting
Cash with Encumbrance Accounting
US Federal Accounting.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Release 11i Term

Release 12 Term

Global Accounting Engine

Subledger Accounting

Global Intercompany System (GIS)

Advanced Global Intercompany System (AGIS)

Intercompany Accounts

Intercompany Balancing

MRC Primary Set of Books

Primary Ledger

MRC Reporting Set of Books

Reporting Currency

Multiple-Posting Set of Books (Global

Accounting Engine)

Secondary Ledgers

Secondary Sets of Books

Secondary Ledgers

Set of Books

Ledger

Translated Currency

Balance-Level-Reporting Currency

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle HRMS Security Profile

Security Profile:
It is attached to responsibility, which determines which applicant or employee records are
available for the holders of the responsibility.
Security profile is also associated with Work structure.

Workstructures in Security Profile:

Internal Organizations and Organization Hierarchies.

Positions and Position Hierarchies.
Payrolls

Please Refer oracle Link for more information:
[Link]

Security Definition:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

The key definition is the responsibility, which allows access to the records specified by the
security profile, using the windows specified by the menu structure, and the reports and
processes specified by the report security group.
For more information please refer:
[Link]

Global Security Profiles:

A responsibility points to Single enterprise structure in Oracle [Link] user creates

security profile it automatically restricts people access to single Business group. So, we
need to create one Security profile for each Business group.

Suppose if users have access to 2 business group, we need to create 2 different Security
profile. As number of business group increases, maintenance of security profiles
becomes complex.

To simplify the administration efforts oracle introduced global security profiles. Using
this feature, we can maintain one security profile which spans across all business groups
and reducing creation of many security profiles.

Advantages of Global Security Profile

Reduces creation of many Security Profiles.
Maintenance is easier during modification.
Enables Global reporting across business Group.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Multi-Org Access Control (MOAC)

Why MOAC?
Currently in Oracle 11i single responsibility is pointed to enterprise structure i.e. a responsibility
can be mapped to only one OU [Represents modules like AP, PO,INV etc]. Consider a structure
with Single Legal entity (LE) having 5 Operating Units [OU] we need to create 5 responsibility
and assign same to each OU.
Every time to create invoice (or) Purchase Orders (or) submitting Requests the user have to
switch responsibility b/w OUs. This is a time consuming process.
By using MOAC, Single Responsibility can be mapped to multiple OUs thus user can perform
multiple tasks across OUs without changing the responsibility.

Is MOAC mandatory to be implemented during R12 Upgrade?

No, this is an Optional functionality in R12.

MOAC Technical Logic

First Check Profile MO: Security Profile is Set Populates OU Details based on Security
Profile Checks Profile MO: Default Operating Unit if set The Default OU will be
populated in Operating Unit Field.

First Check Profile MO: Security Profile is Not Set Checks Profile MO: Operating Unit
based on the profile value it behaves like Oracle 11i Structure.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Trading Committee Architecture (TCA)

It is a Data Model.
It defines the components involved in trading with eBusiness Suite.
The main usage of this technology is to create relationships between entities. It Tracks
relationship between organizations and its trading partners but also between
themselves.
It maintains a Universal Schema for Customers, Suppliers and resellers, banks etc.
across all eBusiness applications.

Key Features:

Provides a foundation for a single source for customer information.

Represent business entity as Party (organizations, people, groups, relationships). This
approach provides flexibility to accommodate all B2B, B2C and hybrid models in the
same repository.
Many-to-many relationships between Parties and Locations to avoid duplicates.
Supports N number of Party classification for reporting purpose.
It is extensible to support multiple businesses.

TCA Logical representation:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

TCA integration with Oracle Products:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Menu:
Navigation: SYS ADMIN Application Menu

Create Request Group:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Responsibility:
Navigation: SYS ADMIN Security Responsibility Define

Similarly create a custom responsibility for HRMS.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create User:
Navigation: SYS ADMIN Security User Define

Now log in as this user.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

First Time login it will ask to reset the password.

Create Currency:
Navigation: GL Setup Currencies Define

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Calendar:

Before Defining Calendars we need to select the Period Types.
Navigation: GL Setup Financials Calendars Types

Now define accounting calendar for your organization.
Navigation: GL Setup Financials Calendars Accounting

Prefix
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC

Type
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH
MONTH

Year
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013

Quarter Num
1
1
1
2
1
3
2
4
2
5
2
6
3
7
3
8
3
9
4
10
4
11
4
12

From
1-Jan-13
1-Feb-13
1-Mar-13
1-Apr-13
1-May-13
1-Jun-13
1-Jul-13
1-Aug-13
1-Sep-13
1-Oct-13
1-Nov-13
1-Dec-13

To
31-Jan-13
28-Feb-13
31-Mar-13
30-Apr-13
31-May-13
30-Jun-13
31-Jul-13
31-Aug-13
30-Sep-13
31-Oct-13
30-Nov-13
31-Dec-13

Name
13-Jan
13-Feb
13-Mar
13-Apr
13-May
13-Jun
13-Jul
13-Aug
13-Sep
13-Oct
13-Nov
13-Dec

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Request Other - Calendar Validation Report will be submitted to check for any Gaps in
Calendar.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Accounting Flexfield:

Navigation:

GL Setup Financials Flexfields Key Segments

Now Click Segments to define structure.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Value set Details:

Navigation: GL Setup Flexfields Validation Sets
D_COMPANY_CODE:

D_DEPT:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

D_ACT:

D_RES:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Key Flexfield Segment Values:

Navigation: GL Setup Financials Flexfields Key Values

COMPANY_CODE:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

D_DEPT:

D_ACCOUNT:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

D_RESERVE:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Profile Options Setups:

Set of Books Profile Changes:

In Release 11i, the GL: Set of Books profile option controlled the set of books that a
responsibility could access.
In Release 12, the GL Ledger Name profile option replaces the GL: Set of Books profile
option.
All responsibilities to which set of books have been assigned using the GL: Set of Books
profile option will be associated to a data access set using the GL: Data Access Set
profile option.
The data access set will provide full read and write access to the upgraded ledger
allowing you to continue to use the ledger the same way as you did in Release 11i.

HR Option

Purpose

HR:Business Group

HR:Security Profile

Business Group that is linked to the security profile for a

responsibility. This option is used online to control access to
records that are not related to organization, position, or payroll.

This option is seeded at Site level with the start-up Business Group.
It is view only. Values are derived from the HR:Security Profile user
profile option.

Restricts access to the organizations, positions, and payrolls defined

in the security profile. This option is seeded at Site level with the
view-all security profile created for the Startup Business Group.

Limits field access on windows shared between Oracle Human

Resources and Oracle Payroll. If you do not use Oracle Payroll, it
must be set to HR User for all responsibilities.

If you do use Oracle Payroll, you can give each Responsibility one of
the following user types, depending on the work role of the holders
of the responsibility: HR User, HR with Payroll User, Payroll User

HR:User Type

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Profile Name
HR:User Type

Value
HR with Payroll User

Level
Responsibility

Set the profile option to all the custom responsibilities we have created.

Navigation: SYS ADMIN Profile System

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Creating Work Day Calendar:

Navigation: INV Setup Organizations Calendars

What is Workday Calendar?
A workday calendar defines the valid working days for a manufacturing organization and consists of
repeating pattern of days on and days off and exceptions to that pattern. This allows you to, for
example, designate a normal workday as a scheduled downtime day, or designate a holiday as a
workday.

Calendar:

Workday Pattern:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Shifts:

Shift Workday Pattern:

Shift Timings:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Dates:

Build Calendar:

Request Build Workday Calendar will be submitted.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Creating Locations:
Navigation: HRMS Work Structures Location

In the Location form to input address, we need to select address style based on the country.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Shipping Details:

Other Details:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Similarly we need to create other locations.
Location 2:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Location 3:

Location 4:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Multi-Org Structure:

We are going to create a similar Multi-Org Structure

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Creating Organizations:
Navigation: HRMS Work Structures Organization Description

Create Business Group:

Organization Classification:

Classify this organization as HR Organization to create employees.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Business Group Additional Information:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Legal Entity:

We can create Legal Entity using two responsibilities;
General Ledger
Legal Entity Manager

General Ledger:
Navigation: GL Setup Financials Accounting Setup Manager Accounting

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Legal Entity Manager:

Navigation: Legal Entity Manager Legal Entity Configurator

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Now let us create using General Ledger Responsibility.

Click Accounting Setup

Click Create Legal Entity.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Legal Entity: Dini Aviation Corporation

(Optional Info)

Click Apply.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Now Assign the Legal Entity,

Click Next

Click Next.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Summary:

Click Finish.

Define Accounting Options:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Accounting Options:

Now Update Ledger Options:

Step 1: Skip this step no changes required. Click Next.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Step 2: Ledger Options

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Step 3: Advance Options

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Step 4: Update Ledger

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Click Finish.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Legal Entity: Dini Power Corporation

Go to Legal Entity Tab.

Click Apply.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Now Add the New Legal Entity. Go to Accounting Setups tab.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Operating Unit:

You can create Operating unit from

HRMS Responsibility
GL Super User Responsibility Accounting Setup Manager

Using HRMS Responsibility:
Navigation: HRMS Work Structures Organization Description
Let us create using accounting Setup Manager.

Update Operating unit.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Click Apply.
Similarly Create New Operating Unit for Power Business.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Click Complete.

Now the Operating Unit status is Active.
Click Complete to finish Ledger setup.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Click Yes.

Click Return to Accounting Setups.

Ledger Setup Successfully Completed.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Security Profile:

Navigation: HRMS Security Profile

Types of Security Types:
1) View all Organizations: It will not allow you to save a new security profile because it
automatically seeds one and no need to create another.
2) Secure Organizations by organization Hierarchy and/or Organization List: It defines a
hierarchy such that only the organization included in this hierarchy can only have access.
3) Secure Organizations by Single Operating Unit: The Operating unit will be decided
based on the profile MO: Operating Unit.
4) Secure Organizations by Operating Unit and Inventory Organizations: The Operating
Unit & Inventory Organization will be decided based on profile MO: Operating Unit.
Exclude Business Groups: To avoid including the business group in the hierarchy this check box
can be checked.
Include the Organizations to which responsibility can have access to.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

HRMS Security Process:

There are 3 HRMS security process available.
1) Grant Permissions To Roles Process (ROLEGEN)
2) Generate Secure User Process (SECGEN)
3) Security List Maintenance Process (LISTGEN)

Security List Maintenance Process (LISTGEN):
This process maintains the lists of organizations, positions, payrolls, employees and applicants
that security profile holders can access. You should schedule it to run every night to take account
of changes made during the day. If a disruption, such as a power cut, occurs while the process is
running, you can manually restart it from the Submit Requests window.
There is one required parameter for this process: Effective Date, which should normally be set to
SYSDATE. You can also enter a security profile name to generate list entries for that security
profile only.
Attention: LISTGEN should normally run when there are no users logged on to Oracle HRMS.
Users attached while LISTGEN is running may experience unexpected results; for example,
additional employees may become visible or previously visible employees may disappear from
view.

For more information please go to below link;
[Link]

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Submit the request using HRMS responsibility.

Request Executed Successfully.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Multi Organization Profile Options:

The following are the Oracle Applications multiple organizations profile options and are
grouped under the Access Control profile option category:

MO: Default Operating Unit

MO: Operating Unit
MO: Security Profile

MO: Security Profile
Assign this profile option to an application responsibility to provide a user with this
responsibility access to multiple operating units.

MO: Default Operating Unit
Use this profile option to specify a default operating unit from the list of operating units
assigned to your application responsibility through the MO: Operating Unit or MO: Security
Profile.
Note: If the MO: Operating Unit is set or you are assigned only one operating unit in the MO:
Security Profile profile option, then the single operating unit becomes your default operating
unit.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

MO: Operating Unit
Assign this profile option to an application responsibility to provide a user with this
responsibility access to one operating unit.

For more information please check the link below.
[Link]

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Populate Module Seeded Values:

How to Populate Module Seeded Values?

Submit concurrent request Replicate Seed Data.

Why Replicate Seed Data Concurrent Request?

It is used to populate the installed modules seeded values, So that new organization can
use the seeded data.
Whenever new organization is created in a multi-Org structure, this request is
mandatory to be submitted.
It can be submitted for single Operating unit (or) for all Operating Units.

Before submitting the request make sure it is available for your responsibility. If not, please add
the same to your request group.

Note** this program is to be executed for all the Operating Units available in you enterprise
structure.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Navigation: Custom Responsibility (d_hrms1) View Requests

We have created the below operating units for BG [DINI_BG1].
DINI_AVIATION_OU1
DINI_POWER_OU1

Operating Unit 1:

Operating Unit 2:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Master Inventory Organization:

Navigation: HRMS Work Structures Organization Description

Commit Setup and classify the organization as Inventory Organization.

Additional Information:
Accounting Information
Inventory Information
Receiving Information

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Accounting Information:

Commit Setup;
Inventory Information:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Costing Information:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Revision, Lot, Serial And LPN:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Other Accounts:

Receiving Information:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Click Save.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Child Inventory Organization:

Aviation OU:

Accounting Information:

Commit Setup;

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Inventory Information:
Now Copy the Master Inventory Organization Setup.

Note** since we have copied the Master Inventory Org data, all the other mandatory setups
will be populated automatically same as IMO.
Receiving Information:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Power OU:

Accounting Information:

Inventory Information:
Now Copy the Master Inventory Organization Setup.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Receiving Information:

Click Save.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Mandatory Profile Options

Before going to further setups please check the below profile options are enabled for the
responsibilities.

Profile Name
GL Ledger Name
GL Ledger ID
GL Set of Books Name

Level
Responsibility
Responsibility
Responsibility

HR:Business Group
HR:User Type
HR: Security Profile

Value
Primary Ledger
Primary Ledger ID
Set of Books

d_hrms1
DINI_PL1
2842
Not Used in R12

Responsibility Business Group

Responsibility HR with Payroll User,
HR User, Payroll User

d_resp1
DINI_PL1
2842
Not Used in
R12
DINI_BG1
HR with
Payroll User

Responsibility Business Group

DINI_BG1

DINI_BG1

DINI_BG1
HR with Payroll User

Open Inventory Accounting Period:

Navigation: INV Accounting Close Cycle Inventory Accounting Periods
Select Organization.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Select Organization: 600

Now Click Change Status to open the Inventory Accounting period.

Click OK.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Follow the above steps to open periods for Child Inventory Organization.
To change the organizations, please click Change Organization.

Select Organization: 601

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Similarly for Organization: 602

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Enable Inventory Transactions:

Navigation: INV Transactions Miscellaneous Transaction

Select Organization: 600

When the form Opens indicates the transactions are enabled.

Similarly follow the same steps for organization 601 and 602.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Sub Inventory:

What is Sub-Inventories?

Sub-Inventories are unique Physical (or) Logical Separations of Material inventory such
as Raw Material, Finished Goods (or) Defective Goods/Materials.
All materials within an Organization are stored in Sub-inventory.

Types of Sub-Inventories:
In warehouse management there are 2 types of sub-inventories.
i.
ii.

Storage
Receiving

Storage

Receiving

Mandatory
Tracking of Goods is possible
On-Hand Quantity is available
N/A

Optional
Tracking of Goods is possible
Does not reflect in on-hand Quantity
Available only if Receipts are created.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Navigation: INV Setup Organizations Subinventories

Select Organization: 602

Similarly create a sub-inventory for organization: 602

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Jobs:
Navigation: HRMS Work Structures Job Description

Click New.

Note** Job should point to some Job Group, if not please cross check the profile HR: Security
Profile.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Now we are going to Create Jobs as below.

Job Name
A0
A1
A2
A3

Job Code
1000
2000
3000
4000

Description
Junior
Senior
Asst. Manager
Manager

Reporting To
A1
A2
A3
--

A0: Junior

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

A1: Senior

A2: Asst. Manager

A3: Manager

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Positions:
Navigation: HRMS Work Structures Position Description

We are going to create positions for each job respective to each department.

SALES

MFG

ADMIN

FIN

A3

A3_SALES

A3_MFG

A3_ADMIN

A3_FIN

A2

A2_SALES

A2_MFG

A2_ADMIN

A2_FIN

A1

A1_SALES

A1_MFG

A1_ADMIN

A1_FIN

A0

A0_SALES

A0_MFG

A0_ADMIN

A0_FIN

Equivalent Position Codes:

SALES

MFG

ADMIN

FIN

A3

4001

4002

4003

4004

A2

3001

3002

3003

3004

A1

2001

2002

2003

2004

A0

1001

1002

1003

1004

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Position Level: A0

Hiring Information:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Position Level: A1

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Position Level: A2

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Position Level: A3

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Employees:
Navigation: HRMS People Enter and Maintain
Create an Employee [Create Employment] and assign position [Assignments].
Employee 1:

Note** when creating employee for first time select option Correction.

Click Yes in Decision window.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Employee 2:

Employee 3:

Employee 4:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Position Hierarchy:

Navigation: HRMS Work Structures Position Hierarchy

Commit Setup;

Commit Setup;
Now place the cursor in the position section and go to query mode to select position.

Query Mode:

Note** Now start from the highest position inside a department and traverse to lowest.
We are going to define hierarchy for Sales Department.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Now we need to define subordinates for this current position.

Commit Setup;

Now click Down Icon [

] to define subordinates for A2.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Similarly we need to define subordinates for A1 position.

Now traverse up and check the hierarchy. When reached the top position a note will be
displayed.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Create Users & Map Employee:

Navigation: SYS ADMIN Security User Define

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Employee - User Mapping:

User

Employee

Position

YO_USER1

emp1, duser1

A0_SALES

YO_USER2

emp2, duser2

A1_SALES

YO_USER3

emp3, duser3

A2_SALES

YO_USER4

emp34, duser4

A3_SALES

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Fill Employee Hierarchy Process:

Navigation: d_resp1 (Custom Resp.) View Requests

Use the Fill Employee Hierarchy process to create a direct mapping between the defined
position hierarchies and the employees holding positions in each hierarchy.
When you run this process, it checks each position hierarchy and updates each employee, his
supervisor, the level of supervision (a direct supervisor is level 1), the employee's position, and
the supervisor's position.

The process creates an error log which lists all positions to which no employee is
assigned, but having such positions is a benign error that does not hamper system
operation.
If you do not use hierarchical security for any of your documents and do not use position
hierarchies for your approvals, you do not need to run this process. Otherwise, you must
run this process before any of the following changes can take effect:
o

add or delete an employee

Change an employee name or an employee position.

Add, delete, or modify a position.

Add, delete, or modify a position hierarchy.

Note** after setting up the position run the request Fill Employee Hierarchy from purchasing
responsibility for each Operating unit.

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Operating Unit 1:

Operating Unit 2:

Oracle R12: Multi Org with MOAC By Dinesh Kumar S

Thus we have completed the R12 Multi Org Setups.