6 IPOCS-Lifecycle Allocation and Replenishment Flat File Exports
IPOCS-LAR exports approved plan data for planned orders and transfers. Exported approved plans data can be used by a retailer to interface with any other applications for reporting purposes or as input to other systems that need Lifecycle Allocation and Replenishment Plan data. All exported files are in CSV format.
For more information related to extracted measures, the approval process, and the administration process related to export, see the Oracle Retail Inventory Planning Optimization Cloud Service-Demand Forecasting / Inventory Planning Optimization Cloud Service-Lifecycle Allocation and Replenishment User Guide.
Note:
In addition to exporting as flat files, IPO-LAR can export the proposed PO and proposed transfers to RMFCS during the batch using webservice calls. Refer to the Batch Control Step in the Oracle Retail Inventory Planning Optimization Cloud Service-Demand Forecasting / Inventory Planning Optimization Cloud Service-Lifecycle Allocation and Replenishment User Guide.
An SR needs to be raised against Oracle to connect the RMFCS server with the Planning Servers. This is needed only if you have IPO-LAR enabled and you want to send POs and transfers from IPO-LAR to RMFCS.
The following sections include information for each export type:
Nightly Batch Export
The following tables list the file field data for the Nightly Batch export.
Table 6-1 Approved Plan Export
Transfers (proposed_transfers_qty.csv)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpRcvngDt |
Export Receiving Date |
date |
ambig_pop |
|
LPExpPropTrfU |
Export Proposed Transfers Units |
real |
total |
|
LPExpDeptSrcDstTFNS |
Department-Source-Destination TFN |
string |
ambig_pop |
Table 6-2 Approved Plan
Export Purchase Orders (proposed_po_qty.csv)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpRcvngDt |
Export Receiving Date |
date |
ambig_pop |
|
LPExpPropPoU |
Export Proposed Orders Units |
real |
total |
|
LPExpDeptSplrPONS |
Department-Supplier PON |
string |
ambig_pop |
Table 6-3 Approved Plan
Export Future Transfers (future_transfers_qty.csv)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
WEEK |
Week |
N/A |
N/A |
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPExpFutrTrfU |
Export Future Transfers Units |
real |
total |
Table 6-4 Approved
Plan Export Future Purchase Orders (future_po_qty.csv)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
WEEK |
Week |
N/A |
N/A |
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPExpFutrPoU |
Export Future Purchase Orders Units |
real |
total |
Intra-day Batch Export 1
The following tables list the file field data for the Intra-day Batch Export 1 export.
Table 6-5 Approve Plan Export
Transfers (proposed_transfers_qty.csv.1 )
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpRcvngDt |
Export Receiving Date |
date |
ambig_pop |
|
LPExpPropTrfU |
Export Proposed Transfers Units |
real |
total |
|
LPExpDeptSrcDstTFNS |
Department-Source-Destination TFN |
string |
ambig_pop |
Table 6-6 Approved Plan
Export Purchase Orders (proposed_po_qty.csv.1)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpRcvngDt |
Export Receiving Date |
date |
ambig_pop |
|
LPExpPropPoU |
Export Proposed Orders Units |
real |
total |
|
LPExpDeptSplrPONS |
Department-Supplier PON |
string |
ambig_pop |
Table 6-7 Approved Plan
Export Manual Transfers (proposed_manual_transfers_qty.csv.1)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpManTrfU |
Export Plan Transfer Units |
real |
total |
|
LPExpManTFNS |
Export Manual TFN |
string |
ambig_pop |
Intra-day Batch Export 2
The following tables list the file field data for the Intra-day Batch Export 2 export.
Table 6-8 Approved Plan Export
Transfers (proposed_transfers_qty.csv.2)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpRcvngDt |
Export Receiving Date |
date |
ambig_pop |
|
LPExpPropTrfU |
Export Proposed Transfers Units |
real |
total |
|
LPExpDeptSrcDstTFNS |
Department-Source-Destination TFN |
string |
ambig_pop |
Table 6-9 Approved Plan
Export Purchase Orders (proposed_po_qty.csv.2)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpRcvngDt |
Export Receiving Date |
date |
ambig_pop |
|
LPExpPropPoU |
Export Proposed Orders Units |
real |
total |
|
LPExpDeptSplrPONS |
Department-Supplier PON |
string |
ambig_pop |
Table 6-10 Approved Plan
Export Manual Transfers (proposed_manual_transfers_qty.csv.2)
| Measure | Measure Label | Data Type | Aggregation Type |
|---|---|---|---|
|
SKU |
Sku |
N/A |
N/A |
|
STOR |
Store |
N/A |
N/A |
|
SLOL |
Source Location |
N/A |
N/A |
|
LPPmTodayDt |
Today Date |
date |
ambig_pop |
|
LPExpManTrfU |
Export Plan Transfer Units |
real |
total |
|
LPExpManTFNS |
Export Manual TFN |
string |
ambig_pop |