Search Results ies_svy_cycles_all




Overview
Explore in AI Chat

Overview

The IES_SVY_CYCLES_ALL table is a core transactional and configuration object within the IES – Scripting product module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It stores survey cycle information, capturing the individual execution instances or "cycles" defined for a survey. In the Oracle EBS data model, this table acts as the central repository that links a reusable survey definition to the specific periods, campaigns, and deployment rules under which respondents are invited to participate. The table resides in the IES schema and is classified as VALID.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure indicates that IES_SVY_CYCLES_ALL is hub-leaning. This suggests the table behaves primarily as a business entity hub, holding one durable record per survey cycle keyed by a stable surrogate identifier. Rather than functioning purely as a link between related entities or a satellite holding only descriptive change history, it defines the cycle as a discrete, identifiable business concept referenced by downstream deployment and statistics objects.

Key Information Stored

The table contains 32 documented columns. The most significant of these are summarized below.

Common Use Cases and Queries

Typical scenarios include listing active cycles for a given survey, identifying cycles awaiting a minimum response count, and reporting on cycle ownership by operating unit. A representative query joining cycles to their parent survey is:

SELECT c.SURVEY_CYCLE_ID, c.SURVEY_CYCLE_NAME, c.CYCLE_STATUS_CODE,
       s.SURVEY_NAME
FROM   IES_SVY_CYCLES_ALL c,
       IES_SVY_SURVEYS_ALL s
WHERE  c.SURVEY_ID = s.SURVEY_ID
AND    c.F_DELETEDFLAG = 'N'
AND    c.ORG_ID = :p_org_id;

Reporting use cases include cycle participation analytics, minimum-response compliance tracking, and auditing of cycle creation and modification activity using the standard audit columns.

Related Objects

The following objects are the most significant dependents and references.

  • IES_SVY_SURVEYS_ALL — Parent survey definition; joined on IES_SVY_CYCLES_ALL.SURVEY_ID.
  • IES_SVY_DEPLYMENTS_ALL — Deployment records referencing this table via SURVEY_CYCLE_ID.
  • IES_SVY_SUMMARY_STATS — Aggregated statistics referencing cycles via SURVEY_CYCLE_ID.
  • FND_SECURITY_GROUPS — Security group reference via SECURITY_GROUP_ID.

These relationships establish IES_SVY_CYCLES_ALL as the pivotal entity connecting survey definitions to their deployments and resulting summary statistics.