Modeling of order data

• US 8,762,415 B2
• Filed: 11/05/2003
• Issued: 06/24/2014
• Est. Priority Date: 03/25/2003
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Catahan, Nardo B. Jr., Kale, Shekhar P., Garg, Shailendra, Leon, Maria Theresa Barnes, Sundararajan, Ramaswamy
• Primary Examiner(s): HO, BINH VAN
• Application Number:
  US10/703,053
• Publication Number:
  US 20040193510A1
• Time in Patent Office: 3,884 Days
• Field of Search: 707/10, 707/1, 707/104.1, 707/793, 705/39, 705/40, 705/14, 717/108, 209/328
• US Class Current: 707/793
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

An order class is defined which includes multiple data elements that are common to various order types. The order class identifies relationships of an order with various entities related to the order.

Claims

1. A method in a computer system, the method comprising:

defining, using a processor of the computer system, a common data model, wherein

the common data model comprises a hierarchical data structure,

the hierarchical data structure is configured to represent an order class,

the hierarchical data structure comprises

a plurality of common data elements, and

a plurality of custom data elements,

the common data elements are common to a plurality of order types utilized by a plurality of applications,

each of the custom data elements is configured to define application-specific data fields for at least one application of the applications,

the order class is configured to identify a plurality of relationships of an order with a plurality of entities related to the order,

a definition of the order class is represented as an XML schema, and

the defining comprises, for each custom data element of the custom data elements,

retrieving a data definition schema for the order class, wherein

the data definition schema comprises the each custom data element, and

the each custom data element is of a custom data type,

adding the each custom data element to the order class by

retrieving a custom data schema for the custom data type,

locating a tag in the custom data schema relating to the custom data type, and

adding the custom data element to the tag;

defining an order line sub-class using the processor, wherein

the order line sub-class is derived from the order class,

the order line sub-class represents an order line within the order,

the order line sub-class comprises

a set of data elements from the order class, and

a set of additional data elements, and

receiving, at the computer system, a collection of order data from a source application, wherein

the collection of order data is organized in a source data format of the source application, and

the collection of order data represents the order;

performing a first transformation operation on the collection of order data using the common data model, wherein

the first transformation operation is performed by the processor,

the first data transformation operation comprises

transforming the collection of order data from a source data format of the source application into a common data format,

the transforming the collection of order data comprises

transforming all data elements in the order line sub-class of the order into the common data format,

the common data format is defined based on the order class, and

the common data format comprises the plurality of common data elements;

performing a second transformation operation on the collection of order data, wherein

the second transformation operation is performed by the processor, and

the second transformation operation transforms the collection of order data from the common data format to a destination data format of a destination application; and

sending the collection of order data in the destination data format to the destination application.

2. The method of claim 1 wherein the plurality of order types comprises two or more order types selected from the group consisting of a sales order, an order return, an order credit memo, an order debit memo, an order cancellation, a quote order, and an order contract.

3. The method of claim 1 wherein the plurality of relationships of the order is selected from the group consisting of relationships with billing terms, relationships with shipping terms, relationships with pricing terms, relationships with payment terms, relationships with parties responsible for the order, relationships with parties participating in the order, and relationships with inventory locations.

4. The method of claim 1 wherein the custom data elements define data fields that are specific to each of a plurality of business systems.

5. The method of claim 1, wherein a transformation order map defines data mappings of the collection of order data from the source data format into the common data format.

6. The method of claim 1 wherein performing a first transformation operation further comprises:

instantiating the order class;

initializing data elements of the instantiated order class;

mapping the received data to the data elements of the instantiated order class;

determining that the received data includes information pertaining to one or more order lines within the order;

instantiating an order line sub-class for each of the one or more order lines;

initializing data elements of each instantiated order line sub-class;

copying data from the data elements of the instantiated order class to corresponding data elements of each instantiated order line sub-class; and

overwriting the copied data with the information pertaining to the one or more order lines when the copied data differs from the information pertaining to the one or more order lines.

7. A computer-readable storage medium having executable instructions to cause a computer system to perform a method comprising:

defining a common data model, wherein

the common data model comprises a hierarchical data structure,

the hierarchical data structure is configured to represent an order class,

the hierarchical data structure comprises

a plurality of common data elements, and

a plurality of custom data elements,

the plurality of common data elements is common to a plurality of order types utilized by a plurality of applications,

each of the custom data elements is configured to define application-specific data fields for at least one application of the applications,

the defining comprises, for each custom data element of the custom data elements,

retrieving a data definition schema for the order class, wherein

the data definition schema comprises the each custom data element, and

the each custom data element is of a custom data type, and

adding the each custom data element to the order class by

retrieving a custom data schema for the custom data type,

locating a tag in the custom data schema relating to the custom data type, and

adding the custom data element to the tag;

the order class identifying a plurality of relationships of an order with a plurality of entities related to the order, and

a definition of the order class is represented as an XML schema;

receiving a collection of order data from a source application, wherein

the collection of order data is organized in a source data format of the source application;

performing a first transformation operation on the collection of order data using the common data model, wherein

the first data transformation operation transforms the collection of order data from a source data format of the source application into a common data format defined by the order class, and

the common data format comprises the plurality of common data elements;

defining an order line sub-class using the processor, wherein

the order line sub-class is derived from the order class,

the order line sub-class represents an order line within the order,

the order line sub-class comprises

a set of data elements from the order class, and

a set of additional data elements, and

the first transformation operation further transforms all data elements in the order line sub-class into the common data format defined by the order class;

performing a second transformation operation on the collection of order data, wherein

the second transformation operation transforms the collection of order data from the common data format to a destination data format of a destination application; and

sending the collection of order data in the destination data format to the destination application.

8. The computer-readable storage medium of claim 7 wherein the plurality of order types comprises two or more order types selected from the group consisting of a sales order, an order return, an order credit memo, an order debit memo, an order cancellation, a quote order, and an order contract.

9. The computer-readable storage medium of claim 7 wherein the plurality of relationships of the order is selected from the group consisting of relationships with billing terms, relationships with shipping terms, relationships with pricing terms, relationships with payment terms, relationships with parties responsible for the order, relationships with parties participating in the order, and relationships with inventory locations.

10. A computer system comprising:

a memory; and

a processor coupled to the memory, the processor executing a set of instructions which cause the processor to

define a common data model, wherein

the common data model comprises a hierarchical data structure,

the hierarchical data structure is configured to represent an order class,

the hierarchical data structure comprises

a plurality of common data elements, and

a plurality of custom data elements,

the plurality of common data elements is common to a plurality of order types utilized by a plurality of applications,

each of the custom data elements is configured to define application-specific data fields for at least one application of the applications,

the defining comprises, for each custom data element of the custom data elements,

retrieving a data definition schema for the order class, wherein

 

the data definition schema comprises the each custom data element, and

 

the each custom data element is of a custom data type, and

adding the each custom data element to the order class by

 

retrieving a custom data schema for the custom data type,

 

locating a tag in the custom data schema relating to the custom data type, and

 

adding the custom data element to the tag;

the order class identifying a plurality of relationships of an order with a plurality of entities related to the order, and

a definition of the order class is represented as an XML schema;

receive a collection of order data from a source application, wherein

the collection of order data is organized in a source data format of the source application;

perform a first transformation operation on the collection of order data using the common data model, wherein

the first data transformation operation transforms the collection of order data from a source data format of the source application into a common data format defined by the order class, and

the common data format comprises the plurality of common data elements;

derive an order line sub-class, wherein

the order line sub-class is derived from the order class,

the order line sub-class represents an order line within the order,

the order line sub-class includes a set of data elements from the order class and a set of additional data elements, and

the first transformation operation further transforms all data elements in the order line sub-class into the common data format defined by the order class;

perform a second transformation operation on the collection of order data, wherein

the second transformation operation transforms the collection of order data from the common data format to a destination data format of a destination application; and

send the collection of order data in the destination data format to the destination application.