My Oracle Support Banner

IGIPGMTH CIS Monthly Return After Apply Patch:20128253 Get ORA-04063: package body "APPS.IGI_CIS2007_IGIPMTHR_PKG" has errors (Doc ID 2087612.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Public Sector Financials (International) - Version 12.1.3 and later
Information in this document applies to any platform.
IGIPGMTH module: IGI : CIS2007 Generate Monthly Returns Process

Symptoms

On : 12.1.3 version, Construction Industry Scheme

To fix the issue with the CIS Monthly Return having poor performance and finally ending with Internet Explorer cant display the web page, <Patch:20128253>:R12.IGI.B is applied, but then the package igipmthrb.pls will not compile due to the following errors:-

ERROR
--------
ORA-04063: package body "APPS.IGI_CIS2007_IGIPMTHR_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.IGI_CIS2007_IGIPMTHR_PKG"
ORA-06512: at line 1

If apply the following patches :-
<Patch:19986009>:R12.IGI.B
<Patch:20128253>:R12.IGI.B

Then get the following error:-

ERROR
--------
Package Body APPS.IGI_CIS2007_IGIPMTHR_PKG
PLS-00323: subprogram or cursor 'GET_PAYMENT_CIS_DETAILS' is declared in a package specification and must be defined in the package body
PLS-00306: wrong number or types of arguments in call to 'GET_PAYMENT_CIS_DETAILS'
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. apply <Patch:20128253>:R12.IGI.B

Changes

 

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!

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