Staging Data Will Not Be Imported by ODS Load After Running Pre-Process Transaction Data Twice (Doc ID 2300908.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

To import data into MSC_SUPPLIES data with the following steps:

1. Insert new record to MSC_ST_SUPPLIES directly.
2. Run Pre-Process Transaction Data.
3. Run Planning ODS Load.

The above procedure is imported into MSC_SUPPLIES without any problems.

However, if run "Pre-Process Transaction Data" program twice as follows, even record of MSC_ST_SUPPLIES are not changed, but Planning ODS Load will not be imported.

1. Insert new record to MSC_ST_SUPPLIES directly.
2. Run Pre-Process Transaction Data (first).
3. Run Pre-Process Transaction Data (Second).
4. Run Planning ODS Load.

Is it an intended behavior?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms