When Running Initial Load: Error FDPSTP failed due to ORA-06550: line 1, column 32: PLS-00302: component 'GET_JOB_MTL_DETAILS_INIT' must be declared (Doc ID 1459868.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Operations Intelligence - Version 12.1.2 and later
Information in this document applies to any platform.

Goal

After upgrading to R12 we are getting the following error when attempting to run a DBI initial load:

OPI_DBI_MUV_INIT_LOAD module: Initial Load - Update Material Usage and Manufacturing Cost Variance Base Summary

**Starts**10-MAY-2012 12:51:30
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 32:
PLS-00302: component 'GET_JOB_MTL_DETAILS_INIT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

How do we resolve this issue?
 

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