I am extremely interested in this thread and I can't sleep so I will give a quick overview (or semi-intelligent rant) of how we achieved this with one of my...
4896
RAVISHANKERAN R
ravis1973
Oct 25, 2012 7:42 am
Hi, Can anyone explain why we need to use SET ENABLED_DATATYPE 9.0 or 9.1 during import * . I know this has been used during initial database creation using...
4897
mail2harish143
Nov 3, 2012 9:39 am
Hi, I would like to know whether we need to inform Oralce if we are planning to Upgrade a Campus Solutions 8.9 MP1 to 9.0. Will our existing license code will...
4898
the_dragon Draco
ceprn
Nov 3, 2012 11:57 am
If you have been paying maint, all upgrades are free, and they don't really care. Or that's my understanding. If you haven't been paying for maint, then you...
4899
imtiaz awan
huzaifahi
Nov 5, 2012 8:48 am
Dear all                I am going to install people soft on linux.people tools version 8.51 and oracle on linux version 5.8 oracle Database...
4900
skilaurieski
Nov 6, 2012 4:35 pm
Hi, We have severe optimizer instability when running nVision reports on our Financials system. We are on Oracle 10.2.0.5 and PeopleTools 8.49. Reports...
4901
David Kurtz
davidkurtz
Nov 6, 2012 5:11 pm
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...