Results for “applied_category”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PAY_JP_GEPPEN_SANTEI_V view is a Japanese statutory reporting object within the Oracle E-Business Suite Payroll (PAY) module, owned by the APPS schema and presenting a status of VALID in the documented 12.2.2 metadata. Its purpose is to supply the data set required for the Japanese Geppen Santei report, a monthly social insurance and pension premium determination that employers must file with the relevant authorities. The view does not materialise data; rather it derives a consolidated, month-based result set from payroll run transactions, element entry values, and organization-related reporting information inputs, returning computed indicators such as SI_TYPE, HI_NUMBER, WP_NUMBER, and OUTPUT_FLAG. Because Geppen Santei reporting is sensitive to element set composition, assignment-level entries, and effective dates, the view acts as a pre-joined projection over the core payroll tables, shielding the statutory report output from the complexity of those joins.
Underlying Base Objects
The documented base objects referenced by this view are PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_LINK_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, and DUAL, together with the database packages PAY_JP_BALANCE_PKG and PAY_JP_REPORT_PKG. The view is structured around an outer join of PAY_PAYROLL_ACTIONS (PPA) and PAY_ASSIGNMENT_ACTIONS (PAA), which anchor each row to a payroll run and assignment action. Element entry headers and their associated flexfield value rows are then joined through PAY_ELEMENT_ENTRIES_F and multiple aliases of PAY_ELEMENT_ENTRY_VALUES_F to retrieve the applied month, applied category, organization, and social insurance number entries. The ORDERED and USE_NL hints, combined with a series of function-based indexes, indicate that the design anticipates nested-loop execution against indexed payroll access paths. The PAY_JP_REPORT_PKG.GET_SI_REC_ID function resolves statutory reporting input value identifiers, while PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_CHAR supplies the output flag value for each assignment.
Key Columns
ASSIGNMENT_ACTION_ID— the primary action identifier established by the assignment action row.ASSIGNMENT_ID,BUSINESS_GROUP_ID,PAYROLL_ID,CONSOLIDATION_SET_ID— identifying and organizational attributes carried through from the payroll action context.DATE_EARNED,EFFECTIVE_DATE— the earning date and effective date used for monthly determination.APPLIED_CATEGORY— the applied element category, defaulting to'O'where no screen entry value exists.ORGANIZATION_ID— the organization associated with the reported entry, defaulting to-1.HI_NUMBER,WP_NUMBER— the health insurance and welfare pension reference numbers, truncated to ten bytes.SI_TYPE— a derived indicator summing HI, WP, and WPF organization input values to classify the social insurance record type.OUTPUT_FLAG— a character flag sourced through the balance package, defaulting to'N'.ELEMENT_SET_ID,APPLIED_MONTH— the element set context and the month to which the entry applies.
Common Use Cases and Queries
The view is typically queried by the Geppen Santei statutory report process, but it can also be used within ad hoc reconciliation and audit scripts. A representative query filters output by month and organization:
SELECT assignment_id, organization_id, si_type, hi_number, wp_number, output_flag, applied_month FROM apps.pay_jp_geppen_santei_v WHERE applied_month = '2024-09' AND element_set_id = :p_element_set_id ORDER BY organization_id, assignment_id;
Reconciliation queries frequently validate that HI_NUMBER and WP_NUMBER are populated for each assignment with an OUTPUT_FLAG of 'Y', while diagnostic queries inspect rows with a default SI_TYPE or ORGANIZATION_ID of -1. Because the view resolves values through package functions, results are sensitive to the effective date and to the input value identifiers defined in the reporting setup; testing should therefore be performed against a consistent payroll period and element set.
-
View: PAY_JP_GEPPEN_SANTEI_V 12.1.1
This view is used by Japanese statutory report of GEPPEN SANTEI.
APPS.PAY_JP_GEPPEN_SANTEI_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_ENTRIES_F·↳ PAY_ELEMENT_ENTRY_VALUES_F·Explore PAY module →
-
View: PAY_JP_GEPPEN_SANTEI_V 12.2.2
This view is used by Japanese statutory report of GEPPEN SANTEI.
APPS.PAY_JP_GEPPEN_SANTEI_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_ENTRIES_F·↳ PAY_ELEMENT_ENTRY_VALUES_F·Explore PAY module →
-
PAY_JP_GEPPEN_SANTEI_MT_V is used by Japanese statutory report of GEPPEN SANTEI for magtape file
APPS.PAY_JP_GEPPEN_SANTEI_MT_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_ENTRIES_F·↳ PAY_ELEMENT_ENTRY_VALUES_F·Explore PAY module →
-
PAY_JP_GEPPEN_SANTEI_MT_V is used by Japanese statutory report of GEPPEN SANTEI for magtape file
APPS.PAY_JP_GEPPEN_SANTEI_MT_V·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_ELEMENT_ENTRIES_F·↳ PAY_ELEMENT_ENTRY_VALUES_F·Explore PAY module →
-
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.