Data structure for a complex order processing system

• US 7,761,337 B2
• Filed: 05/06/2002
• Issued: 07/20/2010
• Est. Priority Date: 12/18/2001
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Caballero, Richard Joseph, Lewis, Mark David
• Primary Examiner(s): Zeender; F. Ryan
• Assistant Examiner(s): Sheikh; Asfand M
• Application Number:
  US10/139,282
• Publication Number:
  US 20070203799A1
• Time in Patent Office: 2,997 Days
• Field of Search: 705/26
• US Class Current: 705/26.4
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0611 Request for offers or quotes
• CPC Class Codes: G06Q 30/0621 Item configuration or customization
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing
• CPC Class Codes: G06Q 30/0639 Item locations

Abstract

A complex order processing system is implemented in an architecture that allows customer service representatives and customers to access the customer'"'"'s accounts, service profiles, quotes, and orders. Account information can be entered and updated. Quotes can be generated for various configurations of products and services having different types of charges including one time fees, recurring fixed fees, and usage-based fees. The quotes can be saved, and later updated by the customer or by the system to reflect changes in the configuration of a product or service that is included in the quote. The quote can be converted to an order, and pending orders can be modified. Before allowing modification of a quote or order, the requested future state of a product or service is created by applying the prior active and unprocessed orders to the product or service. The portion of the product or service currently selected is also applied to the product or service, and the user can then reconfigure the product or service. Once the change is accepted, the difference between the requested state of the product and service before and after the change is generated and saved as a delta quote or order. The system also allows a user to transfer the configuration of products and services from one address to another by selecting a single option. Third party service providers of a customer can also view the configuration of the customer'"'"'s products and services in determining service options for the customer.

Claims

1. An order processing system, configured to be executed on a computer system, comprising:

a complex object, stored in a computer-readable storage medium of the computer system, comprising;

a service profile, quote information, and order information pertaining to an account,

a data manager, executed by a processor of the computer system, configured to

receive at least a portion of the service profile from an external server via an information network, and

generate a business object based on the portion of the service profile, and

a transformation engine configured to generate at least a portion of the complex object based on the business object;

user interface instructions, wherein the user interface instructions are configured to cause the processor to

generate, for display on a display of the computer system, a customer portal view comprising

a list of products and services associated with the account,

a list of quotes associated with the account,

a list of orders associated with the account, and a plurality of user-selectable options, and

receive data input from a user, wherein

the data input comprises a selection of at least a selected option of the plurality of user-selectable options;

a plurality of business service methods configured to perform functions associated with processing the orders; and

a plurality of workflow processes, wherein

each workflow process is configured to cause the processor to execute a function associated with the at least the selected option of the plurality of user-selectable options,

the each workflow process is configured to perform the causing by virtue of being configured to invoke at least one of the plurality of business service methods,

at least one of the plurality of workflow processes is invoked in response to the selection of the at least the selected option of the plurality of user-selectable options

the plurality of business service methods comprises a first business service method,

the first business service method is configured to create a hybrid structure by virtue of being configured to overlay one or more unprocessed components of an open order on a selected one of a plurality of complex objects,

the hybrid structure is configured to be used in a simulation of a future configuration of a first complex asset,

the first complex asset represents a customizable product, and

the plurality of complex objects comprises the complex object.

2. The order processing system of claim 1, further comprising:

instructions configured to update a status of order line items when a provisioning system completes all or part of an order.

3. The complex order processing system of claim 2, further comprising the plurality of complex objects, wherein each complex object is based on a property set comprising:

a complex asset, a quote, and an order; and

the business service methods comprise a plurality of;

an Apply Method to create a hybrid asset/order that simulates the future configuration of the complex asset by overlaying unprocessed items and attributes from open orders on one of the plurality of complex objects that is based on the complex asset;

a Delta Method to generate a delta complex object that represents the difference between at least two of the plurality of complex objects;

a Trim Method to create a new complex object by eliminating all items that meet predefined trim criteria from one of the plurality of complex objects;

a Logical Delete Method to generate a transformed delta order complex object by transforming items in one of the plurality of complex objects with an action code “

Delete”

to “

Update” and

changing status of the transformed items to “

Inactive”

;

an Explode Method to copy items in one of the plurality of complex objects with quantity greater than one, and generate a delta quote complex object with a corresponding number of copies of the item with quantity equal to one;

a Fully Exploded Method to determine whether the items in one of the plurality of complex objects have a quantity greater than one;

a Field Delta Method to set the action code of a parent quote item to “

Update”

when a specified field is updated;

a Set Effectivity Dates Method to generate a “

Calculated Effective End Date”

, a “

Calculated Effective Start Date”

, and a “

Completed Date”

, wherein the “

Calculated Effective End Date”

is set to the date the action code of an item in one of the plurality of complex objects based on an order was set to “

delete”

, the “

Calculated Effective Start Date”

is set to the date the action code of the item in the one of the plurality of complex objects was set to “

add”

, and the “

Completed Date”

is set to the date the order was completed;

a Set Action Method to set the action code of an item in one of the plurality of complex objects;

a Save Object Method to receive a key and a property set hierarchy that represents one of the plurality of complex objects, and saves the one of the plurality of complex objects in a string to object map using the key;

a Get Object Method to receive the key and return the one of the plurality of complex objects that corresponds to the key;

a Reset Method to delete all saved complex objects from the map;

a Module Licensed Method to determine whether the complex order processing system us licensed for a particular computer system;

an Update Order Status Method to check a Status field of a root item and all child items in the hierarchy of one of the plurality of complex objects based on a complex asset to determine whether the Status field is set to “

Complete”

, “

Failed”

or NULL;

a Merge Method to copy all items from one of the plurality of complex objects to another of the plurality of complex objects;

a Set Field Method to enumerate through the item hierarchy of one of the plurality of complex objects, find a named field of each item, and set the named field to a specified value; and

a Create Empty Complex Object Method to create an empty complex object based on one of the plurality of complex objects.

4. The complex order processing system of claim 1, wherein the workflow processes comprise:

a Move Process to transfer a customer'"'"'s complex asset configuration from an old location to a new location by entering the address of the new location and entering a single option selection to transfer the complex asset configuration from the old location to the new location.

5. The complex order processing system of claim 4, wherein the workflow processes comprise:

a Supplemental Orders Process to create a new order by allowing the user to revise a pending order, wherein the Supplemental Orders Process is configured to

generate the requested future state of the complex object by applying the prior active and unprocessed orders to the complex object;

apply a current order line item to the complex object;

allow the user to reconfigure the complex object;

generate the difference between the requested state of the complex object before the current order line item was applied and the state of the object after the user reconfigured the complex object; and

ungroup any order line item with a quantity of more than 1 into multiple line items, each with a quantity of 1.

6. The complex order processing system of claim 1, further comprising a plurality of complex objects, wherein each complex object is based on a property set of at least one of:

a complex asset, a quote, and an order; and

the workflow processes comprise at least one of;

a New Products and Services Process to create a quote;

a Modify Products and Services Process to modify a complex asset in a quote;

a Disconnect Products and Services Process to disconnect a complex asset;

a Profile Process to retrieve account information that corresponds to a quote;

an Edit Quotes Line Items Process to apply all active and unprocessed orders to a complex asset to generate the future state of the complex asset, and allow the user to make changes to the configuration of the complex asset and update a quote;

a Supplemental Orders Process to create a new order by allowing the user to revise a pending order;

an Edit Order Line Items Process to apply all active and unprocessed orders to a complex asset to generate the future state of the complex asset, allow the user to make changes to the configuration of the complex asset, and update an order;

a Quote to Order Process to convert a quote to a sales order;

an Update Opportunity Process to create revenue items for all quote line items;

a Submit Order Process to associate account information with each line item in an order and set the status of the order to “

open”

;

an Ungroup Quotes Process to create multiple copies of line items in a quote that have quantities greater than one;

an Apply Completed Sales Order Line Item To Service Profile Process to update an asset table for a complex asset that has been provisioned; and

a Move Process to transfer a customer'"'"'s complex asset configuration from an old location to a new location by entering the address of the new location and entering a single option selection.

7. The complex order processing system of claim 6, wherein the Move Process is configured to:

identify a move-out address;

identify a move-in address;

retrieve the complex assets for the move-out address;

generate a move-in quote;

add account information from the complex asset for the move-out address to the move-in quote;

generate two quote line items for each quote line item in the move-out quote, wherein one quote line item has an action code of Delete and is associated with the move-out address, and the other quote line item has an action code of Add and is associated with the move-in address;

specify a completed date for the move-out quote; and

assign a service point to each quote line item to be connected in the move-in quote.

8. The order processing system of claim 1, further comprising:

a computer-readable medium, wherein

the business service methods are embodied as instructions on the computer-readable medium,

the user interface instructions are embodied as instructions on the computer-readable medium, and

a plurality of workflow processes embodied as instructions on the computer-readable medium.

9. The complex order processing system of claim 8, wherein the workflow processes include at least one of:

a New Products and Services Process to create a quote;

a Modify Products and Services Process to modify a complex asset in a quote;

a Disconnect Products and Services Process to disconnect a complex asset;

a Profile Process to retrieve account information that corresponds to a quote;

an Edit Quotes Line Items Process to apply all active and unprocessed orders to a complex asset to generate the future state of the complex asset, and allow the user to make changes to the configuration of the complex asset and update a quote;

a Supplemental Orders Process to create a new order by allowing the user to revise a pending order;

an Edit Order Line Items Process to apply all active and unprocessed orders to a complex asset to generate the future state of the complex asset, allow the user to make changes to the configuration of the complex asset, and update an order;

a Quote to Order Process to convert a quote to a sales order;

an Update Opportunity Process to create revenue items for all quote line items;

a Submit Order Process to associate account information with each line item in an order and set the status of the order to “

open”

;

an Ungroup Quotes Process to create multiple copies of line items in a quote that have quantities greater than one;

an Apply Completed Sales Order Line Item To Service Profile Process to update an asset table for a complex asset that has been provisioned; and

a Move Process to transfer a customer'"'"'s complex asset configuration from an old location to a new location by entering the address of the new location and entering a single option selection.

10. The complex order processing system of claim 9, wherein the Move Process is configured to:

identify a move-out address;

identify a move-in address;

retrieve the complex assets for the move-out address;

generate a move-in quote with line items from the complex assets for the move-out address;

add account information from the complex asset for the move-out address to the move-in quote;

generate two quote line items for each quote line item in the move-out quote, wherein one quote line item has an action code of Delete and is associated with the move-out address, and the other quote line item has an action code of Add and is associated with the move-in address;

specify a completed date for the move-out quote;

assign a service point to each quote line item to be connected in the move-in quote; and

specify a connect date for the move-in quote.