2210650 - Error: "ORA-20002: ORA-01741: illegal zero-length identifier ORA-06513" - Data Services

• USA regulatory transform is used (URAC).
• There are descriptions in the description fields.
• Writing to an Oracle temp table and there is no Table Owner specified in the table definition.
• ERROR: "(14.2) ... (E) (0766:2296366880) DBS-070301: |Sub data flow <subdataflowname>|Loader <loadername>
  Oracle <(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT =<port>)))(CONNECT_DATA =(SID=<sid>)))> error message for operation <create table>: <ORA-20002: ORA-01741: illegal zero-length identifier ORA-06512: at line 56>.

  (14.2) ... (E) (0757:2296366880) DFC-250038: |Dataflow <dfname>
  Sub data flow <Dfname> terminated due to error <70301>.
  (14.2) ... (E) (0757:1543501568) FIL-080134: |Dataflow <dfname>|Pipe Listener for <subdataflowname>
  Named pipe error occurred: <EOF>
  (14.2) ... (E) (0757:1409283840) FIL-080134: |Dataflow <dfname>|Pipe Listener for <subdataflowname>
  Named pipe error occurred: <EOF>
  (14.2) ... (E) (0757:1275066112) FIL-080134: |Dataflow <dfname>|Pipe Listener for <subdataflowname>
  Named pipe error occurred: <EOF>
  (14.2) ... (E) (0707:2164397856) DFC-250038: |Dataflow <dfname>
  Sub data flow <subdataflowname> terminated due to error <70301>.

• SAP Data Services
• Oracle

URAC, BODS, Oracle, illegal, zero-length, ORA-06512, EOF , KBA , EIM-DS , Data Services , EIM-DS-EXE , Job Execution , Problem