Cause: Initialization of a Heterogeneous Services connection to set the date format to be used on the connected non-Oracle system. See the solution below.
Error solution: If the Oracle data dictionary supplies a value for the HS_NLS_DATE_FORMAT parameter, confirm that this value is formatted correctly by the rules of the non-Oracle system. Also check for additional information in log and trace files generated by the Heterogeneous Services agent.
Database version: Oracle 11g Release 2 (11.2)