oracle,performance,formula,oracle-apps
By looking at the function reference for OracleFormula, it seems that you have no other option than calling TO_CHAR with the appropriate format to achieve the desired result. based on the doc's example: mesg = 'Birthday is: ' + TO_CHAR (birthdate, 'DD') ...
HZ_CONTACT_POINT_V2PUB is part of the interface for TCA. To quote from the TCA documentation: "Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships...