Results for “pay_au_soe_run_elements_v”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_AU_SOE_RUN_ELEMENTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the PAY (Payroll) product family and identified in ETRM metadata as an Australian localisation view. Its purpose is to consolidate payroll run results into the element-level structure required by the Australian Statement of Earnings (SOE) and related statutory reporting obligations. Rather than presenting raw payroll balances, the view filters and reshapes payroll run results through the element classification framework, applying Australian-specific naming conventions and superannuation fund resolution logic.
The view is defined with a nested, set-based SQL statement that applies DISTINCT at an inner level and then aggregates with SUM on AMOUNT and HOURS, with RATE rounded to two decimals via TRUNC. A notable characteristic of the definition is its dependence on PEC2.CLASSIFICATION_NAME — the classification_name column — which drives conditional branching throughout the SELECT list. When the classification is EMPLOYER SUPERANNUATION CONTRIBUTION, the view substitutes the literal value '-999' for the row identifier and derives the element display name through the PAY_AU_SOE_PKG.SUPER_FUND_NAME function; for all other classifications, standard PAY_ELEMENT_TYPES_F reporting names are used.
Underlying Base Objects
ETRM metadata documents the view as being defined over the following base objects, resolved through APPS-owned synonyms: PAY_ACTION_INTERLOCKS, PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_SUB_CLASSIFICATION_RULES_F, and PER_ALL_ASSIGNMENTS_F. A PL/SQL package, PAY_AU_SOE_PKG, is additionally referenced as an object dependency and is invoked directly within the view body.
The principal fact source is PAY_RUN_RESULTS (aliased PRR in the view text), which supplies row identifiers, source identifiers, element entry identifiers, and amounts. PAY_ELEMENT_CLASSIFICATIONS (PEC and PEC2) provides the classification_name that governs the view's conditional logic, while PAY_ELEMENT_TYPES_F (PET) supplies REPORTING_NAME and ELEMENT_NAME. PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INTERLOCKS, and PAY_PAYROLL_ACTIONS supply the run and assignment-action context used for date and business-group derivation, and PER_ALL_ASSIGNMENTS_F anchors rows to assignment-level attributes. PAY_RUN_RESULT_VALUES and PAY_INPUT_VALUES_F support the hours and rate figures, and PAY_SUB_CLASSIFICATION_RULES_F participates in classification resolution.
Key Columns
- ROW_ID — identifier carried from PET.ROWID, or the literal '-999' when the row is an employer superannuation contribution.
- ELEMENT_NAME / REPORT_NAME — the element label presented on the SOE; for superannuation contributions, resolved through PAY_AU_SOE_PKG.SUPER_FUND_NAME, otherwise NVL(PET.REPORTING_NAME, PET.ELEMENT_NAME).
- LABEL — a derived categorisation string built from classification_name inspections, producing values such as TAXABLE EARNINGS, NON TAXABLE EARNINGS, DIRECT PAYMENTS, TAX DEDUCTIONS, POST TAX DEDUCTIONS, and EMPLOYER SUPERANNUATION CONTRIBUTION.
- AMOUNT — summed monetary value for the grouped element.
- HOURS — summed hours where hours-bearing elements are present.
- RATE — TRUNC(RATE, 2), the per-unit rate rounded to two decimal places.
- PROCESSING_PRIORITY — the element processing order.
- RUN_ASSIGNMENT_ACTION_ID / ASSIGNMENT_ID — keys linking the row to a payroll run action and an assignment.
Common Use Cases and Queries
The view is used to produce element-level earnings breakdowns for Australian payroll reporting, audits of superannuation contributions, and reconciliation between payroll run results and the Statement of Earnings output. A query retrieving categorised earnings for a given run action follows:
SELECT element_name, label, amount, hours, rate FROM apps.pay_au_soe_run_elements_v WHERE run_assignment_action_id = :p_action_id ORDER BY processing_priority;SELECT label, SUM(amount) FROM apps.pay_au_soe_run_elements_v WHERE assignment_id = :p_assignment_id GROUP BY label;SELECT element_name, amount FROM apps.pay_au_soe_run_elements_v WHERE label = 'EMPLOYER SUPERANNUATION CONTRIBUTION';
Because the view aggregates with SUM and applies DISTINCT internally, consumers should treat it as a reporting surface rather than a transactional one, and should not expect one row per run result. Filters on ASSIGNMENT_ID or RUN_ASSIGNMENT_ACTION_ID preserve the intended grouping grain and give predictable results.
-
Australian localisation view.
APPS.PAY_AU_SOE_RUN_ELEMENTS_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_AU_SOE_PKG·Explore PAY module →
-
Australian localisation view.
APPS.PAY_AU_SOE_RUN_ELEMENTS_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_AU_SOE_PKG·Explore PAY module →
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.