My Oracle Support Banner

How to Create a Custom RDE (Doc ID 1584806.1)

Last updated on OCTOBER 02, 2019

Applies to:

Oracle Health Sciences InForm - Version 5.5.0 and later
Information in this document applies to any platform.

Goal

The Reporting and Analysis installation includes logic that allows sponsor users to create scripts that can change the content of both the RT_MD_VIEWDICTIONARY table and the RD_DATADICTIONARY table to modify the default RDE before data is extracted. You can modify the structure of the RD views, and you can create or drop views based on the data that appears in existing views.

Solution

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
Goal
Solution
 Creating a customization script
 Regenerating the RD_ views
 Example: Drop a view
 Example: Drop a column from an existing view
 Example: Change a column name
 Example: Change a view name
 Example: Add a where clause to a view
 Example: Add a column to a view

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