My Oracle Support Banner

BICCC Extract Failed After 19D Upgrade for the PVO HNSInvestigationPVO [nQSError: 17001] Oracle Error code: 972, message: ORA-00972: identifier is too long (Doc ID 2611827.1)

Last updated on FEBRUARY 04, 2021

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.10.0 version, Technology Management - Reports/Analytics

When attempting to run an extract for HNSInvestigationPVO, the following error occurs:

ERROR
-----------------------
[2019-11-16T21:26:42.689+00:00] [bi_server1] [ERROR] [] [oracle.obiacm.dataExtract.BIVOExtractTask] [tid: 20] [ecid: 0000MtpOOvi6MQ_LlQL6iZ1Tnt9700017N,1:32651] [APP: oracle.biacm#11.1.1] [ESS_JobMetadataID: JobDefinition://oracle.apps.ess.biccc/BICloudConnectorJobDefinition] [ESS_RequestID: 1056977] [ESS_Module: Processor] HcmTopModelAnalyticsGlobalAM.HealthandSafetyAM.HNSInvestigationPVO - DataExtractQuery: Attempt=3, QueryExecTime=59ms, QueryExecTimeLimit=60000ms, Failed Query: set variable DISABLE_RIGHTTRIM_FOR_VARCHAR=1,OBIS_DBFEATURES_DEFAULT_BULK_FETCH_ROW_COUNT=1000,OBIS_DBFEATURES_MAX_BULK_FETCH_BUFFER_SIZE=3145728;select_physical t.ActualComletionDateDerived,t.DeriviedIncidentID,t.HNSInvestFindingsPEOCreatedBy,t.HNSInvestFindingsPEOCreationDate,t.HNSInvestFindingsPEODeletedFlag,t.HNSInvestFindingsPEOFindingId,t.HNSInvestFindingsPEOFindingIssueFlag,t.HNSInvestFindingsPEOFindingNotes,t.HNSInvestFindingsPEOFindingResponse,t.HNSInvestFindingsPEOFindingSummary,t.HNSInvestFindingsPEOInvestigateId,t.HNSInvestFindingsPEOLastUpdateDate,t.HNSInvestFindingsPEOLastUpdateLogin,t.HNSInvestFindingsPEOLastUpdatedBy,t.HNSInvestFindingsPEOSeverityLevelCode,t.HNSInvestFindingsPEObjectVersionNumber,t.HNSInvestRecommendsPEOActionFlag,t.HNSInvestRecommendsPEOCreatedBy,t.HNSInvestRecommendsPEOCreationDate,t.HNSInvestRecommendsPEODeletedFlag,t.HNSInvestRecommendsPEOFindingId,t.HNSInvestRecommendsPEOLastUpdateDate,t.HNSInvestRecommendsPEOLastUpdateLogin,t.HNSInvestRecommendsPEOLastUpdatedBy,t.HNSInvestRecommendsPEOObjectVersionNum,t.HNSInvestRecommendsPEORecommendId,t.HNSInvestRecommendsPEORecommendSuggFlag,t.HNSInvestRecommendsPEORecommendSummary,t.HNSInvestigationsSummaryPEOActComDate,t.HNSInvestigationsSummaryPEOActionRequirdFlag,t.HNSInvestigationsSummaryPEOCompletedFlag,t.HNSInvestigationsSummaryPEOCreatedBy,t.HNSInvestigationsSummaryPEOCreationDate,t.HNSInvestigationsSummaryPEODeletedFlag,t.HNSInvestigationsSummaryPEOFindFinalResp,t.HNSInvestigationsSummaryPEOFindingComnt,t.HNSInvestigationsSummaryPEOIncdntDetId,t.HNSInvestigationsSummaryPEOIncidentId,t.HNSInvestigationsSummaryPEOInvAprEmlFlg,t.HNSInvestigationsSummaryPEOInvPreEmlFlg,t.HNSInvestigationsSummaryPEOInvRevEmlFlg,t.HNSInvestigationsSummaryPEOInvSummary,t.HNSInvestigationsSummaryPEOInvTypeCode,t.HNSInvestigationsSummaryPEOInvestOwnerId,t.HNSInvestigationsSummaryPEOInvestStatCd,t.HNSInvestigationsSummaryPEOInvestigateDescr,t.HNSInvestigationsSummaryPEOInvestigateDt,t.HNSInvestigationsSummaryPEOInvestigateId,t.HNSInvestigationsSummaryPEOInvestigateNo,t.HNSInvestigationsSummaryPEOLastUpdateDt,t.HNSInvestigationsSummaryPEOLastUpdatedBy,t.HNSInvestigationsSummaryPEOLastUpdtLog,t.HNSInvestigationsSummaryPEOLsnsLearned,t.HNSInvestigationsSummaryPEOObjVerNum,t.HNSInvestigationsSummaryPEOQuestionId,t.HNSInvestigationsSummaryPEOTarCompDate,t.InvestigationCreateDateDerived,t.InvestigationDateDerived,t.TargetCompletionDateDerived from "HcmTopModelAnalyticsGlobalAM.HealthandSafetyAM.HNSInvestigationPVO" as t where (t.HNSInvestFindingsPEOLastUpdateDate >= TIMESTAMP '2019-11-13 22:14:45' or t.HNSInvestRecommendsPEOLastUpdateDate >= TIMESTAMP '2019-11-13 22:14:45' or t.HNSInvestigationsSummaryPEOLastUpdateDt >= TIMESTAMP '2019-11-13 22:14:45')[[
java.sql.SQLException: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 17001] Oracle Error code: 972, message: ORA-00972: identifier is too long

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
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.