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.

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 ServiceLifecycle 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

• Intra-Day Batch Export 1

• Intra-Day Batch Export 2

RMFCS REST APIs

Following are the Oracle Retail Merchandising Cloud Services (RMFCS) REST APIs called to create and send Purchase Orders, Transfers, and Allocations.

Refer to the ReSTful Web Services chapter within the Oracle Retail Merchandising Cloud Services Inbound and Outbound Integration Guide .

• /MerchIntegrations/services/inventory/allocations/create

• /MerchIntegrations/services/purchaseOrders/create

• /MerchIntegrations/services/inventory/transfers/create

• /RmsReSTServices/services/private/PurchaseOrders/order/id

• /RmsReSTServices/services/private/Transfer/transferId

• /RmsReSTServices/services/private/Alloc/allocNo

Nightly Batch Export

The following tables list the file field data for the Nightly Batch export.

Table 6-1 Approved Plan Export Transfers ( approved_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 ( approved_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 Allocation ( approved_alloc_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
PON	PO Number	N/A	N/A
LPPmTodayDt	Today Date	date	ambig_pop
LPExpOnOrdInPORcvDt	Export Proposed Allocation Units	real	total

Table 6-4 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-5 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-6 Approve Plan Export Transfers ( approved_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-7 Approved Plan Export Purchase Orders ( approved_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

Table 6-7 (Cont.) Approved Plan Export Purchase Orders ( approved_po_qty.csv.1 )

Measure	Measure Label	Data Type	Aggregation Type
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-8 Approved Plan Export Allocation ( approved_alloc_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
PON	PO Number	N/A	N/A
LPPmTodayDt	Today Date	date	ambig_pop
LPExpOnOrdInPORcvDt	Export PO Receiving Date	date	ambig_pop
LPExpPropAlcU	Export Proposed Allocation Units	real	total

Table 6-9 Approved Plan Export Manual Transfers

( approved_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-10 Approved Plan Export Transfers ( approved_transfers_qty.csv.2 )

Measure	Measure Label	Data Type	Aggregation Type
SKU	Sku	N/A	N/A
STOR	Store	N/A	N/A

Table 6-10 (Cont.) Approved Plan Export Transfers ( approved_transfers_qty.csv.2 )

Measure	Measure Label	Data Type	Aggregation Type
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-11 Approved Plan Export Purchase Orders ( approved_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-12 Approved Plan Export Allocation ( approved_alloc_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
PON	PO Number	N/A	N/A
LPPmTodayDt	Today Date	date	ambig_pop
LPExpOnOrdInPORcvDt	Export PO Receiving Date	date	ambig_pop
LPExpPropAlcU	Export Proposed Allocation Units	real	total

Table 6-13 Approved Plan Export Manual Transfers

( approved_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

Table 6-13 (Cont.) Approved Plan Export Manual Transfers

( approved_manual_transfers_qty.csv.2 )

Measure	Measure Label	Data Type	Aggregation Type
LPPmTodayDt	Today Date	date	ambig_pop
LPExpManTrfU	Export Plan Transfer Units	real	total
LPExpManTFNS	Export Manual TFN	string	ambig_pop

---

In this guide

• Guide: IPOCS-Demand Forecasting and IPOCS-LAR Implementation Guide
• Previous: 5 RAP Integration
• Next: A Appendix: New Item Configuration Guide