My Oracle Support Banner

IGIPGMTH After Apply Patch 13257274 : IGI CIS2007 Monthly Returns Report Fails with java.sql.SQLException ORA-06503 ORA-06512 in IGI_CIS2007_UTIL_PKG (Doc ID 1504549.1)

Last updated on FEBRUARY 20, 2019

Applies to:

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

Symptoms

Construction Industry Scheme 2007 is enabled
You apply <Patch 13257274>
You navigate to the Monthly Returns UI page
You enter the required fields
You submit the Monthly Returns
It fails with the following error in the request log file:

ERROR:
java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.IGI_CIS2007_UTIL_PKG", line 229

Changes

<Patch 13257274> 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.