Resolving errors when running the GMD_FORMULA_PUB.INSERT_FORMULA API
Last updated on APRIL 04, 2018
Applies to:Oracle Process Manufacturing Product Development - Version 11.5.10 to 220.127.116.11 [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'.
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