E1: CFR11: Frequently Asked Questions on EnterpriseOne Auditing Tool (21CFR Part 11)
(Doc ID 1087604.1)
Last updated on JANUARY 17, 2025
Applies to:
JD Edwards EnterpriseOne Tools - Version SP23 and Prior and laterInformation in this document applies to any platform.
Purpose
This document contains answers to the most commonly asked questions related to JD Edwards EnterpriseOne Auditing Administration including 21CFR Part 11 Administration. It also contains references to solutions related to 21CFR11 and relevant auditing information.
Questions and Answers
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Questions and Answers |
| Basic CFR11 Audit Questions |
| Question 1: What is auditing of data? |
| Question 2: Why is auditing needed? |
| Question 3: What is the 21CFR11 auditing application/tool in EnterpriseOne? |
| Question 4: Any licensing required to implement 21CFR11 auditing application/tool in EnterpriseOne? |
| Question 5: Is it possible to enable auditing for specific users or roles? |
| Question 6: Does JDE 9.2 have 21-CFR11 auditing enabled by default? |
| Getting started with CFR11 auditing Tool |
| Question 1: Where to find information about MTRs and guide(s) to implement 21CFR11 auditing tool? |
| Question 2: Any tutorial available with the step-by-step screenshots/process to enable 21CFR11 auditing? |
| Question 3: Is there any table in which auditing cannot be enabled? |
| Question 4: Can auditing be enabled on multiple pathcodes simultaneously in tools release prior to 9.1.4.x? |
| Question 5: Can an Electronic Software Update (ESU) /Application Software Update (ASU) / Tools Release be applied if 21 CFR11 Auditing is enabled? |
| Question 6: Does 21CFR11 have a Real Time notification if a signature is refused? |
| Question 7: Can custom table(s) be audited using 21CFR11? |
| Tables, Applications used by CFR11 Auditing Tool |
| Question 1: What are the system tables used to configure 21CFR11 auditing? |
| Question 2: What are the applications used by 21CFR11 auditing tool? |
| CFR11 Auditing Configuration Questions |
| Question 1: How to Copy Audit Table Configurations from one environment to another environment? (Ex: DV to JDV or PY to JPY etc.) |
| Question 2: How to create a non-Julian Database Data Source for CFR11 auditing setup? |
| Question 3: What is the dbtemplate.exe for and what does it create? Where do you execute the EXE from? |
| Question 4: How are the following fields populated: CFRGUID & AUDITTYPE? Is there any relationship between values in these fields? |
| Question 5: Is there a way to turn off auditing on individual fields once a table has been configured? |
| Question 6: If two environments share the same pathcode is auditing in both environments required? |
| Question 7: When auditing is enabled, can a data refresh be done? |
| Question 8: If auditing is disabled and enabled again, does the previous audit data get lost? |
| Question 9: After configuring 21CFR11, is it necessary to restart E1 services? |
| Question 10: What is the impact to the database when auditing is enabled for a table? (or) How much extra space does an audited table take? And does auditing affect the performance? |
| Question 11: When Audit is enabled for a System table like F98OWSEC, why an OCM record is automatically created in System data source for the 'A' table but not created in the Server Map data source? |
| Question 12: Is it required to disable CFR11 Auditing in case of Database Upgrade? (Ex: Oracle, SQL Server, DB2 etc.) |
| Question 13: With 21CFR11 Auditing, Is It possible to work with multiple time zones? |
| Question 14: Where should the OCM for business function B9500005(Get and Delete Temporary Audit Information) should point to? |
| Question 15: How to create record in table F9500001 specific to a table for "J" Environment? Ex: JPY920. |
| Question 16: Is it possible to enabled auditing on environments which share the same pathcode but different set of Business Data and Control Tables? |
| Auditing Table Questions |
| Question 1: Why is the audit table created without a Primary Key Index? |
| Question 2: Can data from an Audited table be copied? |
| Question 3: What are the OWNOGUID records found in the Audit table? Why is there no valid GUID for these records even though they are generated from within E1? |
| Question 4: Should every record in an A table (a table containing an audit trail for 21CFR11 auditing) have an EnterpriseOne userID (a JDB user) for the CFRUSER value? |
| Question 5: How to view the before and after information on the audited table? Is it possible to see the SQLPlus changes/updates? |
| Question 6: Is there a way to delete tables that are being audited in P9500001 audit application? |
| Question 7: Why is the 'A' (audit) table growing in size/records even when users are exiting without making any changes but click on the "OK" button? |
| Question 8: When trying to generate an index for an audited table, error: unable to create index - is thrown. |
| Question 9: Does 21CFR11 auditing feature store the history of changes done to a record (or) does it store only the last change/modification done on a record? |
| Question 10: Can we add a custom table trigger on an existing auditing enabled table. Will this impact the existing CFR11 auditing trigger? |
| Question 11: Is Database Audit Manager (available In JD Edwards World) available/used in JD Edwards Enterprise One? |
| Question 12: Is there a way to check the fields which have "audit trigger columns" enabled? |
| Question 13: How to correct and insert a data in a CFR11 Auditing enabled Table? |
| Question 14: Can the trigger be accessed from E1? |
| Question 15: Is it required to do the Check-In of "A" table from P9500003 application or can this be performed from OMW? |
| Question 16: What happens if auditing is enabled on System tables on only one pathcode? Ex: F0093 |
| Question 17: Is it possible to audit processing option (PO) values in F983051 table? |
| Question 19: Is there a way to exclude selected record updates coming from JDE Reports or third-party interface when Auditing is enabled? |
| Question 21: Is it possible to enable auditing on a table for specific records? (Ex: Capture audit data for a specific company only) |
| Electronic Signature Questions |
| Question 1: Can electronic signatures be configured for all applications/reports in E1? |
| Question 2: Is there any specific setting in electronic signature for populating the columns CFRUGRP1(Role), CFRUPMJ and CFRUPMT? |
| Question 3: Default reason codes are not populated within the approval form for Chinese users who work with items and BOMs. Why? |
| Question 4: What is the purpose of the role entered in the P9500001 - Interactive Application Signature Information (for first approver and second approver)? |
| Question 5: Is It required to build and deploy a package after configuring auditing and electronic signature? |
| Question 6: Does Electronic Signature display separate screen for approval? Is there any examples? |
| Question 7: What value is stored in the column SIGSUC of table F9500006? |
| Question 8: Is it possible to have multiple approvers via CFR11 Electronic Signature? Also, Is there an option to delegate this work to a different user? |
| Question 9: Can electronic signatures be configured and work with LDAP Authentication? |
| CFR11 Auditing Report Questions |
| Question 1: Why should table F9500005 (Audit Report Table) be mapped locally? |
| Question 2: How to execute report R9500005 to print audit information? |
| Question 3: In World software, UBE R98807 helps to review audit related information. Is there a similar report available in E1? |
| Question 4: What is the date format to enter date (BC Date and Time Stamp (F9500005)) in data selection of R9500005? |
| Question 5: Is it possible to track the application that made a change to the table being audited? |
| Others |
| Question 1: What are the normal audit trail columns that are available for a table with no CFR11 auditing? |
| References |