FA OTBI - FAILED TO GENERATE REPORT FOR PAYROLL RUN RESULTS ,ELEMENT ENTRY, PAY RUN COST SAs

(Doc ID 2400943.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In OTBI, using the columns Element.Element Input Currency or Element.Element Reporting Name in the Subject Area Payroll - Element Entries Real Time results in the following error:
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25002: Definition FNDDS__PAY_REPORT_PAYROLL_ELEMENT_DATA__PAY_ELEMENT_TYPES_F__ElementTypeDPEO of type View Criteria is not found. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Payroll - Element Entries Real Time"."Element"."Element Reporting Name" s_1 FROM "Payroll - Element Entries Real Time" FETCH FIRST 250001 ROWS ONLY

Cause

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