Total Pageviews

May 2, 2016

5/02/2016 08:09:00 PM

                         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)

.



0 comments:

Post a Comment