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

SQL prefix for 'As of' Date getting ADFS error

Received Response
edited Jun 22, 2020 3:04PM in Reporting and Analytics for HCM 2 comments



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. 


Howdy, Stranger!

Log In

To view full details, sign in.


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