Here are tables where Organization Data is getting Parked.
- 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 (Inventory), PO/REC.
- 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.
- 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.
- 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.
- 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.
- 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.