My Oracle Support Banner

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 FEBRUARY 28, 2019

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

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
Symptoms
Cause
Solution
References


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