Oracle International Corporation

Ravindra Akella

Savita Durgada

Srikanth Karimisetty

Srinivasulu Puri

Charanjeet Singh

Manish Kumar Gupta

William G Stearns

Mark Fisher

John Danese

Hany Saleeb

Sanjay Rastogi

A method of and system for committing a transaction to a database. In one embodiment the method comprises initiating a database transaction; creating an electronic record that includes transaction data from the database transaction; executing a rule associated with the record to determine whether an electronic signature is required to connote review and/or approval of the electronic record, and requesting the electronic signature prior to committing the transaction to the database if execution of the rule results in a determination that an electronic signature is required.

Method of and system for committing a transaction to database

A method of and system for intercepting a transaction instantiated by a database application to determine if an electronic signature is necessary to commit the transaction to the database is disclosed. In one embodiment the method comprises calling an application program interface to raise an event in response to a triggering action generated by the database application; initiating a workflow process that executes a rule to determine if an electronic signature is required to approve the transaction; and if execution of the rule results in a determination that an electronic signature is required for the transaction, instantiating a signature collection process. Some embodiments further comprise obtaining an electronic signature in response to the signature collection process and thereafter, verifying the electronic signature and updating a filed of the electronic record to indicate a valid signature was collected if the electronic signature is verified.

Method of and system for determining if an electronic signature is necessary in order to commit a transaction to a database

A method of and system for collecting an electronic signature for an electronic record stored in a database. In one embodiment the method comprises automatically creating an electronic record from data stored in a plurality of different database tables in response to the occurrence of a predetermined event; storing an instance of the electronic record in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the system; executing a rule associated with the electronic record to determine whether an electronic signature is required to connote review and/or approval of the electronic record; and if execution of the rule results in a determination that an electronic signature is required, marking the instance of the electronic record as unsigned and initiating a request to collect the required electronic signature. In some embodiments the electronic record is stored as unstructured data in a character large object (CLOB) format and the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.

Method of and system for collecting an electronic signature for an electronic record stored in a database

A method of and system for searching unstructured data stored in a database. In one embodiment the method comprises storing a plurality of electronic records in a common repository of electronic records in the database that provides an audit trail that cannot be altered or disabled by users of the system where each electronic record comprises unstructured data stored in a character large-object (CLOB) format in a column of a table of the database; creating a security protocol that protects the electronic records against unauthorized access; and creating a query designed to identify electronic records in the database that meet criteria designated in the query. The method further comprises modifying the query in accordance with the security protocol to create a modified query prior to executing the query and running the modified query against the unstructured data. In one particular implementation, the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.

Method of and system for searching unstructured data stored in a database

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.

Growing community of inventors

White Plains, NY, United States of America

Ravindra Akella