Primary Organization
Tables
HR_LOCATIONS
Stores
information about organization locations. Address, Org_id, ship_to /
bill_to
site, receiving site, etc LOCATION_ID
is the primary key on this
table.
This table is accessed by forms or reports from the following modules;
HR,
INV, PO/REC.
(See
Oracle Inventory Technical or Oracle HR Technical Reference Manual for more
detail)
HR_ORGANIZATION_INFORMATION
Stores
the information on all organizations defined in the system. It also
stores
most of the organization classification specific information. The table
is
populated through the Define Organization form (PERWSDOR). Each
organization
defined
will have 1 row for the organization and 1 row for each organization
classification
defined on the form. ORG_INFORMATION_ID
is the primary key on
this
table.
(See
Oracle Inventory Technical or Oracle HR Technical Reference Manual for more
detail)
HR_ORGANIZATION_UNITS
Stores
generic information about the organizations. This is an excellent place
to
go if you need to see the relationship between org id and Business group
id
when
troubleshooting a multi-org problem.
ORGANIZATION_ID is the primary key
for
this table. BUSINESS_GROUP_ID is a foreign key. This table is used by a
variety
of org setup and item setup forms.
(See
Oracle Inventory Technical or Oracle HR Technical Reference Manual for more
detail)
MTL_PARAMETERS
Stores
the set of general default options like GL accounts, locator, lot and
serial
number controls, costing method, inter-org options, costing org and item
master,
etc This table is populated by the org
parameters form INVSDOIO. It is
accessed
by a wide variety of forms, reports, user exits, and concurrent
programs
throughout the manufacturing modules. ORGANIZATION_ID is the primary
key.
This is the most heavily used Organization table in the manufacturing
products.
(See
Oracle Inventory Technical Reference Manual for more detail)
RCV_PARAMETERS
Stores
receiving options for each organization that is setup to receive items.
There
is 1 row for each receiving organization. This table is populated by the
org
parameters form, receiving options, or from PO setup receiving options.
(See
Oracle Inventory Technical or Oracle Purchasing Technical Reference Manual for
more detail)
ORG_ACCESS
Stores
the data on which responsibilities are granted access to the existing
organizations.
Frequently customers will partially populate the Organization
Access
form (INVSDORA), and effectively lock themselves out of their organizations.
This
table stores that information. If all else fails, you can frequently resolve
this
issue by truncating this table and having the user re-populate the
Organization
Access form correctly.
(See
Oracle Inventory Technical Reference Manual for more detail)
.
