Setting Up a Data Source for Audit Tables

Make sure that you install 21 CFR Part 11 objects based on the JD Edwards EnterpriseOne release level.

1. Sign on to a client machine.

2. Create a non-Julian database data source for system tables.

   For example, create "System - B9NJ" data source for non-Julian tables for JD Edwards EnterpriseOne 8.11.

3. Generate tables using Object Management Workbench (OMW) for the respective data sources (except F9500005).

   The System Data Source name is based on the JD Edwards EnterpriseOne release level; for example, "SYSTEM - B11" for JD Edwards EnterpriseOne 8.11 and "SYSTEM - 812" for JD Edwards EnterpriseOne 8.12.

   Tables	Data Sources
   F9500001	System Data Source
   F9500002	System Data Source
   F9500003	Non-Julian System Data Source
   F9500004	Non-Julian System Data Source
   F9500005	Local - XXXX
   F9500006	Non-Julian System Data Source
   F986112	System Data Source

4. Create Object Configuration Manager (OCM) mappings for *PUBLIC in the System and Server Map using this information:

   Tables	Data Sources
   F9500001	System Data Source
   F9500002	System Data Source
   F9500003	Non-Julian System Data Source
   F9500004	Non-Julian System Data Source
   F9500005	System Data Source
   F9500006	Non-Julian System Data Source
   F986112	System Data Source

5. Map these objects to the appropriate data source:

   Objects	Data Sources
   B9500001	LOCAL
   B9500003	LOCAL
   B9500005	SERVER
   B986112	LOCAL
   R9500004	LOCAL
   GT9500006	Object Librarian
   B950001L	LOCAL
   B950003L	LOCAL
   B980020L	LOCAL

6. Open Microsoft Windows Explorer and double-click the dbtemplates.exe, which is located in this directory:

   C:\B9\system\bin32\