Categories Uncategorized Transform <SQL> requires option <sql_text> to be set April 21, 2017 | 200 Views | Former Member SAP Data Services share share tweet share like 0 Follow Hi All, I m getting this error when i run a job having multiple Oracle tables with one SQL Query having in SQL Transform. Data Services Management Console initDom(“../images/skin_standard/”,”en”); styleSheet() JOB_DM4113_DAILY_NEWS_TCPN_DMN (14.2) 04-20-17 22:10:31 (E) (88784:89388) VAL-030147: |SESSION JOB_DM4113_DAILY_NEWS_TCPN_DMN|WORKFLOW WF_DM4113_TCPN_DMN|DATAFLOW DF_DM4113_TCPN_ICSPM_STG|STATEMENT <GUID::'90e74271-18b2-407a-a7de-0fc3dab2a12c' TRANSFORM SQL OUTPUT(DM4113_TCPN_DMN_V)> Transform <SQL> requires option <sql_text> to be set Alert Moderator To report this post you need to login first. 1 Reply 1 Comment You must be Logged on to comment or reply to a post. Former Member Post authorApril 22, 2017 at 2:55 am Is anyone have an idea about this error. Here are the details: Have used oracle table directly as source in DF and it was failing with ‘Table or view doesn’t exist’ so, have used SQL Transform and kept this table with ‘Select * from <Oracle Table>’, then getting this “Transform <SQL> requires option <sql_text> to be set” error. Please assist on how to resolve this Issue. Using SAP Dataservives 4.2 SP8 version with Oracle 12c client. Thanks, Abdulrasheed. like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.