My Oracle Support Banner

After Patch 23207046, PA_MULTI_CURRENCY_TXN Invalid, Errors: PLS-00323: subprogram or cursor 'GET_PROJFUNC_CURR_AMOUNT' Declared and not Defined in Body (Doc ID 2671384.1)

Last updated on MAY 26, 2020

Applies to:

Oracle Project Costing - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
PA_MULTI_CURRENCY_TXN PACKAGE BODY
PAXMCTXB.pls
PAXMCTXS.pls

Symptoms

After Patch 23207046, PA_MULTI_CURRENCY_TXN  PACKAGE BODY became invalid. Compiling PAXMCTXB.pls , PAXMCTXS.pls files does not solve the issue.

Recompiling the package throws error as shown below.

 

ERROR:

Errors for PACKAGE BODY APPS.PA_MULTI_CURRENCY_TXN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
396/10   PLS-00323: subprogram or cursor 'GET_PROJFUNC_CURR_AMOUNT' is declared in a package specification and must be defined in the package body

 

Useful query to check the packages:

 

Changes

 New patch applied.

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
Changes
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.