Cross Subject Area analysis getting nQSError: 15018 Incorrectly defined logical table source (Doc ID 2198861.1)

Last updated on JANUARY 26, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Technology Management - Reports/Analytics

Report is built on two Subject areas:
1. Workforce management - Accural real Time
2. Workforce management - Work Relations ship real time

Only "Worker" Column was selected from second Subject area ( Workforce management - Work Relations ship real time)


ERROR
-----------------------

Odbc driver returned an error (SQLExecDirectW).
  Error Details
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: 15018] Incorrectly defined logical table source
 (for fact table Z - VO OBIA ETL) does not contain mapping for [Dim - Assignment Accruals Details.Balance Calculation
Date]. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Management - Accrual
Real Time"."Accrual Plan"."Accrual Plan Name" s_1, "Workforce Management - Accrual Real Time"."Department"."Department
Name" s_2, "Workforce Management - Accrual Real Time"."Employee Plan Participation Details"."Balance Calculation Date"
s_3, "Workforce Management - Accrual Real Time"."Worker"."Employee Name" s_4, "Workforce Management - Accrual Real
Time"."Worker"."Person Number" s_5, "Workforce Management - Work Relationship Real Time"."Work Relationship Details".
"Worker Number" s_6, "Workforce Management - Accrual Real Time"."Employee Plan Participation"."Accrual Value" s_7 FROM
"Workforce Management - Accrual Real Time" FETCH FIRST 75001 ROWS ONLY
Refresh

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