API GMD_FORMULA_PUB.insert_formula: Unable to Insert Formula With Release Type 'Automatic By Step'
(Doc ID 2022063.1)
Last updated on MAY 14, 2019
Applies to:
Oracle Process Manufacturing Product Development - Version 12.1.3 and laterInformation 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
------------------ -------------------------------------------
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |