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 and later
Oracle Fusion Global Payroll Cloud Service - Version and later
Information in this document applies to any platform.
This note was created for Release The note has been reviewed and is current for release


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.


 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.


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
 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?

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