Integration of applications with a financial close management system

• US 8,682,752 B2
• Filed: 10/27/2010
• Issued: 03/25/2014
• Est. Priority Date: 10/27/2010
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Bhatia, Rajesh, Clark, John Jr., Kumar, Shailesh, Liu, Fang, Battaglia, David, Ayyadevara, Bhanu Prakash, Meyerle, John
• Primary Examiner(s): ADE, OGER GARCIA
• Application Number:
  US12/912,835
• Publication Number:
  US 20120109790A1
• Time in Patent Office: 1,245 Days
• Field of Search: 705/30
• US Class Current: 705/30
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A computer-readable medium, computer-implemented method, and financial close management system are provided that includes a integration framework that allows an end user to leverage services or interfaces from external applications as part of a business process, such as a financial close process, of a financial close management system. The integration framework can integrate a task that requires the user to interact with a user interface of an external application (identified as an “end user task”) with the financial close management system. The integration framework can also integrate a task that runs without any user interaction required, and that interacts with a web service of an external application (identified as a “system automated task”) with the financial close management system.

Claims

1. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to integrate a financial close management system with an external application, the integrating comprising:

creating an integration type in the financial close management system, wherein the integration type comprises a reusable definition that describes an action involving a service or user interface of the external application, and wherein the integration type further comprises a set of parameters that are used to call the service or user interface of the external application;

creating a task type based on the integration type in the financial close management system, wherein the task type defines a type of task that can be performed by the financial close management system, and wherein the task type inherits the set of parameters that are used to call the service or user interface of the external application from the integration type;

creating a task that is based on the task type in the financial close management system, wherein the task is a component of a financial close process, and wherein the task inherits one or more attributes or one or more parameters from the task type; and

executing the task in the financial close management system, wherein the task interfaces with the external application by calling the service or user interface of the external application using the integration type.

2. The non-transitory computer-readable medium of claim 1,

wherein the integration type is an end user task integration type;

and

wherein the task interfaces with the external application by interacting with a user interface of the external application using a uniform resource locator provided by the end user task integration type.

3. The non-transitory computer-readable medium of claim 1,

wherein the integration type is an automated task integration type;

and

wherein the task interfaces with the external application by asynchronously calling a web service of the external application using a name of the web service provided by the automated task integration type.

4. The non-transitory computer-readable medium of claim 1, wherein the external application is a software application that is external from the financial close management system.

5. The non-transitory computer-readable medium of claim 1, wherein the integration type comprises at least one of the following attributes:

execution type, task parameters, execution detail, response detail, name, description unique code identifier, or external application.

6. The non-transitory computer-readable medium of claim 1, wherein the task type provides one or more default values for the set of parameters defined by the integration type.

7. The non-transitory computer-readable medium of claim 1, the integrating further comprising:

creating an artifact at the external application; and

returning a link to the artifact to the task.

8. The non-transitory computer-readable medium of claim 1, wherein each parameter of the set of parameters defined by the integration type has at least one of the following attributes:

parameter name, parameter code, required flag, parameter order, tooltip, or parameter dependencies.

9. The non-transitory computer-readable medium of claim 1, wherein the parameter is of one of the following parameter types:

text, number, date, checkbox, static list, dynamic list, options group, document navigator, or dimension selector.

10. The non-transitory computer-readable medium of claim 1, the integrating further comprising handling security for the task to prevent unauthorized users from accessing the external application.

11. The non-transitory computer-readable medium of claim 1, the integrating further comprising creating the integration type by utilizing a user interface of the financial close management system to define the integration type.

12. The non-transitory computer-readable medium of claim 1, the integrating further comprising creating the integration type by creating an integration extensible markup language document and loading the integration extensible markup language document into the financial close management system.

13. A computer-implemented method for integrating a financial close management system with an external application, comprising:

creating, by a processor, an integration type in the financial close management system, wherein the integration type comprises a reusable definition that describes an action involving a service or user interface of the external application, and wherein the integration type further comprises a set of parameters that are used to call the service or user interface of the external application;

creating, by the processor, a task type based on the integration type in the financial close management system, wherein the task type defines a type of task that can be performed by the financial close management system, and wherein the task type inherits the set of parameters that are used to call the service or user interface of the external application from the integration type;

creating, by the processor, a task that is based on the task type in the financial close management system, wherein the task is a component of a financial close process, and wherein the task inherits one or more attributes or one or more parameters from the task type; and

executing, by the processor, the task in the financial close management system, wherein the task interfaces with the external application by calling the service or user interface of the external application using the integration type.

14. The computer-implemented method of claim 13,

wherein the integration type is an end user task integration type;

and

wherein the task interfaces with the external application by interacting with a user interface of the external application using a uniform resource locator provided by the end user task integration type.

15. The computer-implemented method of claim 13,

wherein the integration type is an automated task integration type;

and

wherein the task interfaces with the external application by asynchronously calling a web service of the external application using a name of the web service provided by the automated task integration type.

16. The computer-implemented method of claim 13, further comprising:

creating an artifact at the external application; and

returning a link to the artifact to the task.

17. A financial close management system, comprising:

a memory configured to store instructions; and

a processor configured to execute the instructions stored on the memory;

wherein the processor is further configured, when executing the instructions stored on the memory, to;

create an integration type, wherein the integration type comprises an action involving a service or user interface of the external application, and wherein the integration type further comprises a set of parameters that are used to call the service or user interface of an external application;

create a task type based on the integration type, wherein the task type comprises a type of task that can be performed by the financial close management system, and wherein the task type inherits the set of parameters that are used to call the service or user interface of the external application from the integration type;

create a task that is based on the task type, wherein the task is a component of a financial close process, and wherein the task inherits one or more attributes or one or more parameters from the task type; and

execute the task, wherein the task interfaces with the external application by calling the service or user interface of the external application using the integration type.

18. The financial close management system of claim 17,

wherein the integration type is an end user task integration type;

and

wherein the task interfaces with the external application by interacting with a user interface of the external application using a uniform resource locator provided by the end user task integration type.

19. The financial close management system of claim 17,

wherein the integration type is an automated task integration type;

and

wherein the task interfaces with the external application by asynchronously calling a web service of the external application using a name of the web service provided by the automated task integration type.

20. The financial close management system of claim 17, wherein the processor is further configured, when executing the instructions stored on the memory, to:

create an artifact at the external application; and

return a link to the artifact to the task.