Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

How to dynamically change the user in 'request Information' link of iProc Requisition notification

User_E97G7Mar 8 2021

Hi Experts,

We are using R12.2.3
Hi Team,

We are working on enabling the Workflow for iProc Requisitions. We are receiving mail and we are able to take actions from it without any issues. But, we have a new requirement where we want to change the user in 'Request Information' link. Let me explain with an example

1. ABC created PR and sent it for approval to XYZ
2. XYZ received mail to take action
3. Now, XYZ clicked on 'Request Information' link and requested more info from ABC
4. Now, ABC responded and so XYZ took action and everything is ok.
Now, the requirement is, when XYZ clicked on 'Request Information', instead of ABC it has to show PR_TEAM(lets say we created this user)

Can you please let me know from where the details in 'Request Information' is coming? Is it allowed to change the value dynamically? If yes, then how?

Please note, here, it should not be always PR_TEAM, if the approver is CEO, then instead of PR_TEAM, we need to show as DIRECTOR. But, I can say that it is second level of requirement

Thanks in Advance,
Srivathsava

Comments

Günter

If your stored procedures are huge maybe a Java heap space problem ?

Billy Verreynne

Recompiling a stored proc requires an exclusive lock on the meta data object for the stored proc. Sessions using and executing a stored proc, or objects with dependencies on that stored proc, place a shared lock on the stored proc meta data object. This is to prevent runtime issues and errors to occur by changing the code of an in-use stored proc.
Thus a recompile session call can wait for an extended time for obtaining an exclusive lock for changing the stored proc.

3 people found this helpful
jflack

So, if your database is busy, and your procedures are being used a lot, let me suggest that you use edition-based redefinition to make your changes.

1 - 3

Post Details

Added on Mar 8 2021
#notification, #oracle-application-development, #oracle-help-technologies, #workflow
0 comments
210 views