Automatic reconciliation of discrepancies in asset attribute values

• US 8,095,573 B2
• Filed: 07/09/2007
• Issued: 01/10/2012
• Est. Priority Date: 07/09/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Apte, Umesh Madhav, Alonzo, Jason Aron, Yee, John Leong
• Primary Examiner(s): Yen, Syling
• Application Number:
  US11/774,969
• Publication Number:
  US 20090019089A1
• Time in Patent Office: 1,646 Days
• Field of Search: 707/1, 707/688, 707/690, 707/692, 707/694, 707/701, 707/702, 707/706, 707/713, 707/736, 707/791, 707/802, 707/805, 707/999.101, 707/999.102, 707/999.103, 705/37, 709/224, 709/220, 709/227, 715/736
• US Class Current: 707/805
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 40/04 Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange

Abstract

Discrepancies in two sets of asset data for an organization are identified and automatically reconciled. One set of asset data may be compiled using automatic physical discovery software while the other set is from a financial system of the organization. Automatic reconciliation is performed according to user-configurable rules and corresponding user-configurable actions.

Claims

1. A computer-implemented method comprising:

storing into a first repository, first asset information comprising dynamic physical asset information;

storing into a second repository, second asset information comprising static financial asset information, wherein the second asset information is obtained using a technique different from a technique used to obtain the first asset information;

receiving a first rule, to determine when an exception has occurred by comparing the first asset information with the second asset information and finding on comparison that a first attribute value in the first repository does not match a corresponding second attribute value in the second repository;

displaying on a computer screen a first option to enable or disable automatic execution of a first action when the first rule is satisfied;

receiving input on said first option; and

when the first action is disabled by said input, not performing the first action;

when at least the first action is enabled by said input, automatically performing the first action for the exception, in response to finding that first rule is satisfied;

wherein the first action comprises performing an automated update to the second attribute in the second repository and not modifying the first repository, wherein a value of the update to the second attribute in the second repository is found in the first asset information;

wherein the first rule is further associated with a second action, and the second action has an associated second option to enable or disable execution of the second action when the first rule is satisfied;

wherein the method has a first configured state with the first option enabled and the second option disabled; and

wherein the method has a second configured state with the first option enabled and the second option enabled.

2. The method of claim 1 wherein:

the method has a third configured state with the first option disabled and the second option enabled, and

the method has a fourth configured state with the first option disabled and the second option disabled.

3. The method of claim 1 wherein the first asset information is created using asset discovery software, and the asset discovery software is permitted to make changes to the first repository and is not permitted to make changes to the second repository.

4. The method of claim 3 wherein the first action for updating the second asset information is not performed by the asset discovery software.

5. The method of claim 1 wherein the second action comprises deleting an attribute value from the second asset information.

6. The method of claim 1 wherein the second action comprises making a change to the second asset information which is different from the first action.

7. The method of claim 1 wherein when automatic execution is enabled for the first action by said input, execution of the action is automatic without requiring user authorization when the first rule is satisfied.

8. The method of claim 1 wherein during operation the corresponding second attribute value is compared to the first attribute value during automatic execution, and the corresponding second attribute value in the second repository does not match the first attribute value, and after the automated update an altered second attribute value in the second repository matches the first attribute value.

9. The method of claim 1 wherein performing an automated update to the second attribute value in the second repository includes modifying the second attribute value and not modifying other attribute values associated with the second asset information.

10. The method of claim 1 wherein the first action is executed automatically without requiring a user to invoke the first action.

11. The method of claim 1 wherein:

the method has another configured state with the first option disabled and the second option enabled.

12. The method of claim 1 wherein:

the method has another configured state with the first option disabled and the second option disabled.

13. A non-transitory computer-readable storage medium comprising:

instructions to one or more processors to compare first asset information with second asset information to find exceptions, wherein an exception occurs when a first rule is satisfied, the first asset information is compiled through automatic discovery, the second asset information is not compiled through automatic discovery, the first asset information is stored in a first repository, and the second asset information is stored in a second repository;

instructions to the one or more processors to display on a computer screen a first option to enable or disable automatic execution of a first action when the first rule is satisfied;

instructions to the one or more processors to receive first input on said first option;

instructions responsive to the first action being disabled by said first input to not perform the first action for the exception;

instructions responsive to the first action being enabled by said first input to perform the first action for the exception; and

instructions to modify the second asset information in the second repository based on an attribute value found in the first repository according to the first action;

wherein the first rule is further associated with a second action, and the second action has an associated second option to enable or disable execution of the second action when the first rule is satisfied;

wherein during execution of said instructions, the one or more processors have a first configured state with the first option enabled and the second option disabled; and

wherein during execution of said instructions, the one or more processors have a second configured state with the first option enabled and the second option enabled.

14. The non-transitory computer-readable storage medium of claim 13 wherein the first action does not modify the first asset information in the first repository.

15. The non-transitory computer-readable storage medium of claim 13 further comprising:

a graphical user interface to specify the first rule and the first action associated with the first rule, the graphical user interface comprising a rule sequence number field to indicate when the first rule is executed relative to other rules, wherein the rule sequence number field accepts an integer number input, the graphical user interface comprising a check-box used by said instructions to receive first input, to display a field for the first action, wherein when the check box is checked the first action to modify the second repository is enabled to be executed and when the check box is not checked the first action to modify the second repository is not enabled.

16. The non-transitory computer-readable storage medium of claim 13 wherein:

the first action is to update the attribute value associated with the second asset information with an attribute value found in the first asset information.

17. The non-transitory computer-readable storage medium of claim 13 wherein:

the first action is to delete an attribute value from the second asset information.

18. The non-transitory computer-readable storage medium of claim 13 wherein:

during execution of said instructions, the one or more processors have another configured state with the first option disabled and the second notion enabled.

19. The non-transitory computer-readable storage medium of claim 15 wherein:

during execution of said instructions, the one or more processors have another configured state with the first option disabled and the second option disabled.

20. The non-transitory computer-readable storage medium of claim 13 wherein:

during execution of said instructions, the one or more processors have a third configured state with the first option disabled and the second option enabled; and

during execution of said instructions, the one or more processors have a fourth configured state with the first option disabled and the second option disabled.