Updating a contacts email and phone in Oracles HZ_CONTACT_POINTS through PL/SQL
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...
How to use SQL syntax in Oracle fast formula
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') ...