You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Using two HCM/Compensation subject areas to pull needed data using OTBI, Now want to pull data from

edited Oct 3, 2018 12:50AM in Reporting and Analytics for HCM 2 comments

Content

I am using two HCM/Compensation subject areas to pull needed data using OTBI, Now want to pull data from Incentive Compensation  database table CN_TP_TRANSACTIONS_ALL based on person_number from HCM = Attribute10 in CN_TP_TRANSACTIONS_ALL that we store person_number.  Can this be done using OTBI?  Any thoughts...

Sql Issued using two subject areas:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1,NO_FORCE_TO_DETAIL_BIN=1;SELECT
   0 s_0,
   "Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" s_1,
   "Compensation - Salary Details Real Time"."Salary Details"."Salary change date" s_2,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!