Oracle International Corporation

David Joseph Haimes

Robert Cooke Zwiebach

Rondy C Ng

Arunesh C Banerjee

Zeesha Currimbhoy

Abhijit Dhakephalkar

Todd Jeffery Little

Djiao Mei Siauw

Santosh Kumar Matam

Venkata Ramana Murthy Kosuri

Gregory David Roth

Dinesh Kumar

Ashish Kumar

Carolyn Luk

Mei Siauw

Anil Kumar Desu

Rama Raja Sekhar Allamsette

Imad Jabbour

A blockchain architecture allows blocks to store both public and private data. The public data may be accessible to any node in the blockchain network, while the private data may be accessible only to nodes specified in an access list, which may be provided when a record is added to the blockchain. When a new record is received, any private fields in the record may be identified and encrypted by a receiving node. The key may then be encrypted and sent with the protected record to other nodes in the access list. These nodes can access the encryption key, decrypt the private fields, and provide a consensus decision to a receiving node. After consensus, the protected record may be added to the blockchain, where the public fields may be freely accessed by any node, and the private fields remain accessible only to nodes in the access list.

Securely sharing selected fields in a blockchain with runtime access determination

Generating and applying a prediction model based on blockchain data is disclosed. Based on blockchain data related to historical invoices, a prediction model is generated using machine learning. The prediction model is used to generate a recommendation for a particular entity to obtain a target funding amount by a target funding date. The prediction model is applied to the particular entity's outstanding invoices. Based on blockchain data related to the outstanding invoices, the prediction model determines a predicted cost that the particular entity would incur in obtaining funding, by the target funding date, using each outstanding invoice. A funding type to be used for each invoice is also identified. Invoices are selected based on the predicted costs. An interface presents the recommendation to use the selected invoices to obtain the target funding amount by the target funding date.

Generating and applying a prediction model based on blockchain data

Operations include generating proposals for accounts payable and accounts receivable netting across multiple trading partners. A netting proposal system uses a machine learning model to generate netting proposals that are likely to be approved by the respective trading partners. The netting proposal system identifies characteristics of attributes of previously accepted netting proposals. Candidate attributes, with the same characteristics of attributes of previously accepted netting proposals, are selected for a new netting proposal. The netting proposal system further identifies characteristics of attributes of previously rejected netting proposals. Candidate attributes, without the same characteristics of attributes of previously rejected netting proposals, are selected for the new netting proposal. Furthermore, candidate attributes, with the same characteristics of attributes of previously rejected netting proposals, are not selected for the new netting proposal.

Generating payables and receivables netting proposals based on historical information

Integrating a blockchain ledger with an application external to the blockchain ledger is disclosed. A first method determines a state, to be written to a blockchain ledger, based on a contract transaction. A second method determines a state, to be written to the blockchain ledger, based on an adapter transaction. The first method includes an invocation of the second method. The second method verifies whether the adapter transaction includes a particular set of information associated with a particular application. If the adapter transaction includes the particular set of information, then both the contract transaction and the adapter transaction are committed to the blockchain ledger. If the adapter transaction does not include the particular set of information, then neither the contract transaction nor the adapter transaction are committed to the blockchain ledger. The state determined based on the adapter transaction is used to update the particular application.

Integrating a blockchain ledger with an application external to the blockchain ledger

A method of accelerating transactions for a relational database using a pre-populated multidimensional data cube includes pre-populating the multidimensional data cube based on values from the relational database system; executing one or more transactions using values in the multidimensional data cube instead of using the values from the relational database system; generating one or more entries that update the relational database system using results generated from executing the one or more transactions; posting the one or more entries to the relational database system; and repopulating the multidimensional data cube based on values from the relational database system that changed as a result of posting the one or more entries to the relational database system.

Data transaction acceleration using multiple data structure types

A method of accelerating execution of a transactions includes storing financial ledgers in a relational database, prepopulating a multidimensional data cube using the relational database, executing the transactions using the data cube by querying the data cube for aggregated balances to generate result values, generating accounting journal entries that update each account in the ledgers affected by the transactions using the result values from the data cube, posting the accounting journal entries to the financial ledgers in the relational database, repopulating the data cube with the changes resulting from the posted journal entries, and updating the aggregated balances of the data cube.

In an embodiment, for any structural change that is made to a relational database, a corresponding change is also made to the multidimensional database. In an embodiment, the system determines that a particular structure is not implemented on the multidimensional database system. Based on metadata that defines the structure that is supposed to exist in the multidimensional database, the appropriate structure is created.

Mechanism for synchronizing OLAP system structure and OLTP system structure

Mechanism for updating OLAP system structure and OLTP system structure

Systems, methods, and computer-readable media for acceleration of system documentation conformance to differentiated regulations of multiple countries are provided. A database may be prepopulated with documentation specifications specifying documentation attributes corresponding to transaction types and countries. Information indicative of an enterprise structure may be processed. Countries that correspond to the enterprise structure may be identified. Country-specific rules may be determined, the rules defining requirements pertaining to documentation of transactions. A first subset of documentation attributes may be selected based on the rules, the first subset specifying documentation options pertaining to a first transaction type. A second subset of documentation attributes may be selected based on the rules, the second subset specifying documentation options pertaining to a second transaction type. A set of objects to facilitate setup of an accounting program may be generated. The computer system may be configured to execute the accounting program based on the set of objects.

Acceleration of system documentation conformance to differentiated regulations of multiple countries

A method of detecting variances in a plurality of accounts from different organizations within an Enterprise Financial Accounting system includes receiving a selection of a first account with an account type; receiving a selection of a first time interval and a second time interval; determining a first amount that is associated with the first account during the first time interval; determining a second amount that is associated with the first account during the second time interval; receiving a selection of a comparison operator that relates the first amount to the second amount; receiving a selection of a threshold; determining a comparison value by comparing the first amount to the second amount according to the comparison operator; determining that the comparison value violates the threshold according to the comparison operator; and displaying a first indication in a portal comprised of the first amount, the second amount, and the comparison value.

Efficient detection and analysis of variances

A method of using rules to execute periodic allocations of funds in a hierarchal accounting structure may include receiving an allocation rule, comprising a source account, a rule for determining a first amount, a parent account, and an allocation basis; accessing a multidimensional data cube comprising a hierarchal arrangement and aggregated balances for each level of the hierarchal arrangement; generating an allocation scenario by allocating the first amount to the aggregated balances for the one or more child accounts according to the allocation rule; generating one or more accounting journal entries corresponding to the allocation scenario; posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating, using the relational database, the multidimensional data cube to reflect the allocation scenario.

Allocation manager

A method of using a formula to execute periodic transfers in a hierarchal accounting structure includes receiving a transfer formula that may comprise a source account, a target account, an offset account, an account characteristic, and a formula for determining a first amount of the source account based on the account characteristic. The method may also include accessing a multidimensional data cube with a hierarchal arrangement and aggregated balances for each level. The method may additionally include generating a transfer scenario by transferring the first amount to the aggregated balance for the target account according to the transfer formula, and generating one or more accounting journal entries corresponding to the transfer scenario. The method may further include posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating the multidimensional data cube to reflect the transfer scenario.

Growing community of inventors

Belmont, CA, United States of America

David Joseph Haimes