Everything is handled by the process scheduler. peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you earn a salary, your employer is renting your ...
4806
deepanshu_elc12
Apr 27, 2012 7:38 am
If I am correct that has to be done at the SMTP level it cannot be done from PS side. You can request your network team to put a rule at the smtp sender but in...
4807
Devesh Padmanabhan
devesh_mp
Apr 27, 2012 7:38 am
Nevermind.. I figured it out .. its the Master Scheduler that does this job. On Thu, Apr 26, 2012 at 4:04 PM, Devesh Padmanabhan <...
4808
Deep Pandey
deep_tkt
May 1, 2012 11:38 am
Has someone successfully setup Oracle VM templet for Peoplesoft on Amazon EC2. I am able to login but the database or app servere setup are not launching...
4809
Deep Pandey
deep_tkt
May 1, 2012 3:31 pm
Ok i figured it out. Run this. attached Thanks! Deep ... -- Thanks, Deep...
4810
Rajan Rikame
rrikame
May 6, 2012 6:16 am
Thanks Deepanshu for the reply! Since we have job server (sends email for jobs status) on the same Machine where PS apps is we cannot restrict at OS level. ...
4811
rsalido@...
rsalido
May 10, 2012 5:24 pm
Hi, Â Â We have a situation with a peopleSoft Query. If we run such query from Query (PeopleSoft's product), we get one row. But, if we grab the SQL and run...
4812
Ashish Bhatt
ashishb.rm
May 10, 2012 5:31 pm
Please copy paste the SQL in the mail. Thanks in advance. To: psftdba@yahoogroups.com From: rsalido@... Date: Thu, 10 May 2012 10:24:14 -0700 Subject:...
4813
Andy Wheatcroft
andywheatcroft
May 10, 2012 5:42 pm
Row level security! PS Query may add additional predicates depending on the tables you reference. In particular, if a table has OPRID in a key field, it will...
4814
rsalido@...
rsalido
May 10, 2012 5:43 pm
Here it is but I dont think the SQL is the issue. The SQL runs but the results sets are different depending on the tool used to submit it. Â Thanks! Â SELECT...
4815
Wong, Jane S.
janewong_cal
May 10, 2012 5:44 pm
Can someone remove me from this group. I’m not sure how I was added on but I do not need to be included. Thanks! Jane Jane Wong Creatives Services Advisor ...
4816
James De Atley
jamesdeatley
May 10, 2012 5:47 pm
It's not.  Andy already mentioned PeopleSoft row level security. That's where I would start looking. Using PeopleSoft you must jump through this security...
4817
David Kurtz
davidkurtz
May 10, 2012 5:55 pm
Is it possible that you have hit the maximum query size specified in the Application Server configuration? Note i) the default settings are...
4818
rsalido@...
rsalido
May 10, 2012 6:24 pm
This is a really good thought. However, I just ran into a new issue: TOAD is returning diffrent result sets. Â MOST of the time I get 1200 rows back but there...
4819
sat17singh@...
sat17singh
May 10, 2012 7:14 pm
Have you just upgraded to 11gr2? We had a similiar issue turned out to be a bug , check metalink. - Sent from my HTC on 3 - ... From: rsalido@... To:...
4820
margery brauner
mbrauner2
May 10, 2012 8:56 pm
did you generate a trace from query? Compare the sql being executed by query to that you are executing in Toad. There was also an issue pt 8.51 issue pre...
4821
rsalido@...
rsalido
May 10, 2012 9:00 pm
Just as a heads up to the group: We think this issue might be related to an Oracle bug specific to prefetching. Depending on what Oracle version you run, this...
4822
rogbak_er
May 11, 2012 2:04 am
... Sorry for the late response. Here's a brief summary of what we (I) do, I am sure it's not the most efficient. First off, we do datapump exports of our Prod...
4823
the_dragon Draco
ceprn
May 11, 2012 10:48 am
I remember something like this from a couple of years ago - it required an Oracle patch, if I recall correctly. Could it be some kind of strange shared pool...
4824
Timothy Herring
nitehawke...
May 11, 2012 4:01 pm
There is an Oracle bug that returns inconsistent data-sets related to unnest_subquery PS recommended: *._unnest_subquery=FALSE ... From: the_dragon Draco...
4825
vijaydamodaran
May 11, 2012 4:02 pm
We have a job that can be run for one employee or a range of employees. When we run it for 1 employee it takes about 15 seconds to complete. We need to run the...
4826
Graham Bowden
grahambowden@...
May 11, 2012 7:38 pm
You could... There is a people code verb scheduleprocess (it changed name so check people books) so you could create a process that schedules all the jobs. It...
4827
the_dragon Draco
ceprn
May 11, 2012 9:49 pm
Sure - you can insert rows in the process request table, but I'm not certain this is a good idea. Perhaps there is some other way to narrow down the list to...
4828
Lantzy, Pamela L
neysalynn
May 12, 2012 7:48 pm
You can create an app engine that can submit a process for a particular run control id .. so if the run control table for the process is setup for the specific...
4829
ajay narula
narulajy
May 14, 2012 9:49 am
Hi All, Â Recently I have started facing the issue for one of my PS HRMS instances. HCM: 9.1 , PT: 8.52 Â The PIA hangs and when I check for the Doamin...
4830
David Kurtz
davidkurtz
May 14, 2012 9:57 am
What this shows is that two PSAPPSRV processes are busy running ICPanel services. If this persists and the RqDone doesn't increase then you have a problem with...
4831
the_dragon Draco
ceprn
May 14, 2012 10:15 am
In addition to what David said, this usually points to a custom component with crap sql code behind it. Run a trace and maybe you can catch it. Your users...
4832
Wong, Jane S.
janewong_cal
May 14, 2012 2:20 pm
Hello, I would really appreciate it someone could take me off this email list. Thank you. Jane Wong Creatives Services Advisor Customer Service &...
4833
Andy Wheatcroft
andywheatcroft
May 14, 2012 2:51 pm
Jane, I believe all you have to do is send an email to: psftdba-unsubscribe@yahoogroups.com and you will be taken off the list. Andy. From: "Wong, Jane S."...
4834
soubhagya upadhyay
soubhagya_up...
May 14, 2012 3:54 pm
Hi, There is definitely a long running process causing the issue. It would be better if you can involve your DBA to find of the long running sqls. Stay with...
