Export Plans to RI (exp_plan_ri)

This task is used to export all approved Plans for the planned periods to Oracle Retail Insights (RI) Cloud Service Suite. This can only be scheduled if the retailer has Oracle Retail Insights (RI) and is using RAP integration.

This task calls the interfaces which directly transfers the MFP plan data to RI staging tables that can be directly consumed by RI.

Following is the list of plan versions that are exported:

  • Merch Plan (CP and OP Version)

  • Merch Target Plan (Tgt Version)

  • Location Plan (CP and OP Version)

  • Location Target Plan (Tgt Version)

For more details about this integration with RI and the list of measures exported for each plan, see the Oracle Retail Merchandise Financial Planning Cloud Service Implementation Guide. This task will execute as part of the daily and weekly batch either if it is executed using the JOS/POM scheduler or the daily/weekly batch task is executed directly using OAT.