My Oracle Support Banner

How Can We Populated MSC_ST_SUPPLIES.SHIP_METHOD? (Doc ID 2762905.1)

Last updated on MARCH 31, 2021

Applies to:

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

Goal

We would like to utilize the column: MSC_ST_SUPPLIES.SHIP_METHOD in a data manipulation hook.
in MSC_ST_SUPPLIES table it is of type NUMBER
in MSC_SUPPLIES it is of type VARCHAR2(30)
We tried to place a random number there (lets say 1) and after ODS load completed successfuly, our number from MSC_ST_SUPPLIES.SHIP_METHOD ( value: 1) got pushed to MSC_SUPPLIES.SHIP_METHOD with value of '1' (just a number to varchar conversion).

Normally EBS/VCP operates on shipping method codes.
Can you please explain how to use it?
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.