Bulk order management

• US 9,466,080 B2
• Filed: 02/19/2008
• Issued: 10/11/2016
• Est. Priority Date: 02/19/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Hazarika, Deepak, Fan, David Yee Man, Abichandani, Arun, Tao, Wen Xing, Ramachandran, Prasanna, Si, Wei
• Primary Examiner(s): LIN, SHEW FEN
• Application Number:
  US12/033,176
• Publication Number:
  US 20090210268A1
• Time in Patent Office: 3,157 Days
• Field of Search: 705/26.8, 705/30, 707687-704
• US Class Current: 1/1
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0603 Catalogue ordering
• CPC Class Codes: G06Q 30/0609 Buyer or seller confidence or verification
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A method includes creating a bulk order. The bulk order includes a plurality of action sets. Each action set represents a set of changes to a plurality of assets, and the bulk order represents, for a plurality of accounts, a plurality of services and assets. The method also includes validating the bulk order. The validating includes verifying a validity of a user name, which includes a validity of an association between the user name and the account and a validity of an association between the user name and the service. The validating also includes verifying the action set obeys a constraint of the product. The method also includes submitting the bulk order for execution of the set of changes. The submitting includes preparing the action set, executing the set of changes and changing a status of the bulk orders header to indicate a completion of the bulk order.

Claims

1. A method comprising:

creating a bulk order embodied in a bulk order data structure, the bulk order data structure comprising

a bulk orders header and

a plurality of action sets, wherein

the bulk orders header comprises a plurality of status fields,

each of the plurality of status fields is associated with a respective one of the plurality of action sets,

each of the plurality of action sets identify a set of changes to be made to one or more data records, and

the one or more data records are associated with a plurality of assets associated with a plurality of customer accounts;

executing said bulk order, wherein said executing comprises;

validating a first subset of the plurality of action sets, wherein the validating comprises, for each action set of the first subset of the plurality of action sets, verifying a validity of an association between a user name of the action set and an account of the action set, an association between the user name of the action set and a service of the action set, and a parent-child association specified in the action set,

in response to the validating the first subset of the plurality of action sets, applying the set of changes identified by the first subset of the plurality of action sets to said plurality of data records, resulting in changes to a first plurality of assets and a first plurality of customer accounts, and updating the plurality of status fields to indicate completion for each action set of the first subset of the plurality of action sets,

determining one or more exceptions for a second subset of the plurality of action sets,

in response to the determining one or more exceptions for the second subset of the plurality of actions sets, updating the plurality of status fields to indicate an exception for each action set of the second subset of the plurality of action sets,

updating the bulk orders header with one or more textual explanations identifying each exception for the second subset of the plurality of action sets,

presenting the one or more textual explanations identifying each exception for the second subset of the plurality of action sets, and

receiving one or more adjusted fields for the second subset of the plurality of action sets; and

re-executing said bulk order, wherein said re-executing comprises applying the one or more changes identified by the second subset of the plurality of action sets without re-applying the one or more changes identified by the first subset of the plurality of action sets.

2. The method of claim 1, wherein:

each of said plurality of assets is linked to a plurality of services;

each of said plurality of services is supplied to said plurality of customer accounts;

each of said plurality of customer accounts is embodied by said plurality of data records; and

said plurality of data records span a plurality of database tables.

3. The method of claim 1, further comprising:

determining whether a first action set from among said plurality of action sets requires validation.

4. The method of claim 1, further comprising:

verifying validity of a product, wherein

said validity of said product comprises validity of a specified component of said product, and

a first action set of the plurality of action sets comprises said product;

setting a field from among a plurality of fields to a valid value for said field; and

verifying that an action of said first action set obeys a constraint of said product.

5. The method of claim 1, wherein said method further comprises:

sending to a user a notification of completion of said bulk order.

6. The method of claim 1, further comprising:

submitting said bulk order through a graphical user interface for asynchronous execution of said plurality of action sets.

7. The method of claim 1, wherein the executing further comprises determining a status of an action set, wherein

the executing is performed if the status is configured to process the execution of the bulk order, and

the executing is not performed if the status is configured to cancel the execution of the bulk order.

8. The method of claim 1, wherein the presenting the one or more textual explanations and the receiving one or more adjusted fields are performed via an applet.

9. A system comprising:

at least one processor, and

a memory storing instructions that, when executed by the at least one processor, cause the system to perform a method comprising;

creating a bulk order embodied in a bulk order data structure, the bulk order data structure comprising

a bulk orders header and

a plurality of action sets, wherein

the bulk order header comprises a plurality of status fields,

each of the plurality of status fields is associated with a respective one of the plurality of action sets,

each of the plurality of action sets identify a set of changes to be made to one or more data records, and

the one or more data records are associated with a plurality of assets associated with a plurality of customer accounts;

executing said bulk order, wherein said executing comprises;

validating a first subset of the plurality of action sets, wherein the validating comprises, for each action set of the first subset of the plurality of action sets, verifying a validity of an association between a user name of the action set and an account of the action set, an association between the user name of the action set and a service of the action set, and a parent-child association specified in the action set,

in response to the validating the first subset of the plurality of action sets, applying the set of changes identified by the first subset of the plurality of action sets to said plurality of data records, resulting in changes to a first plurality of assets and a first plurality of customer accounts, and updating the plurality of status fields to indicate completion for each action set of the first subset of the plurality of action sets,

determining one or more exceptions for a second subset of the plurality of action sets,

in response to the determining one or more exceptions for the second subset of the plurality of actions sets, updating the plurality of status fields to indicate an exception for each action set of the second subset of the plurality of action sets,

updating the bulk orders header with one or more textual explanations identifying each exception for the second subset of the plurality of action sets,

presenting the one or more textual explanations identifying each exception for the second subset of the plurality of action sets, and

receiving one or more adjusted fields for the second subset of the plurality of action sets; and

re-executing said bulk order, wherein said re-executing comprises applying the one or more changes identified by the second subset of the plurality of action sets without re-applying the one or more changes identified by the first subset of the plurality of action sets.

10. The system of claim 9, wherein:

each of said plurality of assets is linked to a plurality of services;

each of said plurality of services is supplied to said plurality of customer accounts;

each of said plurality of customer accounts is embodied by said plurality of data records; and

said plurality of data records span a plurality of database tables.

11. The system of claim 9, wherein the method further comprises:

determining whether a first action set from among said plurality of action sets requires validation.

12. The system of claim 9, wherein the method further comprises:

verifying validity of a product, wherein

said validity of said product comprises validity of a specified component of said product, and

a first action set of the plurality of said action sets comprises said product;

setting a field from among a plurality of fields to a valid value for said field; and

verifying that an action of said first action set obeys a constraint of said product.

13. The system of claim 12, wherein the method further comprises

sending to a user a notification of completion of said bulk order.

14. The system of claim 9, wherein the method further comprises:

submitting said bulk order through a graphical user interface for asynchronous execution of said plurality of action sets.

15. A computer program product, comprising:

a non-transitory computer-readable storage medium;

instructions stored on the non-transitory computer-readable storage medium for creating a bulk order, wherein

said bulk order is embodied in a bulk order data structure,

said bulk order data structure comprises

a bulk orders header and

a plurality of action sets, wherein

the bulk orders header comprises a plurality of status fields,

each of the plurality of status fields is associated with a respective one of the plurality of action sets,

each of the plurality of action sets identify a set of changes to be made to one or more data records, and

the one or more data records are associated with a plurality of assets associated with a plurality of customer accounts;

instructions stored on the non-transitory computer-readable storage medium for executing said bulk order, wherein said instructions for executing comprises

instructions for validating a first subset of the plurality of action sets, wherein the validating comprises, for each action set of the first subset of the plurality of action sets, verifying a validity of an association between a user name of the action set and an account of the action set, an association between the user name of the action set and a service of the action set, and a parent-child association specified in the action set,

instructions for, in response to the validating the first subset of the plurality of action sets, applying the set of changes identified by the first subset of the plurality of action sets to said plurality of data records, resulting in changes to a first plurality of assets and a first plurality of customer accounts, and updating the plurality of status fields to indicate completion for each action set of the first subset of the plurality of action sets,

instructions for determining one or more exceptions for a second subset of the plurality of action sets,

instructions for, in response to the determining one or more exceptions for the second subset of the plurality of action sets, updating the plurality of status fields to indicate an exception for each action set of the second subset of the plurality of action sets,

instructions for updating the bulk orders header with one or more textual explanations identifying each exception for the second subset of the plurality of action sets,

instructions for presenting the one or more textual explanations identifying each exception for the second subset of the plurality of action sets, and

instructions for receiving one or more adjusted fields for the second subset of the plurality of action sets; and

instructions stored on the non-transitory computer-readable storage medium for re-executing the bulk order, wherein said instructions for re-executing comprise

instructions for applying the one or more changes identified by the second subset of the plurality of action sets without re-applying the one or more changes identified by the first subset of the plurality of action sets.

16. The computer program product of claim 15, wherein:

each of said plurality of assets is linked to a plurality of services;

each of said plurality of services is supplied to said plurality of customer accounts;

each of said plurality of customer accounts is embodied by said plurality of data records, and

said plurality of data records span a plurality of database tables.

17. The computer program product of claim 15, further comprising:

instructions stored on the non-transitory computer-readable storage medium for determining whether a first action set from among said plurality of action sets requires validation.

18. The computer program product of claim 15, further comprising:

instructions stored on the non-transitory computer-readable storage medium for verifying validity of a product, wherein

said validity of said product comprises validity of a specified component of said product, and

a first action set of the plurality of action sets comprises said product;

instructions stored on the non-transitory computer-readable storage medium for setting a field from among a plurality of fields to a valid value for said field; and

instructions stored on the non-transitory computer-readable storage medium for verifying that an action of said first action set obeys a constraint of said product.

19. The computer program product of claim 18, wherein said computer program product in a computer-readable storage medium further comprises:

instructions stored on the non-transitory computer-readable storage medium for sending to a user a notification of completion of said bulk order.