hi Sat, if I got it right, what you want (and I quote) is "to get those PO_IDs those having same number of rows,with same item_id,volume... with different ...
I took a look at two Demo environments, a client and my firms. In each, subscription PeopleCode is missing from standard Messages, i.e. VOUCHER_BUILD among...
I had a client who wrote an SQR that would create consecutive named datafiles (output1.csv, output2.csv, etc.) depending on the number of rows in increments of...
I'm not clear on exactly what you are trying to do. Sounds like you need something like: Select distinct SUBSTRING(a.PO_ID,1,5), other items From PS_PO_TBL...
What records are you trying to retrieve this data from? If it is from the PO header and/or the PO line table - it is impossible to have duplicate PO_IDs for a...
Steven, What version of PeopleTools are you on ... Messaging has changed if you are on PT 8.48 or higher. Pam ... From: peoplesoft-fans@yahoogroups.com ...
its application package now with the same name of subscription peoplecode Hth ________________________________ From: peoplesoft-fans@yahoogroups.com ...
create a view and insert the sql that you said worked into this view ...... just do a select all on this view in psquery and tht shld work well for u ... ...
just do a trace on ar_predict2 app engine and you will find out which step the payment is not being picked up by the process. ...... i had a similiar issue ......
It wasn't 5 minutes after I made my request that I stumbled across the answer. In 8.48, there is no subscription PeopleCode. The Message Events that were once...
Hello, group, I have discovered that the only index verification performed by DDDAUDIT.sqr is indexes created in App Designer and not in the database. ...
I am attempting to raise some havoc with the XML Publisher. Where no sane man may go, I do wander. The lightbulb is lit about Report Templates and joining up...
My last company used CedarCrestone to upgrade financial and HR from 8.0 to 8.9. We used their upgrade lab and then went from the upgrade to their hosted...
sorry, no poetry in this reply... just three suggested ways for doing it... a) c&p an existing message using message monitor b) test a message with designer...
Hi all, I'm doing an analysis of PeopleSoft Vs SAP products in three main family products (primarily focus on PS strengths vs SAP): - RH - Educational -...
We are currently running HRMS 8.8 sp1 on tools 8.45. As we prepare our upgrade to HRMS 9, we are also looking at a tools upgrade. I haven't beeen able to...
Folks, We could really use your help with this. We are working on a Go Live plan for Payroll Interface. We are upgrading from 8.0 to 8.9 and were wondering if...
Anyone from Howard University or University of Maryland Baltimore on here that would care to discuss your last upgrade/implementation using Cedar Crestone? If...
In my company we have some employees with large number of job data. When retrieve those employees in PIA in order to update EE record, the users timeout. We...
I'm curious to find out how people deal with deleting run control ID's? We are on an 8.9 system. Thanks! rf ... Food fight? Enjoy some healthy debate in the...
Depending on the developer level, I would run theough the SQR in Peoplesoft book. I would also do a ebay search for PeopleSoft and see if you can get a Tools...
you have to disable the firewall, when you disable the firewaal then you can run in 3-tier the application server for debug for example Julio ... From:...
i gave the developers a project to load a data file using sqr and to create a page online to view the contents of the interface file..they have all been thru...
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.
