Resolving errors when running the GMD_FORMULA_PUB.INSERT_FORMULA API
(Doc ID 398598.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Process Manufacturing Product Development - Version 11.5.10 to 11.5.10.2 [Release 11.5]Information in this document applies to any platform.
Goal
Using the GMD_FORMULA_PUB.INSERT_FORMULA API to create formulas. Have had a number of errors each of which have been solved in turn.
Typical errors.
1. PLS-00306 error wrong number of arguments.
2. ORA-06502 error meaning a PL/SQL: numeric or value error. An arithmetic, numeric, string.
3. Message 'Duplicate line no for item XXXX in formula/ version ABC-123'.
4. Resolving the error message 'GMD_API_INVALID_USER_ID (USER_ID=) '
2. ORA-06502 error meaning a PL/SQL: numeric or value error. An arithmetic, numeric, string.
3. Message 'Duplicate line no for item XXXX in formula/ version ABC-123'.
4. Resolving the error message 'GMD_API_INVALID_USER_ID (USER_ID=) '
All formulas are created with a status of 100 ie 'New'. How do you create them to be created with a status of 'Approved for General Use'.
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 |