Associating Table Data Classes

A table is associated with a data class using a field on the Object Librarian table (F9860.sicldf). Table data classes can be modified two ways.

• Object Management Workbench (GH902) - Select the table in the left tree view in OMW and click Design.

  Select the Install\Merge Codes tab and modify the data class value. Click OK. Modifying the data class does not affect existing OCM mappings, it is only used when creating mappings for a new environment.

• Table Data Classes - This application can be used to modify the data class for several tables at once.

  This should only be used by a JD Edwards EnterpriseOne administrator. Go to GH9611 and open Table Data Classes. Use the QBE to filter the list of tables in the grid. Select one or more tables whose data class will be changed. Click Select. Type in the new data class value and click OK.

Once these three steps have been taken, planner will prompt for the new data source and create OCM mappings for the new data source whenever an environment is added to a plan and the plan is finalized.

Environment	Object Name	User/Group	Data Source
ENV1	DEFAULT	*PUBLIC	Business Data - ENV1
ENV1	F0094	*PUBLIC	System - 920
ENV1	F9860	*PUBLIC	Object Librarian - 920
ENV1	F9200	*PUBLIC	Data Dictionary - 920
ENV1	F0004	*PUBLIC	Control Tables - ENV1
ENV1	F983051	*PUBLIC	Versions - PY920
ENV1	GT92002	*PUBLIC	Data Dictionary - 920
ENV1	GT9860A	*PUBLIC	Object Librarian - 920
ENV2	DEFAULT	*PUBLIC	Business Data - ENV2
ENV2	F0094	*PUBLIC	System - 920
ENV2	F9860	*PUBLIC	Object Librarian - 920
ENV2	F9200	*PUBLIC	Data Dictionary - 920
ENV2	F0004	*PUBLIC	Control Tables - ENV2
ENV2	F983051	*PUBLIC	Versions - DV920
ENV2	GT92002	*PUBLIC	Data Dictionary - 920
ENV2	GT9860A	*PUBLIC	Object Librarian - 920