Automatic reconciliation of discrepancies in asset attribute values

• US 8,671,122 B2
• Filed: 01/09/2012
• Issued: 03/11/2014
• 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:
  US13/346,143
• Publication Number:
  US 20120117039A1
• Time in Patent Office: 792 Days
• Field of Search: 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 first asset information comprising a first attribute, wherein the first asset information is obtained using a first technique;

storing second asset information comprising a second attribute corresponding to the first attribute, wherein the second asset information is obtained using a second technique different from the first technique;

receiving a first input on a first option displayed on a computer screen;

wherein the first option is to enable or disable automatic execution of a first action when a first rule is satisfied;

wherein a second option is to turn on or off automatic reconciliation of discrepancies;

in response to the automatic reconciliation being turned on by enabling the second option, using at least one computer processor to compare a first attribute value in the first asset information with a second attribute value in the second asset information to check if the first rule is satisfied;

wherein the first action is to change the second attribute value in the second asset information, in response to finding an exception based on the comparison at least on determining that the method is configured with the first option enabled and the second option enabled; and

wherein the exception occurs when the first attribute value in the first asset information does not match the second attribute value in the second asset information at least on determining that the method is configured with the first option disabled and the second option enabled.

2. The method of claim 1 wherein:

the change by the first action comprises deletion of the second attribute value from the second asset information.

3. The method of claim 1 further comprising:

logging all actions automatically executed on the second asset information.

4. The method of claim 1 wherein:

when automatic execution is enabled for the first action by the first input, execution of the first action is automatic without requiring user authorization when the first rule is satisfied.

5. The method of claim 1 wherein:

when the second attribute value is compared to the first attribute value prior to performing the first action, the second attribute value in the second repository does not match the first attribute value; and

after performing the first action, an altered second attribute value in the second repository matches the first attribute value.

6. The method of claim 1 wherein:

the first asset information is compiled through automatic discovery.

7. The method of claim 6 wherein:

the second asset information is comprised in a financial system.

8. The method of claim 1 further comprising:

when the first action is enabled by the first input, using the at least one computer processor to check if a restriction is satisfied;

when the restriction is not satisfied and the first rule is satisfied, performing the first action; and

when the restriction is satisfied and the first rule is satisfied, not performing the first action.

9. The method of claim 8 wherein:

the restriction is satisfied when an IP address of a device in the first asset information is within a range of IP addresses.

10. The method of claim 1 wherein:

when the automatic reconciliation is turned off by the second option, the exception on being determined, is provided as output.

11. A non-transitory computer-readable storage medium comprising instructions to one or more processors to:

store first asset information comprising a first attribute, wherein the first asset information is obtained using a first technique;

store second asset information comprising a second attribute corresponding to the first attribute, wherein the second asset information is obtained using a second technique different from the first technique;

receive a first input on a first option displayed on a computer screen;

wherein the first option is to enable or disable automatic execution of a first action when a first rule is satisfied;

wherein a second option is to turn on or off automatic reconciliation of discrepancies;

respond to the automatic reconciliation being turned on by enabling the second option, by comparing a first attribute value in the first asset information with a second attribute value in the second asset information to check if the first rule is satisfied;

wherein the first action is to change the second attribute value in the second asset information, in response to finding an exception based on the comparison at least on determining that the one or more processors are configured with the first option enabled and the second option enabled; and

wherein the exception occurs when the first attribute value in the first asset information does not match the second attribute value in the second asset information at least on determining that the one or more processors are configured with the first option disabled and the second option enabled.

12. The non-transitory computer-readable storage medium of claim 11 wherein:

the change by the first action comprises deletion of the second attribute value from the second asset information.

13. The non-transitory computer-readable storage medium of claim 11 further comprising instructions to:

log all actions automatically executed on the second asset information.

14. The non-transitory computer-readable storage medium of claim 11 further comprising:

responsive to automatic execution being enabled for the first action by the first input, instructions to execute the first action automatically without requiring user authorization when the first rule is satisfied.

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

when the second attribute value is compared to the first attribute value prior to performing the first action, the second attribute value in the second repository does not match the first attribute value; and

after performance of the first action, an altered second attribute value in the second repository matches the first attribute value.

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

the first asset information is compiled through automatic discovery.

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

the second asset information is comprised in a financial system.

18. The non-transitory computer-readable storage medium of claim 11 further comprising:

responsive to the first action being enabled by the first input, instructions to use the at least one computer processor to check if a restriction is satisfied; and

responsive to the restriction being not satisfied and the first rule being satisfied, instructions to perform the first action.

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

the restriction is satisfied when an IP address of a device in the first asset information is within a range of IP addresses.

20. The non-transitory computer-readable storage medium of claim 11 further comprising:

responsive to the automatic reconciliation being turned off by the second option, and the exception being determined, instructions to provide at least the exception as output.

21. One or more computers comprising:

at least one processor and a memory;

wherein the memory comprises;

instructions to store first asset information comprising a first attribute, wherein the first asset information is obtained using a first technique;

instructions to store second asset information comprising a second attribute corresponding to the first attribute, wherein the second asset information is obtained using a second technique different from the first technique;

instructions to receive a first input on a first option displayed on a computer screen;

wherein the first option is to enable or disable automatic execution of a first action when a first rule is satisfied;

wherein a second option is to turn on or off automatic reconciliation of discrepancies;

responsive to the automatic reconciliation being turned on by enabling the second option, instructions to compare a first attribute value in the first asset information with a second attribute value in the second asset information to check if the first rule is satisfied;

wherein the first action is to change the second attribute value in the second asset information, in response to finding an exception based on the comparison at least on determining that the one or more computers are configured with the first option enabled and the second option enabled; and

wherein the exception occurs when the first attribute value in the first asset information does not match the second attribute value in the second asset information at least on determining that the one or more processors are configured with the first option disabled and the second option enabled.