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

Applies to:

Symptoms

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

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