HCM - Compensation - Payroll Earnings Subject Area In EPM 9.1 Out Of Box RPD

(Doc ID 1983096.1)

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise EPM Foundation - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

While creating a report using delivered RPD for OBIEE version 10.1.3.4.1 in HCM - Compensation - Payroll Earnings Subject Area, adding column Earnings."Earnings Code", "Pay Period End Date"."Pay Period End Day Date", "Fact Payroll Earnings"."Regular Earnings Amount (Trans)", "Fact Payroll Earnings"."Regular Hourly Earnings Amount (Trans)", it generates the error as shown below:

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: 15018] Incorrectly defined logical table source (for fact table Dimension Earnings) does not contain mapping for [Dimension Day Pay Period End Date.Pay Period End Day Sid]. (HY000)
SQL Issued: SELECT Earnings."Earnings Code" saw_0, "Pay Period End Date"."Pay Period End Day Date" saw_1, "Fact Payroll Earnings"."Regular Earnings Amount (Trans)" saw_2, "Fact Payroll Earnings"."Regular Hourly Earnings Amount (Trans)" saw_3 FROM "HCM - Compensation - Payroll Earnings" ORDER BY saw_0, saw_1

RPD version : EPM 9.1 MP4
 

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