Import Actuals (imp_data)

This task is used to schedule and run all the importer interfaces which import actuals data needed for MFPCS from RAP integration. If the RDX Enabled flag is set, it runs as part of weekly batch and as part of JOS/POM schedule. This task can be used to directly execute this interface which pulls the fact/measures data from RDX into MFP.

Following is the list of interfaces which are imported from RDX:

  • Sales (W_PDS_SLS_IT_LC_WK_A)

  • Inventory (W_PDS_INV_IT_LC_WK_A)

  • Inventory Adjustments (W_PDS_INVADJ_IT_LC_WK_A)

  • On-Order (W_PDS_PO_ONORD_IT_LC_WK_A)

  • Receipts (W_PDS_INVRC_IT_LC_WK_A)

  • Markdowns (W_PDS_MKDN_IT_LC_WK_A)

  • Transfers (W_PDS_INVTSF_IT_LC_WK_A)

  • Wholesale/Franchise (W_PDS_SLSWF_IT_LC_WK_A)

  • Deal Incomes (W_PDS_DEALINC_IT_LC_WK_A)

  • Currency Conversion Rates (W_PDS_EXCH_RATE_G)

  • Location Data (VW_LOC_DATA)

  • Location Attributes (W_PDS_ORG_ATTR_STR_D)

For more details about the interfaces and their mapping details, see the Oracle Retail Merchandise Financial Planning Cloud Service Implementation Guide.