Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
SQL prefix for 'As of' Date getting ADFS error
Content
Hello,
I have a sql prefix set as SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}';
I'm all of a sudden getting this error:
State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G (HY000)
I read I need to update the prefix to this:
SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}';
When I do that I still get an error. Could someone give me a second set of eyes on this? Maybe I'm just missing a needed change with my filter or prompt.
Appreciate any guidance. My xml is attached.
0