Query Action_status In Pay_assignment_actions Table

(Doc ID 2336215.1)

Last updated on JANUARY 09, 2018

Applies to:

Oracle Payroll - Version 12.1.2 and later
Information in this document applies to any platform.

Goal

Need to understand the significance of Action_status column in pay_assignment_actions table. See some duplicate records in the table with status as 'B'. While writing a query to fetch run results, is it advisable to fetch records with status as 'B'.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms