eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
TABLE: HR.PAY_ASSIGNMENT_ACTIONS
Object details.
PAY_ASSIGNMENT_ACTIONS holds information about the effects of processing on specific assignments. An assignment action is one instance of an assignment for a particular process. For example, when an assignment has been processed by a payroll run a row is created to identify the action applied to the assignment. Importantly, the existence of a row in this table indicates that some processing, or at least inclusion in the payroll run, has taken place. The ACTION_STATUS indicates whether it processed successfully, unsuccessfully, or not at all.
Storage Details
Primary key: pay_assignment_actions_pk, foreign keys.
Cut, paste (and edit) the following text to query this object:
Dependencies
[top of page]
- Privacy Policy
- Ask Question
- Fun at work
- Oracle Cloud Absence Management
- Oracle Compensation Management (CWB)
- Oracle Cloud Global HR
- Oracle Learning Cloud
- Oracle Cloud Profile Management
- Oracle Cloud Performance Management
- Oracle Cloud Goal Management
- Succession Management and Talent Pool
- Oracle Cloud Talent Review
- Oracle Cloud Touchpoints
- All Talent Management Articles
- Oracle Time and Labor (OTL)
- Oracle Recruiting Cloud (ORC)
- Oracle Cloud HCM
- Oracle Cloud HCM Common Issues
- Oracle Cloud HCM Interview Questions
- Oracle Cloud Approval Workflow
- Oracle Cloud Fast Formula
- Oracle Reports and Alerts
- Oracle Cloud Reusable Queries
- All Articles
Oracle Payroll Actions : Query to identify all payroll actions
Oracle Payroll Actions
Following query can be used to retrieve all payroll actions against any assignment. Do not forget to Change the assignment number. “ pay_payroll_actions ” table holds the value but only the code. Decode function needs to be used to get the meaning.
SQL query to retrieve oracle payroll actions for any assignments
SELECT paf.person_id, ppa.effective_date, ppa.action_type, ppa.action_status, DECODE (ppa.action_type, ‘R’, ‘Payroll Run’, ‘Q’, ‘Quickpay’, ‘C’, ‘Costing’, ‘D’, ‘Void’, ‘A’, ‘Cash’, ‘B’, ‘Balance Adj’, ‘E’, ‘Manual Pay’, ‘F’, ‘Advance Pay’, ‘G’, ‘Action Retropay’, ‘H’, ‘Cheque’, ‘I’, ‘Balance Init’, ‘N’, ‘Non Tracked’, ‘M’, ‘BACs’, ‘X’, ‘End of YEAR’, ‘V’, ‘Reversal’, ‘T’, ‘Trasfer to GL’, ‘P’, ‘Prepay’, ‘O’, ‘Retropay’, ‘U’, ‘Q Prepay’, ‘Z’, ‘Purge’ ) TYPE, DECODE (ppa.action_status, ‘C’, ‘Complete’, ‘E’, ‘Error’, ‘I’, ‘Incomplete’, ‘M’, ‘Retry’, ‘P’, ‘Processing’, ‘U’, ‘Unprocessed’ ) status, ppa.payroll_action_id, ppa.action_type, ppa.business_group_id, ppa.payroll_id, ppa.org_payment_method_id, ppa.payment_type_id, ppa.action_status, ppa.request_id, ppa.start_date, ppa.date_earned, ppa.display_run_number, ppa.pay_advice_date, ppa.run_type_id, ppa.end_date, ppa.future_process_mode FROM apps.pay_payroll_actions ppa, apps.pay_assignment_actions paa, apps.per_assignments_f paf [su_highlight background=”#cd2122″]WHERE paf.assignment_id = 14142–‘&assignment_id'[/su_highlight] AND paf.assignment_id = paa.assignment_id AND paa.payroll_action_id = ppa.payroll_action_id ORDER BY ppa.effective_date
Related Posts
Oracle Fusion (Cloud) Reusable SQL Queries
OTL timecard/timesheet query to fetch submitted/approved hours
Don't stop, continue to gain knowledge.
Improve your Alexa Ranking of website with these 5 easy steps
The training partner you can trust.
Trending Posts
- Oracle Cloud HCM Functional
Enhancing Learner Experience: A Guide to Category and Topic Communities
Learn to Configure and Use Self-Service Community
Learn to Configure Specialization (Learning Path) In Oracle Learning Cloud
Learn to Configure and Use Course Prerequisite in Oracle Learning Cloud
© 2023 iavinash.com - Learn Oracle Fusion HCM for free iavinash .
- Manage VIP Account
- Register for VIP Plan
- VIP Member-Only Content
- HCM Data Loader
- HCM Extract
- BI Publisher
- Fast Formula
- OTBI Analytics
- Personalizations
- Scheduled Processes
- Absence Management
- Performance Management
- Talent Management
- Time & Labor
- HCM Extracts Questions
- HCM Data Loader Questions
- BI Reports Questions
- Report Issues/suggestions
- Your Feedback counts
- Write for Us
- Privacy Policy
- Join Telegram Group
- Join LinkedIn Group
- Join Facebook Page
Payroll Actions and their usage in Fusion
- Post category: Others
- Post comments: 0 Comments
- Post last modified: August 24, 2020
- Reading time: 3 mins read
In this article we will look into the list of all payroll actions and their significance. We will also look into how to retrieve all of these payroll actions using a SQL Query at the end of the article.
ACTION_TYPE field on PAY_PAYROLL_ACTIONS table will store the payroll action information.
The most common Action Types used are for Payroll Processing: R – Payroll Run, Q – Quick Pay, V – Reversal, B – Balance Adjustment.
SQL Query to get this list of Payroll Actions:
For every payroll process or extract run, an entry will be added to this PAY_PAYROLL_ACTIONS table for the corresponding Action Type. PAYROLL_ACTION_ID is the unique key which when joined to other tables will provide more details on the process details.
You Might Also Like
How to Audit Configure HCM Data Loader parameters?
Core HR Workforce Structures Table Relationships
FREE Oracle Training & Accreditation with Oracle Learning Explorer
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Payroll does not deal with a lot of tables, in comparison with other modules like Benefits / Core-HR. So the idea was to go through the functional set ups first and then look at the technical aspects, and peep through the tables.
PAY_ELEMENT_TYPES_F : No need to say, that this is a date track enabled table. This table stores the details about all the elements in the system. The Primary key is ELEMENT_TYPE_ID and the two date fields. This is usually used to get the name of the element, as ELEMENT_TYPE_ID is used in a lot of places to refer to the element.
PAY_ELEMENT_LINKS_F : This one is date track enabled as well. This one stores the details on the links. The primary key is: ELEMENT_LINK_ID and the two date tracked columns, stores the ELEMENT_TYPE_ID as the foreign key.
PAY_INPUT_VALUES_F : This table stores the Input values for each element. This is the Date track enabled table. The primary key is INPUT_VALUE_ID and the two date tracked columns. This table also holds the ELEMENT_TYPE_ID as a foreign key to PAY_ELEMENT_TYPES_F. This can be used to pull in the Element input value name.
PAY_ELEMENT_ENTRIES_F : This is another Date tracked table. This one stores the details about the element entries. The table stores the Entries with the ASSIGNMENT_ID and the ELEMENT_LINK_ID as foreign key. The Primary key is ELEMENT_ENTRY_ID. This table also links itself to PAY_ELEMENT_TYPES_F with storing ELEMENT_TYPE_ID as a foreign key.
PAY_ELEMENT_ENTRY_VALUES_F : This date track enabled table stores the values for each entry. This table has only 6 columns. Out of which, the Primary key is: ELEMENT_ENTRY_VALUE_ID and the two date tracked columns, it stores the ELEMENT_ENTRY_ID as the foreign key to PAY_ELEMENT_ENTRIES_F and the SCREEN_ENTRY_VALUE stores the actual value of the Input Value. The INPUT_VALUE_ID column links the table to the Input values table (PAY_INPUT_VALUES_F).
PAY_PAYROLL_ACTIONS : This table logs all the actions taken by the Payroll Engine. Primary key is PAYROLL_ACTION_ID, and it logs in each and every activity. The Table is capable enough to store a lot of information as it has got columns to store all kind of data used in Payroll; although it does not populate all the columns / row. However it logs in only the ones those are needed.
PAY_RUN_RESULTS : This table stores the status related to the elements against the assignment actions. The primary key is RUN_RESULT_ID. ELEMENT_TYPE_ID and ASSIGNMENT_ACTION_ID are the two other important foreign keys.
PAY_RUN_RESULT_VALUES : This table takes the RUN_RESULT_ID and the INPUT_VALUE_ID and stores the Value obtained by the Payroll Engine.
So these were the important tables in Payroll. However here is a list of few others, which are use very frequently.
- In the table below, if the Date tracked column is marked as Yes, assume the Primary key to be Composite. The given Primary with bind with the two date tracked columns to make the Composite Primary key.
- The below table is in Alphabetical order.
- Some of the values in the column Table could be a view / synonym. However they pull data. That's what we want right? :)
- Payroll Insight
The following table lists objects (tables) of the Payroll Insight for Oracle
- Authorizations Insight specific objects
- Process Insights specific objects
- System Configuration Insight
- Financial Close Insight
- Order-to-Cash Insight
- Procure-to-Pay Insight
Payroll and OTL - EBS (MOSC)
Discussions
PAY: pay_assignment_actions.ASSIGNMENT_ACTION_ID differ with pay_run_results.ASSIGNMENT_ACTION_ID
today I run Payroll Process run Found pay_run_results.ASSIGNMENT_ACTION_ID differ from pay_assignment_actions.ASSIGNMENT_ACTION_ID. this create problem to design the report sql for the Payroll Slip.
Howdy, Stranger!
To view full details, sign in to My Oracle Support Community.
Don't have a My Oracle Support Community account? Click here to get started.
Instructions for posting
1. Select a discussion category from the picklist.
2. Enter a title that clearly identifies the subject of your question.
3. In the body, insert detailed information, including Oracle product and version.
Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).
Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .
New to My Oracle Support Community? Visit our Welcome Center
Oracle Applications Knowledge Repository
Monday, january 19, 2015, api's to rollback enhanced retropay, update retropay assignment status, delete retro entries & delete retropay assignment.
- Using Learning
Change Status Options for Oracle Learning Assignments
You can change the status of a learning assignment. The available change status actions depend on status of the selected learning assignments.
IMAGES
COMMENTS
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'.
HR. FND Design Data: PAY.PAY_ASSIGNMENT_ACTIONS. Subobject Name: Status: VALID. PAY_ASSIGNMENT_ACTIONS holds information about the effects of processing on specific assignments. An assignment action is one instance of an assignment for a particular process. For example, when an assignment has been processed by a payroll run a row is created to ...
Oracle Payroll Actions Following query can be used to retrieve all payroll actions against any assignment. Do not forget to Change the assignment number. "pay_payroll_actions" table holds the value but only the code. Decode function needs to be used to get the meaning. Code Meaning Code Meaning Code Meaning Code Meaning R Payroll Run B […]
This indicates whether the Payroll Run is expedited. Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
To default the assignment status based on action, select a value in the Assignment Status list of values (LoV) when you add an action in the Add Action page. Each assignment contains an assignment status. The assignment status contains an HR status, a payroll status , and optionally user statuses. The HR status and payroll status values are ...
select distinct ppa.action_type, hrl.meaning from pay_payroll_Actions ppa, hr_lookups hrl where ppa.action_type = hrl.lookup_code and hrl.lookup_type='ACTION_TYPE' order by ppa.action_type asc. For every payroll process or extract run, an entry will be added to this PAY_PAYROLL_ACTIONS table for the corresponding Action Type.
pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , per_all_assignments_f ASS , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
In this query, pay_payroll_actions is joined onto pay_assignment_actions solely to verify that for a given payroll, source_action_id is NOT null. If it is null, the query will not consider it for the 401k query. To view full details, sign in to My Oracle Support Community.
PAY_RUN_RESULTS: This table stores the status related to the elements against the assignment actions. The primary key is RUN_RESULT_ID. ELEMENT_TYPE_ID and ASSIGNMENT_ACTION_ID are the two other important foreign keys. PAY_RUN_RESULT_VALUES: This table takes the RUN_RESULT_ID and the INPUT_VALUE_ID and stores the Value obtained by the Payroll ...
The action framework consists of the action type, action, action reason, and assignment status components. The action type identifies the business process associated with the action and can have one or more predefined actions. The action tracks changes to the employment and assignment record. You can associate the actions you create with the ...
Content (required): Need Relevant Record for pay_assignment_actions in Cloud which is joined with pay_action_interlocks and pay_payroll_actions . Record need to have fields assignment_action_id, source_action_id, payroll_action_id which can be joined with pay_payroll_actions, pay_action_interlocks. Tagged: General Payroll. Log In.
Payroll Insight. Payroll Insight. The following table lists objects (tables) of the Payroll Insight forOracle. Table/view name in IRC. Friendly name. AP_BANK_ACCOUNTS_ALL Extracted table name for Oracle 12 version = IBY_EXT_BANK_ACCOUNTS. Bank Accounts. BEN_BENEFIT_CLASSIFICATIONS.
inner join pay_assignment_actions paa on paa.assignment_action_id = prr.assignment_action_id inner join per_all_assignments_f paaf on paaf.assignment_id = paa.assignment_id and activity.original_payment_date between paaf.effective_start_date and paaf.effective_end_date inner join pay_payroll_actions ppa on ppa.payroll_action_id = paa.payroll ...
PAY: pay_assignment_actions.ASSIGNMENT_ACTION_ID differ with pay_run_results.ASSIGNMENT_ACTION_ID Jun 10, 2013 9:46PM edited Jun 24, 2013 3:32AM in Payroll and OTL - EBS (MOSC) 2 comments Answered Dear All;
ACTION_STATUS. OBJECT_VERSION_NUMBER. NUMBER. 9. Yes. Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. ACTION_SEQUENCE.
Hi all, I am trying to run the HR-Payroll Subject Area from DAC.The Informatica workflow says running and is running from 25 hours. I don't why its taking that much time. Can any one help me out why its taking that much time? SELECT PAYROLL.ASSIGNMENT_ACTION_ID, PAYROLL.ASSIGNMENT_ID, PAYROLL.INPUT_CURRENCY_CODE, PAYROLL.OUTPUT_CURRENCY_CODE, PAYROLL.END_DATE, PAYROLL.START_DATE, PAYROLL.PAY ...
select * from pay_assignment_actions where payroll_action_id = 40825 and action_status = 'E'; BEGIN FOR i IN c1 LOOP py_rollback_pkg. ... Step 2: Update RetroPay Assignment Status to Deferred. DECLARE CURSOR c1 IS SELECT * FROM pay_retro_assignments pra
This table contains the assignment action locking rules to control rollback processing. Details. Schema: FUSION. Object owner: PAY. Object type: TABLE
Describes Tables and Views to integrate with or extend Oracle HCM Cloud.
You can change the status of a learning assignment. The available change status actions depend on status of the selected learning assignments. Activate the learning assignment. This action is available for only learning assignments with a Waitlisted or Request Approved status. Override action that cancels the approval transaction and updates ...