Skip to content

Oracle Techno Functional Portal, Technical and Functional Resource

Home
ERP Implementation/Support
Technical Resource
Functional Resource
Trainings
Courses
Jobs
Tips & Tricks
Contact

Category: HR / Payroll Related Queries

Query to get Absence Detail Employee wise

Posted on May 19, 2015October 2, 2015 by Administrator

Query to get Absence Detail Employee wise. Approved Absence details. SELECT papf.EMPLOYEE_NUMBER,papf.FULL_NAME,pat.NAME absence_type, paa.date_start leave_start_date, paa.date_end leave_end_date, paa.absence_days, paa.abs_information_category, paa.abs_information2,

Continue reading

HR / Payroll Related Queries

2 comments

Oracle HR and Payroll Related Queries

Posted on October 26, 2010October 19, 2015 by Administrator

Oracle EBS/Apps R12. ( Oracle HR / Payroll ) Important Queries Note: All following queries are customized and may not

Continue reading

HR / Payroll Related Queries

Categories

1- Accounting Concepts
1- Oracle R12 Financial Setup
1.1 General Ledger Setup
1.1.1 User Creation and Assign Responsibility
1.1.2 Chart of Account and Segments Lists
1.1.3 Accounting Flexfield
1.1.4 Accounting Calendar
1.1.4 Define/Enable Currency
1.1.5 Accounting Flex Field Value Set
1.2 Payable Setup
1.2.1 Business Group/Calendar/Inv Org Creation
Administrator n Concurrent
Alerts and WorkFlows in Oracle Apps
Concurrent Programs Related
Configuring and Administrating Approval Transactions
Defining HR Responsibility
Enable Arabic for Reports
Encumbrance : Accounting Concept Oracle
Error Messages in Oracle Fusion
FlexFields
Forms Personalizations
Grade Key Flexfield Definition
HR / Payroll Important Tables
HR / Payroll Related Queries
Important Tables
Impratant Queries
Installing GNU Make For EBS
Jobs
Manufacturing
MO_Global.Set_Policy_Context
News and Articals
OAF Personalization
OAFramework R12X Customization
OPM Related Queries
Oracle AME Setup
Oracle Apps Basics
Oracle Cloud
Oracle EBS Documentation Library
Oracle EBS Shut Down Script for Windows
Oracle EBS Standard APIs and Interfaces
Oracle Framework Personalization
Oracle Fusion
Oracle HR Fast Formual
Oracle HRMS / Payroll
Oracle HRMS / Payroll Setup
Oracle HRMS Technical
Oracle I-Recruitment
Oracle Inventory User Practice
Oracle OPM Accounting Cycle
Oracle Purchasing User Practice
Oracle R12 Form Customiztion
Oracle R12 Installation on Windows
Oracle Self-Service Human Resources
Oracle Trainings
Oracle XML / BI Publisher
Other Apps
Others
Report Customization Oracle EBS
SCM Related Queries
Self Service
Setting Item Mandatory
System Administration
Tips & Tricks
Toad Tricks and Tips
Uncategorized
Understanding and Using API User Hooks
What are RICE Components

Recent Comments

Arun on Oracle BI Publisher Tab issue in MS Word.
Leo Caipei Chen on Report Customization Oracle R12
Kavitha Shivaiah on Oracle BI Publisher Tab issue in MS Word.
ZAFAR IMAM on Oracle SCM Techno Functional Training
Zafar Imam on Oracle SCM Techno Functional Training

Recent Posts

Oracle Cloud Support and Help Resources
Oracle Fusion Error message Legal Entity doesn’t exit (PER-1531116)
How to create Alerts or send Auto Email or Notification from Oracle Fusion.
How to Edit Notification in Oracle Fusion.
Enabling vacation rules and delegating approval responsibilities in Oracle Fusion.

Tags

API to Create EIT Extra Information API with Example to Update Basic Salary. Conditional Formatting Connect oracle database without tnsnames.ora Creating a New Vacancy Errors data bars Defining HR Responsibility Error while creating New Vacancy Excel Shortcuts Gmail Tricks how to add flexfield in oracle oaf page how to create blanket purchase order in oracle apps r12 how to create buyer in oracle purchasing how to create dff in oracle apps how to create purchase order in oracle how to create purchase order in oracle Apps how to create standard purchase order in oracle apps how to create unit of measure in oracle how to personalize oracle oaf page lease enter a value of Y or N location of tnsnames.ora Ms Excel oaf form personalization steps oaf personalization in oracle apps r12 oaf personalization tutorial Oracle API Oracle EIT upload Data Oracle Framework Personalization Oracle Fusion Oracle Fusion Profile oracle IRecruitment oracle kanban process flow oracle oaf personalization oracle oaf personalization examples oracle purchase order types oracle purchasing categories oracle purchasing create supplier oracle purchasing module oracle purchasing setups oracle purchasing user guide oracle purchasing user manual The employee (or contractor) information is invalid. tips and tricks tnsnames.ora what is kanban in oracle apps

www.oracleport.com