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

Last updated on NOVEMBER 03, 2016

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

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

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