Oracle Transactional Business Intelligence Forum

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

[OTBI] Extract "comment" field in the transaction console

Received Response
10
Views
1
Comments

Hello,

I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console.
Specifically for the termination quick action, in which we have to insert a comment in the third step of the terminate work relationship page

image.png

Transaction info :

image.png

In BI Publisher, I was able to retrieve this field using the FA_FUSION_SOAINFRA.wfcomments table, which works perfectly.

However, in OTBI, I can’t seem to locate this comment.
I tried the "Human Capital Management – Transaction Administrator Real Time" subject area and used the Comment field under Issue Comment, but this field does not return the correct comment.
I checked the underlying table, and it indeed points to HRC_CONSOLE_ISSUE_COMMENTS, which is not the table I need.

image.png

Could you advise ?
Thank you

Answers