Creating Julian and Non-Julian Database Data Sources for 21 CFR Part 11

When setting up auditing, you must configure a Julian database data source and non-Julian database data source for the auditing system/configuration tables. To do so:

1. Sign in to the EnterpriseOne Windows client.

2. In the Fast Path, enter GH9011.

3. Drill down into Data Source Management.

4. Create a Julian Database Data Source.

5. Open the Database Data Sources application and locate the data source:

   1. Select System - 900.

   2. In the Data Source Name QBE (Query by example) field, enter System - 900.

   3. Click Find.

   4. Select System - 900 in the grid and click Copy.

   5. Enter System - XXSY in the Data Source Name field, where:

      XX denotes the path code for which you are configuring auditing, such as DV for Development, PY for Prototype, or PD for Production.

   6. Enter the database server name.

   7. In the Object Owner ID field, enter the database owner, for example: DVSY for Development Julian system and configuration tables.

   8. Click Advanced and make sure the "Use Julian Dates" check box is selected.

   9. Click OK.

   10. Select the Row menu and then select Database Sizing.

       This opens the Work with Oracle Database Object Sizing form.

   11. Click the Add button.

   12. In the Object Name field, enter Default.

   13. In the Table Space Name field, enter xxsyt, where:

       xx denotes the path code you are configuring for auditing.

   14. In the Index Space Name field, enter xxsyi, where:

       xx denotes the path code you are configuring for 21 CFR Part 11.

   15. Click OK.

   16. Click Cancel.

   17. Click OK.

6. To configure the non-Julian data source:

   1. Open the Database Data Sources application.

   2. Enter System - 900 in the Data Source Name QBE (query by example) field.

   3. Click Find.

   4. Select the System - 900 data source.

   5. Click Copy.

   6. Enter System - XXNJ in the Data Source Name field, where:

      XX denotes the path code you are configuring 21 CFR Part 11 for.

      NJ denotes that the data source will contain non-Julian tables.

   7. Enter the database server name.

   8. Enter the object owner ID.

   9. Enter the database name.

   10. Click on Advanced.

   11. Clear the Use Julian Dates check box.

   12. Click OK.

   13. Click the Database Sizing Form exit.

   14. Click Add.

   15. In the Object Name field, enter default.

   16. In the Table Space Name field, enter xxnjt, where:

       xx denotes the path code you are configuring 21 CFR Part 11 for.

   17. In the Index Name field, enter xxnji, where:

       xx denotes the path code you are configuring 21 CFR Part 11 for.

   18. Click OK.

   19. Click Close.

   20. Click OK.

   Repeat these steps for each path code for which you are configuring 21 CFR Part 11 in System and all server maps.

   After defining the System - XXSY (Julian) and System - XXNJ (Non-Julian) data sources, generate the required OCM mappings.

   After creating OCM mappings and data sources, you must restart the EnterpriseOne Windows client for the mappings to take effect.