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.