Skip to Main Content
Forums

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PSFT - can workflow transaction page be edited/part filled by workflow users

4017711Nov 16 2019

Hi, i have a question and need suggestions on how to achieve this. Can we have different sections in workflow transaction page which will be completed by participants of respective stages/steps?

For example,

Step 1 - line manager submits, reporting change

Step 2 - HRBP approves it, buy has some additional details to fill

Step 3 - receiving line manager or department manager approves but have additional details to fill like KPIs etc

Can we make this complete transaction to be partially completed and workflow triggered at respective stages with proper security intact?

Any ideas will be appreciated. Thank you

Comments

Mark D Powell
Answer
The package was in use. There are a couple of ways to find who is using a package at any given moment.

You can join v$session to dba_ddl_locks or you can use v$acess but you can see who is executing the package. The code cannot be recompiled while the code is in use.

HTH -- Mark D Powell --
Marked as Answer by 784227 · Sep 27 2020
Helios-GunesEROL
Hi;

For can root cause please see:
How to analyze ORA-04021 or ORA-4020 errors? [ID 169139.1]

Hope it helps

Regard
Helios
784227
Hi,

Thanks for reply.

There are two session id which are access same package in dba_ddl_locks, do i need to kill that session id?

Thanks
oradba
do i need to kill that session id?
I would first try to find out, WHO is behind this id.
Mark D Powell
It would have been nice if you had posted your query and results so we could make suggestions on how to improve the query or what you should check next.

Generally speaking if you submit a create or replace on a package and it takes longer than expected you can open a second session and query for usage. Depending on what you find determines your action.

If may be you just need to re-submit immediately or wait till a batch job completes. There could be a daemon (continuously running batch) job that you have stopped and re-started right after you make the change. It depends on your environment.

HTH -- Mark D Powell --
1 - 5

Post Details

Added on Nov 16 2019
#peoplesoft, #peoplesoft-general-discussion, #peopletools
0 comments
183 views