API GMD_FORMULA_PUB.insert_formula: Unable to Insert Formula With Release Type 'Automatic By Step' (Doc ID 2022063.1)

Last updated on APRIL 04, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, API Issues

When attempting to use the API gmd_formula_pub.insert_formula to create formulas and are passing release_type = 3 ‘Automatic by Step’.

ERROR
-----------------------
The API failed to create formula with "Invalid release type" error message. Please see below for error message.
        Error Message: Release type for formula/ version  formulaname/version is invalid.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. API gmd_formula_pub.insert_formula
2.Validating Release type in GME_LOOKUPS and type='RELEASE_TYPE' and found that there is no entry for 'Automatic by Step' in lookup.
 Below are the entries exists in RELEASE_TYPE LOOKUP:
------------------      -------------------------------------------
LOOKUP_CODE     MEANING
------------------      -------------------------------------------
0                         Automatic Release
1                         Manual Release
2                         Incremental Release
------------------      -------------------------------------------




Cause

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