I'm trying to abort some workflow activities which are not 'COMPLETE' and then purge them. I'm using "WF_ENGINE.AbortProcess" to accomplish this task and then purge using "WF_PURGE.Total" to purge the activities. During this process, does any notifications fire?
View 2 Replies
We are on 12.1.3 Apps.
We want to be able to send attachments at the invoice header level with the invoice approval workflow email as attachments. The standard workflow does not provide this functionality.
We were able to achieve this functionality using the approach given here:
[URL]........
Basically we added a document type attribute to the notification message, and set a BLOB variable to it inside our custom procedure, which is set as the function for the notification: DOCUMENT_APPROVAL_REQUEST.
Now we are able to see the attachments coming as attachments in approval request emails to the approvers. But the issue is that the first approver on the list, the requester is not seeing the attachments. All the other approvers can see the attachments. We have checked the WF Role for the user and the Notification preference is set as MAILHTML
As far as i can see, same notification and same message is used to send the email to all approvers including requester. Then why only requester is not getting the attachments?
I am getting the below error while deploying a workflow in Control Center.
ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException:
The file /u01/app/oracle/product/11.2.0.2/dbhome_1/owb/bin/admin/rtrepos.properties cannot be accessed or has not been properly created on the server XXXXXX. If the file does not exist or if the database owner (normally user 'oracle') does not have the required file permissions or if the file has not been properly created then the file can be recreated by running the SQL*Plus script /u01/app/ oracle/ product/11.2.0.2/dbhome_1/owb/ rtp/sql/ reset_ repository. sql (in a RAC environment the file must be manually copied to each server which is used for OWB). Otherwise if using a 10.2 database instance, then please run the SQL*Plus script /u01/app/oracle/product/11.2.0.2/dbhome_1/owb/UnifiedRepos/reset_owbcc_home.sql.
i`m new to EBS. steps for following changes in the PO Approval workflow
1.Any new PO that gets processed / approved in the system needs to auto run the PO Print program (to generate the PDF copy of the PO) with the email function switched on.
2.PO Print program needs to be modified to auto email docuclass (test@tes.com) always ( even if email option is switched off) and email both buyer and PM ( if email option is on). Email subject should contain PO# and revision#.
After HRMS RUP6 patch, we overlooked a customization that set the Performer Type and Performer Role on an activity. Consequently, we have many workflows that are currently in progress and in an error status with:
HRSSA workflow errors with 3120: Activity 'HRSSA/343959' has no performer.
We see in the wf_process_activities table that the
PERFORM_ROLE and PERFORM_ROLE_TYPE for activity 343959 have the wrong values.
Their values are currently, PERFORM_ROLE_TYPE = 'CONSTANT' , PERFORM_ROLE is null.
They should be: PERFORM_ROLE_TYPE = 'ITEM_ATTR' and PERFORM_ROLE = 'FORWARD_TO_USER_NAME'.
This has been fixed for current workflows but the activities in error do not complete successfully on retry. Is there an API that allows us to set PERFORM_ ROLE and PERFORM_ROLE_TYPE on a specific activity?
when a procedure, package or function is executed which part of oracle code gets loaded, where the values of the variables are stored etc. When a package is loaded in the memory does specification and body both gets loaded?
How can I found how much memory is required to execute a procedure? consider oracle architecture (SGA, PGA, UGA etc.)
I would like to log session activities. I would also like to be able to check if the session for which an activity has been logged is still active. The problem is, what do I need to uniquely identify a session?
DBMS_SESSION.UNIQUE_SESSION_ID - is explained as: unique for all sessions currently connected to this database. Meaning that if I restart the DB or connections are closed and opened, it might not be unique anymore, right?
SYS_CONTEXT('userenv','sessionid') - returns AUDSID, but is this guarantied to be unique and not been reused, forever? What I do not want to happen is, that I use a session identifier, which might reappear.
My best guess is currently:
SYS_CONTEXT('userenv','sessionid') + logon_time (from V$SESSION)
This combination should be really unique and should never reappear, right?
My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.
View 1 Replies View RelatedCan AME workflows be implemented in ADF?
View 3 Replies View RelatedHow I can set the #FROM_ROLE to be from 'Sysadmin'?
View 2 Replies View RelatedWhere can i find the workflow initiator (initialization of parameters or variables) details/query. like who initiated the workflow in the workflow tables.
View 1 Replies View RelatedFor a couple of employees created in our system, the workflow display name is coming with 'AMERICAN' at the end which clearly looks like is the language setting for the user. ORIG_SYSTEM for this users in WF_LOCAL_ROLES is WF_LOCAL_USERS.
There is no option called WF_LOCAL_USERS in the Synchroinze WF Local Roles program.
we are trying to update the Email attribute in OIM followed by OID. we have written a scheduler to copy the username field to email field in USR Table through tc User Operations interface, followed by change email task and update email task to OID.
But it is taking 1 hour for 1000 records to finish the job. we have 200000 Users in Production, Is there any better approach I can fasten the process? we are having an idea to update the USR Table through SQL Querry for OIM Side. And when we tried to update the CT_MAIL table in OID. But it is not showing the values in the front end ODSM.
Now thinking to write a scheduler separately for OID by just connecting to ldapctx, update each records and disconnect finally after updating all the operations.
OIM Version : 9.1.0.2
OID Version: 11.1.1.3.0
I created simple custom workflow (Start -> Notification -> End).
I got the following error when I run the workflow.
[WF_ERROR] ERROR_MESSAGE=ORA-02289: sequence does not exist ERROR_STACK= FND_SEARCH_EVENTS.On_Object_Change(oracle.apps.wf.notification.send, 5C84790B967158FFE04400144F23BF3C)
The notification activity returned this error but the notification has been sent to performer.
[URL]
creating custom AWE Line Level Approval? I’m having trouble trying to get the method for line approval to fire. I have header level working so I decided to dig deeper. I added the line keys to the Xref table, Updated the Registry, Configured the Events, and created a new Process Definition using line level (very simple “Always True”). I have seen OnProcessLaunch fire so my routing has begun.
The graphics look good. But when my approver goes in and hits the Approve button, it saves and nothing happens to the approval. Tracing it shows that no methods are firing. How does the system know to fire the line level method vs the header level method?
My workflow stuck in Active status and user is not able to proceed further. But it is not happening every time. Sometimes the process activity gets stuck.
View 5 Replies View RelatedWe have implemented a approval notification for our customer which on a high level is as follows
requester -> Approver 1-> Approver 2
Once a request is submitted, the 'approval' notification goes to Approver 1 followed by Approver 2. The request is approved when both approves approve the request. If no action is taken by the approvers, the original notifications are cancelled and escalation notification is sent to supervisor of approver 2.
We have a timeout of 48 hours set for the initial approval notifications sent to the approvers (1 & 2). In case Approver 2 requests for more information using the 'Request information' button, the TIMEOUT clock does not seem to reset and the notification is cancelled after 48 hrs even if the notification is in the queue of the requester.
This is causing the escalation notification to be supervisor of approver 2.
The question here is why does the timeout clock not reset when the notification goes back to the requester for additional information. Is this how the standard oracle workflow notification behaves ? Is there a way to customize and achieve this ?
i want to run this procedure manually for testing purpose
procedure Reject_Doc(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out NOCOPY varchar2 )
what are the possible values for the variables itemtype,itemkey, actid,funcmode?
How to make node to deferred node in oracle workflow ?
View 2 Replies View RelatedI have two questions:
1. Our business users had a requirement to approve or reject the Workflow Notification Emails form their Email account on MS Outlook Express. When they perform action from MS Outlook Express it sends email to wfmailer but no action perform in application. The notification inbox in application shows this notification as OPEN notification and the requested function also shows 'Waiting for Approval'.
2. I need to hide Request Information button/link from the email notification send through Workflow mailer to user. There are three actions button available in email notification Approve, Reject and Request Information. I need to have only two button Approve and Reject. How to hide Request Information button.
We downloaded Arabic Version of workflow from server using WF_LOAD command.We are able to see Arabic names for item type,attribute,message etc if we open the .wft file in customer PC.But if we open it in our PC,Arabic names are coming as junk. We guess that it needs some setups.
setups to open Arabic .wft file in workflow builder in windows 7? The note id 444068.1 is removed by oracle.
I have a custom concurrent program which has a SQL query which returns multiple rows. Each row is a for each supplier e.g.
Supplier1 sup1@gmail.com 123 5000Supplier2 sup2@gmail.com 456 4000Supplier3 sup3@gmail.com 789 3000
This set is returned based upon some criteria mentioned in the where clause of the SQL.Ultimate aim is to send 1 notification to each of the email id's and those notification should have the corresponding attribute values. 3 notifications fired from a workflow triggered by the concurrent program (which actually returns this 3 rows in a SQL)Supplier 1 to receive 5000Supplier2 to receive 4000Supplier3 to receive 3000 My approach / or the only approach coming in mind is using a cursor for the SQL inside the concurrent program and using a for loop, initiating the workflow each time for a loop iteration i.e for each iteration of loop , workflow procedure will need to be initiated, so item type will be same but item key will of 3 different item key. is it somehow possible to fire only one instance of workflow and not 3 different instances to send 3 notifications. Ad hoc role creation would not be option here because the number of rows may be large and not just 10-15.
Where are the details of the Actual Responder Details stored in the case of the below scenario
If a notification for one user was closed by another user through access to the first user's worklist, the name of the second user, who actually took the action, is displayed as the responder.
I am only able to find the Original Recipeint username in the wf_notifications table.But where will the details of the Actual Responder name displayed in the notification be stored.
When I use the "wf_notification.Responder" function, I get the Original Recipeint username of the user but not the one who acted on the notification. Is there ANY way by which I can get the Actual responder user name who acted on the notification
select responder from wf_notifications where notification_id = <nid> also gives me the Original Recipeint username of the user but not the one who acted on the notification
I am working on Workflow and the issue is When a person leaves for vacation he can set his vacation rules so that someone has to attend / approve his workflow notifications. But when we set vocation rules all notification goes into errors state and this error can resolve by refreshing/Retry this notification. And the error detail is mentioned below An Error occurred in the following Workflow.
Item Type = CONCSPL
Item Key = 086937-15990
User Key =
Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(cust_f_test.f_find_approver, CONCSPL, 086937-15990, 180198, RUN)
[code]....
Bottom line is all notifition should be successfully process and send to dedicated person.
I have a requirement where I have to show attachment in R12.1.3 Sourcing Award Approval Notification.I am able to achieve this by adding #ATTACHMENTS attribute in the message and Attachment appears in the Notification in the E-Business work list but somehow its not appearing in "e-mail notification".
View 0 Replies View RelatedI have a standard workflow process which was started but got completed without performing all the process.The process had to generate two(Comments & Approval) notifications but generated only one & as the user responded to the notification it got completed without invoking the approval process.Now I need the workflow to be rolled back to the initial step to restart the whole process again.
View 1 Replies View RelatedI need to take the certain logs on my 3-Node, 10gR2 RAC with ASM on Solaris 10.I have been asked to shutdown the database, nodeapps, listener, asm and crs and then restart crs. Below are t steps that I have prepared.
CODE
====Enable trace=========
ENABLE LEVEL 5 tracing-
./crsctl debug log crs allcomp:5
====Stop database, asm, listener, nodeapps finally crs===
1. STOP DATABASE
srvctl stop database -d DB_NAME
[code]....
I have done IZ007 in 9i. Now I wanted to complete the OCA in 10g for Oracle Administration. which exam I need to go for to complete 10g OCA.
View 1 Replies View RelatedThe "private strand flush not complete" is a "noise" error, and can be disregarded because it relates to internal cache redo file management.
However this "private strand flush cannot complete" error is sometimes accompanies by a hung database.
These are quotes from MR Burleson himself .
But can this be really ignored as it's also mentioned "hung database"
how to find out queries that took more than 15 seconds to execute.
View 4 Replies View Related
