You can create transforms to transform any of the TCA Registry attributes in the entities used in DQM: Party, Address, Contact, and Contact Point.

Procedure

1. Create a PL/SQL function for transforming a TCA table column.

   Create the transformation in the APPS schema as a PL/SQL function that conforms to the following standard signature:

   FUNCTION <transformation_function_name>  
       p_original_value         IN     <ATTRIBUTE_DATATYPE>  
       p_language               IN     VARCHAR2,
       p_attribute_name         IN     VARCHAR2,  
       p_entity_name            IN     VARCHAR2,  
       p_context                IN     VARCHAR2 DEFAULT NULL) 
   RETURN VARCHAR2;

   • p_original_value: The data type of the parameter p_original_value depends on the data type of the attribute that the parameter is transforming. The return value, however, must be VARCHAR2.

     This table shows an example of p_original_value data types for different attributes.

     Attribute Name	Attribute Code	Data Type of p_original_value
     Party Name	PARTY_NAME	VARCHAR2
     Person Name	PERSON_NAME	VARCHAR2
     Last Update Date	LAST_UPDATE_DATE	DATE
     Date of Birth	DATE_OF_BIRTH	DATE

   • p_language: You must include this parameter, but cannot use it.

   • p_context_value: The p_context value, STAGE or SEARCH, indicates whether the transformation is to be used in the context of staging or searches.

     You can use any PL/SQL procedure that adheres to the above signature as a transformation.

2. Assign your custom PL/SQL function to a transformation. To use the transformation, you must also assign the transformation to at least one attribute. See: Defining Attributes and Transformations.