Method of and system for associating an electronic signature with an electronic record

• US 7,600,124 B2
• Filed: 12/08/2003
• Issued: 10/06/2009
• Est. Priority Date: 11/18/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Puri, Srinivasulu, Durgada, Savita, Akella, Ravindra, Karimisetty, Srikanth, Singh, Charanjeet
• Primary Examiner(s): Zand; Kambiz
• Assistant Examiner(s): Powers; William S
• Application Number:
  US10/731,657
• Publication Number:
  US 20050108283A1
• Time in Patent Office: 2,129 Days
• Field of Search: 726/11
• US Class Current: 713/176
• CPC Class Codes: G06F 16/81 Indexing, e.g. XML tags; Data structures therefor; Storage structures

Abstract

A method of and system for associating an electronic signature with an electronic record in a computer system. In one embodiment the method comprises allowing a user to define an event that, upon occurrence, generates an electronic record that requires an electronic signature; allowing a user to define the fields stored in the electronic record; allowing a user to generate a map that maps data from underlying database tables to at least some of the fields defined for the electronic record; allowing a user to define a layout for displaying data in the electronic record on a computer display when an electronic signature for the data record is collected; allowing a user to identify a signatory approver for the electronic record; generating the electronic record and displaying the electronic record to the signatory approver according to the defined layout in response to the occurrence of the event; receiving an electronic signature from the signatory approver; and associating the electronic signature with the electronic record. Some embodiments further comprise verifying the electronic signature prior to associating the signature with the electronic record.

Claims

1. A computer-implemented method of associating an electronic signature with an electronic record, the method comprising:

receiving, at a computer system configured to manage a database of electronic records, first information provided by a user via a graphical user interface configured to enable users of the computer system to define operations by one or more database applications as triggering conditions for application events monitored by the computer system and processing that occurs when the application events are triggered, the first information defining an application event that, upon occurrence, causes the computer system to intercept a database transaction instantiated by one of the database applications with a database management system of a database and generate from data identified in the database transaction an electronic record that requires an electronic signature;

receiving, at the computer system, second information provided by the user via the graphical user interface, the second information defining one or more fields for data to be stored in the electronic record;

receiving, at the computer system, third information provided by the user via the graphical user interface, the third information providing a mapping between data from underlying database tables associated with the database transaction to at least some of the fields defined for data to be stored in the electronic record;

receiving, at the computer system, fourth information provided by the user via the graphical user interface, the fourth information defining a layout that is applicable when an electronic signature is collected for the electronic record for displaying data stored in the electronic record on a computer display;

receiving, at the computer system, fifth information provided by the user via the graphical user interface, the fifth information identifying a signatory approver for the electronic record;

in response to detecting the occurrence of the application event at the computer system when the one of the database applications instantiates the database transaction associated with the application event with the database management system of a database, automatically generating the electronic record with the computer system from data intercepted from the database transaction according to the mapping between the data from the underlying database tables associated with the database transaction to the at least some of the fields in the electronic record;

displaying the electronic record using the computer system to the signatory approver according to the defined layout in order to collect an electronic signature for the electronic record;

receiving, at the computer system, an electronic signature from the signatory approver for the electronic record; and

generating, by the computer system, sixth information associating the electronic signature from the signatory approver with the electronic record prior to performing an action with the computer system that results in committing the database transaction to the database associated with the database management system.

2. The method of claim 1 further comprising verifying the electronic signature at the computer system prior to associating the electronic signature with the electronic record.

3. The method of claim 2 wherein associating the electronic signature with the electronic record comprise associating by the computer system the electronic signature with the electronic record in response to a positive verification of the electronic signature.

4. The method of claim 1 wherein the electronic signature comprises a user id and a password.

5. The method of claim 1 further comprising verifying the electronic signature by the computer system and storing the electronic record with the computer system in a common repository of electronic records that are generated from multiple data sources.

6. The method of claim 5 wherein the electronic record comprises unstructured data in a character large object (CLOB) format.

7. The method of claim 6 wherein the common repository is a database and wherein the unstructured data is a well-formed XML document stored within a column of a table stored in the database.

8. The method of claim 1 further comprising:

receiving, at the computer system, seventh information provided by the user via the graphical user interface, the seventh information specifying a set of business rules associated with the application event;

determining, with the computer system, a business rule from the set of business rules associated with the application event; and

executing the business rule with the computer system to determine whether an electronic signature is required to connote review or approval of the electronic record.

9. A computer system that manages a database of electronic records, the computer system comprising:

a processor; and

a computer-readable memory coupled to the processor, the computer-readable memory configured to store a computer program;

wherein the processor is operative with the computer program to;

(i) receive first information provided by a user via a graphical user interface configured to enable users of the graphical user interface to define operations by one or more database applications as triggering conditions for application events and processing that occurs when the application events are triggered, the first information defining an application event that, upon occurrence, causes the processor to intercept a database transaction instantiated by one of the database applications with a database management system of a database and generate from data identified in the database transaction an electronic record that requires an electronic signature;

(ii) receive second information provided by the user via the graphical user interface, the second information defining one or more fields for data to be stored in the electronic record;

(iii) receive third information provided by the user via the graphical user interface, the third information providing a mapping between data from underlying database tables associated with the database transaction to at least some of the fields defined for the electronic record;

(iv) receive fourth information provided by the user via the user interface, the fourth information defining a layout that is applicable when an electronic signature is collected for the electronic record for displaying data stored in the electronic record on a computer display;

(v) receive fifth information provided by the user via the graphical user interface, the fifth information identifying a signatory approver for the electronic record;

(vi) intercept data from the database transaction instantiated by the one of the database applications with the database management system of a database to generate the electronic record in response to detecting the occurrence of the application event, the electronic record generated by the processor according to the mapping between the data from the underlying database tables associated with the database transaction to the at least some of the fields in the electronic record;

(vii) receive an electronic signature from the signatory approver for the electronic record; and

(viii) generate sixth information that associates the electronic signature from the signature approver with the electronic record prior to performing an action committing the database transaction instantiated by the one of the database applications with the database management system of a database to the database associated with the database management system.

10. The computer system of claim 9 wherein processor is further operative to verify the electronic signature.

11. The computer system of claim 10 wherein processor is operative to associate the electronic signature with the electronic record in response to a positive verification of the electronic signature.

12. The computer system of claim 9 wherein the electronic signature comprises a user id and a password.

13. The computer system of claim 12 wherein the processor is further operative to verify the electronic signature and store the electronic record in a common repository of electronic records that are generated from multiple data sources.

14. The computer system of claim 13 wherein the electronic record comprises unstructured data in a character large object (CLOB) format.

15. The computer system of claim 14 wherein the common repository is a database and wherein the unstructured data is a well-formed XML document stored within a column of a table stored in the database.

16. The computer system of claim 9 wherein the processor is further operative to:

determine a business rule from a set of business rules associated with the application event; and

execute the business rule to determine whether an electronic signature is required to connote review or approval of the electronic record.

17. A computer program product embodied on a computer-readable storage medium configured to store a set of code modules which when executed by a processor of a computer system cause the processor to manage a database of electronic records, the computer program product comprising:

code for displaying a graphical user interface configured to enable users of the graphical user interface to define operations in one or more database applications as triggering conditions for application events and processing that occurs when the application events are triggered;

code for receiving first information provided by a user via the graphical user interface, the first information defining an application event that, upon occurrence, causes a database transaction instantiated by one of the database applications with a database management system of a database to be intercepted and an electronic record that requires an electronic signature to be generated from data identified in the database transaction;

code for receiving second information provided by the user via the graphical user interface, the second information defining one or more fields for data to be stored in the electronic record;

code for receiving third information provided by the user via the graphical user interface, the third information providing a mapping between data from underlying database tables associated with the database transaction to at least some of the fields defined for data to be stored in the electronic record;

code for receiving fourth information provided by the user via the graphical user interface, the fourth information defining a layout that is applicable when an electronic signature is collected for the electronic record for displaying data stored in the electronic record on a computer display;

code for receiving fifth information provided by the user via the user interface, the fifth information identifying a signatory approver for the electronic record;

code for, in response to detecting the occurrence of the application event when the one of the database applications instantiates the database transaction with the database management system of a database, generating the electronic record from data intercepted from the database transaction according to the mapping between the data from the underlying database tables associated with the database transaction to the at least some of the fields in the electronic record;

code for displaying the electronic record to the signatory approver according to the defined layout in order to collect an electronic signature;

code for receiving an electronic signature from the signatory approver for the electronic record; and

code for generating sixth information associating the electronic signature from the signatory approver with the electronic record prior to performing an action that results in committing the database transaction to the database associated with the database management system.

18. The computer program product of claim 17 further comprising code for verifying the electronic signature.

19. The computer program product of claim 18 wherein the electronic signature comprises a user id and a password.

20. The computer program product of claim 18 further comprising code for storing the electronic record in a common repository of electronic records that are generated from multiple data sources.

21. The computer program product of claim 20 wherein the electronic record comprises unstructured data in a character large object (CLOB) format.

22. The computer program product of claim 21 wherein the common repository is a database and wherein the unstructured data is a well-formed XML document stored within a column of a table stored in the database.