Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Order Management and Fulfillment Analytics Option >
About the Grain at Which Currency Amounts and Quantities Are Stored
Quantities and currency amounts may be stored at different grains in the Order Cycle Time (W_SALES_CYCLE_LINE_F_HOLD_TMP) table, because of their unique ability to be rolled up. Consider as an example a situation where a customer orders one package, which includes a computer, scanner, printer, and two speakers. In addition to the package, the customer also orders one monitor, which is not included in the package deal. In this case, the sales quantities are listed for the parent line item as well as for each child line items. However, the currency amounts are only listed for the parent line items; they are not listed for the individual child line items. Table 76 illustrates this example.
Table 76. Storing Currency Amounts at the Parent Line Level in Order Cycle Time table
|
|
|
|
|
|
|
|
Line_1 |
1000 |
Package |
1000 |
Line_1 |
1 |
$1000 |
Parent A |
Line_2 |
1000 |
Computer |
1000 |
Line_1 |
1 |
- |
Child A1 |
Line_3 |
1000 |
Scanner |
1000 |
Line_1 |
1 |
- |
Child A2 |
Line_4 |
1000 |
Printer |
1000 |
Line_1 |
1 |
- |
Child A3 |
Line_5 |
1000 |
Speaker |
1000 |
Line_1 |
2 |
- |
Child A4 |
Line_6 |
1000 |
Monitor |
1000 |
Line_5 |
1 |
$400 |
Parent B (no children) |
Consider another example. In this example, a customer orders the same package, which includes a computer, scanner, printer, and two speakers. In addition to the package, the customer also orders one monitor, which is not included in the package deal. In this case, the quantities are provided for the parent and child line item levels. In addition, the currency amounts are also listed for both the parent and child line item levels. Table 77 illustrates this example.
Table 77. Storing Currency Amounts at the Child Line Level in Order Cycle Time table
|
|
|
|
|
|
|
|
Line_1 |
1000 |
Package |
1000 |
Line_1 |
Parent A |
1 |
- |
Line_2 |
1000 |
Computer |
1000 |
Line_1 |
Child A1 |
1 |
725 |
Line_3 |
1000 |
Scanner |
1000 |
Line_1 |
Child A2 |
1 |
75 |
Line_4 |
1000 |
Printer |
1000 |
Line_1 |
Child A3 |
1 |
150 |
Line_5 |
1000 |
Speaker |
1000 |
Line_1 |
Child A4 |
2 |
50 |
Line_6 |
1000 |
Monitor |
1000 |
Line_5 |
Parent B (no children) |
1 |
$400 |
For more information on parent and child relationships, see About Tracking Multiple Products for Oracle Order Management and Fulfillment Analytics Option.
|