4 Working with Auditing and Electronic Signature Approvals

This chapter contains the following topics:

4.1 Entering an Electronic Signature Approval

This section provides an overview of the Signature Approval form and discusses how to use the Signature Approval form.

4.1.1 Understanding the Signature Approval Form

The Signature Approval form is used to require an electronic signature approval before an interactive or batch application can continue. When attempting to save or delete information in interactive applications or run batch applications that have been configured to require an approval, users are prompted for an approver's user ID and password. After an approver enters this information, the system verifies the credentials and then records it in a log file.

A signature consists of an approver's ID, password, and reason code. If the signature is valid, JD Edwards EnterpriseOne records who approved the change, the role, the reason, the application used, and the date and time in the Signature table (F9500006). An approver has four attempts to enter a valid user ID and password. If the signature is not valid, an error message appears and the user has three more attempts to enter the correct information. If the fourth signature attempt fails, a failed signature record is written to the F9500006 table.

The Signature Approval form can require up to two signature approvals. The second approver has the option to view the previous approver's information. In addition, users can attach media objects to electronic signature approvals.

4.1.2 Using the Signature Approval Form

When an application has been configured for signature approval, it launches the Signature Approval form before data can be processed or deleted.

  1. On the Signature Approval form, complete the User ID and Password fields.

  2. Select a reason code in the Reason Code field.

  3. If needed, enter additional information for the transaction in the Comment field.

  4. To add a media object attachment to the approval, click the attachment button.

  5. If two signature approvals are required, the second approver can view the previous approver's information by selecting Previous Info from the Form menu.

    After reviewing the information, the second approver can click Cancel to return to the current approval form.

  6. Click OK to validate the approval and allow the application to continue.

    Clicking Cancel on this form stops the transaction from processing and does not log an approval.

4.2 Removing Unmatched Audit Records

Before you review audit and signature records, you can run the R9500005A (Delete Unmatched Audit Log Records) batch application to remove any unmatched (or invalid) audit records. Audit records in the F9500003 and F9500004 tables are invalid if they do not have associated audit records in the corresponding audit table. The system can create unmatched records due to a system failure, an error, or other circumstance.

This section discusses how to run the R9500005A batch application to remove unmatched audit records.

4.2.1 Running the R9500005A Batch Application to Remove Unmatched Audit Records

Enter BV in the Fast Path to access the Batch Versions applications.

  1. On the Work With Batch Versions - Available Versions form, enter R9500005A in the Batch Application field and click the Find button.

  2. Select the Delete Unmatched Audit Log Records batch application and then select the Row menu, Processing Options.

  3. On the Processing Options form, enter the appropriate processing option value in the Mode for Deletion field and then click the OK button:

    • Enter 0 for proof mode.

      This processing option enables you to view a report of the invalid records that the batch application will delete when run in final mode.

    • Enter 1 for final mode, which deletes all unmatched records.

      This processing option removes invalid records and generates a report that lists the invalid records that were removed.

    • Enter 2 for final mode, which deletes unmatched records but retains records if an audit table could not be opened.

      This processing option removes invalid records on a table unless the table associated with the invalid records has been taken offline; then the system will not delete the invalid records.

  4. On the Work With Batch Versions - Available Versions form, click the Select button.

  5. On the Batch Versions - Version Prompting form, click the Submit button.

  6. On the Printer Selection form, click the OK button.

  7. On the Work With Batch Versions - Available Versions form, select the Form menu, Submitted Jobs.

  8. On Batch Versions - Submitted Job Search, to review the results of the batch job, select the job in the grid and then select the Row menu, View PDF.

4.3 Viewing Audit and Electronic Signature Records

The View Audit/Signature Information application (P9500005) enables you to view detailed records of signature and audit information. This application is available on Microsoft Windows client or the web client.

This section lists prerequisites and discusses how to:

  • View audit information.

  • View signature information.

  • View audit and signature information together.

4.3.1 Prerequisites

Before you can view audit and electronic signature records:

  • Specifications for the audit shadow table must exist on the enterprise server. Therefore, after you configure auditing for a table, you must build and deploy a package to the enterprise server.

  • To view audit information on the web client, you must build and deploy a package that contains all audit table specifications to the enterprise server.

4.3.2 Viewing Audit Information

Enter GH9091 in the Fast Path, and select the View Audit and Signature Information menu.

  1. On the Work with Audit and Signature Information form, click the Audit Information link.

  2. On the Work with Audit Information form, complete the appropriate fields to search for the desired information, and then click Find:

    • Table Name

      Search by the name of the table that was audited (Fxxxx).

    • Audit Table Name

      Search by the name of the audit table (Axxxx).

    • Date Updated

      Search by the date the audit record was created.

  3. Select the Matched Audit Records Only check box to refine the records so that the system only displays the audit records (from the F9500003 and F9500004 tables) that match the audit records in the corresponding audit table (Axxxx).

    This filters unmatched audit records that can be created due to a system failure or other circumstance.

    Note:

    You can also run a batch application that deletes all unmatched records from the table.

    See Removing Unmatched Audit Records.

  4. Click Find.

  5. Select the desired record and click Select.

  6. Select one or a combination of the following options to refine the search, and then click OK:

    • Unique Identifier

    • Table Name

    • Audit Table Name

    • Data Source

    • User ID

    • Address Number

    • Full Name

    • Date Updated

    • Time Last Updated

    • Program ID

    • Machine Key

    • IP Address

  7. To view a report of the audit information in PDF, select the Report Menu, Print Data.

    Note:

    If multiple users will be using this application, the Temporary Audit Table (F9500005) must be mapped locally.
  8. To view the signature information that corresponds to the audit record, on the Work with Audit Detail Information form, select the Row menu, Link to Signature Info.

  9. On the Work with Signature Information form, to access a blank Search Audit Info form, select the Form menu, Input Search Info.

  10. On the Search Audit Info form, enter the desired search parameters in the appropriate fields, select the corresponding check box, and then click OK.

4.3.3 Viewing Signature Information

Enter GH9091 in the Fast Path, and select the View Audit and Signature Information menu.

  1. On the Work with Audit and Signature Information form, click the Signature Information link.

  2. On the Work with Signature Information form, complete any of these fields and then click Find to search for signature records:

    • Application Name

    • Version

    • Form Name

    • Subform Name

    • Event

      Use this field to search by the event executed when the signature was captured (1 = OK, 2 = Delete)

    • Signature Successful

      Use this field to search by the success or failure value of the approval (0 = Success, 1 = Failure).

  3. Select the desired signature record and click Select.

    Alternatively, from the Row menu select More Info to see additional details about the signature.

  4. On the More Signature Information form, select the Form menu, Link to Audit Info.

  5. On the Work with Audit Information form, to print the signature information in PDF format, select the Report menu, Print Data

    Note:

    If multiple users will be using this application, the Temporary Audit Table (F9500005) must be mapped locally.

4.3.4 Viewing Audit and Signature Information Together

Enter GH9091 in the Fast Path, and select the View Audit and Signature Information menu.

  1. Click the Signature and Audit Information link.

  2. On the Work with Signature and Auditing Information form, complete any of these fields and then click Find to search for signature and audit records:

    • Application Name

    • Version

    • Form Name

    • Subform Name

    • Event. (Search by the event executed when the signature was captured [1 = OK, 2 = Delete].)

    • Table Name. (Search by the name of the audited table [Fxxxx].)

    • Audit Table Name. (Search by the name of the Audit table [Axxxx].)

    • Signature Successful. (Search by the success or failure value of the approval [0 = Successful, 1 = Failure].)

  3. On the Work with Signature and Auditing Information form, select the desired record and click Select.

  4. On the Search Audit Info form, select one or a combination of the following options to refine the search, and then click OK:

    • Unique Identifier

    • Table Name

    • Audit Table Name

    • Data Source

    • User ID

    • Address Number

    • Full Name

    • Date Updated

    • Time Last Updated

    • Program ID

    • Machine Key

    • IP Address

  5. To view a report of the audit information in PDF, select the Report menu, Print Data.

  6. To view a report that contains both signature and audit information, select the Report menu, Print Information.