nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Complete extract of Scheduled Processes

Emily Taylor-182010

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

Find more posts tagged with

Submitted

ERP Analytics Content

Status: Submitted

Comments

Sriharsha Devraj

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.

https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2311-fetching-list-of-scheduled-processes-using-bi-report-in-oracle-cloud

Thanks

Sri

Emily Taylor-182010

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

MarshaH

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