IGIPGMTH CIS Monthly Return After Apply Patch:20128253 Get ORA-04063: package body "APPS.IGI_CIS2007_IGIPMTHR_PKG" has errors
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
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:-
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 :-
Then get the following 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
The issue can be reproduced at will with the following steps:
1. apply <Patch:20128253>:R12.IGI.B
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms