342/12 PLS-00323: subprogram or cursor 'SET_INTERIM_STATUS

Mar 6, 2022 9:45AM

Dear All,

While upgrading from 12.1.3 to 12.2, many objects compiled with invalid status. One of these are FND_CONCURRENT, compile error message is:

342/12 PLS-00323: subprogram or cursor 'SET_INTERIM_STATUS' is declared in a package specification and must be defined in the package body.

SELECT SUBSTR(text,1,70) Text, SUBSTR(name,1,30) Name FROM all_source WHERE UPPER(name) LIKE UPPER('FND_CONCURRENT') AND line = 2;

/* $Header: AFCPUTLS.pls 120.4.12010000.3 2018/02/16 22:22:49 ckclark FND_CONCURRENT

/* $Header: AFCPUTLB.pls 120.18 2010/08/13 20:42:11 pferguso ship $ */ FND_CONCURRENT

--File versions before upgrade:

strings -a home/oracle/d01/oracle/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/AFCPUTLS.pls | grep '$Header'

/* $Header: AFCPUTLS.pls 120.4.12010000.3 2018/02/16 22:22:49 ckclark ship $ */

Install, Upgrade, Clone, Patch - EBS (MOSC)