We are facing issue in sending direct mail delivery. We enabled SQL query logs in the workflow, There is something wrong in the below SQL statements(autogenerated after enabling SQL logs).
INSERT INTO NmsPropositionRcp (iPropositionId,iOfferId,iOfferSpaceId,iInteractionId,tsEvent,tsLastModified,iStatus,iDeliveryId,iRecipientId,iBu_Key,
tsExpiration_Date)
SELECT NmsPropositionId.nextval,Prop.iOfferId,48622248,BL.iMessageId,BL.tsEvent,cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE),0,BL.iDeliveryId,
BL.iRecipientId,Prop.iBu_Key,BL.tsExpiration_Date FROM wkDlv_398175106 BL JOIN wkf390478608_93_1_ALL T1 ON (BL.iRecipientId=T1.iId AND
BL.iTargetDataId=T1.iTargetDataId) JOIN NmsOffer Prop ON ($long(@currentOfferId)=Prop.iOfferId)
WHERE BL.iFailureReason = 0 AND BL.sTargetCode='__MAIN__' AND (Prop.iOfferId > 0 OR Prop.iOfferId < 0)
ORA-00911: invalid character
Please let me know the possible root cause.