I think it's optional, but you definitely do not need it. I've never used it or seen it used in any of the delivered peoplecode I've looked at. ... From:...
Hi All, We are on PS HR v7.5, Unix, Oracle. We have a peculiar problem as follows - SQL> select emplid from ps_emplmt_srch_gbl where emplid = '1002999' and ...
Hi all, I need an immediate help from all the guys who have worked on Asset Management and the Accounts Payable interface. We have the following situation in...
Hi Anyone plese tell me how to configure peoplesoft7.5 with oracle8/9i Regards Moin ... Yahoo! Messenger Show us what our next emoticon should look like. Join...
Hi Gurus, Is there any code to get exact age in years, month and days in SQR? If anybody has a code for this can you please send me. thanks -Gopal Yahoo! India...
We are in the initial stages of setting up Canadian EFT with Royal Bank of Canada for a subsidiary. We have received the specs from the bank, RBC STANDARD...
Sorry Gurus but this is what I am stuck at. 1. I need to Load Excel file into Oracle/Psoft (2. I can use a AE program I guess). 2. I need to automate it with a...
Hi Anyone please tell me how to configure peoplesoft7.5 with oracle8/9i Regards Moin ... Do you Yahoo!? Yahoo! Small Business - Try our new resources site! ...
If the compiler accepts the code, that is no excuse to capitalize on it. It may cause you problems later on due to other parser errors becoming compounded...
You create the asset before and after you want to add the cost of the voucher to this asset ... why you don't put the asset code on the row of the voucher ? ...
I don't use a ";" after then, but if it works, why does it matter? And this comes from someone who is very very particular about syntax and overall look of...
You don't need the semi-colon for evaluation statements like If / Then /Else, Evaluate / When, For &i = 1 to &LVL1.activerowcount, While SQL.Fetch. Whereas...
Hi Stuart, That's actually what I have already for the script - I figured that out the first time I built a custom view. I keep the build scripts separate and...
Hello All, I have a problem with a prompt record. I have to create a prompt record that has a User's direct reports and his direct reports' direct reports and...
Is there anyway to set up Depreication Accounting entries so that the the Department ID value will be retained for the Depreciation Expense entry but can be...
You can do that in your journal generator template. Set your template to summarize by account for all accumulated depreciation accounts. It will however...
Kathy....tough one here to do with just a view. I have done it before but it gets pretty complicated and not very efficient. How about a table that you load...
Hey fans, we are working on our check/advice stub and I have been looking into the origin of the employee address information. If my testing is valid, the...
I totally agree with "pplsoft_curt". If I were you, I would adhere to and work within the PeopleSoft rules and have that semi-colon after the "then" removed -...
Sorry - mistaken on previous post - the function you want is this one... begin-procedure Diff-DateElapsed ($indate1,$indate2,:#wkYears,:#wkMonths,:#wkDays) if...
I've just uploaded something in the FILES section that might get you on your way. It's called "BestDamnFL-v1.1.zip" (yeah, I've got no ego at all) and it's an...
Thanks Corey Not sure if that will work since we need to department populated for the expense side. If we summarize by account, won't it blank out the expense...
Barbara, It sounds like you have named all of the ones I am aware of. The only additional one that relates to pay is the ability to change it during W2...
I have created a Role Query and designated it as such in the Query properties box. In App Designer I can see and use PS delivered Role Queries, but not the...
Yogesh, Build the view to a SQL script and use that in your join, you'll likely see right away what the problem is. Bruce ... Sent using cyberus.ca WebMail -...
When you set up the journal generator template, you can tell it to retain detail on some accounts and summarize other accounts. ... From: Vince_Lombardo...
well i would like to give u some idea but i don't know whether it will sound good for u or not i have done an app engine program using filelayout to load an...
well i would like to let u know about one more thing. if u use semi-colon after while then also peoplecode compiles well. that's really strange to me ... not...
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.
