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
Presentation Variable Prompt causes Error on Results tab, but not in Open link — 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

Presentation Variable Prompt causes Error on Results tab, but not in Open link

Accepted answer
83
Views
8
Comments
edited Apr 10, 2017 12:48PM in General Transactional Reporting (OTBI) 8 comments

Summary

AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65P

Content

I added the follow prefix to my analysis:  SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}';

Then I created a Presentation Variable prompt for AsOfDate with the following:

Default Selection: Variable Expression  @{system.currentTime}[MM/DD/YYYY]

 

This works when I run the analysis from the Open link, but when I am in Edit mode I get the following error on the Results tab:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-1004: Invalid/empty ADF query. (HY000)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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