Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Variable using SYSDATE - Issues comparing against EBS last_update_date

user507190Dec 23 2009 — edited Dec 24 2009

Hello All,
I followed the directions in the Oracle blog "Using Variables in ODI: The Timestamp Example". I created the variables and the package. My interface is trying to load incremental data from the source GL_JE_BATCHES table to my target table. I am comparing the last_update_date field in the GL_JE_BATCHES table to the LastUpdate variable. Using the standard variable build per the blog [Select sysdate from dual] I am receiving all kinds of errors. When I view the value in the variable I see 2009-12-23 [no quotes]. I have tried all kinds of to_char and to_date conversions on both the variable and the last_update_date fields. No matter what I've tried and Ican't make the variable work. Now I'm up against a deadline and I'm reaching out for some help! Hopefully someone else is working during the holidays!

Thanks!
Cheryl

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 21 2010

Added on Dec 23 2009

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration, #variable

2 comments

2,340 views