My Oracle Support Banner

E1: CFR11: Frequently Asked Questions on EnterpriseOne Auditing Tool (21CFR Part 11) (Doc ID 1087604.1)

Last updated on MAY 29, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
Information 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?
 
 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.
 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 18: From where will the data be fetched when Auditing in enabled ? Example What happens when auditing is enabled on table (Ex:F0101), will the data be fetched from F0101 or F0101_ADT or the audit table A0101?
 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?

 
 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.