Getting ORA-07445: Core Dump [kkfdqc] Error on UNION ALL View (Doc ID 1183993.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2.0 [Release 11.2]
Information in this document applies to any platform.

Symptoms

On 11.2.0.1 production, the following error is occurring:

ORA-07445: exception encountered: core dump [kkfdqc()+176] [SIGSEGV]
[ADDR:0x28] [PC:0x104611FB0] [Invalid permissions for mapped object] []
when a select from a view is performed:

SELECT * FROM OBT_AA."PO_GA_ORG_ASSIGNMENTS_V";


----- PL/SQL Call Stack -----
object line object
handle number name
700000035f2c900 1053 package body SYS.DBMS_SQL
700000035fd1340 868 package body APPS.OBTCO_UTILS
7000000340d0250 1 anonymous block

Select query of view po_ga_org_assignments_v is failing


SQL> SELECT pga.row_id, pga.po_header_id, ou.NAME, pga.organization_id,
pga.enabled_flag, pvs.vendor_id, pvs.vendor_site_id, pvs.vendor_site_code,
DECODE (pga.organization_id, poh.org_id, 1, 2), pga.last_update_date, pga.last_updated_by, pga.creation_date, pga.created_by, pga.last_update_login, ou2.NAME, pga.purchasing_org_id
FROM hr_operating_units ou, hr_operating_units ou2, po_vendor_sites_all pvs,
po_ga_org_assignments pga, po_headers_all poh
WHERE pga.po_header_id = poh.po_header_id
AND pga.organization_id = ou.organization_id
AND pga.vendor_site_id = pvs.vendor_site_id
AND pga.purchasing_org_id = ou2.organization_id
/
 SELECT pga.row_id, pga.po_header_id, ou.NAME, pga.organization_id,
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


VIEW po_ga_org_assignments_v contains the problematic column row_id which is
filled in from po_ga_org_assignments 

CREATE OR REPLACE VIEW po_ga_org_assignments (row_id,
po_header_id,
organization_id,
enabled_flag,
vendor_site_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
purchasing_org_id
)
AS
SELECT /*+ PUSH_JOIN_PRED */
CHARTOROWID (ROWIDTOCHAR (ROWID)) row_id, "PO_HEADER_ID",
"ORGANIZATION_ID", "ENABLED_FLAG", "VENDOR_SITE_ID",
"LAST_UPDATE_DATE", "LAST_UPDATED_BY", "CREATION_DATE",
 "CREATED_BY", "LAST_UPDATE_LOGIN", "PURCHASING_ORG_ID"
FROM "PO"."PO_GA_ORG_ASSIGNMENTS"@ba11510h
UNION ALL
SELECT /*+ PUSH_JOIN_PRED */
CHARTOROWID (ROWIDTOCHAR (ROWID)) row_id, "PO_HEADER_ID",
"ORGANIZATION_ID", "ENABLED_FLAG", "VENDOR_SITE_ID",
"LAST_UPDATE_DATE", "LAST_UPDATED_BY", "CREATION_DATE",
 "CREATED_BY", "LAST_UPDATE_LOGIN", "PURCHASING_ORG_ID"
FROM "PO"."PO_GA_ORG_ASSIGNMENTS"
WITH READ ONLY

Cause

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 hundreds of Community platforms