Workflow :: How To Find Initialization Variables
May 25, 2013Where 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
ADVERTISEMENT
Workflow :: How To Find Actual Responder Name Displayed In Notification
Feb 13, 2013Where 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
Workflow :: Send Attachments To Requester In AP Invoice Approval Workflow
Sep 4, 2012We 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?
PL/SQL :: How To Find Difference Between Timestamp In Two Variables
Aug 1, 2012how to find the difference between time stamp in two variables.
Say in a java file i am getting start time and end time i am storing it in a string variables now i need to know what is the time difference of them in millisecond
Srting1 of java will give me some thing like
StartTime =2012-08-01 15:14:20.36 +5:30
Srting2 of java will give me some thing like
EndTime =2012-08-01 15:14:21.254 +5:30
I need to take the millisecond difference between them the code i have written in java and connecting oracle database and doing some logic's in java so i need to capture start time and end time of code.!
Workflow :: Error While Deploying A Workflow In OWB
Apr 3, 2013I 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.
Workflow :: PO Approval Workflow Change
Sep 17, 2012i`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#.
Workflow :: HRSSA Workflow Errors With 3120 - Activity HRSSA/343959 Has No Performer
Oct 3, 2013After 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?
SQL & PL/SQL :: Local Variables Are Bind Variables
Apr 27, 2012Which of the below is considered a bind variable. In example one proc. Test the parameter p1 is directly used in the query, so this can be considered as a bind variable.
Is that true about the second proc. where p1 is assigned to a local variable v1 , or this needs hard parsing because v1 is not a bind variable ?
Create or replace procedure test(p1 IN VARCHAR2,p_refcursor OUT SYS_REFCURSOR) IS
BEGIN
OPEN p_refcursor FOR select * from Test_tab WHERE item=p1;
END;
------------
Create or replace procedure test1(p1 IN VARCHAR2,p_refcursor OUT SYS_REFCURSOR) IS
v1 varchar2(100):=p1;
BEGIN
OPEN p_refcursor FOR select * from Test_tab WHERE item=v1;
END;
SQL & PL/SQL :: Initialization Of Varray Variable?
Aug 30, 20111.)different ways to initialize a varray variable. one way i know is
declare
type nt_type is varray(4) of numer;
nt nt_type:=nt_type();
begin
...
..
...
end;
2.)is it possible to initialize a varray variable in begin section.
3.)
decalre
type nt_type is varray(4) of number;
nt nt_type;
begin
null;
end;
in this situation if i want to initialize a varray variable "nt" in separate stmt how to do it and where to write it?
SQL & PL/SQL :: ORACLE Initialization Or Shutdown In Progress
Oct 11, 2011I try to login to my server but got "Login Error: SQL Error State 08004 , Native Error Code : 409 , ODBC Error , [Oracle][ODBC][Ora] ORA-01033 : ORACLE initialization or shutdown in progress".
View 3 Replies View RelatedNotification In Workflow
Jun 6, 2011My PO notification is showing only 5 lines even PO contains more than 5 lines. new to workflows.
View 1 Replies View RelatedWorkflow :: AME Implementation In ADF
Jun 26, 2012Can AME workflows be implemented in ADF?
View 3 Replies View RelatedORA-01033 / ORACLE Initialization Or Shutdown In Progress
Feb 16, 2011i have a Problem when i try to connect to my Database Oracle 10.2.
every time i tried to connect to my database the Message: ORA-01033: ORACLE initialization or shutdown in progress appear.
In the alert.log there is the last writen part:
Wed Feb 16 21:55:54 2011
Errors in file d:\oracle\admin\v8\bdump\v8_arc0_5220.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 102385664 bytes disk space from 21474836480 limit
[code].....
In the morning i still work with my database then it freez and after restart the System i get everytime the same error Message.Start and stop the Oracle Service does not work.My system is Windows XP SP 3 if this is importend.
Installed Oracle 11.2.0 On Windows 7 64 Bit - Initialization Error
Mar 20, 2011I install Oracle 11.2.0 on Windows 7 64bit and i install PL/SQL Developer.
when i run the PL/SQL and connect to Oracle i get this error:
Initialization error
Could not load "C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll"
OCIDLL forced to C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll) returned 0
Server Administration :: Which Initialization Parameter Can't Be Changed
Apr 29, 2012which initializaion parameter cant be change after creating the database?
View 5 Replies View RelatedORA-01033 / ORACLE Initialization Or Shutdown In Progress In 10g
Sep 22, 2011I am facing with the following error where I can not log into the iSQL*Plus 10.2.0.3.0.
ERROR - ORA-01033: ORACLE initialization or shutdown in progress in oracle 10g.
Workflow :: Activities Which Are Not COMPLETE
Jan 16, 2013I'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 View RelatedWorkflow :: How To Set #FROM_ROLE To Sysadmin
Jul 30, 2012How I can set the #FROM_ROLE to be from 'Sysadmin'?
View 2 Replies View RelatedORA-01033 Oracle Initialization Or Shutdown In Progress Error
Nov 11, 2013I am using windows 7 on my 64-bit machine, and I installed oracle database 12c. Everything was installed fine, and i was able to connect to the HR schema. However, the next day when I wanted to connect, I got the ORA-01033 Oracle initialization or shutdown in progress error.
View 10 Replies View RelatedORA-01033 - Oracle Initialization Or Shutdown In Progress Not Working?
Oct 11, 2012C:>sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Oct 11 09:56:23 2012
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
SQL> startup nomount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01109: database not open
[code]...
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>
Workflow :: Display Name Coming Up With AMERICAN At The End?
Aug 13, 2012For 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.
Workflow :: Update Mail Attribute In OIM / OID
Dec 17, 2012we 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
Workflow :: ORA-02289 / Sequence Does Not Exist
Apr 27, 2013I 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]
Server Administration :: Initialization Parameter File - Currently In Effect For Session
Jan 31, 2012I have a question about spfile.
SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20
v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.
Server Administration :: ORA-01033 / Oracle Initialization Or Shutdown In Progress
Oct 14, 2010When I am trying to connect to sql from scott or any other user i am getting this error message ,
ORA-01033: ORACLE initialization or shutdown in progress
I have been getting this error message for 4 four days . Butt when i am trying to connect from SYS user it connects successfully ,but when i do query it gives me following error message .
ORA-01219: database not open: queries allowed on fixed tables/views only
I shutdown Database from SYS user ,and start it again .But at startup it gives me following error message .
ORA-00204: error in reading (block 3, # blocks 8) of control file
ORA-00202: control file: 'D:ORACLEPRODUCT10.2.0ORADATAORCLCONTROL03.CTL'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).
Performance Tuning :: Setting Flash Cache Initialization Parameters?
Aug 11, 2010I have OEl 5.5 installed and patched. I have my SSD mounted..
but when i ran the command 'alter system set db_flash_cache_file ='/media/ssd/' scope=spfile;'
It wouldn't startup giving ORA-01078: failure in processing system parameters...
Server Administration :: ORA-01033 Oracle Initialization Or Shutdown In Progress
Jul 1, 2010when i am using sql prompt and enter username and password scott and tiger it is giving error ORA-01033 oracle initialization or shutdown in progress.
View 9 Replies View RelatedNetworking And Gateways :: Ora-01033 - Oracle Initialization Or Shutdown In Progress
Feb 24, 2010I am getting the error 'ora-01033: Oracle initialization or shutdown in progress' when I try to login into oracle. It was working fine some days ago.I tried the below steps :-
C:Documents and Settingssk32740>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 24 14:31:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
[code]....
Server Administration :: ORA-1033 Error Initialization Or Shutdown In Progress
May 16, 2012I have oracle 10g as well as oracle 8i on my server. currently we are using oracle 10g. now we get the following error when we try to connect to oracl 10g database.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:Documents and Settingsomni>cd
C:>sqlplus
olog
The system cannot find the path specified.
C:>sqlplus/nolog
SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 15 16:39:13 2012
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> connect sys/admin as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
LRM-00109: could not open parameter file 'D:oro8iDATABASEINIT.ORA'
ORA-01078: failure in processing system parameters
The location of pfile of oracle 10g database is c:/oracle/product/10.0.0.1/admin/pfile.
Workflow :: Custom AWE Line Level Approval?
Jul 25, 2013creating 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?