All posts on Sample SQL Queries

How to modify the reports/value sets for Payroll table changes in 24A?

Do you know Oracle has provided new Payroll views for PAY_RANGE_ITEMS_F and PAY_VALUE_DEFINITIONS_F from 24A? Why did they introduced these new views? What would happen to reports/value sets if these are not modified? Read on to know more details.

Continue ReadingHow to modify the reports/value sets for Payroll table changes in 24A?

How to fetch Balance Initialization and Adjustments for employees?

Do you know how to fetch the payroll balance initialization and balance adjustment information for balances of an employee? This will be helpful in reconciling the data loaded and also in reporting balances. Read on to know more details.

Continue ReadingHow to fetch Balance Initialization and Adjustments for employees?