Search Results assignment_action_id_payroll

Overview

PAY_KR_ASG_ACTIONS_V is an APPS-owned reporting view in the Oracle E-Business Suite Payroll (PAY) module, oriented specifically toward Korean localization requirements. It consolidates assignment-level payroll action data, employee and assignment attributes, payroll run identifiers, and Korean establishment and grade classifications into a single denormalized structure. Its primary role is to support statutory and internal reporting where an assignment's payment event must be linked to the payroll action that produced it, the underlying payroll and run type, and the associated legal establishment (business place registration) in Korea.

A defining characteristic of the view is its exposure of a column literally named PAID_DATE. This column is sourced from PPA.EFFECTIVE_DATE on the PAY_PAYROLL_ACTIONS record, meaning it represents the effective date of the payroll action rather than a stored payment date attribute. This distinction is important: the user query term "paid_date" maps here to a derived alias. The view restricts rows to completed, relevant actions—payroll actions with ACTION_STATUS 'C' and ACTION_TYPE in ('R','Q'), and the paired assignment-level or prepayment actions with status 'C' and type in ('P','U')—so it returns only successfully processed payroll events.

Underlying Base Objects

The view is defined over a join across payroll, people, and HR organization objects. Documented base objects include PAY_PAYROLLS_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_TYPES_F, PAY_ACTION_INTERLOCKS, PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_GRADES_TL, PER_KR_GRADES, PER_TIME_PERIODS, HR_ORGANIZATION_INFORMATION, and the HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages. In 12.2.2 the owner is APPS, with PAY_PAYROLLS_F, PER_ASSIGNMENTS_F, and PER_PEOPLE_F resolved as views and the remaining payroll/HR objects accessed through synonyms.

The central join links PAY_PAYROLLS_F to PAY_PAYROLL_ACTIONS, then to PAY_ASSIGNMENT_ACTIONS, PER_ASSIGNMENTS_F, and PER_PEOPLE_F. A derived inline subquery on PAY_ACTION_INTERLOCKS (grouped by LOCKING_ACTION_ID, taking MAX(LOCKED_ACTION_ID)) resolves action interdependencies. HR_ORGANIZATION_INFORMATION is filtered to organization context 'KR_BUSINESS_PLACE_REGISTRATION', supplying the Korean establishment name. Grade descriptions are outer-joined from PER_GRADES_TL and PER_KR_GRADES, with the language predicate tied to USERENV('LANG').

Key Columns

• PAID_DATE — aliased from PPA.EFFECTIVE_DATE; the effective date of the payroll action.
• ASSIGNMENT_ACTION_ID / ASSIGNMENT_ACTION_ID_PAYROLL — assignment action identifiers from the two PAY_ASSIGNMENT_ACTIONS instances.
• PAYROLL_ACTION_ID / PAYROLL_ACTION_ID_PAYROLL — payroll action identifiers linking the payroll context.
• FIRST_NAME, LAST_NAME, ORDER_NAME, EMPLOYEE_NUMBER — person identifiers from PER_PEOPLE_F.
• ASSIGNMENT_NUMBER, ASSIGNMENT_ID — assignment identity from PER_ASSIGNMENTS_F.
• PAYROLL_ID, PAYROLL_NAME, RUN_TYPE_NAME — payroll and run type context.
• HIRE_DATE — aliased from PAP.START_DATE.
• START_DATE, END_DATE — time period boundaries from PER_TIME_PERIODS.
• ORGANIZATION_ID, ESTABLISHMENT_NAME — Korean business place registration details.
• GRADE, KR_GRADE — grade description and Korean grade name.

Common Use Cases and Queries

Typical scenarios include reconciling payroll actions against assignments for a pay period, reporting payment events by establishment, and auditing Korean grade and payroll classifications. The following sample retrieves payment events for a given assignment within a period:

• SELECT employee_number, order_name, payroll_name, run_type_name, paid_date, start_date, end_date, establishment_name, grade, kr_grade FROM apps.pay_kr_asg_actions_v WHERE assignment_id = :p_assignment_id AND paid_date BETWEEN :p_start AND :p_end;

Because PAID_DATE reflects the payroll action effective date, queries filtering on payment timing should join to PAY_PAYROLL_ACTIONS for precision. The view's completed-action and Korean establishment filters mean results are limited to processed events tied to valid KR business place registrations.