Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
[OTBI] Extract "comment" field in the transaction console
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
Transaction info :
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.
Could you advise ?
Thank you
Answers
-
Hi Sara,
Welcome to Oracle Analytics and AI community.
This is currently not supported in OTBI and only way to get this information is to use BIP.
Thanks.
0



