Error Applying Patch:21027308:R12.GMF.C - ORA-04063 package body "APPS.GMF_LOT_COSTING_PUB" has errors (Doc ID 2041678.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Process Manufacturing Financials - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Patch Application Issues

Error applying <Patch:21027308>:R12.GMF.C


ERROR
-----------------------

**Starts**22-JUL-2015 11:02:00
**SQL error and free**22-JUL-2015 11:02:00
ORACLE error 4063 in FDPSTP

Cause: FDPSTP failed due to ORA-04063: package body "APPS.GMF_LOT_COSTING_PUB" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.GMF_LOT_COSTING_PUB"
ORA-06512: at line 1


In fact the pkg GMF_LOT_COSTING_PUB is invalid and trying to compile it fails with a lot of errors.

The user has
CREATE OR REPLACE PACKAGE APPS.GMF_LOT_COSTING_PUB AUTHID CURRENT_USER AS
/* $Header: GMFPLCRS.pls 120.5 2011/05/06 13:41:19 spabolu ship $ */

CREATE OR REPLACE PACKAGE BODY APPS.GMF_LOT_COSTING_PUB AS
/* $Header: GMFPLCRB.pls 120.84.12020000.28 2015/01/21 07:43:53 penpan ship $ */

compilation Errors are:
-line 1279: PL/SQL: ORA-02315: incorrect number of arguments for default constructor
-line 5812: PLS-00302: component 'COST_SOURCE' must be declared
-line ....: PLS-00302: component 'COST_SOURCE' must be declared


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Apply <patch:21027308>:R12.GMF.C

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the patch cannot be applied and the issues with Lot Costing cannot be resolved

Cause

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