Results 1 to 8 of 8

Thread: CFR Auditing

  1. #1

    CFR Auditing


    How to turn on CRF auditing in E1 ssytem ?

    We are on 8.12 Oracle 10g unix.


  2. #2
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,736

    Re: CFR Auditing

    SRI,

    CFR Auditing is a bit more complex than can should be explained here.

    First - find the CFR manual and glaze through it (your eyes will go all foggy on about page ten)....

    You may (MAY) want to partner with someone that has done it a few times - it's not just 'turn on' type functionality. It has some Database repercussions that you need to consider (thus, the manual)...

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  3. #3
    Member 78aspide78's Avatar
    Join Date
    Mar 2008
    Location
    Italia
    Posts
    624

    Re: CFR Auditing

    Hi,
    take a look at this 21CFR .
    Regards.

    Bruno Condemi
    E1 9.1 - TR 9.1.4.4 AS400 + WIN2008 - WAS 8.5

  4. #4
    Member
    Join Date
    May 2001
    Location
    Toronto, Canada
    Posts
    126

    Re: CFR Auditing

    It’s been a couple of years since I’ve done this and perhaps there is more recent documentation but you could start by looking for these.

    CFR 11 white paper oti-02-0102-02
    E1_Tools_8.96_Auditing_Admin_inc_21_CFR__Rev_1
    ERP 8.0 Auditing Administration including 21CFR Part 11

    Michael
    B7.1.4 to EnterpriseOne 9.0

  5. #5
    Member
    Join Date
    Feb 2001
    Posts
    501
    Hi. My company wants to audit F4006. They are thinking about turning on CFR auditing. Once CFR is turned on for a pathcode, are all tables within that pathcode being audited? Or can we pick and choose which
    C Ho

    E9.1 TR9.1.4.3 SQL Server 2008

  6. #6
    Member Soumen's Avatar
    Join Date
    Sep 2005
    Location
    Houston, Texas
    Posts
    218
    CFR is based on specific tables and yes you can pick and choose. But again as (DB) said take a look at the manuals .. you will be ending up with A4006 table corresponding to F4006 on your DB side. Also it would add some extra steps to your data refreshes ... like turning it off and on.

    And with my exp .. I doubt your co. will stop at F4006 ..there will be more tables which will follow! ;-)
    Just my 2c !!!

  7. #7
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,047
    CHo,

    consider Database Triggers as an alternative to turning on 21 CFR.
    Its a much less invasive approach.

    Basically what you do is:

    IN JDE:
    ---------
    1. Copy the Table Definition to a '55' version in omw (create a F554006L). (2 minutes)
    2. Edit the Table Definition and add a new Date/Time Stamp field (or some unique serialized field value). Add this field to the Primary Key of the Table (at end). (5 minutes)
    3. Generate the Table (create the table in the database). (< 1 minute)
    4. Create a JDE Business View (V554006L) 4 for the table (2 minutes)
    5. Create a Application (P554006L) with one (1) Form - a simple Find/Browse form - based on the V554006L view.

    DATABASE:
    -------------
    At the database level create a After Update Trigger on F4006 that writes the contents of the updated row in F4006 to F554006L.
    Changes to rows in F4006 will now automatically be logged into F554006L.

    We have ~ 20 tables we've done this for and have provided Row exits in the main Apps to view the Change History for an Item, a Work Order, etc.
    Larry Jones
    E1 9.1 - TR 9.1.5 on Win 2012 R2. Oracle DB 11.2.04
    WebLogic 12.1.3, Wintel, BI Publisher

  8. #8
    Member
    Join Date
    Feb 2001
    Posts
    501
    Hi Larry.

    Thanks for the advice. I did present database triggers as an option and it was rejected along with table triggers. The other two options remaining are CFR or mod the P4006 to add new record to audit table.
    C Ho

    E9.1 TR9.1.4.3 SQL Server 2008

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.