Hi Bob, In my opinion, you should not delete the Application Message. One reason that I know is if any message is in NEW status and developer wanna to post...
Has anyone worked thru this error message? How did you resolve the problem? ORA-01438: value larger than specified precision allows for this column in Stored...
How about exporting your text value to an environment variable and reading that in to your SQR via the getenv() function? Say your script exports the value -...
Jattin, Currently on DB2 v8.1 but we did the same on DB2 v7 as we do for v8.1 Take online backup of production environment, ftp to test environment server (we...
Hi All, i am having a problem in PS Query. i have added the record TREE_NODE_TBL then i am selecting DESCR field as the output field. But then the fields...
We do get this error and PS has not been able to fix this error so far. you can resolve this issue by Eliminating the problem employee. To get the problem...
We're being asked to modify the EEO-1 report (PER016.sqr) to select only actives, right now it includes those on layoff, suspension, etc. Basically any status...
Without having to go through a trace, does anyone know what Iscript or PeopleCode gets executed when a user clicks on the View1 or ViewAll hyper-links in a...
we had this kind of issue and got resolved after we increased decimal postion for this field in application designer as well as in cobol program , of course...
Talina -- Have you run a trace on the process when it fails? That will show you the bind variables of what is causing the failure. You can then check the SQL...
Hi Group, I have an Sqr that pulls the class start time and end time. When the classes are setup they enter the time in the local time zone for eg. 9 A.m EST ,...
Hi, We have a requirement for creating an interface file with SQR; the purpose is to extract JOB and PERSONAL_DATA and print the names and addresses in...
Our management has decided they want to change our class field to a smart coded system and would like us to change the field length from 5 to 8 characters. ...
How does anybody test for all the issues fixed by Oracle/peoplesoft in a release, we are upgrading to 8.9 from 8.4 SP1. It is overwhelming to read all the...
Hi, Anyone can help me out how to spawn new process without restarting the application server. It can be done by editing psappserv.ubx but for that we hve to...
Wouldn't the printer have to have the fonts installed? Regards, Paul Miliotto ... Hi, We have a requirement for creating an interface file with SQR; the ...
I wouldn't concentrate on testing isssues during an upgrade. I think the emphasis should be on system testing, or testing ALL the core business processes. If...
Very slowly, carefully, and extensively. Clearly it's a large functional effort. That's why some upgrade projects take a year to do. ... in ... understand ......
I assume that you are talking about the CLASS_FLD in the financials modules. If so: I've never had a client that changed the length of such an important and...
Hi Vimal, I was able to reproduce your problem, and I'm not sure why the key fields are added to the select section of the SQL. However, I noticed that when I...
Check the record definitions, sounds like one of the records has a related language record attached to it which causes the extra sql to be added whenever a...
THis is a PS thing. It does that on its own. Ignore it. don.barclay@... wrote:Hi Vimal, I was able to reproduce your problem, and I'm not sure why the...
I agree the emphasis on an upgrade should be a system validation of your business processes. We read the "fixed issues" and do checkout anything that applies...
I can't be a lot of help, but I do know at one point we had a problem where a character set worked OK in the DBMS but wasn't correct in our UNIX server. So...
Hi, Maybe you have a group by on one of your record. Remove it if it is not necessary. But anyway it is not really important. You can just ignore it. Sincerely...
Soap box alert on... "Smart coded" is, in my humble opinion, a misconception. The problem with making codes mean something is that the meaning can change and...
You didn't give your tools version.... which can matter since SQCs changed dramatically between 7.x and 8.x. But, hopefully this will work... checkout the...
Raymond, This should be an easy modification. Look for this code in the SQR: (search for EMPL_STATUS) AND ((J.EMPL_STATUS = 'A' AND J.EFFDT <= $ThruDate) OR...
Here my two cents after reading all replies (by the way, I would also like a copy of the document that did not come through. Release 8.9 is the last true...
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.
