My Oracle Support Banner

Fusion Global Payroll: How to Obtain List of Employee Payroll Actions and What Are ACTION_TYPE Meanings in PAY_PAYROLL_ACTIONS and PAY_PAYROLL_REL_ACTIONS Tables? (Doc ID 2169506.1)

Last updated on MARCH 20, 2024

Applies to:

Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.04.0 and later
Information in this document applies to any platform.
This note was created for Release 11.1.8.0.0. The note has been reviewed and is current for release 11.13.20.04.0.

Purpose

The purpose of this document is to provide a guidance in how to obtain:

1. Employee run results from Fusion Payroll tables PAY_PAYROLL_ACTIONS and PAY_PAYROLL_REL_ACTIONS, and

2. Understand meaning of codes of payroll actions.

Scope

 This document can be used as a guide by Functional as well as Technical Users, Support Engineers and others to get employee run results from Fusion Payroll.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 What sqls can be run to select payroll actions that were processes on an employee?
 What payroll ACTION_TYPE mean in PAY_PAYROLL_ACTIONS table?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.