Fusion Applications CRM OTBI "Marketing Segmentation Targets": Analysis Error "ORGPARTYPEO"."PARTY_TYPE": Invalid Identifier (Doc ID 1625301.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Customer Center Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion CRM Cloud 11.1.7 Upgrade issue

Custom OTBI analyses based off Marketing Segmentation Targets Subject Area fail with

ORA-00904 Invalid Identifier at OCI Call...

"ORGPARTYPEO"."PARTY_TYPE": invalid identifier

logical SQL

set variable LOGLEVEL = 2;SELECT s_0, s_1, s_2, s_3, s_4 FROM (
SELECT
  0 s_0,
  "Marketing Segmentation Targets"."Contact"."Full Name" s_1,
  "Marketing Segmentation Targets"."Customer Organization Extension"."Extension Attribute Character 006" s_2,
  REPORT_COUNT("Marketing Segmentation Targets"."Contact"."Full Name" BY "Marketing Segmentation Targets"."Customer Organization Extension"."Extension Attribute Character 006") s_3,
  CAST(NULL AS INTEGER) s_4
FROM "Marketing Segmentation Targets"
WHERE
"Marketing Segmentation Targets"."Customer Organization Extension"."Extension Attribute Character 006" IS NOT NULL
UNION ALL
SELECT
  1 s_0,
  "Marketing Segmentation Targets"."Contact"."Full Name" s_1,
  "Marketing Segmentation Targets"."Customer Organization Extension"."Extension Attribute Character 006" s_2,
  CAST(NULL AS INTEGER) s_3,
  REPORT_COUNT("Marketing Segmentation Targets"."Contact"."Full Name" BY ) s_4
FROM "Marketing Segmentation Targets"
WHERE
("Marketing Segmentation Targets"."Customer Organization Extension"."Extension Attribute Character 006" IS NULL)
) djm ORDER BY 1, 3 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY
/* QUERY_SRC_CD='rawSQL' *

error in the nqquery log after the physical SQL is

[2013-11-22T06:12:05.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-34] [] [ecid: 004uvr^hSEs3NA15Rv0Fyd0000ao0005Xh,0:2:1:1:5] [tid: 4631d940] [requestid: ceb60008] [sessionid: ceb60000] [username: aloks] -------------------- Query Status: [nQSError: 17010] SQL statement preparation failed. [[

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