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:
Oracle Public Sector Financials (International) - Version 12.1.3 and laterInformation in this document applies to any platform.
IGIPGMTH module: IGI : CIS2007 Generate Monthly Returns Process
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
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 |