You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue SQL Timing Out for ProcessedTimeEntryPVO and HistoricProcessedTimeEntryPVO

in HCM Integrations

Hi All,

I'm trying to retrieve source record counts for the following HCM PVOs using Issue SQL, but the query is consistently timing out. I suspect this is due to the large data volume in these objects.

PVOs:

  1. HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ProcessedTimeEntryPVO
  2. HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.HistoricProcessedTimeEntryPVO

Issue SQL Used:

select count(*) from (
select  * from 
EXTERNAL('ADF', '"oracle.apps.hcm.model.analytics.applicationModule.HcmTopModelAnalyticsGlobalAM_HcmTopModelGlobalAMLocal"."Connection Pool"').'HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ProcessedTimeEntryPVO' as t) b

Has anyone encountered a similar issue with these high-volume PVOs? If so, were you able to identify a workaround or an alternative approach to obtain source record counts?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!