data deploy Exception Message: ORA-00923: FROM keyword not found where expected

Hi,

Following query built by teamsite DD component is throwing ORA-00923 error.

SELECT HELP_DETAIL.HELP_DETAIL_ID , HELP_DETAIL.HELP_TERM_ID,HELP_DETAIL.IDENTIFIER_TYPE,HELP_DETAIL.IDENTIFIER_KEY,HELP_DETAIL.IS_EXPIRED,HELP_DETAIL.COMPANY,HELP_DETAIL.RES_BUS,HELP_DETAIL.TELCO_UVERSE,HELP_DETAIL.STATE_ID,TO_CHAR(HELP_DETAIL.LAST_UPDATED_DATE,'MM/DD/YYYY HH24:MI Smiley Frustrated

S') AS HELP_DETAIL.LAST_UPDATED_DATE,HELP_DETAIL.LAST_UPDATED_USER FROM HELP_DETAIL,HELP_TERM WHERE HELP_DETAIL.HELP_TERM_ID = HELP_TERM.HELP_TERM_ID AND HELP_TERM.HELP_TERM_ID IN (?) ORDER BY HELP_DETAIL.HELP_DETAIL_ID

in above query if I modify 'AS HELP_DETAIL.LAST_UPDATED_DATE' to 'AS LAST_UPDATED_DATE' its working fine in oracle client(Toad/Sql developer).

My question is about how to update/where to update the DD to generate above query with out tablename in 'AS .... LAST_UPDATED_DATE'!!!

please find attached dd config and log file for reference.

appreciate your help!

thanks
Nagendra

Find more posts tagged with

Comments

nagendra

one of my team member, suggested to use real-update="no" and it worked!

Is this a known issue/bug in OD 6.2.0.0 version? or I need to review any of our configuration files?

thanks
nagendra