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 …
Query to find details of Scheduled Processes ESS jobs?
Dec 27, 2024 · Summary: Hi Team, we have requirement to fetch all ESS jobs from Scheduled Processes UI.
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).
Table names/SQL query for Individual Compensation details in HCM
Aug 11, 2022 · Summary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required):
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 …
Query for Transaction Console transactions — Cloud Customer Connect
May 3, 2023 · Summary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, related to Expense …
PO Revisions SQL query to retrieve all revisions in a given period of ...
I need a SQL query to retrieve all PO revisions cases within a period.The revisions can be quantity,rate,taxes,ship to location,payment terms,note to vendor etc.This means I should have the …
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 …
Query to get Fusion Workflow Approvals — Cloud Customer Connect
Jul 13, 2024 · Hello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee?