Modeling of an Organization / firm in Oracle E business Suite


Friends, do share your feedback on this topic :-

We can host multiple Oracle eBusiness suites on one Instance separated by security group. This is primarily aimed for Application service providers who host and maintain Oracle Apps for many SME clients on pay-per-use basis.

Business Group

The business group represents the highest level in the organization structure. It secures human resources information. If you have multiple business groups, you must associate each responsibility to one and only one business group. You associate a business group with a responsibility via the HR:Business Group system profile option.

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.

Legal Entity

Set the responsibility from which you define the organizations in the profile option HR: User Type to HR User, to get access to the Define Organizations window. Log in to the responsibility associated with the business group for which you are defining an organization. Define a legal entity. It is then automatically attached to the correct business group. Legal entity is 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 operating unit is associated with a legal entity. Information is secured by operating unit for applications viz: Order Management, Shipping Execution, Oracle Payables, Oracle Purchasing, Oracle Receivables and Oracle Cash Management. To run any of these applications, you choose a responsibility associated with an operating unit.

Inventory Organization

Inventory Organization is an organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products viz: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.

  • Define Organization :

Navigate to Define Organization window. Enter a name for the organization.You can define all types of organizations viz manufacturing facility, warehouse, branch office etc. Choose a location where this organization exists.Enter what type(s) of organization is this, in organization classification viz:
GRE/Legal Entity : For a Legal Entity, click others and enter Accounting info like Set of Books.
Operating Unit : For an Operating Unit, enter Accounting Information like Legal Entity, Set of Books.
Inventory Organization : For an Inv Organization enter Accounting Information like Set of Books, Legal Entity & Operating Unit.
HR Organization : HR organizations represent the basic work structure of any enterprise. They usually represent the functional management, or reporting groups that exist within a business group. Click others and enter all such information .
HR_ALL_ORGANIZATION_UNITS
ORGANIZATION_ID
NAME
BUSINESS_GROUP_ID
LOCATION_ID
DATE_FROM
INTERNAL_EXTERNAL_FLAG
INTERNAL_ADDRESS_LINE
TYPE
HR_ORGANIZATION_INFORMATION
ORG_INFORMATION_ID
ORGANIZATION_ID
ORG_INFORMATION_CONTEXT
ORG_INFORMATION1 ~ 20

All organizations are maintained in HR_ALL_ORGANIZATION_UNITS table and organization classifications like Legal entity or operating unit information are stored in HR_ORGANIZATION_INFORMATION table. There are 3 views provided based on these 2 tables to easily find out the Legal entity, Operating unit and Inventory organization viz:
HR_LEGAL_ENTITIES
ORGANIZATION_ID
BUSINESS_GROUP_ID
NAME
DATE_FROM
DATE_TO
SET_OF_BOOKS_ID
VAT_REGISTRATION_NUMBER
HR_OPERATING_UNITS
ORGANIZATION_ID
BUSINESS_GROUP_ID
NAME
DATE_FROM
DATE_TO
LEGAL_ENTITY_ID
SET_OF_BOOKS_ID
ORG_ORGANIZATION_DEFINITIONS
ORGANIZATION_ID
BUSINESS_GROUP_ID
USER_DEFINITION_ENABLE_DATE
DISABLE_DATE
ORGANIZATION_CODE
ORGANIZATION_NAME
SET_OF_BOOKS_ID
CHART_OF_ACCOUNTS_ID
INVENTORY_ENABLED_FLAG
OPERATING_UNIT
LEGAL_ENTITY
The values in below profiles give you the desired data security as explained above. These values are set at site or responsibility level such that once you choose any responsibility, you are restricted to the data pertaining to the above profile value.

  • HR:Business Group (PER_BUSINESS_GROUP_ID)- implies the business group you are currently attached with.
  • MO: Operating Unit (ORG_ID)- implies your current operating unit.

select
business_group_id,name
from per_business_groups
where lower(name) like ‘%vision corporation%’
order by name
select
set_of_books_id,
name sob_name,
chart_of_accounts_id,
chart_of_accounts_name,
period_set_name calendar_period,
accounted_period_type,
user_period_type,
currency_code
from gl_sets_of_books_v
where set_of_books_id=1
select
organization_id legal_entity_id,
business_group_id,
name,
date_from,
date_to,
set_of_books_id,
vat_registration_number
from hr_legal_entities
where set_of_books_id=1
and business_group_id=202
select
organization_id operating_unit,
name,
business_group_id,
substr(set_of_books_id,1,10),
substr(legal_entity_id,1,10),
date_from,
date_to
from hr_operating_units
where legal_entity_id=204
select
organization_id,
organization_code,
organization_name,
(select location_id from hr_all_organization_units ou
where od.organization_id=ou.organization_id) location_id,
user_definition_enable_date,
disable_date,
chart_of_accounts_id,
inventory_enabled_flag,
operating_unit,
legal_entity,
set_of_books_id,
business_group_id
from org_organization_definitions od
where operating_unit=204
order by organization_code
/
The location_id found here is referenced in hr_locations table (described later), for detailed address information of this organization.
Advertisements

One thought on “Modeling of an Organization / firm in Oracle E business Suite

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s