Fusion Application - OTBI - Payroll Run date to be included in Payroll Results real time Subject Area

(Doc ID 2326032.1)

Last updated on DECEMBER 07, 2017

Applies to:

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

Goal

Getting the below error while trying to cross join the 2 subject areas 'Payroll Run Results Real Time' and 'Payroll Balances Real Time'

 Error
  View Display Error
 
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC: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: 17001. [nQSError: 17001] Oracle Error code: 1652, message: ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP at OCI call OCIStmtFetch. (HY000)
State: HY000. Code: 17012. [nQSError: 17012] Bulk fetch failed. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;SELECT 0 s_0, "Payroll - Payroll Run Results Real Time"."Business Unit"."Business Unit Name" s_1, "Payroll - Payroll Run Results Real Time"."Element"."Element Name" s_2, "Payroll - Payroll Run Results Real Time"."Input Value"."Input Value Name" s_3, DESCRIPTOR_IDOF("Payroll - Payroll Run Results Real Time"."Business Unit"."Business Unit Name") s_4, "Payroll - Payroll Balances Real Time"."Balance Value"."Balance Value" s_5, "Payroll - Payroll Run Results Real Time"."Payroll Run Results"."Amount" s_6, SUM("Payroll - Payroll Balances Real Time"."Balance Value"."Balance Value" BY "Payroll - Payroll Run Results Real Time"."Element"."Element Name",DESCRIPTOR_IDOF("Payroll - Payroll Run Results Real Time"."Business Unit"."Business Unit Name")) s_7 FROM "Payroll - Payroll Run Results Real Time" WHERE (("Element"."Element Classification Name" IN ('Tax Deductions', 'Employer Taxes')) AND ("Payroll Run Results"."Amount" IS NOT NULL)) FETCH FIRST 75001 ROWS ONLY

Attached the analysis and the screenshot of the error message
 

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