After CS 9.2 Upgrade, SCC_COMMGEN Generates the Following Error: Error in Opening Query QA_CS_AVAK_ORG_DS (50,220) (Doc ID 2197988.1)

Last updated on OCTOBER 27, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

When trying to run Communication Generation after CS 9.2 upgrade, get the following message:

Error in opening query QA_CS_AVAK_ORG_DS (50,220)

Error opening the PS Query (14015,6) SCC_COMMGEN.Model.DSAdapters.PSQueryAdapter.OnExecute Name:Validate PCPC:772 Statement:14

Called from:SCC_COMMGEN.Model.CommGen.OnExecute Name:InitializeCommGenDS Statement:559

Called from:SCC_COMMGEN.Model.CommGen.OnExecute Name:ExtractData Statement:210

Called from:SCC_COMMGEN.Model.CommGen.OnExecute Name:GenerateXMLExtractForCommPart Statement:143

Called from:SCC_COMMGEN.GenXMLDS.GBL.default.1900-01-01.Step10.OnExecute Statement:5 (0,0)

Error Generating Communication for COMMON_ID: ########, SEQ_3C: ##, CG_SEQ: %3 (14015,3145)

CommGen Aborting (14015,3163)

 

Solution

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