Resolving errors when running the GMD_FORMULA_PUB.INSERT_FORMULA API
(Doc ID 398598.1)
Last updated on APRIL 04, 2018
Applies to:Oracle Process Manufacturing Product Development - Version 11.5.10 to 184.108.40.206 [Release 11.5]
Information in this document applies to any platform.
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.
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'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!