Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Complete extract of Scheduled Processes
Organization Name
University of Wisconsin Hospital
Description
We would like a full complete extract of available scheduled processes and their description.
Use Case and Business Need
We don't know what we don't know. We want to know all scheduled processes and what they are intended for.
Original Idea Number: bb911fef34
Comments
-
Hi Emily,
You can run the sql in the below link. Aashish has put together the query and you can have the developers run this query. Here is what I could extract from 20C.
Thanks
Sri
0 -
Thanks for your comment.
The SQL does not List all Finance processes , the base Table “fusion.ASE_PRIVILEGE_TL” in the SQL is not having entries for below finance processes
- Import Journals
- Receivables Aging by General Ledger Account Report
- Create Customer Statements
- Import Costs
- Create Accounting
Note: above list of processes not available is just a sample we verified to find its existence in the tables, there can be many more processes
0 -
We have a similar need for a report so that we can schedule certain activities around the processes, or pause specific processes. The fields we need (at a minimum) that aren't available are:
- Frequency
- Scheduled start date
- Scheduled end date
- Scheduled start time
- Process Name
0