After you do what Jim said to do, you'll have an audit record ready and waiting to be used. Then, go into App Designer, open the table you want to audit and...
I have never encountered any problems with implementing tax updates during open enrollment. All of the Ben Admin tables and programs are pretty well...
Hi all , i have to change the font color of links like "Home", "Worklist ", "Add to favourites" which is in the top right hand corner of the PS page from white...
It works and it is clearly specified in the PeopleSoft document. ... From: drnichols@... [mailto:drnichols@...] Sent: Tuesday, August 31, 2004 8:03 PM ...
Yes, I'm running the query from 2-Tier. I have set the Query Templates directory path to the path where my EXCEL.EXE file is. But I'm still receiving the...
Hi Dorairaj, There is no delivered function in SQR whihc returns random number. There are three ways you can accomplish it. 1. Write own functions in other...
It is difficult to do a "true" random, but you may want to look at creating a number based upon the date, hours, minutes and seconds of the system clock. You...
Hi All, Thank you for your suggestions, I have decided not to use the Record Level audit, as it does not track changes made using SQR'S and Application Engine...
After you changed the stylesheets, did you stop the web server and delete the web cache? You might want to do that if you haven't and then retest it....
You get this error when the workstation ODBC driver from PeopleSoft has not been installed properly from configuration manager. On the client setup Tab in the...
hi I am Transfering my projects from development server to production server. In peoplesoft 8.8 i can insert a object with all of its related definitions and...
Could you set up triggers on these tables, so that whenever data is changed, the new row can be inserted into an audit table? If the trigger was on the table...
Ditto. But do a really great test! Jim McKeever <jim_mckeever2002@...> wrote:I have never encountered any problems with implementing tax updates during...
Thanks for the information. In your experiences did you encounter the Retro Pay calculating for all employees w/ a back date? They are showing up as Zero...
HRMS 8.3 SP1 I am loading phone numbers into the PS_EMPLOYMENT table PHONE field and want to be able to load an extension. We are using the delivered PHONE...
Ware 8.3 sp1 and we load the extension only in PS_PERSONAL_PHONE. In personal_data we only have the phone without extension. Guess that doesn't help you. In...
The SQR command print-image can print files that have BMP or HPGL extensions. Also, you should provide the printer type parameter, as a runtime argument in the...
I am on 8.4 and running the Publish Outbound Message (IN_PUB_MSG App Engine) successfully but instead of going to the web I want the file to go to a specific...
All, I am trying to write a file out to the NT box when running on the NT server. According to the sysadms, the NT looks at e: . I have tried both hardcoding...
can you look at the NT server yourself? Is the file in the directory you expect when your process is finished? If so, close the file before trying to pgp and...
we did this, on App engine EOL_PUBLISH.FLATFILE.Step05 we created bat file to save the file to other share Local string &RESTART, &ORDER_BY, &FILE_CREATED,...
Hi all, Does anybody know in what table PS stores the permission lists associated with a menu item? Thanks in advance GV. [Non-text portions of this message...
I think the db trigger option is the best to capture all types of changes to the record. drnichols@... wrote: Could you set up triggers on these tables, so...
Hi , The Answer to ur First Question is 1) Yes it will overwrite ..., as you cannot do a compare this is the reason why Peoplesoft always asks you to apply new...
Hi all, Random function does not exist in SQR, ...but you can create a random function in C, it's easy, here's the step to follow : To Write a Custom Function ...
i had done that...but still its the same .. Thanks. ... delete the web cache? You might want to do that if you haven't and then retest it. ... tried...
