Using the %%SOURCE_REFRESH_TIME_STAMP in BICS DataSync Job

(Doc ID 2384743.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Business Intelligence Cloud Service - Version 17.4.5 and later
Information in this document applies to any platform.

Goal

When using the %%SOURCE_REFRESH_TIME_STAMP in BICS DataSync Job, this value is not replaced with the latest time stamp in the SQL when running the jobs.
What is needed to make the update work ?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms