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:...
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...
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...
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 ...
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...
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...
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:...
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...
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...
... 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...
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...
There is an Oracle bug that returns inconsistent data-sets related to unnest_subquery PS recommended: *._unnest_subquery=FALSE ... From: the_dragon Draco...
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...
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...
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...
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...
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...
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...
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."...
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...
Hi Gurus, How can we add components into menu automatically after migration. we are having components with portal registry structures. those are getting...
4836
Graham Bowden
grahambowden@...
May 23, 2012 5:32 pm
Migrate portal registry stuff Run portal registry sync May also need to clear web server cache and potentially web browser cache (where you get differences...
Thanks Graham. what i was looking for is addition of components into the menu once we migrate them. its not happening automatically after migration. so i was...
Greetings and salutations, throbbing brain; PT 8.50.18 HR 9.1 PA 9.1 Have a really strange issue. I have two systems, a production and a non-prod. Basically...
4839
Graham Bowden
grahambowden@...
May 24, 2012 5:15 pm
Permission denied - leads me to think of authentication cookie domains not all being same (web and app servers ) and cookie name or load balancer interference...
Solution - the web profile being used had http rather than https on the virtual addressing page. Happy weekend. peace, clark 'the dragon' willis To:...
