Error While Generating Audience Through PS Query (Doc ID 2088672.1)

Last updated on JULY 16, 2017

Applies to:

PeopleSoft Enterprise CRM Marketing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : CRM 9.2

When attempting to generate Audience through PS Query, the following error occurs.


ERROR
-----------------------
"isConnectedQuery field can only be Y or N (228,123) RA_QAS_FRAMEWORK.ExecuteQuery.OnExecute Name:ExecuteQueryViaQAS PCPC:3843 Statement:48
Called from:RA_QAS_WRK.RA_QAS_AB_QRY.FieldChange Statement:15

isConnectedQuery field can only be Y or N"



STEPS
-----------------------

1. Navigate to Main Menu > Marketing > Manage Audience
2. Create new audience, change the Audience source to 'Internal using PS Query'. Select a query and and click on execute Query



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