Need To Connect HRC_TXN_COMMENT Table With PER_ALL_ASSIGNMENTS_M Table

(Doc ID 2349934.1)

Last updated on APRIL 19, 2018

Applies to:

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

Goal

Need to fetch the comment put by manager while changing data of employee which is probably stored in HRC_TXN_COMMENT. Need to Action taken against the employee and the comment put by manager. We are struggling to join the table with assignment related table.
 

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