My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

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' *



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.