Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
9
Item Flow Task
The Item Flow task manages weekly sales and receipt planning for Short Life Cycle (SLC) products. Unlike Long Life Cycle (LLC) items, which are managed through replenishment systems, SLC items require detailed time-phased planning due to their limited selling window. This workflow supports both Single Drop (one-time delivery) and Multiple Drop (phased deliveries) strategies, providing flexibility to align with business needs.
Planners define key parameters including planning method, sales curve, sell-through, and timing. Predefined sales curves (such as Bell, Trending, Slow Introduction, MFP, or Last Year) shape demand distribution across weeks. Default receipt parameters—such as lead time, order frequency, and safety stock—are pre-populated from administrative settings and can be adjusted as needed.
The system generates weekly sales and receipt plans using the Create Sales and Receipt Plan application action. For Single Drop items, buy quantity is driven by total demand and sellthrough. For Multiple Drop items, sales are distributed using the selected curve and receipts are calculated based on delivery parameters.
This workflow enables accurate and efficient planning of SLC items, ensuring alignment to demand patterns, minimizing risk, and optimizing inventory flow. This step translates assortment decisions into executable receipt plans.
Create the Item Flow Segment
When working in a segment, limit wizard selections to the specific scope being planned to improve navigation and performance.
To create the Item Flow segment:
1. Click Assortment Services in the Task menu.
2. Select the Planning Services activity.
3. Select the Item Flow task. The Create New Plan dialog opens.
4. Click Create New Plan.
5. Enter a plan label and click OK.
6. In Select Assortment Period , choose an assortment period and click Next .
7. In Select Product , choose one style-color or more and click Next .
The wizard automatically filters to approved Short Life Cycle items.
8. Click Finish.
Step: Item Flow
The Item Flow workflow begins with defining parameters for Short Life Cycle (SLC) items, including the delivery strategy and sales curve. Planners select a planning method (Single
Drop or Multiple Drop), choose a sales curve, and review default receipt parameters such as lead time, order frequency, and safety stock.
Planners then execute the Create Sales and Receipt Plan application action to generate weekly sales and receipt projections. For Single Drop items, planners review and adjust buy quantity. For Multiple Drop items, planners review and refine weekly sales and receipt distributions.
Once the plan is validated, planners reconcile results against MFP targets and execute approval of the Item Flow. Additional views support review of sales curves and administrative parameters to ensure alignment with planning objectives.
Tab and Views in this Step:
-
Define Item Flow Tab:
-
Define Item Flow View
-
Adjust Buy Quantity View
-
Adjust Weekly Flow View
-
Reconcile to MFP View
-
Approve Item Flow View
-
Review Sales Curves View
-
Review Admin Parameters View
-
Define Product Rollup View
-
Application Actions
Create Sales & Receipt Plan
Generates weekly sales and receipt unit recommendations based on defined Item Flow parameters.
Copy Like Item
Copies values from Like Item into Wp for AF Cp Sales U, AF Cp Week Start/End date, Wp Retail Price, Wp Cost.
Approve Item Flow
Moves Working Plan (Wp) assortment to the Original Plan (Op) and Current Plan (Cp) version for use in downstream process steps. As a Pre-Season process this creates both Op and Cp versions.
Export Placeholders
Exports placeholder items for downstream processing, such as item creation or integration with external merchandising systems.
Refresh Rollup
Creates alternate hierarchies based on selected product attributes for aggregated analysis.
Define Item Flow Tab
The Define Item Flow tab enables planners to define delivery strategy, select sales curves, review receipt parameters, and generate weekly sales and receipt plans for Short Life Cycle (SLC) items.
Define Item Flow View
The Define Item Flow view supports planning of SLC items by defining key parameters such as Planning Method (Single Drop or Multiple Drop), sales curve selection, and selling start and end weeks.
Receipt parameters—including lead time, order frequency, and safety stock—are autopopulated from administrative settings and can be adjusted as needed.
The Create Sales and Receipt Plan application action generates weekly sales and receipt projections. Weekly sales for both Single Drop and Multiple Drop items are based on the selected curve and date range. Cp Sales U from Assortment Fit serves as the default assortment period sales plan unless modified.
For Single Drop items, buy quantity is calculated using sell-through, sales units, lead time, and minimum order quantity. For Multiple Drop items, receipts are calculated using sell-through, order frequency, safety stock, and related parameters.
Filters enable aggregation and analysis across Single Drop and Multiple Drop products.
If new placeholders are created and recommended sales potential values are desired, return to the Assortment Fit step to generate sales potential before proceeding. Otherwise, Like Item can be assigned for seeding sales.
The steps to complete this process:
1. (Optional) Assign Like Items to seed Item Flow parameters.
-
a. Unhide Wp Copy Like Item and Wp Like Item measures.
- Wp Like Item is a picklist measure available at the All Location level.
-
b. Select a Wp Like Item from an existing style-color in the workspace.
-
c. Set Wp Copy Like Item to True.
-
d. Execute the Copy Like Item application action to copy the following values into the selected style-color: AF Cp Sales U , AF Cp Week Start/End , Wp Retail Price , Wp Cost .
-
e. Once Wp Sales U is populated, default receipt parameters populate automatically.
2. Define item flow parameters, including Wp Planning Method , Wp Sales Curve Source , Wp Sales U (Initial) , and Wp Week Start/End .
3. Switch measure profiles as needed to support different planning methods and delivery strategies.
4. The Filter by Assorted Options, Filter by Single Drop Items , and Filter by Multiple Drop Items special filters are available to change display to show only desired items. Filter by Assort Options is enabled by default but may be adjusted as needed.
5. Review and adjust receipt parameters such as lead time, order frequency, presentation minimum, and safety stock.
6. Select Wp Create Sales and Receipt Plan for the desired style-colors.
7. Execute the Create Sales and Receipt Plan application action to generate sales and receipt flows.
| ”2.xBoyQuant[<bina mwrwN | s/coa @>] | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
=a | Merwe WpBuyOty u | WpSelThru ‘% (ievitial) | =WpSalesU Qinniat) | = WpSelesR = Orvaiad) | WpGM®% (iretial) | WpdgROS WU inital | WoWeek Sart | AFCpSalesU | AFCpSslesR = | AFCpGM% | AFCpAvgROS u |
| ~LWomen’sActherwarTops | 265,459 | 100.0% | 205.459 | 21,006,748 | 405% | aie | ouy29/2023 | 203,459 | 21,626,746 | 458% | ibaa |
> 1 Women’sActivewear LongSleeve Tops: | 63,215 | 100.0% | 63,205 | 5,145,755 | 464% | A198 | 01/29/2023 | 43,215 | 5,443,785 | 44% | 196 |
| CrewNeckTop_pink | 3392 | 100.0% | 5,802 | 6 | oo% | a70 | 01/20/2025 | 5,92 | o | o0% | a0 |
Hoodiewhite | ata | 100% | ante | 208876 | 414% | aos. | o4/z9/20235 | 4274 | 006,876 | s74.% | 10.61 |
Placehokier LS 000000801 | 4225 | 100.0% | 4223 | 0 | o0% | 20.48 | 01/29/2023 | A225 | o | 00% | 10.48 |
| PlacehoklerLSOO0000802 | 5418 | 100.0% | 5488 | o | 0% | 2437 | 04/29/2023 | 548 | o | o0% | 44.37 |
Placehokler TL Aghiesune 5000000800 | 414 | 1000% | aha | 0 | 0% | 2145 | 00/29/2023 | agla | o | 00% | 145 |
| FabibedV-Neck Top_purple | 4.082 | 1000% | Ane2 | 19.877 | 750% | 1164 | 01/79/2073 | 492 | 160.877 | 750% | libs |
| Swenatshirt_red | 4297 | 1o0% | 4207 | 838689 | 448% | aLoz | 91/29/2023 | 4297 | 56,049 | 448% | oz |
| Swearshirt_yelliow | 5387 | 100.0% | 5,487 | ‘e70,080 | 4L7e | 1357 | o1f20/2023 | 5387 | 870,030 | 47% | 13.37 |
| Turtleneck Top_off_white | 5080 | 1a0% | 5009 | 420,780 | 502% | a2as | oa/20/2025 | 5,099 | 420,780 | 502% | 12.65 |
| VeeckToppink | 3907 | 100.0% | 3907 | 585,940 | 47% | 2056 | o1/29/2025 | 5.907 | 588,940 | 4a7% | 1058 |
VoNeckTop_white | 5792 | 1000% | 3,792 | 549,850 | 45.0% | 972 | 01/20/2025 | 3,792 | 549,880 | 450% | O72 |
>2Women’sActivewear ShortSleeveTops | 89,532 | 100.0% | 89,332 | SB1S.574 | 530% | 2185 | 00/29/2023 | 89,332 | 3815,574 | 530% | Las |
CompressionCrewMeck T-Shurt_bilack | 4552 | 1000°% | 4552 | 11.160 | 50.2% | 2130 | 01/29/2023 | 4552 | 191160 | 502% | 4130 |
| CompressionV-NeckT-Shirttblack | 3722 | 190% | 3722 | 165,244 | 703% | 923 | 01/29/2023 | 3722 | 165,844 | 703% | 923 |
| \Sammenenfon[Cusan | wmsyar@ >) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Measure Product | Wp Wp Approve Approve A item Flew Comment | Wp pproval into | Op Approve Enabled | WoSalesU | Wp Sales | Wp Receipts U | Wp =ReceiptsR | WoSel Thr% | WeGMR | WpGM% | Wo Ave ROSU |
| = 1Women’sActivewearTops | ia) | 161,627 | 15,764,335 | 275.092 | 22,120.860 | 475% | 7,185,904 | 45.6% | 7.03 | ||
| = 1Women’s Activewear Long SleeveTops | o | 49,332 | 5,981,737 | 77410 | 7,307,450 | 490% | 2,308,088 | 386% | 935 | ||
| CropTop_black, | oO | 6364 | 1,027,022 | 7978 | = 903,895 | 57.7% | 368,656 | 35.9% | 15.79 | ||
| Hoodie pink | o | 5.195 | © 597,042 | 7.670 | =880,071 | 50.9% | 266,658 | 44.7% | 13.32 | ||
| Hoodie_white | o | 5497 | 895,740 | 8149 | (915,727 | 519% | 382.413 | 42.7% | 1414 | ||
| Placehokler LS000000802 | o | a | a | a | o | 0.0% | a | oo% | o.oo | ||
| Placeholder LS000000802 | o | a | a | a | a | O0% | a | oo% | ooo | ||
| Placehokier TLAthleisureLS000000800 | o | o | a | a | 0 | 00% | o | oo% | a0 | ||
| fibbed V-NeckTop_purple | oO | 4293 | 239,400 | 20331 | 792,706 | 510% | 178,142 | 744% | 15.62 | ||
| ‘Sweatshirt_rod | oa | 5.780 | 783,969 | 7520 | 881,427 | 55.6% | 300,028 | 38.3% | 1482 | ||
| Sweatshirt_yellow | EJ | 6504 | =B48,804 | 7861 | 1,034,407 | 59.1% | 245,366 | 78.9% | 15.64 | ||
| TurtleneckTop_off_white | o | 2,786 | 140,155 | 2.639 | 94,760 | 45.9% | 93,724 | 66.9% | 691 | ||
| V-Neck Top_pink | o | 6012 | 823,304 | 7846 | 944.440 | 55.4% | 311,847 | 37.9% | 1595 | ||
| ‘V-NeckTop_white | o | 4,900 | 626,112 | TAs | ‘BS0,017 | 42.4% | 161,253 | 25.8% | 1256 | ||
| + 2Women’sActivewear Short SleeveTops | o | $3,245 | 4371414 | 84,614 | 6,814,937 | 487% | 2,470,305 | 565% | 7.06 | ||
| Compression Crew NeckT-Shirt_black | o | 4524 | 333,105 | 241d | 90,854 | 903% | 228,687 | 68.7% | 16.19 | ||
| CompressionV-NeckT-Shart_black | oO | @ | 3,782 | 181.498 | 11799 | 566,234 | 321% | 127,605 | 703% | 938 |
|> 6Review Selling Curves
|
|< SalesCurves
|@
>|
| ¢
Ank
|leLengthJogger
tioc
|k@
>|
|< US
|Brick& MortarUS/
|@
>
||
||
|---|---|---|---|---|---|---|---|---|---|
|Caleriar|=
all [Calendar]|Week 1FY2023|Week2FY2023|Week SFYZ023|Week4FY2023|WeekSFY2025
|WeekOFY2023|Week7FY2023
|Week 8|
|Curve Points:
||||||||||
|1. BellCurve
|0.0%
|00%
|o0%
|00%
|00%
|00%.
|o0%
|00%
||
|2 Trending Curve
|0.0%
|oo%
|oo%
|00%
|oo%
|00%
|00%
|oo%
||
|3.Slow IntroCurve
|0.0%
|00%
|00%
|0.0%
|00%
|00%
|00%
|00%
||
|4. MEP Curve
|100.0%
|33%
|35%
|aS%
|105%
|114%
|98%
|13%
||
|§.Last Year Curve
|100.0%
|61%
|128%
|148%
|143%
|15.1%
|63%
|43%
||
|UserCurve01|00%|00%|oo%|00%|oo%|00%|oo%|oo%||
|>7.ReviewAdminParameters|<|USBri|ck&Mortar@
>|||¢AP1Sprin|@
>|||
|---|---|---|---|---|---|---|
|
M
Product|
easure|
=AdminLead Time
(Weeks)|
AdminMinOrder
QtyU|
Admin Order
Frequency(Weeks)|AdminSafetyStock
(Weeks)|AdminPresMinU|
|1Women’sActivewear Leggings||Z|1,200:|2|2|120|
|1Women’sActivewear Long Sleeve Tops.||2|o|i|oO|o|
|2Women’sActivewearJoggers||Oo|Oo|1|o|Oo|
|?Women’s Activewear Short SleeveTops||0|0|1|2|oO|
|3Women’sActivewearSleevelessTops||z|o|i|o|0|