morning. One of my DBAs has seen the following sql running about 30,000 times a day, and wanted to know if anyone had any ideas about it... is it an issue?...
1) In your DMS script - remove all lines before createvw.dms 2) add ---> set statistics off 3) Save as some temp.dms 4) open temp.dms and execute  It...
Hi All, We are facing this error, COBOL Program GLPPPOST aborted (2,-1) JRNL_PANELS_WRK.PB_POST.FieldChange Name:post_jrnl PCPC:855 Statement:2 Called...
Hello Everyone,  Just want to know if we have to retrofit a SQR where a particular table is split into two tables and we need some of the fields (50) from...
What are your thoughts on changeing the Very Porwerful 1's password. We only use it one rare occassions to review a problem. The Places I can think of where...
Hi This could sound simple. When the users are running the PSQueries from PIA, if the queries run for more than 11 mins, the user gets logged out off the PIA...
We are developing a custom Utility tool(Productivity oriented) to automate most of the tasks in PeopleSoft. I thought if i could get some specific feedback on...
Hello All, I am running one app server for past one and a half years but the servers having a problem now i have two questions to ask now- 1) What should i do...
We just did a refresh from our production database into our QA database. One problem I am having and is the Host Name in the Process Scheduler still points to...
Are there any "gotchas" with changing the connect id and or password? (people/peop1e) I know there is no intelligent reason to do so, but security "auditors";...
My organization is moving peoplesoft environments to AIX 6.1. There is talk that in new system we might want to go with single application server & web server...
Can anyone one explain the process of setting the integration broker setup as i don't have much experience on the real environment. Scenario is like this ...
Hi We have a number of process scheduler jobs that have a recurrence schedule . This morning, every time the jobs ran, they re-submitted themselves twice. We...
Hi, Â We have just converted our DB to RAC 11gR2 and we are on PT 8.49, Apps FS Brazil 9.0. Now, after converting to RAC (Two node system) we are seeing lots...
Experts, Throw your thoughts on report sharing between two environments. my business req is FMS team wants to their reports in HR ennvironment whithout logging...
Hi, If a company has purchased 1000 self service licenses for HRMS/CS. What does this 1000 number means? Does this means max 1000 users can access the system...
I was looking up the certification status of PeopleTools 8.50 with Oracle version 11.2. The top of the document that I found says Product: PeopleSoft...
We are using Multiple Application Server Domains in our configuration.properties file and all the app. Servers domains have PUB/SUB configured and active:- Go...
Hi All - I am trying to see if anyone has completed an analysis on how many RAC nodes is optimum for PS applications.  Here is the logic.  PS has a lot...
Hi, Sometimes when user runs the query from query manager they get information alert 504 gateway timeout error. Please let me know what are the possibilities...
While processing the responses of sync messages, we see difference in seconds between "Pub/Sub time stamp" and "updated" Time stamp for some messages in...
While processing the responses of sync messages, we see difference in seconds between "Pub/Sub time stamp" and "updated" Time stamp for some messages in...
Does anyone have a script to copy a Permission List from one database to another. Or better yet to copy all of the security from one database to another. We...
I want to trace the flow of a cobol program. I know I have to uncomment the code in PTCLIBFX and recompile the program I want to trace. Is there anything else...
We are currently on PT8.46 and HRMS 8.9 and planning to upgrade. Do we need to purchase new license from oracle or as we are in contract with oracle they will...
