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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

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

in Reporting and Analytics for HCM 3 comments

Summary:

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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