How are products synced between the inventory product master and sales?

The sync between the Oracle SCM Product Information Master (PIM) and Sales products is accomplished using scheduled processes.

These are the scheduled processes:

  • Import Sales Products from PIM Data Hub
  • Refresh Denormalized Product Catalog Table for BI

Import Sales Products from PIM Data Hub Scheduled Process

Run the Import Sales Products from PIM Data Hub process anytime you update or create products in the product model.

You must run this scheduled process so that products you created (or those you updated) in the Product Model show up in the sales Products UI.

Refresh Denormalized Product Catalog Table for BI Scheduled Process

Every time you publish a catalog, the scheduled process, Refresh Denormalized Product Catalog Table for BI, runs automatically to update the current view of the product group hierarchy in the applications.

In addition, each time you make a new assignment of Base to a root product group, you must run the process. If you don't run the process, your product group hierarchy might not appear in the applications.

Run the Processes

Here are the steps to run either process:

  1. Sign in as a setup user and navigate to Scheduled Processes.
  2. In the Scheduled Processes page, click Schedule New Process.
  3. In the Schedule New Process dialog window, click the down-arrow next to the Name field and click Search.
  4. In the Search dialog window, search for the process you want to run.
  5. Select the process in the results that are returned and click OK.
  6. Click OK again, if needed.
  7. In the Process Details window, click Submit.