Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Looking for a workaround / solution for filter date field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Looking for a workaround / solution for filter date field

Received Response
18
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Summary

Not all tables have a filter date field

Content

Team

In this wonderful world of Data-Sync (DS) 2.6.

I am doing a copy of each table needed for my AP reports from PSOFT to ADW.  I still must set the keys (no big deal I got that) but DS also wants a “filter date field” it can use to compare to the last time it was updated. 

In some of the tables (ps_voucher) we have “Last_Update_DTTM” however in other tables like (PS_PYMNT_VCHR_XREF) we have no such date field. 

In this case DS forces us the do a destruct and initial load every time.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!