GMD_FORMULA_PUB API Allows Invalid Scale Type to be Passed In and Saved

(Doc ID 2399119.1)

Last updated on MAY 15, 2018

Applies to:

Oracle Process Manufacturing Product Development - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Product Development Formulas

The GMD_FORMULA_PUB API allowed you to pass scale_type = 2 (Integer) for a product (and
presumably for a byproduct). This is not a valid value for products or
byproducts, only for ingredients. Products and byproducts can only have
values of 0 or 1 (Fixed or Proportional).

When you create a formula this way and retrieve it on the Formula Details screen, the
product is not shown onscreen; the entire product line is blank.

Expect the API to not allow invalid data to be passed in and saved




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