Search Results per_cagr_requests_pk

Overview

PER_CAGR_REQUESTS is a Human Resources (PER) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The acronym CAGR refers to Collective Agreement, the framework under which entitlements, accruals, and related calculations are governed by negotiated labor agreements. This table functions as the master record of a collective agreement processing request. Each row represents a single request initiated by a user or concurrent program to run a collective agreement entitlement calculation, committing the results and logging the activity against the request identifier.

The table acts as a control and header record that orchestrates downstream processing, and the metadata classifies it heuristically as standalone within a Data Vault modeling suggestion. In practice, it behaves most like a hub or transaction header: it carries its own surrogate primary key, is referenced by child tables capturing entitlement results and log entries, and holds descriptive foreign keys to the governing agreement rather than being a pure satellite of another entity.

Key Information Stored

The documented physical schema contains fourteen columns. The most significant are:

• CAGR_REQUEST_ID — the surrogate primary key (constraint PER_CAGR_REQUESTS_PK), uniquely identifying each collective agreement request.
• PROCESS_DATE — the date the request was processed or is scheduled to be processed.
• OPERATION_MODE — indicates the mode of operation for the request, typically distinguishing calculation-only runs from calculation-with-commit runs.
• BUSINESS_GROUP_ID — the enterprise business group context under which the request executes.
• ASSIGNMENT_ID — the specific assignment targeted by the request, where the request is scoped to a single assignment.
• ASSIGNMENT_SET_ID — identifies a set of assignments when the request covers a group rather than one individual.
• COLLECTIVE_AGREEMENT_ID — foreign key to PER_COLLECTIVE_AGREEMENTS, identifying the governing collective agreement.
• COLLECTIVE_AGREEMENT_SET_ID — identifies a set of collective agreements processed in the run.
• PAYROLL_ID — the payroll context for the request.
• CAGR_ENTITLEMENT_ITEM_ID — the entitlement item being evaluated.
• PERSON_ID — the person associated with the request.
• COMMIT_FLAG — controls whether calculated results are committed to the database.
• DENORMALISE_FLAG — governs whether results are written in denormalized form.
• PARENT_REQUEST_ID — a self-referencing pointer linking a request to a parent request, supporting request hierarchies or reprocessing chains.

The surrogate key is CAGR_REQUEST_ID; no separate unique business-key index is documented in the provided metadata.

Common Use Cases and Queries

Typical uses include auditing processing history, diagnosing failed or incomplete runs, and reporting on collective agreement activity. A representative query retrieves requests with their governing agreement and processing date:

• SELECT r.CAGR_REQUEST_ID, r.PROCESS_DATE, r.OPERATION_MODE, r.COMMIT_FLAG, a.COLLECTIVE_AGREEMENT_ID FROM PER_CAGR_REQUESTS r JOIN PER_COLLECTIVE_AGREEMENTS a ON r.COLLECTIVE_AGREEMENT_ID = a.COLLECTIVE_AGREEMENT_ID WHERE r.BUSINESS_GROUP_ID = :p_bg_id;
• Filtering by PROCESS_DATE to isolate runs within a payroll period.
• Joining to PER_CAGR_ENTITLEMENT_RESULTS on CAGR_REQUEST_ID to review calculated entitlements.
• Joining to PER_CAGR_LOG on CAGR_REQUEST_ID to trace messages and errors.
• Using PARENT_REQUEST_ID to trace reprocessing lineage where a request supersedes an earlier one.

Related Objects

The following objects are most significant to this table:

• PER_COLLECTIVE_AGREEMENTS — referenced via COLLECTIVE_AGREEMENT_ID; the parent agreement definition.
• PER_CAGR_ENTITLEMENT_RESULTS — child table referencing this table via CAGR_REQUEST_ID; stores calculated entitlement outcomes.
• PER_CAGR_LOG — child table referencing this table via CAGR_REQUEST_ID; captures processing log entries.
• PER_ALL_ASSIGNMENTS_F — source of assignment context referenced through ASSIGNMENT_ID.
• PER_ALL_PEOPLE_F — source of person context referenced through PERSON_ID.
• PAY_ALL_PAYROLLS_F — payroll context referenced through PAYROLL_ID.

Collectively these relationships position PER_CAGR_REQUESTS as the header and control point for collective agreement processing within Oracle EBS Human Resources.