We have a product called TeamQuest http://www.teamquest.com/ which we use to gather statistics on database, webservers (we use BEA 8.1) as well and what...
I have a follow-up question. We run our PS databases in a shared server environment. We have many non-PS databases on our prod db server. Each db has...
how about creating a database link and then doing a create as, and then populating the table? peace, clark 'the dragon' willis PSA: Salary <> Slavery. If you...
how about exporting the table from SQL server into a delimited text file and importing this text file to Oracle using sqlldr ? the dragon <ceprn@...>...
This is would be a hetrogeneous database link. You need to set up Hetrogeneous Database services. Its not very difficult, it requires an Oracle Listener on a...
Thanks and yes I was wondering what datatypes would give me problems..Apart from long are there any other datatypes. As this is a one time thing I will...
You need to think about the differences between the two platforms. Be careful with dates. SQL Server has separate date, time and datetime fields. Also times...
Hi All, I am using a vanilla FSCM database. The PS_EMPLOYEE table has been deleted by someone else. So can u please help me in retrieving the PS_Employee table...
i have installed oracle 9i and peopletools 8.49 & the application on my laptop i am tryin to create the Database ... should i install the DEMO or first the...
Hi Sunil, You don't mention which RDBMS you are using. If you are on Oracle 10g, you may be able to use flashback query to retrieve your data. If you are on...
Hi Sunil, PS_EMPLOYEE ? Is that a custom table or do you mean PS_EMPLOYEES ? And do you mean financials? It doesn't exist in FSC. Maybe you meant HCM? Bob ...
If you can't restore from the backup or query flashback, your could try exporting/importing just that table from a recently refreshed db. Might be better than...
Hold on - what are we doing. PS_EMPLOYEES can be refreshed from the Refresh Employees Table process. Just run that. Voila. Robert Ellis PSE Data Security...
Has anyone removed _complex_view_merging=false when upgrading from 9i to 10.2.0.2? We are trying to figure out if it is still needed. Thanks. Bill ... ...
I haven't had cause to set _complex_view_merging in 10.2, and there is no specific advice from PeopleSoft/Oracle so to do. The following is a quote from the...
Guys, A general question. 1. For example PeopleSoft just released bundle #6 for PeopleSoft financials 8.9. How and where would you apply it? How would you know...
Sorry, that is obviously an interview question, and if you can't answer it, I personally am not going to assit you in getting a job you're obviously not ...
Vinay, On the off chance this is peoplesoft data, how about the export/import commands in datamover? I've not tried it across database types though. John...
Note: forwarded message attached. ... No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. Hi I have a confusing situation....
Hi, I am getting the following error in the App server logs as well as the Prcs logs , this error comes with Perf Monitor service running in the Apps server , ...
Thanks guys..I got this resolved. I created a table in Oracle with similar coulumns as in the SQL server. I used SQL server DTS to transfer data... Thanks for...
Hi, We upgraded our oracle database from 10.1.0.4 to 10.2.0.3. in our TimeAdmin batch jobs, All peoplecode fails. Do we have to do anything with peoplecode...
Most of the time Data Moving between Oracle and SQL Server works fine. You may have to do some editing of the DAT file if you have dates prior to 1900 etc. ...
It would be helpful if you posted the specific PeopleCode and SQL statement that is causing the problem. regards _________________________ David Kurtz ...
Any rules of thumb for app server sizing with 8.49? For a given number of concurrent users: How many app server process should be running in FN? HR? How may...
We had a situation where nested sub-queries were giving ORA-600 error messages on 10.2.0.3 whereas on 9.2.0.6 they worked fine. The work round is to set the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
