My Oracle Support Banner

Resolving errors when running the GMD_FORMULA_PUB.INSERT_FORMULA API (Doc ID 398598.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Process Manufacturing Product Development - Version 11.5.10 to [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.

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=) '

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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.