Search Results pay_za_tys_processes




Overview
Explore in AI Chat

Overview

The PAY_ZA_TYS_PROCESSES table is a Payroll (PAY) module object owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores information about each South African Tax Year Start (TYS) process that has been submitted, providing the control record that prevents duplicate TYS runs for the same payroll and tax year and that governs whether a rollback is permitted. Because the TYS process initializes payroll balances and statutory tax accumulators at the beginning of a South African tax year, the table acts as an audit and locking mechanism rather than a transaction or balance store.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as standalone within the Data Vault taxonomy. This suggests the table behaves as a hub-like control entity: it records the occurrence of a discrete business event (a TYS run) identified by a single surrogate key, with no documented foreign-key dependencies to other hubs or satellites. Modelers building a Data Vault layer should therefore treat it as an independent hub, with the payroll and consolidation set attributes retained as descriptive context.

Key Information Stored

The documented physical schema comprises four columns. The structure separates a system-generated surrogate identifier from the natural business key:

  • TYSP_ID — The surrogate primary key, enforced by the index PAY_ZA_TYS_PROCESSES_PK. It uniquely identifies each Tax Year Start process instance and is the column used for direct row retrieval and for referencing a specific run.
  • TAX_YEAR — The South African tax year for which the TYS process was executed. Along with the two columns below, it forms the unique business key.
  • PAYROLL_ID — Identifies the payroll definition to which the run applies, tying the control record to a specific payroll within the consolidation group.
  • CONSOLIDATION_SET_ID — Identifies the consolidation set under which the affected payrolls are grouped, ensuring the uniqueness constraint applies at the correct legislative grouping level.

The unique index PAY_ZA_TYS_PROCESSES_UK1 on (TAX_YEAR, PAYROLL_ID, CONSOLIDATION_SET_ID) is the enforcement point for the business rule that a given payroll and tax year combination cannot be processed twice. Any application logic that checks prior runs or blocks rollback resolves against this combination rather than against TYSP_ID.

Common Use Cases and Queries

The primary operational scenario is a pre-run validation: before a TYS process is launched, the payroll application queries this table to determine whether a record already exists for the target payroll, consolidation set, and tax year. A second scenario is rollback control, where the existence of a row conditions whether a reversal is offered.

A representative validation query is:

  • SELECT tysp_id FROM hr.pay_za_tys_processes WHERE tax_year = :p_tax_year AND payroll_id = :p_payroll_id AND consolidation_set_id = :p_consolidation_set_id;

For reporting, administrators commonly list all TYS runs for an audit period, joining the payroll identifier to the payroll name for readability:

  • SELECT p.tysp_id, p.tax_year, pp.payroll_name, p.consolidation_set_id FROM hr.pay_za_tys_processes p, hr.pay_all_payrolls_f pp WHERE p.payroll_id = pp.payroll_id ORDER BY p.tax_year, pp.payroll_name;

Because the table is small and control-oriented, it is frequently used in reconciliation reports that confirm every active South African payroll has a TYS record for the current tax year. Such reports highlight missing runs by comparing the payroll list against this table.

Related Objects

The metadata documents no foreign keys, consistent with the standalone classification, so relationships are functional rather than declarative. The most significant associated objects are:

  • PAY_ALL_PAYROLLS_F — joined on PAYROLL_ID to resolve the payroll name and legislative context.
  • PAY_PAYROLL_ACTIONS — records the concurrent process submission; TYS runs are initiated as payroll actions.
  • PAY_CONSOLIDATION_SETS — resolves CONSOLIDATION_SET_ID to its descriptive name.
  • PAY_ZA_TAX_YEAR_START (South African TYS concurrent program) — the executable that writes rows into this table.
  • PAY_ZA_BALANCES and related South African balance initialization objects — receive the accumulator updates that the TYS run performs.
  • FND_CONCURRENT_REQUESTS — the request log for the TYS process, correlated by request identifier for troubleshooting.

Together these objects support the end-to-end South African tax year initialization cycle, with PAY_ZA_TYS_PROCESSES serving as the authoritative record of which payroll and tax year combinations have already been opened.