Hi DBA's, Our customer is running the Payroll process , in which the Cobol process GPPDPRUN is being run by various users , randomly the process is in the...
Hi Prasad, I understand that there may be contention for rows in cases where the payroll is being run by simultaneous users (**Case for deadlock??). So one of...
Hi DBA's, The are the process scheduler o/p , The process gets stuck at this phase and throws no errors, Oracle Enterprise Global Payroll and Absence...
Hi I have developed the below code for W4 changes 8.9/8.48, So that State Tax data gets updated from the W4 Fed tax changes page. When i try to save I get...
I got the following sql from Oracle that was supposed to fix our 403(b) problem but it errors on the minus sign. I've tried everything to get it to run. Any...
It may very well be a reserved word, but it's not a command... At least nothing I can find documented in Oracle SYSADM@FSDEV>selectselect> year(sysdate) from...
Oh.... get rid of that parenthesis - it doesn't belong there. It's ending that paragraph of the select. Put it at the end of calendar_year after the other...
I do not think you want a minus. The way I read the code, you're taking a number value and subtracting another number value from it for each record. Using the...
You're correct. But it still isn't working. When I moved the right paren before the - sign I got another error. AND U.LIMIT_EXT_TYPE = S.LIMIT_EXT_TYPE - * ...
Use "find" command in unix/linux. Â Regards Vinayan ... From: H NG <psoftneto@...> To: psftdba@yahoogroups.com Sent: Wednesday, 23 July, 2008 3:01:29 PM ...
Stephen,  I assume you know that for your SQL update to be successful, the two select SQLs (one minus the other) on the right side of "Set" clause must...
I've tried this with various sets of extra brackets and I can't get it to work either. drop table t; create table t (a number); insert into t values (1); ...
Can someone if it is possible to copy project from people tools 8.46 to 8.49 ..I mean copy to file from PT 8.46 & copy from file to 8.49. Thanks, Sameer....
You can only copy directly between two databases within the same release. The only way to copy between two different releases is via a flat file. Export the...
Hello Everyone, Our Production App Server is getting crashed once in a while with the following error in the Appsrv log file: PSVerityPipeExec.1183748 (5)...
Yes. It is possible. Copy the project to file and save it. Open Application designer for 8.49 . Copy the project from file and open the file . Thats all. Â ...
Hi all, I am running request using system process requests screen. I want the output to be distributed to other users. The ends well and is posted. I am unable...
ok Thanks for information. ... From: balakrishnan senthil <besenthil@...> To: psftdba@yahoogroups.com Sent: Thursday, August 14, 2008 3:15:15 AM Subject:...
Check the status of the PSRF services... Also research report distribution, and the report manager in peoplebooks. peace, clark 'the dragon' willis PSA:...
Hi Tech-folks , I am looking at upgrading Peopletools from 8.46 to 8.49. I found out from customer connection that for PT 8.49 it needs upgradation of Cobol...