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

Join "Approval Notification Archive Real Time" & "Transaction Administration Real Time" subject area

Received Response


How to join Human Capital Management - Approval Notification Archive Real Time & Human Capital Management -Transaction Administration Real Time subject area

Content (required):

I am working on putting together a logical sql to create an OTBI report that displays all relevant transaction details (Source: Transaction Administration Real Time) along with a few attributes like "Last Action By", "Comments" , Assigned By" etc. (Source: Approval Notification Archive Real Time) in it.

I tried to join these two subject areas using "Object ID" (see "Join ID" in the SQL below) from the "Transaction Administration Real Time" subject area and "Transaction ID" from "Transaction Administration Real Time" subject area. It worked for some processes but for some it is returning incorrect/ different values. For eg., for "Object ID" =1234 the Process Name is 'Termination in "Transaction Administration Real Time" SA but for the same "Transation ID" (1234) in "Approval Notification Archive Real Time" SA the process name is "Maintain Individual Compensation" which is not true.


Howdy, Stranger!

Log In

To view full details, sign in.


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