My Oracle Support Banner

Fusion Global Payroll: FAQ: Value Definitions and Range Items Model Changes via What's New in 23D (Doc ID 2987679.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version and later
Oracle Fusion Global Payroll - 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 document provides information on Frequently Asked Questions about the Value Definitions and Range Items Model Changes via the What's New in 23D.

Questions and Answers

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
Questions and Answers
 Q1. The understanding is that these changes will auto-migrate in 24A from table to view but we would like the customer to check their custom reports, extract etc.. that use these tables and manually make the change from the table to view to make the 24A transition seamless and to avoid slow performance issue due to these changes. Is that correct?
 Q2. It stated via the What’s News above that if the customer has reports that '..retrieve information directly from the PAY_VALUE_DEFINITIONS_F or PAY_RANGE_ITEMS_F tables should be updated to use these views...' Is there an SQL query that the customer can run to see which report is currently using these tables to make a change from TL to VL? Or are they on their own to figure this out?
 Q3. This feature is enabled by default. If customers have reports that do not get converted from table to views, will the performance be impacted (for example report might not run)?
 Q4. Will Oracle convert this Table to View automatically for all seeded BI and reports? Customers would only have to update the custom extract, BI/reports that use these tables, is that correct?
 Q5. When will these tables be obsolete (please provide a time frame) and Customers must convert them to the newer views or the reports won’t run at all?
 Q6. Which View to use as the replacement?
 Q7. What has happened to the Audit tables pay_value_definitions_f_and pay_range_items_f_
 Q8. How has the change impacted use of the Source System ID used in HDL?

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