Workflow :: Activities Which Are Not COMPLETE

Jan 16, 2013

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


ADVERTISEMENT

Workflow :: Send Attachments To Requester In AP Invoice Approval Workflow

Sep 4, 2012

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?

View 0 Replies View Related

Workflow :: Error While Deploying A Workflow In OWB

Apr 3, 2013

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.

View 0 Replies View Related

Workflow :: PO Approval Workflow Change

Sep 17, 2012

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#.

View 0 Replies View Related

Workflow :: HRSSA Workflow Errors With 3120 - Activity HRSSA/343959 Has No Performer

Oct 3, 2013

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?

View 0 Replies View Related

SQL & PL/SQL :: Activities When Procedure Executed

Sep 6, 2010

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.)

View 3 Replies View Related

Server Administration :: To Log Session Activities

Jun 11, 2007

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?

View 11 Replies View Related

Notification In Workflow

Jun 6, 2011

My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.

View 1 Replies View Related

Workflow :: AME Implementation In ADF

Jun 26, 2012

Can AME workflows be implemented in ADF?

View 3 Replies View Related

Workflow :: How To Set #FROM_ROLE To Sysadmin

Jul 30, 2012

How I can set the #FROM_ROLE to be from 'Sysadmin'?

View 2 Replies View Related

Workflow :: How To Find Initialization Variables

May 25, 2013

Where 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 Related

Workflow :: Display Name Coming Up With AMERICAN At The End?

Aug 13, 2012

For 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.

View 2 Replies View Related

Workflow :: Update Mail Attribute In OIM / OID

Dec 17, 2012

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

View 0 Replies View Related

Workflow :: ORA-02289 / Sequence Does Not Exist

Apr 27, 2013

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]

View 1 Replies View Related

Workflow :: Custom AWE Line Level Approval?

Jul 25, 2013

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?

View 0 Replies View Related

Workflow :: Process Stuck In Active Status

Jul 20, 2012

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 Related

Workflow :: Notification Timeout When Requested For Information?

Feb 21, 2013

We 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 ?

View 2 Replies View Related

Workflow :: Run Procedure Manually For Testing Purpose

Oct 23, 2012

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?

View 3 Replies View Related

Workflow :: How To Make Node To Deferred In Oracle

Aug 17, 2012

How to make node to deferred node in oracle workflow ?

View 2 Replies View Related

Workflow :: How To Get Response Of Notification Email From MS Outlook Express

Oct 20, 2012

I 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.

View 3 Replies View Related

Workflow :: Set Up To Open Arabic Version Of File In Builder

Mar 2, 2013

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.

View 4 Replies View Related

Workflow :: To Send Notifications To Multiple Supplier Email IDs?

Aug 26, 2013

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.

View 0 Replies View Related

Workflow :: How To Find Actual Responder Name Displayed In Notification

Feb 13, 2013

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

View 5 Replies View Related

Workflow :: When Set Vocation Rule - It Stuck All The Users Notifications

Sep 3, 2012

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.

View 2 Replies View Related

Workflow :: R12.1.3 Sourcing Award Approval Notification - Email Attachment

Oct 9, 2013

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 Related

Workflow :: How To Revert Back Or Rollback A Process To Its Initial Step

Oct 15, 2012

I 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 Related

RAC ASM Complete Shutdown And Startup

Jul 7, 2011

I 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]....

View 2 Replies View Related

Complete The OCA In 10g For Oracle Administration

Aug 5, 2013

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 Related

Private Strand Flush Not Complete

Feb 5, 2013

The "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"

View 1 Replies View Related

SQL & PL/SQL :: Finding Queries That Took More Than 15 Secs To Complete?

Aug 31, 2010

how to find out queries that took more than 15 seconds to execute.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved