Fusion OTBI : Analysis Errors With "ADFException-1004: Invalid/empty ADF query. (HY000)" When Adding A Date Parameter/Prompt In BI Answers, for Effective Dated Reports

(Doc ID 2050398.1)

Last updated on SEPTEMBER 30, 2015

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

Following steps from http://docs.oracle.com/cd/E51367_01/common_op/OCHRA/F1415829AN11D19.htm#F1469193AN12A15 to use Effective date reporting fails with

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)
 

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