Hierarchical transaction filtering

• US 7,958,026 B2
• Filed: 04/29/2003
• Issued: 06/07/2011
• Est. Priority Date: 04/29/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Solberg, Eric L., Avital, Jacob
• Primary Examiner(s): Colbert; Ella
• Assistant Examiner(s): Anderson; John A
• Application Number:
  US10/426,474
• Publication Number:
  US 20070174160A1
• Time in Patent Office: 2,961 Days
• Field of Search: 705/35
• US Class Current: 705/35
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

Systems and methods of allocating transactions among business objects are described. Allocation is accomplished using generated allocation rules that are generated using a hierarchical data structure representative of relationships between the business objects and using predefined rules that characterize the business objects. Each generated allocation rule is associated with at least one of the business objects and is used to query a set of transactions to be allocated. Query results, generated using a generated allocation rule, include the transactions to be allocated to the associated business object. Embodiments are disclosed to illustrate how the invention can be used to allocate sales commissions to members of a sales team. The invention is applicable to a variety of business objects including people, organizations, accounts, tasks, or the like.

Claims

1. A transaction filtering system for allocating credit for transactions among a plurality of business objects, the system comprising:

a processor for executing instructions;

storage configured to store commission allocation rules and to store transaction data associated with a plurality of transactions, each commission allocation rule being associated with at least one of a plurality of business objects and being generated using relationships between members of the plurality of business objects; and

a query engine including processor-executable instructions for placing the generated commission allocation rules in a structured query language (SQL) query and generating a set of query results based on the SQL query.

2. The transaction filtering system of claim 1, wherein a member of the plurality of transactions is a sale and the query is configured to determine commission allocation.

3. The transaction filtering system of claim 1, wherein a member of the plurality of transactions is a service request and the query is configured to determine a business object to provide the requested service.

4. The transaction filtering system of claim 1, wherein a member of the plurality of transactions includes distribution of a sales lead.

5. The transaction filtering system of claim 1, wherein the plurality of transactions include sales and a result of the query is used to sum transactions allocated to a member of the plurality of business objects.

12. A transaction filtering system according to claim 1, wherein the storage is configured to store data according to a hierarchical data structure, the hierarchical data structure comprising:

a root node;

one or more intermediate nodes related to the root node;

one or more predefined commission allocation rules, each predefined commission allocation rule associated with a member of the one or more intermediate nodes; and

a leaf node,

wherein a generated commission allocation rule is associated with the leaf node and configured for use in determining credit for transactions to a business object associated with the leaf node, the generated commission allocation rule including a member of the one or more predefined rules inherited from the one or more intermediate nodes.

13. The transaction filtering system of claim 12, wherein the business object is a person.

14. The transaction filtering system of claim 12, wherein the business object is an organization.

15. The transaction filtering system of claim 12, wherein the business object is an account.

16. The transaction filtering system of claim 1, wherein the query engine generates a query for determining transaction allocation output, the transaction allocation output comprising:

a set of transactions selected using a query, the query based on a generated commission allocation rule generated using a hierarchical data structure and associated with a leaf of the hierarchical data structure, at least two transactions of the set of transactions including a transaction value; and

a summation of the transaction values.

17. The transaction filtering system of claim 16, wherein the transaction allocation output includes digital data transferred through a communications channel between a computing system and a client.

18. The transaction filtering system of claim 16, wherein the generated allocation rule includes a predefined commission allocation rule associated with a node of the hierarchical data structure.

19. The transaction filtering system of claim 16, wherein the generated allocation rule includes a predefined rule associated with a node of the hierarchical data structure, and wherein the transaction values include sales commissions.

20. The transaction filtering system of claim 16, wherein the generated allocation rule includes a predefined rule associated with a node of the hierarchical data structure, and wherein the transaction values include inventory allocation.

21. The transaction filtering system of claim 16, wherein the generated allocation rule includes a predefined rule associated with a node of the hierarchical data structure, and wherein the transaction values include resource allocation.

22. The transaction filtering system of claim 1 wherein the query engine executes instructions for storing the commission allocation rules directly as the SQL query.

23. The transaction filtering system of claim 22 wherein the query engine executes instructions for retrieving the commission allocation rules directly as the SQL query.

6. A computing system for hierarchical transaction filtering, the computing system comprising:

a processor for executing instructions;

storage configured to store a hierarchical data structure, a generated commission allocation rule, and transaction data;

a rule generation engine including processor-executable instructions to produce the generated commission allocation rule using data stored in the hierarchical data structure; and

a query engine including processor-executable instructions to place the generated commission allocation rule in a structured query language (SQL) query and generate a set of query results based on the SQL query.

7. The computing system of claim 6, wherein the hierarchical data structure is configured to represent relationships between business objects in an organization.

8. The computing system of claim 6, wherein the generated allocation rule includes a predefined commission allocation rule inherited from a parent node.

9. The computing system of claim 6, wherein the generated commission allocation rule is produced by traversing the hierarchical data structure.

10. The computing system of claim 6, wherein the query engine is configured to select transactions meeting a predefined rule included in a generated allocation rule.

11. The computing system of claim 6, further including a transaction source configured to generate the transaction data.