Laurie I have written about nVision in the past - see http://www.go-faster.co.uk/pres.htm#nvision_performance_tuning and ...
4902
Laurie Murray
skilaurieski
Nov 6, 2012 9:04 pm
Hi, David Thanks for your response! 1)Â use_literal_field_values is unchecked. Â Cursor_sharing = Exact 2)Â ps_ledger: haven't considered partitioning by...
4903
David Kurtz
davidkurtz
Nov 6, 2012 9:28 pm
Laurie 2. Consider partition by range(fiscal_year, accounting_period) – you can do a range partition on the combination of two columns – it still only one...
4904
Laurie Murray
skilaurieski
Nov 7, 2012 12:08 am
Here is the bad execution plan, per your request. Thanks for the ideas you already sent! I look forward to trying them out. --Laurie ... ...
4905
Ashish Bhatt
ashishb.rm
Nov 14, 2012 5:32 am
Dear All, I hope you are doing fine today. We have Peoplesoft HR 9.1 on Oracle database 11g. It is hosted by 3rd party. We have Peoplesoft Finance 8.4 on...
4906
BANKS, Richard
BanksR@...
Nov 14, 2012 5:35 am
Have you considered PeopleTools Integration Broker, using the delivered enterprise integration point? From: psftdba@yahoogroups.com...
4908
Andy Wheatcroft
andywheatcroft
Nov 14, 2012 6:12 pm
Another option is Materialized Views. I have a split CS 9.0 and HR 9.0 environment with all sorts of data sharing between the two databases: Integration Broker...
4909
jagat
jagadatma
Nov 15, 2012 9:17 am
Hi Ashish, You can use multiple ways to do it. 1. Use Data mover to export data from your oracle 11g and then import it in your 9i DB. 2. use traditional...
4910
imtiaz awan
huzaifahi
Nov 29, 2012 11:37 am
I am facing cobol compilation problem in people soft ../pscbl.mak: line 57: pscbl_mf.mak: command not found My database is oracle 11g R2 People Tools 8.52 HRMS...
4911
Nicolas Gasparotto
gnom92
Nov 29, 2012 12:02 pm
Please have a look to the My Oracle Support Note : E-COB: Cobol Compile Error "pscbl_mf.mak: not found" [ID 1420173.1] Nicolas....
4912
tom12l
Nov 30, 2012 4:50 pm
Every once in a while we get the following message sent to our email acccounts indicating there is a problem withthe PSAPMSGPUBCON table. I am unable to...
4913
mwallred
Dec 7, 2012 5:25 pm
We're upgrading to HR 9.1 & PT 8.52 and have this shiny new database server with lots of horsepower and memory. I thought I'd see if anyone had any suggestions...
4914
mwallred
Dec 7, 2012 6:04 pm
I forgot to mention... This is on Windows Server 2008r2 64bit and with Oracle 11g. Thanks....
4915
ewayte
Dec 10, 2012 5:32 pm
... My Oracle Support Doc ID 1445965.1 "Advice For the PeopleSoft Oracle DBA" is the first place you should look. Required parameters: _unnest_subquery = false...
4916
srisaro
Dec 21, 2012 12:29 pm
Please check the message which is in error out status or it might be still in processing status. Any junk characters in the message would also cause this...
4918
srisaro
Jan 10, 2013 6:15 pm
Hi, We are in PeopleTools 8.18 and 8.3 HRMS. We are planning to copy the PS_HOME to another windows server and trying to bring up the services. I would kindly...
4919
the_dragon Draco
ceprn
Jan 11, 2013 12:37 pm
1) you need to have all the software PeopleSoft needs installed first - tuxedo, weblogic (if a PIA server), java, cobol, etc. Otherwise it won't work 2) You...
4920
srisaro
Jan 11, 2013 1:01 pm
Thanks Clark. I will surely consider the pre installations required for this. The reason why this kind of an activity is in plan is that we don't have the...
4921
the_dragon Draco
ceprn
Jan 11, 2013 3:56 pm
My apologies - the question made me think it was not an admin asking it. If you don't have the install media, just cloning the PS_HOME will not work. You'll...
4922
srisaro
Jan 11, 2013 4:41 pm
No Problem Clark, no need to apologize for this silly matter. Now, actually, we have three diff server in which three app servers are configured in production....
4923
vinod kk
vinod_kk1
Jan 12, 2013 5:34 pm
Hi Sri, In the new windows server, install tuxedo, crystall and oracle client. Copy the PS_HOME to this new server and reconfigure it. Am a beginner in psoft...
4924
wjgioioso
Jan 23, 2013 7:57 pm
Hi, I'm wondering if anyone has experience with cloning a PS virtual server. In our case it would be a virtual MS Win2008 server with Jrockit, Weblgic, Ptools,...
4925
srisaro
Jan 28, 2013 10:42 am
Thanks Vinod. Surely take your recos. Will update you all once I've done testing. Thanks and Regards, Sri....
4926
RAVISHANKERAN R
ravis1973
Jan 29, 2013 10:15 am
Hi Sri, You can download the old tools version from the following site. ftp://ftp.oracle.com/peoplesoft/outgoing/ptools/ But,I find only PT8.18.10 not PT...
4927
Manoj Negi
negi2u
Feb 2, 2013 9:32 pm
Hello Gurus,  Is anyone has any idea about -jrockit flag. I want to know how to enable this flag; If setEnv has this flag ("java -jrocket") along with the...
4928
Ramesh
rameshsraj
Feb 4, 2013 7:48 am
Manoj, Reply from Oracle as Below: Oracle Support - February 11, 2011 3:31:00 PM GMT+05:30 [ODM Action Plan] JRockIt should be installed at the same time than...
4929
srisaro
Feb 12, 2013 4:49 pm
Hi Bill, If you see my thread where I'm trying for the same in Windows 2000 server, being that a virtual one as well. I will try that in Windows 2000 and let...
4930
Ragineni Maheswar
mragineni
Feb 13, 2013 5:09 am
Hi, Â Yes its possible through Windows Image. Â Cheers Mahesh Ragineni Hi, Yes its possible through Windows Image. Cheers Mahesh Ragineni...
4931
srisaro
Feb 13, 2013 8:45 pm
Hi Ravi, Thanks for your help and sorry for the delayed response. Yes, even I found the same before getting into this cloning idea. But actually I want...
4932
the_dragon Draco
ceprn
Feb 13, 2013 9:09 pm
You can try this, but I have no confidence in its success. Install using the media you do have, and then compare directories between your source server and...