
How to get the last login date for all users including the terminated ...
Aug 26, 2024 · By using this table not getting all users login dates. we have scheduled the "Import User Login History" job on daily basis. We have used these SQL's. But not getting the last login date for all …
SQL Query to get PO Change and Approval History
Dec 1, 2023 · I am building an audit report to get a clear view of the PO Changes and Approval History.
Table to get Assignment change history — Cloud Customer Connect
May 2, 2023 · Summary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer).
What are the tables or SQL query to fetch ESS job name, Report name ...
Aug 21, 2024 · Hi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc.
PO Change order History Table — Cloud Customer Connect
May 21, 2020 · Summary SQL/Table to fetch Purchase order change history Content Hi, Can anyone please help me with the back end table/SQL to get the purchase order change history. I was able to …
SQL to fetch the history ratings from talent profiles
Aug 20, 2024 · Summary: Hi, Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation:
Get workflow task history for Purchase Requisition (SQL Query)
Jul 4, 2024 · Summary: I need help to understand how can I get the WF task history to Purchase Requisition. I am trying to use the query below:
SQL query to retrieve the approval history data
May 19, 2025 · Summary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval'
Need an sql query to get the latest leave approver or assignee details ...
Sep 29, 2024 · Hi Team, I am unable to get the approver or assignee details from the below tables 1. fa_fusion_soainfra.wftask 2. fnd_bpm_task_history_b So Please provide an sql query/tables to get …
Approval History - AP Invoice Account Coding Workflow Notification ...
Jul 10, 2024 · We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query. In BPM Workflow notification we can see the approval history in …