What Are the Steps to Populate the DEFQ_GLOBAL_VALUES Table for Filters on Data Entry Forms?
Last updated on OCTOBER 24, 2014
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
DEFQ - Data Entry Forms and Queries
Question 1: After setting up a user filter on a DEFQ form, where is the filter information stored?
Question 2: How to populate the DEFQ_GLOBAL_VALUES table? As per the readme for <Patch: 16933299> - USERS ABLE TO SEE DATA IN FORMS FOR WHICH THEY ARE NOT MAPPED AND VICE VERSA:
6. The Global value for the user will be entered in DEFQ_GLOBAL_VALUES table
as shown below in the atomic schema. This table should be created through
Incremental Model Upload to the atomic schema where the data can be uploaded
CREATE TABLE DEFQ_GLOBAL_VALUES
GLOBAL_VALUE VARCHAR2(50) NOT NULL,
What is the global_value and user_name for a user? Where can this information be found? How does this table actually filter (i.e. only users in this table are allowed to see all data in the Form)? Can you provide an example of what values to enter and how the entered rows filter the data?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms