Page 2 of 2 FirstFirst 1 2
Results 11 to 12 of 12

Thread: Track changes to Address Book numbers

  1. #11
    Adding to what others have said, my thoughts below

    Firstly using the Interop Outbound feature to track changes is a great idea. Had not thought of it before.

    Both options (CFR11 Auditing and Interoperability ) require custom reports or screens to report / inquire against the audit data

    CFR11 option is implemented as a table trigger on the database , so this will also capture any changes done directly at the database level through SQL etc. Interop option will not.

    CFR option can let you track changes done to specific columns in addtion to the primary keys (which are always tracked) , but I believe Interop will always write out a record if anything is changed on the record .

    Interop option is easier to activate and turn on. CFR 11 requires some foundational setup work and then the table specific setup, service bounce , package build (If you want to query the A tables using JDE screens and Reports).

    If querying the audit data using external tools , it helps that the CFR audit tables have native date and time fields as opposed to JDE Juilan Dates.

    During Upgrades / table index changes through JDE etc , CFR auditing needs to be turned off and on again after the changes are made, Interop option is not affected by this
    EnterpriseOne Xe to 9.2
    Windows/ Unix / AS400
    Oracle , SQL Server, DB2
    WAS , WLS
    AppWorx, Tidal , SmartScheduler

  2. #12
    The auditing in CFR auditing is performed by the database, but managed within JDE. So, I would say the CFR auditing is also out-of-the-box.
    Jeremy Shearer

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 and, or Oracle.