Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

Creating Functions for User-Defined Datatypes in Oracle Applications

Creating Functions for User-Defined Datatypes in Oracle Applications

If you have a user-defined datatype and you want to use data subset or data masking with Oracle Applications, you must run SQL scripts to create functions in the database and print output that you add to the Oracle_UDT_Native_Conversions.properties file.
  1. Run the CreateReplaceClobString.sql SQL script. You can find the SQL script in the following location:
    <TDMInstallationDirectory>\Content\Accelerators\Oracle Apps\SQL\
  2. Run the OracleUDT_FunctionCreation.sql SQL script. OracleUDT_FunctionCreation.sql is in the same directory as CreateReplaceClobString.sql.
    OracleUDT_FunctionCreation.sql creates TargetSQLFunction and prints output.
  3. Open the Oracle_UDT_Native_Conversions.properties file and add the output from OracleUDT_FunctionCreation.sql to the properties file.