You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a way to identify where Model changes (Value Definitions and Range Definitions) are used

Received Response
51
Views
8
Comments
edited Oct 19, 2023 8:25PM in Payroll and Global Payroll Interface (GPI) 8 comments

Summary: In 23D/24A - Oracle is moving to new Models for Value Definitions and Range Definitions and recommends that we modify any custom reports, extracts, and code (fast formulas, value sets...) that use these. Is there a sql or diagnostic process out there that would help us to identify where these are used. Has anyone found a good way to begin identifying these?


Content (please ensure you mask any confidential information):

PAYROLL PROCESSING

VALUE DEFINITIONS AND RANGE ITEMS: MODEL CHANGES

Retrieve information for value definitions and range items using the supplied database views.

The model for value definitions and range items is being updated to deliver performance enhancements for high volume payroll processes and reports. In Update 24A, all data for value definitions and range items will be migrated to the new model. A number of database views are now available to support the forthcoming model changes and ensure a smooth transition. These are stored queries that derive data from the value definition and range item tables. The views are designed to support the retrieval of data held in the original model or the new model.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!