One embodiment is directed to a computer system, and more particularly, to a computer system that orchestrates supply chain financial processes.
Large multi-national companies, or other enterprises, often operate through a number of subsidiary companies, or other legal entities, spread across the globe. These subsidiary companies can be further divided into business units or lines of businesses. The intersection of each subsidiary company and line of business (identified as a “profit center business unit”) can become a supply chain entity that engages in manufacturing, purchase, and/or sale of goods and services.
The profit center business units typically engage commercially with an external supply chain, such as a collection of suppliers and customers. They can also engage in internal trades, or internal transfers, within the subsidiary company. One example type of an internal trade is an “inter-company trade,” where a profit center business unit belonging to one subsidiary company trades with a profit center business unit belonging to another subsidiary company, at arm's length terms and conditions. Another example type of an internal trade is an “intra-company trade,” where two profit center business units belonging to the same subsidiary company trade among each other on a competitive basis. Such internal trades can trigger internal transactions pre-defined as part of internal trade relationship. Further, such internal trades can trigger one or more tasks to be executed. Such tasks may require that messages be sent to target external systems, in order for the tasks to be executed at the target external systems. Such target external systems can each have different task payload formats.
One embodiment is a system that communicates tasks. The system generates a task including task payload data, where the task payload data is in a task payload format. The system further transforms the task payload data from the task payload format to a universal format. The system further sends the task payload data and a system parameter to an external interface layer, where the task payload data is sent in the universal format, and where the system parameter identifies an external target system. The system further identifies an external target system and connector service based on the system parameter. The system further sends the task payload data to the connector service, where the task payload data is sent in the universal format.
Further embodiments, details, advantages, and modifications will become apparent from the following detailed description of the preferred embodiments, which is to be taken in conjunction with the accompanying drawings.
According to an embodiment, a supply chain financial orchestration system is provided that can communicate different types of payload data for different supply chain tasks (such as purchase order tasks, sales order tasks, payable tasks, or receivable tasks) with different external target systems using a universal format, where the different types of task payload data can have different formats, and where the different external target systems can also have different formats. The supply chain financial orchestration system can further handle modifications to the task payload data (such as modifications to a task payload data structure or the integration of new tasks) without requiring modifications to the universal format. As understood by one of ordinary skill in the art, payload data is data contained within a data communication, where an example of a data communication is a message.
A computer-readable medium may be any available medium that can be accessed by processor 22. A computer-readable medium may include both a volatile and nonvolatile medium, a removable and non-removable medium, a communication medium, and a storage medium. A communication medium may include computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any other form of information delivery medium known in the art. A storage medium may include RAM, flash memory, ROM, erasable programmable read-only memory (“EPROM”), electrically erasable programmable read-only memory (“EEPROM”), registers, hard disk, a removable disk, a compact disk read-only memory (“CD-ROM”), or any other form of storage medium known in the art.
Processor 22 can also be operatively coupled via bus 12 to a display 24, such as a Liquid Crystal Display (“LCD”). Display 24 can display information to the user. A keyboard 26 and a cursor control device 28, such as a computer mouse, can also be operatively coupled to bus 12 to enable the user to interface with supply chain financial orchestration system 10.
According to one embodiment, memory 14 can store software modules that may provide functionality when executed by processor 22. The modules can include an operating system 15, a supply chain financial orchestration task communication module 16, as well as other functional modules 18. Operating system 15 can provide an operating system functionality for supply chain financial orchestration system 10. Supply chain financial orchestration task communication module 16 can provide functionality for communicating tasks, as is described in more detail below. In certain embodiments, supply chain financial orchestration task communication module 16 can comprise a plurality of modules that each provide specific individual functionality for communicating tasks. Supply chain financial orchestration system 10 can also be part of a larger system. Thus, supply chain financial orchestration system 10 can include one or more additional functional modules 18 to include the additional functionality. For example, functional modules 18 may include modules that provide additional functionality, such as an “Oracle Fusion Applications” product from Oracle Corporation. In another example, functional modules 18 may include enterprise resource planning (“ERP”) modules of an ERP system, where an ERP system is a computer system that integrates several data sources and processes of an organization into a unified system.
Processor 22 can also be operatively coupled via bus 12 to a database 34. Database 34 can store data in an integrated collection of logically-related records or files. Database 34 can be an operational database, an analytical database, a data warehouse, a distributed database, an end-user database, an external database, a navigational database, an in-memory database, a document-oriented database, a real-time database, a relational database, an object-oriented database, or any other database known in the art.
According to the illustrated embodiment, supply chain financial orchestration system 300 includes event mediator 301, event capture 302, event manager 303, orchestration service 304, execution manager 305, task layer service 306, external interface layer service 307, connector service 308, and callback service 309. Event mediator 301 listens for events generated by an external source system (i.e., application) of external source systems (i.e., applications) 310. If an event is of interest to supply chain financial orchestration system 300, event mediator 301 can also call a web service exposed by the external source system of external source systems 310 to enrich the event details. Event mediator 301 then sends the event to event capture 302. Event capture 302 validates the event details retrieved after enrichment, and stores the event in an external source system format.
Subsequently, event manager 303 identifies a source document enrichment web service based on a source order type, and calls the source document enrichment web service for enrichment. The source document enrichment service is exposed by an external source system of external source systems 310 where the source order originated. Event manager 303 can pass a source document identifier as an input parameter to the enrichment web service and can retrieve the source document information, where a source document identifier is a unique identifier of the source document that is communicated to the external source system of external source systems 310. The external source system of external source systems 310 that is responsible for capturing the physical transaction can be responsible for passing the source document identifier as part of event information. Supply chain financial orchestration system 300 can maintain an association between a supply chain event and a source document type. Event manager 303 can further transform the source document information into a format that is understandable by supply chain financial orchestration system 300, and can identify a supply chain financial orchestration flow based on qualifiers, source document type, physical route, parties involved in an internal trade, and a priority of the supply chain financial orchestration flow. Further, a supply chain financial orchestration flow can be date effective. This means that any modification to a supply chain financial orchestration flow can cause a new effective date to be associated with the supply chain financial orchestration flow. Thus, transactions pertaining to a source document created before the effective date of the modification can be associated with the original supply chain financial orchestration flow, and transactions pertaining to a source document created after the effective date of the modification can be associated with the modified supply chain financial orchestration flow.
Orchestration service 304 verifies whether a supply chain financial orchestration flow is already assigned to a source document or not. If the supply chain financial orchestration flow is not already assigned, orchestration service 304 can assign the supply chain financial orchestration flow to the source document, and can generate the tasks that are to be performed between internal entities based on the documentation and accounting rules setup for the supply chain financial orchestration flow (such as a global procurement flow, a customer shipment flow, and an internal transfer flow). A global procurement flow is a supply chain financial orchestration flow where a central buying entity buys goods from suppliers on behalf of one or more internal entities. The supplier liability is borne by the purchasing entity. The purchasing and requesting entity settle the transaction among themselves using a transfer price (sometimes through one or more intermediary entities). A customer shipment flow is a supply chain financial orchestration flow in which a selling business unit is different from a profit center business unit of the entity that owns and ships the goods. The selling entity receives an order from a customer, and the shipping entity ships the goods directly to the customer. The shipping entity is settled financially by the selling entity (sometimes through one or more intermediary entities). A customer shipment flow can be an internal drop shipment flow, which is a forward customer shipment flow, or a customer drop shipment flow, or a return customer shipment flow. An internal transfer flow is a supply chain financial orchestration flow in which physical movement of goods happens between internal entities. The internal entities settle the financial transactions among themselves using a transfer price.
The tasks that are to be performed can be specific to a forward flow and a return flow for the supply chain financial orchestration flow. A forward flow is a flow of events that proceeds in a specific direction (such as from a supplier entity to a purchaser entity), and a return flow is a flow of events that proceeds in a reverse direction (such as from a purchaser entity to a supplier entity). In addition to ownership transfer between internal entities, events indicating ownership transfer from a supplier entity to a purchasing entity can also be setup in a supply chain financial orchestration flow definition. When an event designated as a supplier ownership change event occurs, orchestration service 304 can generate the tasks for creating trade distributions to book supplier accrual and costs in a costing system, as well. Execution manager 305 invokes a task layer service based on a task type. Generally, the tasks are performed in a defined sequence, and if there is any dependency from a previous task, execution manager 305 can wait for the previous task to complete. Example task types can include inter-company trade documents (e.g., purchase order and sales order), trade distribution tasks related to costing, inter-company receivable invoices related to inter-company receivable, payables invoice, or credit memo tasks that are set in documentation and accounting rules. Task types can also include user-defined tasks.
Task layer service 306 creates a task layer service payload. Task layer service 306 can include logic to populate the payload data depending on a global procurement flow, a customer shipment flow, or an internal transfer flow. Task layer service 306 can also call a transfer price service to get a transfer price, where the transfer price is a price in which a selling entity sells goods to a purchasing entity, where the selling entity and the purchasing entity are involved in an internal trade. External interface layer service 307 identifies a target system (i.e., application) of target systems (i.e., applications) 320, and obtains a connector service (e.g., connector service 308) for the target system of target systems 320 based on the task type. Connector service 308 transforms the task layer service payload into a format which is understandable by the target system of target systems 320. Once the task data is transformed according to a target system format, connector service 308 calls a web service to interface tasks in interface tables of the target system of target systems 320. Callback service 309 receives responses from the target system of target systems 320 and updates the task status. If the task is a last task in a sequence, then the supply chain financial orchestration is complete. Otherwise, the next task in the sequence is selected, and execution manager 305 is invoked with the task type.
Supply chain financial orchestration system 300 further includes a supply chain financial orchestration work area 330 that includes a plurality of user interfaces that allow a user to interact with supply chain financial orchestration system 300. Supply chain financial orchestration work area 330 includes manage event exceptions 331, confirm financial orchestration route assignments 332, and monitor financial orchestration execution 333. Manage event exceptions 331 is a user interface that allows users to view, troubleshoot, and manage events which faulted due to a setup or technical reason. Confirm financial orchestration route assignments 332 is a user interface that allows a user to confirm a supply chain financial orchestration flow before the tasks of the supply chain financial orchestration flow are initiated by orchestration service 304. Monitor financial orchestration execution 333 is a user interface that allows user to monitor supply chain financial orchestration flows that are in progress, that have not started, and that have completed.
In one example, two tasks, an accounts payable (“AP”) task and an accounts receivable (“AR”) task are interfaced to an appropriate external target system. A task payload format of the AP task can be as follows:
Further, a task payload format of the AR task can be as follows:
As illustrated in
As illustrated in
The EIL can refer to a setup table which contains a mapping between a target uniform resource locator (“URL”) and one or more system parameters. The EIL, based on the input system parameters, can identify an external target system and target URL from the setup table. An example setup table is shown below:
Once an external target system is identified, the payload data can be routed to an appropriate connector service after transformation. The EIL can remain immune to business data and can focus on routing the payload data to a specific connector service. Any transformation of the payload data can be implemented by the appropriate connector service which interfaces with the external target system.
Since the EIL integrates with different task layer services, any payload modifications to a task layer service can affect the EIL payload format and also the corresponding connector service. Consider the following sample scenario: (1) a new parameter ‘D’ of type “String” is introduced to an AP task layer service; and (2) a new task layer service (i.e., a purchase order (“PO”) task layer service) is added. As described below in conjunction with
AP task layer service 610 is different from AP task layer service 410 of
The block diagram in
The block diagram in
The block diagram illustrated in
As previously described, most of the modifications described in conjunction with
In accordance with certain embodiments of the invention, a supply chain financial orchestration system is provided that includes the following features: (1) usage of a universal format in communication between a task layer service and an EIL; (2) usage of a universal format in communication between the EIL and a connector service; and (3) usage of a setup-based transformation that leverages an extensible stylesheet language transformation (“XSLT”) in a connector service for transforming data from the universal format to an external target system format. As is described below in greater detail, the supply chain financial orchestration can utilize the universal format to minimize changes in an EIL and connector service of a supply chain financial orchestration system, and to protect the EIL of a supply chain financial orchestration system from such changes.
According to certain embodiments, a universal format is a data format that does not contain any restriction or constraints on the data content, and thus, is compatible with any task payload format, as well as any external target system format. Thus, task payload data of any task payload format can be transformed from the task payload format to the universal format. Further, data that is stored using the universal format can be transformed from the universal format to any external target system format.
An example of a universal format is an “anyType” data type. An anyType data type is one of the data types used in an extensible markup language (“XML”), and is the root of all XML schema types. An anyType data type can contain any XML type data, such as primitive data types, complex data types, or user-defined data types. An anyType data type has no restrictions or constraints on the data content. Another example of a universal format is a “java.lang.Object” data type in a JAVA® programming language.
According to an embodiment, a task layer service can generate task payload data using a task payload format, and transform the task payload data from the task payload format to the anyType data type. The task layer service can subsequently send the transformed task payload data to an EIL. The task layer service can further send one or more parameters used to identify an external target system. By using an anyType data type as an input data type for EIL, the EIL can be protected from any modifications to a task payload format of a task layer service. No matter what the modification to the task payload format, the task layer service can transform the task payload data to the anyType data type, and send the task payload data to the EIL, without requiring any changes to the EIL. Further, an addition of a new task layer service can also be accomplished without requiring any changes to the EIL, because the new task layer service can also transform task payload data to the anyType data type, and send the task payload data to the EIL.
According to the embodiment, similar to the scenario illustrated in
The block diagram in
According to the embodiment, in addition to anyType data type 740, AP task layer service 710, AR task layer service 715, and PO task layer service 720 can each send one or more system parameters that identify an external target system. An example setup table that includes system parameters for an AP task type, an AR task type, and a PO task type is shown below:
Thus, according to the embodiment, for the task payload data of AP task layer service 710, EIL 745 uses the system parameter “S1” that is sent by AP task layer service 710 to determine an external target system and a target URL. Once the external target system is identified, EIL 745 sends the task payload data of AP task layer service 710 to connector service 755 using anyType data type 750. Likewise, for the task payload data of AP task layer service 715, EIL 745 uses the system parameter “S2” that is sent by AP task layer service 715 to determine an external target system and a target URL. Once the external target system is identified, EIL 745 sends the task payload data of AP task layer service 715 to connector service 755 using anyType data type 750. Similarly, for the task payload data of AP task layer service 720, EIL 745 uses the system parameter “S3” that is sent by AP task layer service 720 to determine an external target system and a target URL. Once the external target system is identified, EIL 745 sends the task payload data of AP task layer service 720 to connector service 755 using anyType data type 750.
For each task payload data, connector service 755 transforms the task payload data from the anyType data type to an external target system format that corresponds to the identified external target system. The transformation is further described in greater detail in conjunction with
To perform this transformation, connector service 820 can retrieve an XSLT file from a setup table stored within connector service 820 (not illustrated in
An example setup table that can be stored within connector service 820 is shown below:
As shown in the example setup table, connector service 820 can read a corresponding XSLT file stored within the setup table based on a task type and external target system, and can transform EIL input data from anyType data type 821 to external target system format 822.
In the embodiment illustrated in
Thus, according to an embodiment, the aforementioned modifications to one or more task layer services (e.g., an addition of parameters, or an addition of new task types) can only require modifications to the task layer services to create the modified business logic (e.g., logic to populate new parameters, or logic to build the new task layer services). The aforementioned modifications can optionally require modifications to the setup tables stored within an EIL and a connector service (e.g., to store the new URLs, or to store the new XSLT files). Other than the modifications to the task layer services, such modifications constitute setup data modifications, which generally do not require any system component or service to be modified or redeployed. Thus, the aforementioned modifications to one or more task layer services (e.g., an addition of parameters, or an addition of new task types) can be made more simply and more quickly.
The flow begins and proceeds to 910. At 910, a task is generated that includes task payload data, where the task payload data is in a task payload data format. The task can be defined for a supply chain financial orchestration flow, where the supply chain financial orchestration flow defines a trade relationship between a first entity and a second entity. The generation of the task can be performed at a task layer service. The flow then proceeds to 920.
At 920, the task payload data is transformed from the task payload format to a universal format. The universal format can be an anyType data type. The anyType data type can be compatible with any task payload format and any external target system format. The transformation of the task payload data from the task payload format to the universal format can be performed at the task layer service. The flow then proceeds to 930.
At 930, the task payload data and a system parameter are sent to an EIL. The task payload data can be sent in the universal format. Further, the system parameter can identify an external target system. The system parameter can be retrieved from a setup table based on a task type of the task. The sending of the task payload data and the system parameter can be performed at the task layer service. The flow then proceeds to 940.
At 940, a target execution system and connector service can be identified based on the system parameter. The identification of the target execution system and the connector service can be performed at an EIL. The flow then proceeds to 950.
At 950, the task payload data is sent to the connector service. The task payload data can be sent in the universal format. The sending of the task payload data can be performed at the EIL. The flow then proceeds to 960.
At 960, an XSLT file is retrieved. The XSLT file can be retrieved from a setup table based on a task type of the task and the external target system. The retrieval of the XSLT file can be performed at a connector service. The flow then proceeds to 970.
At 970, the task payload data is transformed from the universal format to an external target system format using the XSLT file. The transformation of the task payload data can be performed at the connector service. The flow then proceeds to 980.
At 980, the task payload data is sent to the external target system. The task payload data can be sent in the external target system format. The external target system can execute the task based on the task payload data that is in the external target system format. Further, in certain embodiments, the task payload format of the task can be modified where the universal format is not modified. The flow then ends.
Thus, in one embodiment, a supply chain financial orchestration system can utilize a universal format to facilitate communication of task data to external target systems. Thus, any modifications to a task payload format do not necessarily affect the supply chain financial orchestration system, as the supply chain financial orchestration system is not required to modify its universal format. Further, the supply chain financial orchestration system can utilize XSLT files to facilitate transformation of task data from the universal format to an external target system format. The creation and editing of the XSLT files can be a simple task that can be performed by a text editor. Thus, a user does not need to possess technical expertise to customize the transformations, and the actual transformation can be taken care of at run time. This can reduce the effort necessary to modify and customize the communication of task data to the external target systems.
The features, structures, or characteristics of the invention described throughout this specification may be combined in any suitable manner in one or more embodiments. For example, the usage of “one embodiment,” “some embodiments,” “certain embodiment,” “certain embodiments,” or other similar language, throughout this specification refers to the fact that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the present invention. Thus, appearances of the phrases “one embodiment,” “some embodiments,” “a certain embodiment,” “certain embodiments,” or other similar language, throughout this specification do not necessarily all refer to the same group of embodiments, and the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
One having ordinary skill in the art will readily understand that the invention as discussed above may be practiced with steps in a different order, and/or with elements in configurations which are different than those which are disclosed. Therefore, although the invention has been described based upon these preferred embodiments, it would be apparent to those of skill in the art that certain modifications, variations, and alternative constructions would be apparent, while remaining within the spirit and scope of the invention. In order to determine the metes and bounds of the invention, therefore, reference should be made to the appended claims.
This application claims priority of U.S. Provisional Patent Application Ser. No. 61/707,630, filed on Sep. 28, 2012, the subject matter of which is hereby incorporated by reference.
Number | Date | Country | |
---|---|---|---|
61707630 | Sep 2012 | US |