Yes, It’s possible to achieve this by following these steps:

1- create a menu that has status monitor function and two other sub-menu, “Workflow Configuration tab” and “workflow administrator notification tab”.

2- assign this menu to your responsibility.

3- create a grant through a functional administrator for your responsibility to all or specific users

4- exclude the above two menus from the responsibility.

That’s it.

And for the detailed steps with screenshots, I will write an article to showcase this process step by step and will update this answer later on by leaving the article link.

stay tuned 🙂

The list of GL Table are:

1. GL_LEDGER
2. GL_JE_HEADERS
3. GL_JE_LINES
4. GL_CODE_COMBINATIONS
5. GL_BALANCES
6. GL_JE_BATCHES
7. GL_IMPORT_REFERENCES
8. GL_PERIODS
9. GL_CURRENCIES
10. GL_DAILY_RATES

Queries and Description of each GL Table:

• gl_ledgers stores all ledger pieces of information.

SELECT * FROM gl_ledgers; 

• gl_je_headers stores GL Journals Header Information.

SELECT * FROM gl_je_headers;

• gl_je_lines stores GL Journals Lines Information.

SELECT * FROM gl_je_lines;

• gl_ledgers stores GL code combination pieces of information.

SELECT * FROM gl_code_combinations;

• gl_balances Stores actual, budget, and encumbrance balances for detail and summary accounts.

SELECT * FROM gl_balances;

• gl_je_batches stores GL Journal Batches Informations.

SELECT * FROM gl_je_batches;

• gl_import_references is holding the reference keys between journals and sub-ledger transactions like AP&AR.

SELECT * FROM gl_import_references;

• gl_periods stores all GL period pieces of information like name, start date, and end date.

SELECT * FROM gl_periods;

• gl_currencies stores all GL the GL currencies pieces of information.

SELECT * FROM gl_currencies;

• gl_daily_rates stores all GL currencies’ Daily rates in the system.

SELECT * FROM gl_daily_rates;

CTE stands for Common Table Expression. Another acronym is subquery factory; It’s simply a query that you can define in another query. It starts with WITH clause that lets you assign a name to a subquery block. Then you can reference this subquery block in multiple places within your main query by giving that query a name.

Oracle database traits that query name as either an inline view or as a temporary table that will be dropped automatically after the execution of your main query is finished.

Let’s take a simple example to showcase the use of CTE in the Oracle database

Let’s say we need to get the employees that are hired on the first day of each month in the current year.

WITH hiring_periods (period)
AS (SELECT to_date ('2006-01-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-02-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-03-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-04-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-05-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-06-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-07-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-08-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-09-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-10-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-11-01', 'yyyy-mm-dd') FROM dual
UNION ALL
SELECT to_date ('2006-12-01', 'yyyy-mm-dd') FROM dual)
SELECT e.first_name, e.last_name, e.hire_date
FROM employees e, hiring_periods hp
WHERE e.hire_date = hp.period;

Output:

| FIREST_NAME | LAST_NAME | HIRE_DATE
| ——————- | —————- | —————-|
| Samuel                 | McCain           | 01/07/2006   |

In the above query, we first start our query with a WITH clause to define a temporary table that has a date of the first day of each month and give that temp table or inline view a name which is “hiring_period” and then uses this name in the main query by joining it with the employee’s table using the hire date column.