Ned Shryock posted Message 53 in Message Board Dated : February 24, 1999 at 14:02:47 EST Subject: Payroll and BaaN IV Mfg Is anyone using PeopleSoft Payroll and BaaN IV Manufacturing? We are considering this combination and want to link PS - Time and Attendance to BaaN IV hours accounting. I understand we could run seperatley but is anyone actually doing this and if so what has been your experience? Thank you, ***************** End Of Article ****************** Marko posted Message 54 in Message Board Dated : February 24, 1999 at 17:38:40 EST Subject: MS Word integration with PeopleSoft I am told that Peoplesoft comes with the ability to provide data to MS Word for purposes of mail merge, etc. Does Peoplesoft support WordPerfect? Thanks! ***************** End Of Article ****************** kalyan posted Message 55 in Message Board Dated : February 24, 1999 at 20:47:10 EST Subject: Re: external interface to PS AP v7 with one-time vendors we did this in public sector version 7.0 we first loaded all the vendors into PS as onetime vedors from the flat file and then loaDED vouchers against those vendors from the same flat file in the same order and the trick is u have to inactive that vendor once u load the voucher against him and then and only then u should load the next voucher against next vendor but the whole thing can be done from one flatfile and one sqr. : Chris, : We are having the exact same requirement : set up a one time Vendor from a legacy system, and also populate a related voucher to PS AP. If you get any solution not requiring a non trivial SQR, I would love to hear it ! : Will also let you know, of our final solution. : Thanks, : Vikram Muratee : 846-866-3177 : at Rotary International : Evanston, IL : vmuratee@yahoo.com : : : : : We are attempting to interface a file from an external system to our PS AP system. The file contains refund information for one-time vendors (for out-of-stock items etc.) that need to be paid via AP. This file is processed via EDI and the "VCHR" template (v.7) The problem is, these one-time vendors are not set up in the AP vendor tables before the refund file goes against it. The users want us to setup the vendors on the fly as this file is being processed. However, there are no EDI templates for "vendor", and we are faced with writing a nontrivial SQR to accomplish this. We'd really like to avoid "reinventing the wheel", so if anybody out there in PeopleSoftLand has any ideas, SQRs, etc on this subject, we'd be most appreciative! (We'll even buy you lunch next time you're in Dallas!) : : Thank you in advance : : Chris Richter, Sr. Analyst : : Boy Scouts of America, Natl. HQ : : 972.580.2551 : : crichter@netbsa.org ***************** End Of Article ****************** Mike Dybis posted Message 56 in Message Board Dated : February 25, 1999 at 07:29:40 EST Subject: Re: MS Word integration with PeopleSoft The way PeopleSoft interfaces to MS Word is a two step process. First, there is an SQR to extract the data from the appropriate tables and format an ASCII file to be used by the MS Word mail merge process. Second, there is a MS Word template with a macro attached that reads the ASCII file and performs the mail merge process. I'm not familiar with WordPerfect so I'm not sure if a similar process could be performed. Hope this helps. : I am told that Peoplesoft comes with the ability to provide data to MS Word for purposes of mail merge, etc. Does Peoplesoft support WordPerfect? : Thanks! ***************** End Of Article ****************** dw posted Message 57 in Message Board Dated : February 26, 1999 at 12:20:27 EST Subject: Re: Message Agent API Calls from Java? The 99 limit is not how many requester can be serviced but how many services are handling requests. The message agent uses the "Burger King" queuing method where requests are serviced by a pool of services. Even one service handler could eventually handle 100,000 requests but if you had one request that was long, you could cause the others to wait. Think about it the next time you're in McDonalds :-) ***************** End Of Article ****************** Stan posted Message 58 in Message Board Dated : February 26, 1999 at 15:14:56 EST Subject: RE: Web API now available I have an API dll that can hook up a web page to PeopleSoft's Application. Anyone that would like to try it out. I have a demo version for $99. The Full version with docs and examples is $10,000. ***************** End Of Article ****************** Hector Ramirez posted Message 59 in Message Board Dated : March 01, 1999 at 13:11:44 EST Subject: Re: Inventory Interface : Hi Al, : Is anybody out there is working on Inventory Interface for Peoplesoft 7.5?? If yes let me share the knowledge : : Venu ***************** End Of Article ****************** Marco L. Rivera posted Message 60 in Message Board Dated : March 01, 1999 at 16:11:24 EST Subject: Signed numbers in SQR? Anyone know how to output a Cobol signed number in SQR to a flatfile??? Thanks. ***************** End Of Article ****************** Mike Dybis posted Message 61 in Message Board Dated : March 02, 1999 at 06:04:02 EST Subject: Re: Signed numbers in SQR? Check the SQR user group website for suggestions or to pose the question. The URL is WWW.SQRUG.COM. I've found alot of good technical tips and suggestions there. : Anyone know how to output a Cobol signed number in SQR to a flatfile??? : Thanks. ***************** End Of Article ****************** Hartono Sutirman posted Message 62 in Message Board Dated : March 02, 1999 at 22:52:55 EST Subject: Interfacing to other Database I'm using Oracle database 7.3.3 for peoplesoft 7.0 Asia Pasific Version and I need to read and write to another Oracle Database 7.3.3 that used by Oracle Application 10.7 Can peoplesoft read and write the tables from another oracle database ?? thanks in advance ***************** End Of Article ****************** Cheryl Stine posted Message 63 in Message Board Dated : March 05, 1999 at 08:22:23 EST Subject: Message Agent I am trying to update an effective dated panelgroup via the message agent (from a VB app). I can add new rows and update data on existing rows (in correction mode). I want to be able to change the effdt field on an existing row in correction mode just like you can do directly on the panels. When I try, it simply adds a new row. Does anyone know if this possible to do, and if so, what are the details I need to have (API calls, msg definition settings). Thanks! Cheryl Stine ***************** End Of Article ****************** Daytona posted Message 64 in Message Board Dated : March 10, 1999 at 20:28:45 EST Subject: PeopleSoft G/L ***************** End Of Article ****************** Rob Collins posted Message 65 in Message Board Dated : March 11, 1999 at 16:54:10 EST Subject: external interfaces to PS Billing module We are preparing to implement the PS Billing module (version 7), and would like to know if anyone out there has had any experience with interfacing external "legacy" data. Thank you very much! ***************** End Of Article ****************** SHANKAR posted Message 66 in Message Board Dated : March 18, 1999 at 02:46:03 EST Subject: Alliance solution center Dear Fans, I was told that there is quite a lot of info on Message Agents and Interfacing with VB kind of stuff in PeopleSoft Aillance Solution Center web site - but could not find anything in that sight - do i have to have a customer connection to download some thing. please advice me cheers ***************** End Of Article ****************** DW posted Message 67 in Message Board Dated : March 18, 1999 at 13:27:52 EST Subject: Re: Alliance solution center Here you go... URL is http://www4.peoplesoft.com/allconn/stsbenchm.nsf/d7007f3c3f166fe988256658005b3275/157e6d56657dc9b5882566b8007fd9ac?OpenDocument ***************** End Of Article ****************** Anh posted Message 68 in Message Board Dated : March 24, 1999 at 07:20:57 EST Subject: Re: Interfacing to other Database : I'm using Oracle database 7.3.3 for peoplesoft 7.0 Asia Pasific Version : and I need to read and write to another Oracle Database 7.3.3 that used by Oracle Application 10.7 : Can peoplesoft read and write the tables from another oracle database ?? : thanks in advance As long as you have DB Links set up appropriately, you should be able to access these databases from SQL PLus. ***************** End Of Article ****************** Dennis Gross posted Message 69 in Message Board Dated : March 24, 1999 at 16:51:20 EST Subject: SQL Server Accessibility I have a very strange problem on my PC. We basically use 2 databases, a production database (lets call it PROD), and a development database (DEV). I am able to log in to PROD via PeopleTools; when I try to log in to DEV i get the following error message: "SQL Error. Stmt #2 Error Position: 0 Return: 8200 - Cannot connect to requested database". I am able to access both databases in SQL Server 6.5, our backend. I am also able to access both databases from another PC. its only my PC that has this problem. I've checked all the configuration files against our standard config and everything seems to match. Can someone help? ***************** End Of Article ****************** Gavin John Fowler posted Message 70 in Message Board Dated : March 25, 1999 at 06:13:17 EST Subject: Re: SQL Server Accessibility Can you get into the DB from ISQL ? From another ODBC aplication - eg MS Query32 ? Are both DB's on the same server ? ***************** End Of Article ****************** shankar posted Message 71 in Message Board Dated : March 25, 1999 at 06:41:55 EST Subject: Run reports using Message agents Dear Friends, I am using Message Agent APIs in my c and c++ program to do panel level operations is it possible to run a report as we do from our panels ( clicking the run button) using messageagent from an external C program. Please help ASAP thanks ***************** End Of Article ****************** Dennis Gross posted Message 72 in Message Board Dated : March 25, 1999 at 08:14:25 EST Subject: Re: SQL Server Accessibility : Can you get into the DB from ISQL ? From another ODBC aplication - eg MS Query32 ? : Are both DB's on the same server ? Yes, I can get into the DB from ISQL and perform queries on them both (I'm not sure about MS Query32?) Both databases are on the same server. ***************** End Of Article ****************** Altan Khendup posted Message 73 in Message Board Dated : March 28, 1999 at 20:09:37 EST Subject: Re: SQL Server Accessibility The error looks to be a connectivity problem in the ODBC connections. I am assuming you are trying to connect in 2-tier mode. If it's 3-tier mode you need to check your settings in the Configuration Manager to validate the information there. Remember that for 2-tier connectivity, Peoplesoft uses the ODBC drivers to connect (coupled with the MS Sql client libraries). Since you've identified that it is only with your PC, here is a quick list of things to check: * Do you have a valid ODBC entry? Make sure everything is set per the manual. * If you have a valid ODBC entry does it work using the MS Query or MS Access? This is the quickest way to see if the ODBC driver is setup properly. If you can connect to the database using either Access or Query then Psoft should work. If in 3-tier mode check the Configuration Manager for: * Proper hostname * Proper DB Paths * Proper Port #'s After verifying all of these things you'll find your answer. I'd bet it's something in the ODBC drivers. HTH and good luck! ***************** End Of Article ****************** Gavin John Fowler posted Message 74 in Message Board Dated : March 31, 1999 at 02:07:29 EST Subject: Re: SQL Server Accessibility Network OK ? Slow networks can give timeouts which MAY manifest themselves under various guises. Have youtried Trace ? ***************** End Of Article ****************** K.Ranapratap posted Message 75 in Message Board Dated : April 01, 1999 at 18:33:38 EST Subject: conversion of data from legacy systems to Peoplesoft The data from the legacy systems is to be loaded in to the Peoplesoft. Is there any document prepared by the Peoplesoft which gives all the list of tables and fields group by say vendor info, customer info. , item info., ledger info. Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Steve Foley posted Message 76 in Message Board Dated : April 05, 1999 at 14:52:06 EST Subject: Re: conversion of data from legacy systems to Peoplesoft Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Dave Gordon posted Message 77 in Message Board Dated : April 06, 1999 at 10:30:01 EST Subject: Re: conversion of data from legacy systems to Peoplesoft Hi Steve, I think you mean Import Manager. SQA robot is an automated testing tool - it's used to run test scripts. Import Manager is slow, but it does a good job of applying the same edit rules you'd apply if the data was entered by hand. This isn't always necessary, though. A lot of folks use SQR and SQL scripts, various delivered RDBMS tools and third-party tools to directly populate the database. It requires some knowledge of how the system actually operates, but in many cases, it's the only way to get the data into the system in a reasonable amount of load time. Regards, Dave : Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Gary Flynn posted Message 78 in Message Board Dated : April 06, 1999 at 14:32:19 EST Subject: Re: Interface to C++ module ? : If that is the case, Any idea about, how to invoke a C++ executable from PeopleSoft(PeopleCode !!)with some parameters and retrieve back some values that executable returns, into PeopleSoft(Panel !!) ?? Have you looked at the Exec, Winexec, and Declare Peoplecode statements? ***************** End Of Article ****************** Gary Flynn posted Message 79 in Message Board Dated : April 06, 1999 at 14:45:01 EST Subject: External Authentication Questions I'm looking at ways to use external authentication mechanisms with Peoplesoft. 1) Is the DataMover Encrypt_Password the only way to encrypt the operID password? 2) If PSAUTH fails when validating the operID and password from the workstation and I return TRUE from PsTuxAuthExit will the login succeed? (assuming I validate the operID exists in PSOPRDEFN and authenticate externally) thanks! ***************** End Of Article ****************** Hugh Jass posted Message 80 in Message Board Dated : April 09, 1999 at 16:04:14 EST Subject: Re: conversion of data from legacy systems to Peoplesoft As a matter of fact in Peoplebooks you will find a section called "Tables Loading Sequence" and this should give you an idea of what tables and fields are required for data conversion. ***************** End Of Article ****************** Reagan Lee posted Message 81 in Message Board Dated : April 11, 1999 at 14:03:34 EST Subject: Re: conversion of data from legacy systems to Peoplesoft Dave, Steve actually has a point. SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. First you record a script loading one record. On your script, you replace any number of values with variables. You tell define the order in which these variables are stored in a comma-delimited file. Create a loop on the script. Reference the import file in the script. The next time you run your script it will insert your import file values where you defined variables. It's almost like a super-human performing data entry. The script loops through all lines on your import file. For a small amount of records (but too much to enter manually), this is a good alternative especially when you don't want to figure out the tables and edits that are involved. I have used this to load vendor and customer information. It works, but the data must be clean. Otherwise, the script will stop in the middle and you must determine where to restart. It means you have to modify the import file to start at the correct row on the file. Hope this helps. : Hi Steve, : I think you mean Import Manager. SQA robot is an automated testing tool - it's used to run test scripts. : Import Manager is slow, but it does a good job of applying the same edit rules you'd apply if the data was entered by hand. This isn't always necessary, though. A lot of folks use SQR and SQL scripts, various delivered RDBMS tools and third-party tools to directly populate the database. It requires some knowledge of how the system actually operates, but in many cases, it's the only way to get the data into the system in a reasonable amount of load time. : Regards, : Dave : : Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : : : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Dave Gordon posted Message 82 in Message Board Dated : April 13, 1999 at 10:58:27 EST Subject: You Learn Something New Every Day :SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. Hi Reagan, That's an interesting technique; however, I think I'd rather stick with Import Mangler for small, clean data sets. I don't mind looking behind the panels to figure out which tables are being loaded, and I usually drop to a SQL prompt and do a "select count(*)" to ensure all the data got loaded. However, I'm also a belt, suspenders, velcro and superglue kinda guy ... Regards, Dave ***************** End Of Article ****************** Chris Richter posted Message 83 in Message Board Dated : April 19, 1999 at 09:13:00 EST Subject: 1099-Rs Has anyone out there ever modified their PeopleSoft AP system to generate 1099-Rs? We did it years ago on our mainframe system by cloning and modifying the 1099-MISC process, and are contemplating doing the same with PeopleSoft. If anyone out there has already done this and would be willing to share info with us, it would be greatly appreciated! Thanks ***************** End Of Article ****************** Reagan Lee posted Message 84 in Message Board Dated : April 23, 1999 at 01:22:08 EST Subject: Re: 1099-Rs : Has anyone out there ever modified their PeopleSoft AP system to generate 1099-Rs? We did it years ago on our mainframe system by cloning and modifying the 1099-MISC process, and are contemplating doing the same with PeopleSoft. If anyone out there has already done this and would be willing to share info with us, it would be greatly appreciated! Thanks Hi Chris, I can share with you how we did it. It is definitely not the recommended method but it worked and made our AP supervisor very happy. First we ran the normal 1099 processes except for printing. We wanted to print on a standard 1099 sheet with three forms. Then, we created a query joining VENDOR_1099 with M1099_BALANCE. The query was output to Excel where we had the flexibility to add/remove rows or modify the information. Why? Because we implemented mid-year and did not convert vendor balances from our legacy system. We could have given the vendor two forms from two systems, but that would have confused our vendors. We mailed merged this data into a Word document that had the fields laid out like the form. We had complete control on how it printed. Of course, we only had a few hundred vendors that were sent 1099, so this process wasn't too cumbersome. If you need more specifics, feel free to send me an email at rwklee@yahoo.com. Hope this helps. ***************** End Of Article ****************** Giri Vissa posted Message 85 in Message Board Dated : April 24, 1999 at 11:02:25 EST Subject: Re: conversion of data from legacy systems to Peoplesoft To estimate data conversion effort, any useful parameters? From Table loading sequence peoplebook, we can find out the number of required and optional tables to load. For example, Public Sector HRMS 7 has around 500 required+optional tables. Based on this number can we arrive at useful effort estimates for data conversion? Giri : Dave, : Steve actually has a point. SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. : First you record a script loading one record. On your script, you replace any number of values with variables. You tell define the order in which these variables are stored in a comma-delimited file. Create a loop on the script. Reference the import file in the script. The next time you run your script it will insert your import file values where you defined variables. It's almost like a super-human performing data entry. The script loops through all lines on your import file. : For a small amount of records (but too much to enter manually), this is a good alternative especially when you don't want to figure out the tables and edits that are involved. : I have used this to load vendor and customer information. It works, but the data must be clean. Otherwise, the script will stop in the middle and you must determine where to restart. It means you have to modify the import file to start at the correct row on the file. : Hope this helps. : : Hi Steve, : : I think you mean Import Manager. SQA robot is an automated testing tool - it's used to run test scripts. : : Import Manager is slow, but it does a good job of applying the same edit rules you'd apply if the data was entered by hand. This isn't always necessary, though. A lot of folks use SQR and SQL scripts, various delivered RDBMS tools and third-party tools to directly populate the database. It requires some knowledge of how the system actually operates, but in many cases, it's the only way to get the data into the system in a reasonable amount of load time. : : Regards, : : Dave : : : Unless you have a lot of data AND a lot of resources, your best bet is to use the SQA Robot. This will push the data in throught the appropriate panels and insure all required fields are populated. Trying to push it in 'throught the back door' will cause problems. : : : : Can anyone give the right method of conversion of data in to ps tables. We are in 7.5 version of ps. The client is implementing financials and distribution. ***************** End Of Article ****************** Giri Vissa posted Message 86 in Message Board Dated : May 03, 1999 at 05:34:29 EST Subject: Implementing Student Admin w/o PS Financials Universities are implementing integrated administrative systems using PeopleSoft packages for Higher Education and Financials. In terms of implementation options, what are the disadvantages of implementing the Student Admin modules in the Higher Education package without implementing PeopleSoft Financials? Giri ***************** End Of Article ****************** Kirsten posted Message 87 in Message Board Dated : May 04, 1999 at 16:17:56 EST Subject: Tips on Message Agent I am going to write an interfacebetween Peoplesoft and an external system. What design issues should I consider in the begining??? I am planning to use C APIs. Thanx in advance. Bye, Gary. ***************** End Of Article ****************** Brian Hundt posted Message 88 in Message Board Dated : May 11, 1999 at 18:50:43 EST Subject: Billing Interface I'm currently in the process of building an interface from a package called 'Interworld' to the PeopleSoft Billing module. Has anyone had any experience with this or something similar to it? Thanks. ***************** End Of Article ****************** Rohit posted Message 89 in Message Board Dated : May 13, 1999 at 15:06:45 EST Subject: Re: Run reports using Message agents : Dear Friends, : I am using Message Agent APIs in my c and c++ program to do panel level operations is it possible to run a report as we do from our panels ( clicking the run button) using messageagent from an external C program. : Please help ASAP : thanks Shankar, I think I might have a work around for you. Assuming that your reports are run through the Process Scheduler : 1.Put a derived work record field on the panel you are working on. 2. At FieldChange event, write peoplecode that invokes the process scheduler (ScheduleProcess command). 3. When you enter data into the panel, pass a value to the derived record field so that FieldChange is triggered. 4. You will have to map this field too in the MessageAgent definition. Preferable keep it as the last field to map so that the process is triggerred after the values are passed. Voila - you should have your results. All the best. ***************** End Of Article ****************** Pedro Garcia posted Message 90 in Message Board Dated : May 13, 1999 at 17:04:47 EST Subject: Re: PeopleSoft calling function in C/C++ DLL : Is there a way for PeopleSoft to call a C or C++ function : in a Windows DLL? ***************** End Of Article ****************** C. Hanel posted Message 91 in Message Board Dated : May 21, 1999 at 14:06:48 EST Subject: Re: PeopleSoft opening its APIs : Hello. I'm a reporter with InfoWorld Magazine, working on a story that PeopleSoft plans to open its APIs for third-party developers to create better integration interfaces -- somewhat the way SAP announced last fall that it was opening its BAPIs. We've got confirmation from PeopleSoft that they're doing this, but not a lot of details yet on how this will work. What would open PeopleSoft APIs mean to you? Do you consider this news important? Feel free to post a message or call me at (650) 525-3465. Thank you. ***************** End Of Article ****************** C. Hanel posted Message 92 in Message Board Dated : May 21, 1999 at 14:29:27 EST Subject: Re: PeopleSoft opening its APIs (and ending M.A. support?) Along the same lines, I've heard the the Message Agent will 'not be supported' in the future. I'm assuming PS wouldn't go there until they actually publish some APIs, but what does that do to third party developers (SeekerSoft, Advis, etc.)? We're in the process of figuring out a way to integrate multiple backends (PS, Tesseract, Restrac, etc.) into a cohesive front-end (maybe web, maybe VB or some combo). Reverse engineering and doing updates direct to the PS DB is dangerous and unsupported, and with no APIs, near as I can tell all you have to work with is the Message Agent. If it's going away, soon, I don't want to start developing to it now. So...does anyone know when PS actually plans to publish some APIs? : Hello. I'm a reporter with InfoWorld Magazine, working on a story that PeopleSoft plans to open its APIs for third-party developers to create better integration interfaces -- somewhat the way SAP announced last fall that it was opening its BAPIs. We've got confirmation from PeopleSoft that they're doing this, but not a lot of details yet on how this will work. What would open PeopleSoft APIs mean to you? Do you consider this news important? Feel free to post a message or call me at (650) 525-3465. Thank you. ***************** End Of Article ****************** Rob Collins posted Message 93 in Message Board Dated : May 25, 1999 at 16:20:38 EST Subject: Re: 1099-Rs : : Has anyone out there ever modified their PeopleSoft AP system to generate 1099-Rs? We did it years ago on our mainframe system by cloning and modifying the 1099-MISC process, and are contemplating doing the same with PeopleSoft. If anyone out there has already done this and would be willing to share info with us, it would be greatly appreciated! Thanks : : Hi Rob, : I can share with you how we did it. It is definitely not the recommended method but it worked and made our AP supervisor very happy. : First we ran the normal 1099 processes except for printing. We wanted to print on a standard 1099 sheet with three forms. Then, we created a query joining VENDOR_1099 with M1099_BALANCE. The query was output to Excel where we had the flexibility to add/remove rows or modify the information. Why? Because we implemented mid-year and did not convert vendor balances from our legacy system. We could have given the vendor two forms from two systems, but that would have confused our vendors. : We mailed merged this data into a Word document that had the fields laid out like the form. We had complete control on how it printed. Of course, we only had a few hundred vendors that were sent 1099, so this process wasn't too cumbersome. : If you need more specifics, feel free to send me an email at rwklee@yahoo.com. : Hope this helps. ***************** End Of Article ****************** David Thompson-Hall posted Message 94 in Message Board Dated : May 26, 1999 at 15:44:41 EST Subject: Re: Message Agent API Calls from Java? I would add that the question of how many services to run on your application server is a tricky one, but if you do know your user load, it's not too bad. For instance, say you do have 100 users concurrently. If you start up 10 instances of the Message Agent, then in theory each person is waiting in a line with 10 others. (All the setup for this is done using the Tuxedo manager on your Application server. I'm not clear on the issue of Load balancing and the like, but I can tell you that PS does a nice seminar called "3 Tier Seminar" where they review this stuff on a technical level - a good place to send your DBAs or whomever is doing ongoing support for your Application Server...) : The 99 limit is not how many requester can be serviced but how many services are handling requests. The message agent uses the "Burger King" queuing method where requests are serviced by a pool of services. Even one service handler could eventually handle 100,000 requests but if you had one request that was long, you could cause the others to wait. Think about it the next time you're in McDonalds :-) ***************** End Of Article ****************** Jorge Zavala posted Message 95 in Message Board Dated : May 27, 1999 at 22:33:32 EST Subject: Re: Message Agent limitations DO somebody has any experience integrating Peoplesoft with Microsoft Exchange Server. I want to sent some information gather in a Exchange Electronic Form to store into a workflow procees within Peoplesoft ***************** End Of Article ****************** John Theobald posted Message 96 in Message Board Dated : June 15, 1999 at 15:27:19 EST Subject: Re: Run reports using Message agents You can also use the PeopeSoft OpenQuery API. This API was designed to allow you to run PeopleSoft queries from 3rd party programs. It works great from VB, VBA, and C++. Check out your PeopleBooks for further information. ***************** End Of Article ****************** Allan Young posted Message 97 in Message Board Dated : June 15, 1999 at 15:43:23 EST Subject: Need an Interface? Contact me if you would like more information on an incredible interface engine that is currently going to market. it's less expensive than you would think and uses PeopleSoft as it's baseline. It can be customized to meet you're specific organizations interface needs. Email me or call at 404-238-0579. ***************** End Of Article ****************** Allan Young posted Message 98 in Message Board Dated : June 15, 1999 at 15:46:55 EST Subject: Re: Tips on Message Agent Have you started your interface? I know several awesome developers who can help your company write an outstanding interface at a very low cost. Contact me if interested -Allan Young, IT Agent, Inc 404-238-0579 : I am going to write an interfacebetween Peoplesoft and an external system. What design issues should I consider in the begining??? I am planning to use C APIs. : Thanx in advance. : Bye, : Gary. ***************** End Of Article ****************** steve posted Message 99 in Message Board Dated : June 17, 1999 at 06:41:41 EST Subject: Volume batch input from Unipay(payroll system) to HRMS - any advice Volume batch input from Unipay(payroll system) to HRMS : - We are going to have a sizeable batch interface from our payroll system to Peoplesoft HRMS approx 1000 starters/leavers per week plus 1000's of changes The interface need to run overnight each 24 hours the intention at the moment is to write this interface utilising SQL/SQR Is it better to attempt to update all of the databases ie personel, employment, job, etc in a single hit (sqr) , or in seperate processes ? Has anyone got any general advice ? ***************** End Of Article ****************** steve posted Message 100 in Message Board Dated : June 17, 1999 at 09:50:32 EST Subject: Volume batch input from Unipay(payroll system) to HRMS, advice wanted Volume batch input from Unipay(payroll system) to HRMS : - We are going to have a sizeable batch interface from our payroll system to Peoplesoft HRMS approx 1000 starters/leavers per week plus 1000's of changes The interface need to run overnight each 24 hours the intention at the moment is to write this interface utilising SQL/SQR Is it better to attempt to update all of the databases ie personel, employment, job, etc in a single hit (sqr) , or in seperate processes ? Has anyone got any general advice ? ***************** End Of Article ****************** John Eaton posted Message 101 in Message Board Dated : June 17, 1999 at 15:07:50 EST Subject: VBScript I am trying to call ProcessMessage function in the message agent from my VBScript web page. The function takes a long*. I dim a variable and then pass it and I get a type mismatch. Even with I try to convert my variable with CLng I still get the error. Anyone have any suggestions. Thanks ***************** End Of Article ****************** Filip Hanik posted Message 102 in Message Board Dated : June 24, 1999 at 16:52:15 EST Subject: Re: VBScript Try this Dim nReplyOption& Dim Mag As CMagAutoServer Dim Result As Variant Set Mag = CreateObject("PeopleTools.MessageAgent") Result = Mag.StartMessage("ACT_AGT", "AgentList", False) Result = Mag.ProcessMessage(nReplyOption) That should work : I am trying to call ProcessMessage function in the message agent from my VBScript web page. The function takes a long*. I dim a variable and then pass it and I get a type mismatch. Even with I try to convert my variable with CLng I still get the error. Anyone have any suggestions. : Thanks ***************** End Of Article ****************** Van posted Message 103 in Message Board Dated : June 26, 1999 at 12:24:46 EST Subject: Re: Conversion Hi, Well the first time we did the conversion at my company(PS VER 7.5), we used SQL*Loader for loading flat file into Temporary Table. Then, we uses PL/SQL to create store procedure wich is doing some manipulating data from Temporary table before insert into PeopleSoft Table. I had try out Import Manager, but we encouter some problem for some of the table like PS_JOB, we uses Import Manager as a tools for validating our Data only. thats what we did. Thanks Van : :SQA Robot can be used to load data, though not very large amounts. Also, the data has to be very clean in order to pass all online edits. : Hi Reagan, : That's an interesting technique; however, I think I'd rather stick with Import Mangler for small, clean data sets. I don't mind looking behind the panels to figure out which tables are being loaded, and I usually drop to a SQL prompt and do a "select count(*)" to ensure all the data got loaded. However, I'm also a belt, suspenders, velcro and superglue kinda guy ... : Regards, : Dave ***************** End Of Article ****************** miki,kudo posted Message 104 in Message Board Dated : June 28, 1999 at 12:51:37 EST Subject: Interfacing PS with Credit Card Authoristion Software ICVERIFY I need some help for developing interface for Peoplesoft Distribution module with ICVERIFY, a Credit Card Authoristion Software I have written SQR for reading the data, But I need some ones guidance to finish the job like Scheduling, files directory, etc, It will be of great help if some one gives their guidance at the earliest thank you ***************** End Of Article ****************** Meena Sinha posted Message 105 in Message Board Dated : June 29, 1999 at 14:33:45 EST Subject: Re: General Ledger Interface for HR using SQR : Hi, I am interesed in your package as I am currently working on G/L interface SQR for a public school : I have developed a module, which can be added to the HR package of Peoplesoft, which creates General Ledger interface files for posting into Accounts. : It can be run by the end-user. It runs using SQR, and one main feature is its flexibility, meaning Account Codes can be changed on-line for immediate effect. It also takes care of Accruals. Also, you can run GLs for multiple paygroups in the batch mode. : If anybody is interested in the package, please email me at 'sbhowmik@juno.com' : Thanx. : - sb. ***************** End Of Article ****************** GP posted Message 106 in Message Board Dated : July 02, 1999 at 10:24:08 EST Subject: GL Interface-Public Sector product v7.5 The Budget Encumbrances and the GL Interface Module are used to facilitate flow of data to and from GL. The Deduction Tables, earnings tables and other tables use Account Numbers (and not account codes [a combination of chartfields] that are pulled in from GL by running a process). Are account Numbers extracted from the account codes? If not, does finance provide these account numbers? Any ideas on this issue? ***************** End Of Article ****************** Kalyan posted Message 107 in Message Board Dated : July 05, 1999 at 12:32:21 EST Subject: Interface Techniques Dear Friends, In SAP whn u want to import data from a flat file (Legacy system file),we use the BDCs,which go thru the SAP screens/transactions and then update the database.Similarly,How does it happen in PeopleSoft?In peopleSoft,we r told that the tables(called Records in PS) r updated directly.But a screen (called a Panel in PS)may contain more than one table.Pl. throw some light on this issue. I request u all to pl. give the process in Detail ASAP. Thanx, Kalyan ***************** End Of Article ****************** Anthony Wilson posted Message 108 in Message Board Dated : July 05, 1999 at 19:05:12 EST Subject: Import Manager In PeopleSoft this is accomplished in a variety of ways. If I understand your requirements, though, you want the data to be edited as it is imported. There are basically two ways to import data into the PeopleSoft system, while still using the edits that have been applied to a record definition - Import Manager and Message Agent. Which one you choose depends on your actual requirements. The Import Manager updates one specific record with the data from a flat file. This flat file can be applied to more that one record, but the different records will not be updated at the same time. The data will be edited with non-panel specific edits. The advantage of the Import Manager is that it is very easy to set up and execute. The disadvantage is that only one record can be updated at a time, if the file being imported contains multiple dependencies, this method may not work. NOTE: This is most useful during conversions. The Message Agent updates the PeopleSoft system through the use of Message Forms. These forms are designed to comply with the requirements of the actual panel group they are updating. This method allows you to update multiple records through the use of panel definitions. The advantage of the Message Agent is that it actually performs as though a user where entering the data through a panel. The disadvantage is that this requires allot of set up and testing. NOTE: Don't use this method for one time only solutions. If neither of these solutions will work for your particular problem, you will probably need to create an SQR program. The advantage of SQR programs is that they are easy to create and test and they allow a maximum of flexibility and control. NOTE: You will you the method for most of you external interfaces. I hope this helps, Anthony Wilson ***************** End Of Article ****************** tul posted Message 109 in Message Board Dated : July 07, 1999 at 13:16:07 EST Subject: Application System Download Dear friends, Pl. help in the following: How do you extract an application system without data? How do you extract an application system with data? Regards Tul ***************** End Of Article ****************** Mark Tuente posted Message 110 in Message Board Dated : July 13, 1999 at 09:37:13 EST Subject: Re: conversion of data from legacy systems to Peoplesoft There are tools who take care of these things. SmartDB for example has put all the application logic and constraints into their product. Have a look at www.smartdb.com. They might help you with your problem. ***************** End Of Article ****************** ZJS posted Message 111 in Message Board Dated : July 13, 1999 at 10:31:36 EST Subject: Posting to external GL system We are implementing HR/BEN/PAYROLL 7.5 and maintaining our external financials system. Are there any PeopleSoft programs that may be a good starting point to pull payroll transactions from PeopleSoft to create GL journal entries in the external system? How have others tackled this interface? Thanks. ***************** End Of Article ****************** Dave Gordon posted Message 112 in Message Board Dated : July 13, 1999 at 11:47:29 EST Subject: Re: Posting to external GL system Hi ZJS, GLX001A and GLX001B are delivered sample programs for interfacing to legacy financial systems. Regards, Dave : We are implementing HR/BEN/PAYROLL 7.5 and maintaining our external financials system. Are there any PeopleSoft programs that may be a good starting point to pull payroll transactions from PeopleSoft to create GL journal entries in the external system? How have others tackled this interface? : : Thanks. ***************** End Of Article ****************** Simon Paul posted Message 113 in Message Board Dated : July 16, 1999 at 20:42:02 EST Subject: interface Payroll and extra (billing) information to PS GL - Dave? Dear Anyone_that_can_help (Dave?) At my client, Payroll/HR is a billable service and we have a billing calculation engine that interfaces to PS billing. We also calculate some extra costs associated with the payroll. After processes we already have, the additional costs get into PS_HR_ACCT_LINE and the processed Billing info resides in PS_HR_ACCT_ENTRY. What we'd like is to be able to post the cost (Payroll), the extra costs, and the revenue (from Billing side) as one journal entry. My preference would be to use standard interfaces as much as possible but I am beginning to lean toward a custom version of PayGL01.sqr which would grab the three lots of data from the various sources and create the single journal straight into headers and lines. Any thoughts on this or other solutions? Simon Paul ***************** End Of Article ****************** Dave Gordon posted Message 114 in Message Board Dated : July 17, 1999 at 12:34:13 EST Subject: Hack PayGL01 Hi Simon, I'd have to agree with you - modifying PayGL01 is probably the most straightforward approach. Be careful with rounding errors, though, because successive arithmatic operations in SQR can accumulate small differences, which tend to show up as one or two cents in large dollar amounts. This is a function of the way SQR stores real numbers, and isn't a fault, just a limitation on what's practical. My rule of thumb is probably too conservative, but here goes: If a calculation requires more than three successive operations, giving results with more than seven significant places, code it in COBOL. Someone from SQRibe might have an opposing viewpoint, but that's mine. Regards, Dave ***************** End Of Article ****************** Anthony Wilson posted Message 115 in Message Board Dated : July 17, 1999 at 14:12:55 EST Subject: Numeric Precision with SQR The problem with performing calculations in SQR is that it doesn't allow you to define variables with numeric precision. For example: 7.5% of $22.50 is how much? 22.50 x .075 = 1.6875. SQR will store this amount as 1.6875 even though you may actually want 1.68 (truncated) or 1.69 (rounded). Now, this problem is compounded each time you perform another calculation with the results. For example: two times the result would be 3.375. Even though with numeric precision the results would have been 3.36 (truncated) or 3.38 (rounded). There is a solution to this problem. PeopleSoft provides some custom functions that allow you to achieve numeric precision within SQR programs. They are stored in number.sqc. Use PS_SQR_Trunc to provide your calculations with truncated precision and use PS_SQR_Round for rounding precision. These functions should allow you to avoid using a COBOL program and still provide the numeric precision you need. Hope this helps, Anthony Wilson ***************** End Of Article ****************** Simon Paul posted Message 116 in Message Board Dated : July 17, 1999 at 22:54:54 EST Subject: Re: Hack PayGL01 Dave, Thanks for the input. I'll move ahead with payGL01. I don't think the precision will be an issue and we will consider the use of the functions that Anthony describes in his post (Thanks Anthony!). Simon Paul : Hi Simon, : I'd have to agree with you - modifying PayGL01 is probably the most straightforward approach. Be careful with rounding errors, though, because successive arithmatic operations in SQR can accumulate small differences, which tend to show up as one or two cents in large dollar amounts. This is a function of the way SQR stores real numbers, and isn't a fault, just a limitation on what's practical. : My rule of thumb is probably too conservative, but here goes: If a calculation requires more than three successive operations, giving results with more than seven significant places, code it in COBOL. Someone from SQRibe might have an opposing viewpoint, but that's mine. : Regards, : Dave ***************** End Of Article ****************** Peter Cooke posted Message 117 in Message Board Dated : July 20, 1999 at 08:37:18 EST Subject: Password change I would like to be able to add support for the PeopleSoft product to our "Password Synchronization" product. We currently have agents for Unix, NT, Oracle, Sybase, NetWare, AS/400, Web Servers etc etc. Is there an API call, script or command within the product to set the password for a user, eg CHANGE_PASSWORD ( "PETER", "xyz" ) If so, what is it ? What platforms does your product run on ? Can I get hold of a copy for development purposes ? Thanks! Peter ***************** End Of Article ****************** Lee posted Message 118 in Message Board Dated : July 22, 1999 at 13:37:09 EST Subject: Scanning Interface Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. ***************** End Of Article ****************** Mike Dybis posted Message 119 in Message Board Dated : July 23, 1999 at 07:44:35 EST Subject: Re: Scanning Interface I'm sure there are more, but the only scanner interface I've dealt with is the Restrac Resume Reader for PeopleSoft. You might be able to get some infor from Restrac's web page. : Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. ***************** End Of Article ****************** Zuke posted Message 120 in Message Board Dated : July 26, 1999 at 18:11:36 EST Subject: Re: Scanning Interface : Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. Personics is another option ***************** End Of Article ****************** Greg Tucker posted Message 121 in Message Board Dated : July 28, 1999 at 09:16:32 EST Subject: Message Agent - Help! Need Makefile for HP/UX C From the PeopleBooks I can't figure out what shared libs I need to link in or what compiler flags to use. If someone has a makefile or some info on where to find one, please email me at gregt@mindspring.com. Thanks in Advance! ***************** End Of Article ****************** Savitha Devarakonda posted Message 122 in Message Board Dated : July 30, 1999 at 18:37:33 EST Subject: Optimizer settings in Oracle Hi all, When running an AR Update in Peoplesoft Financials, we run into a infinite loop, as AR does not work well with Cost based Optimizer. So we have to change the optimzer setting to Rule based everytime we want to run AR update process. I have tried deleting statistics on the tables . But it still does not work. Oracle version is 7.3.3.0 on NT. Peopletools version 7.01 can anybody helps us on this? Thanks ***************** End Of Article ****************** Greg Schuler posted Message 123 in Message Board Dated : August 03, 1999 at 13:01:49 EST Subject: PO interface I need some info and help on creating an interface between our existing PO system, PO Writer Plus, and PeopleSoft. Specifically, I need to load requisition information for inventory reorders from PO Writer into PeopleSoft. I know, why not use PS Inventory - we will, but not for 18 mos. If anyone has worked with PO Writer let me know. This seems to be the main stumbling block. ***************** End Of Article ****************** Ted Johnson posted Message 124 in Message Board Dated : August 04, 1999 at 09:56:48 EST Subject: PS Financials without PS Student Admin We are currently converting our financials to PS. The problem we are running into is that when we purchased the software we did not buy the AR package. The thinking from above was that all of our AR is student oriented (it isn't), and they were told that we could bring up just the AR part of Student Admin (you can't). We are staying with our current student records system and have no plans now or in the future to use student admin, and are planning on keeping our current AR system from our old financial software because it interacts closely with our student records package. However now the implementation team is balking at having to write an interface between the two systems, and wants to change the GL used by the AR system to match the PS GL. Our current AR system is very flexable in that we use different divisions to account for different types of charges, and therefore send out different types of statements to different addresses for the same person. For example we may send the students tuition/room charges home to the parent, but the health services chagres all go directly to the student on a separate bill. We need to keep this flexability in whatever software we may eventually migrate. Will the standard PS AR system provide this flexability? Does anyone have any suggestions, opinions, ideas on what direction we might go. Thank you, Ted Johnson IS Department Wake Forest University ***************** End Of Article ****************** sub posted Message 125 in Message Board Dated : August 04, 1999 at 14:38:25 EST Subject: Re: Optimizer settings in Oracle hi savitha, first, its not in an infinite loop; it's just taking too long to complete. infinite loop problems can never be solved by changing the optimizer mode. second, how are you changing the optimizer mode to rule-based ? just deleting the statistics does not put oracle back to rule-based mode. you have to bring down the database, and then bring up the database instance after changing the optimizer_mode parameter to 'rule' in the initialization file. if thats a problem, you should try to have two instances running against the database, one with each type of optimization, and use the different ones for the different purposes. btw, as far as i recall, oracle version 7.3 and up are supposed to run best in the cost-based mode. hope that helps. - sub. ***************** End Of Article ****************** Filip Hanik posted Message 126 in Message Board Dated : August 05, 1999 at 16:12:59 EST Subject: Re: Message Agent - Help! Need Makefile for HP/UX C All the libraries are under bin/client/your-os the message agent API is defined under Peopletools/src/Psmsgapi.h Filip : From the PeopleBooks I can't figure out what shared libs I need to link in or what compiler flags to use. : If someone has a makefile or some info on where to find one, please email me at gregt@mindspring.com. : Thanks in Advance! ***************** End Of Article ****************** Greg Tucker posted Message 127 in Message Board Dated : August 06, 1999 at 09:01:52 EST Subject: Libs in dev/bin in I see alot of shared libs in dev/bin on the Unix box. I don't know which ones on link in and in what order. On the NT box I do see dev\bin\client\Win86 with a bunch of DLLs but I want to write a C program on the UNIX side. Anyone out there have a UNIX makefile? ***************** End Of Article ****************** Henry E.P. Sutjipto posted Message 128 in Message Board Dated : August 09, 1999 at 23:13:56 EST Subject: PeopleSoft-Oracle interface I'm trying to design an interface between PS HRMS 7.0 with Oracle Application (i.e. Project, Financials). Any idea what is the best way to maintain an online connection between those modules? Thks. ***************** End Of Article ****************** A. Bola posted Message 129 in Message Board Dated : August 10, 1999 at 12:10:50 EST Subject: Payroll Interface my client in implementing PS Payroll Interface V7.5. We are interfacing basic employee details from, Job, Employment, Personal Data and Job_Earn_Dist records only. Not deductions etc. I have populated, pay grp, pay run id, balance id, pay calendar and have tried to run the interface after setting up the fields etc in the 13 interface tables. This is the error i am getting... can any help? what is the file Status? PeopleSoft prcs_bat Started Using RDBMS ORACLE Database name HRPSTEST Process instance 4817 PeopleSoft Payroll -- Version 7.50 Copyright (c) 1988-1998 PeopleSoft, Inc. All Rights Reserved Payroll Interface Started at 17:06:28.45. DB Type:[SQLBASE | ORACLE | INFORMIX | DB2 | DB2ODBC | DB2400 | DB2UNIX | SYBASE | MICROSFT]:ORACLE Database:[hrpstest]:HRPSTEST Username:[PS ]:PS Password:[********]: Run Control ID[ ]: 14 Process Instance:[0]:4817 SQL Trace:[0]: for Operator ID :PS and Batch Run ID :14 and PI Run Number :0009 and Process Date :1999-08-10 and Run Type :L and Run Option :N and Reprocess Option :N and Export Full Set : CheckPoint/Restart Data CheckPoint Interval:0005 Loading Interface Definitions for PI System = TRC Started at 17:06:29.36. Ended at 17:06:29.45. Started import/load of payroll data at: 17.06.29.000000 Error on Open for Input File Name: TRACE.DAT File ID: 01 File Status: 35. Unable to open external file for read: Check Messages!!! <<< Checkpoint Taken >>> IMPORT/LOAD PROCESS COMPLETED PeopleSoft prcs_bat Terminating ***************** End Of Article ****************** Jay Jayaram posted Message 130 in Message Board Dated : August 10, 1999 at 16:01:04 EST Subject: Re: Payroll Interface Looks like it cannot find a file it needs to open. Maybe you do not have the right directory to create the file - maybe c:\temp or whatever the %Temp% variable is. : my client in implementing PS Payroll Interface V7.5. We are interfacing basic employee details from, Job, Employment, Personal Data and Job_Earn_Dist records only. Not deductions etc. I have populated, pay grp, pay run id, balance id, pay calendar and have tried to run the interface after setting up the fields etc in the 13 interface tables. This is the error i am getting... can any help? what is the file Status? : PeopleSoft prcs_bat Started : Using RDBMS ORACLE : Database name HRPSTEST : Process instance 4817 : PeopleSoft Payroll -- Version 7.50 : Copyright (c) 1988-1998 PeopleSoft, Inc. : All Rights Reserved : : Payroll Interface Started at 17:06:28.45. : DB Type:[SQLBASE | ORACLE | INFORMIX | DB2 | : DB2ODBC | DB2400 | DB2UNIX | SYBASE | : MICROSFT]:ORACLE : : : Database:[hrpstest]:HRPSTEST : : : Username:[PS ]:PS : : : Password:[********]: : : Run Control ID[ ]: 14 : : : Process Instance:[0]:4817 : : : : SQL Trace:[0]: : : for Operator ID :PS : : and Batch Run ID :14 : : and PI Run Number :0009 : and Process Date : :1999-08-10 : and Run Type :L : and Run Option : :N : and Reprocess Option :N : and Export Full Set : : : CheckPoint/Restart Data : CheckPoint Interval:0005 : : Loading Interface Definitions for PI System = TRC : : Started at 17:06:29.36. : Ended at 17:06:29.45. : : Started import/load of payroll data at: 17.06.29.000000 : Error on Open for Input : : File Name: TRACE.DAT : File ID: 01 : : File Status: 35. : Unable to open external file for read: : : Check Messages!!! : <<< Checkpoint Taken >>> : IMPORT/LOAD PROCESS COMPLETED : PeopleSoft prcs_bat Terminating ***************** End Of Article ****************** Dave Gordon posted Message 131 in Message Board Dated : August 10, 1999 at 22:33:16 EST Subject: Payroll Interface Initial Load Hi A, Prior to doing an export, the process compares the last batch of data sent to the payroll system with existing records, so it doesn't send old news. You need to run the initial load process, in order to "prime the pump." Set run type to initial load, run option to new, and export to full set of records. Regards, Dave ***************** End Of Article ****************** raj posted Message 132 in Message Board Dated : August 18, 1999 at 17:24:52 EST Subject: MICR Check Printing direct from PS AP Hi, Has anyone done straight check print from PS on a Lexmark printer? Any details would be appreciated. Raj ***************** End Of Article ****************** Scott Hicks posted Message 133 in Message Board Dated : August 20, 1999 at 09:54:58 EST Subject: Re: MICR Check Printing direct from PS AP : Hi, : Has anyone done straight check print from PS on a Lexmark : printer? : Any details would be appreciated. : Raj Hi Raj; What in particular are you wondering? We print cheques from AP onto a Lexmark. ***************** End Of Article ****************** sri posted Message 134 in Message Board Dated : August 30, 1999 at 04:59:35 EST Subject: upgradation!urgent please! We are upgrading from Peoplesoft application version 7 to version 7.5 kindly let me know what all are the issues to be considered.please treat this on priority thanks in advance Sri ***************** End Of Article ****************** john Ferguson posted Message 135 in Message Board Dated : September 16, 1999 at 15:24:35 EST Subject: PLEASE... Payroll GL Interface Has anyone written an interface from HR 7.5 to Fin 6.0? I have been tasked to do so and could use any help I can get. I have to create a flat file containing all of the info. I need to be able to summarize from the pay line for all employer paid items. i.e. FICA, Medicair, Taxes, etc. If anyone has something that could help me out I would greatly appreciate it. Thanks. ***************** End Of Article ****************** Anthony H. Rainey posted Message 136 in Message Board Dated : September 21, 1999 at 09:54:12 EST Subject: PeopleSoft/AFIN Interface Has anyone developed and interfaces between PeopleSoft and AFIN (Advantage Financial)? ***************** End Of Article ****************** Steve North posted Message 137 in Message Board Dated : September 22, 1999 at 12:16:19 EST Subject: Re: Run reports using Message agents Using HRMS 7.02. I have a number of issues using the Query API. 1. Using Microsoft Access to run an exisiting PS query, I have found that data types other than 'char' cause errors. This seems to occur only when the non-char field does not contain data in every row of the returned dataset. I currently have to convert all fields of this type to char in PS Query to get the Access query working. 2. Again using MS Access to run PS Queries; Why do I get errors when the query contains expressions. I am using expressions to convert non-char data type fields to char (see issue 1). The peoplesoft interface prompts for a parameter for these expressions. This problem does not occur all the time. I seem to be able to re-enter the expressions within Peoplesoft to get around the problem in some cases. In others however, I have had to completely re-write the query (which is time consuming when using unioned select statements each using several tables and up to 10 criteria expressions per select). If I could only predict where and when the errors occur, the problems would be greatly allieviated. Are these known interface problems and is there a backdoor method that I could adopt to overcome them (perhaps via the psquery% tables). ***************** End Of Article ****************** Vidhya posted Message 138 in Message Board Dated : September 30, 1999 at 16:42:15 EST Subject: Re: PLEASE... Payroll GL Interface I had written an SQR for payroll - GL interface and it produces 6 ASCIIflat files (each for more readability and tracking), one for cash receipts( Gross TMRS, FRRS, FICA, withholding, EIC ), Employee Matching, Cash distribution, Pay fund, Individual fund, Header which contains the total credits and debits and the no of journal entries. Another SQR to be written on the Financials side to read these flat files and load to the Journal header and details tables. Hope this helps, Vidhya : Has anyone written an interface from HR 7.5 to Fin 6.0? I have been tasked to do so and could use any help I can get. I have to create a flat file containing all of the info. I need to be able to summarize from the pay line for all employer paid items. i.e. FICA, Medicair, Taxes, etc. If anyone has something that could help me out I would greatly appreciate it. : Thanks. ***************** End Of Article ****************** Dan Nguyen posted Message 139 in Message Board Dated : October 13, 1999 at 10:13:02 EST Subject: conversion to packed decimal format While sending data from PeopleSoft to IBM mainframe, I need to convert number to packed decimal format. Has anyone ever known the best way to handle this problem. Thanks. ***************** End Of Article ****************** Dave Gordon posted Message 140 in Message Board Dated : October 14, 1999 at 11:29:08 EST Subject: Re: conversion to packed decimal format Hi Dan, The last time I had a problem like that, I wrote the extraction program in COBOL, reading the required tables and writing to a file. If you have any questions about COBOL programs for the PeopleSoft environment, EMail me at dagordo@ibm.net. But do it soon, because I'm changing ISP's at the end of the month. Regards, Dave ***************** End Of Article ****************** Randy posted Message 141 in Message Board Dated : October 22, 1999 at 12:12:59 EST Subject: Re: conversion to packed decimal format Dan, This is a SQC with two procedures. One converts packed decimal to ASCII and the other goes the other way. Take a look at them - the Packed Decimal to number formats are in here with a basic instruction on how to use them !*********************************************************************** ! * ! $Header:: /PT75/SQR/CNVTPACD.SQC 11 ! * !*********************************************************************** begin-procedure PAC_DEC_CNVT($NUMBER_IN, :#NUMBER_OUT) ! converts numbers from Packed Decimal to ASCII numbers. ! this procedure also assumes that the number in has had the decimal point removed ! EX $number_in = '1234E' ! #number_out = 12345 ! EX $number_in = '1234N' ! #number_out = -12345 let $num = ltrim(rtrim($number_in, ' '), ' ') let #len = length($num) let #NUMBER_OUT = 0 let #multiplier = 1 if #len > 1 let #first = #len - 1 let $num1 = substr($num, 1 , #first ) let $num2 = substr($num, #len, 1) move $num1 to #num1 let #NUMBER_OUT = #num1 * 10 else let #NUMBER_OUT = 0 let $num2 = $num end-if if #len <> 0 evaluate $num2 when = '{' let #multiplier = 1 let #num2 = 0 break when = 'A' let #multiplier = 1 let #num2 = 1 break when = 'B' let #multiplier = 1 let #num2 = 2 break when = 'C' let #multiplier = 1 let #num2 = 3 break when = 'D' let #multiplier = 1 let #num2 = 4 break when = 'E' let #multiplier = 1 let #num2 = 5 break when = 'F' let #multiplier = 1 let #num2 = 6 break when = 'G' let #multiplier = 1 let #num2 = 7 break when = 'H' let #multiplier = 1 let #num2 = 8 break when = 'I' let #multiplier = 1 let #num2 = 9 break when = '}' let #multiplier = -1 let #num2 = 0 break when = 'J' let #multiplier = -1 let #num2 = 1 break when = 'K' let #multiplier = -1 let #num2 = 2 break when = 'L' let #multiplier = -1 let #num2 = 3 break when = 'M' let #multiplier = -1 let #num2 = 4 break when = 'N' let #multiplier = -1 let #num2 = 5 break when = 'O' let #multiplier = -1 let #num2 = 6 break when = 'P' let #multiplier = -1 let #num2 = 7 break when = 'Q' let #multiplier = -1 let #num2 = 8 break when = 'R' let #multiplier = -1 let #num2 = 9 break when-other let #multiplier = 1 let #num2 = 0 break END-EVALUATE LET #NUMBER_OUT = (#NUMBER_OUT + #num2) * #multiplier END-IF end-procedure begin-procedure PAC_DEC_out(#num, #length, :$NUMBER_OUT) ! converts numbers from ASCII to Packed Decimal numbers. ! this procedure also removes the decimal point by multiplying by 100 ! the #length then zero fills the number on the left to fit an output rec ! ! EX #num = '123.45' ! #length = 8 ! $number_out = '0001234E' ! EX #num = -123.45 ! #length = 8 ! $number_out = '0001234N' if #num >= 0 let $neg = 'N' let #num = #num * 100 ! remove the decimal else let $neg = 'Y' let #num = #num * -100 ! remove the decimal end-if let $num = edit(#num, '99999999999') let $num = ltrim(rtrim($num, ' '), ' ') let #len = length($num) if #len > 1 let #first = #len - 1 let $num1 = substr($num, 1 , #first ) let $num2 = substr($num, #len, 1) else let $num1 = '' let $num2 = $num end-if let $NUMBER_OUT = '{' if #len <> 0 if $neg = 'N' !value is positive evaluate $num2 when = '0' let $num2 = '{' break when = '1' let $num2 = 'A' break when = '2' let $num2 = 'B' break when = '3' let $num2 = 'C' break when = '4' let $num2 = 'D' break when = '5' let $num2 = 'E' break when = '6' let $num2 = 'F' break when = '7' let $num2 = 'G' break when = '8' let $num2 = 'H' break when = '9' let $num2 = 'I' break when-other let $num2 = '{' break end-evaluate else ! value is negative evaluate $num2 when = '0' let $num2 = '}' break when = '1' let $num2 = 'J' break when = '2' let $num2 = 'K' break when = '3' let $num2 = 'L' break when = '4' let $num2 = 'M' break when = '5' let $num2 = 'N' break when = '6' let $num2 = 'O' break when = '7' let $num2 = 'P' break when = '8' let $num2 = 'Q' break when = '9' let $num2 = 'R' break when-other let $num2 = '{' break END-EVALUATE end-if LET $NUMBER_OUT = $num1 || $num2 LET $NUMBER_OUT = lpad($number_out, #length, '0' ) END-IF end-procedure ***************** End Of Article ****************** Matthew Holroyd posted Message 142 in Message Board Dated : October 25, 1999 at 10:10:43 EST Subject: Web enabling Peoplesoft 7.5 I am looking into ways of web enabling PS 7.5 and have heard several techniques are available. I'm completely new to PS and so would appreciate any help available. Does anyone have opinions on what are the best ways to do this? We are currently running a 2 tier setup with DB2 database, and will be enabling for IE4. Any opinions on any of the following would be most appreciated, with reasons behind pros and cons, performance issues etc. x.500 Peoplesoft's web tools RCMS Please email any comments. Thanks Matt ***************** End Of Article ****************** Raghu posted Message 143 in Message Board Dated : October 26, 1999 at 09:32:51 EST Subject: About Payroll Interface Tables(PARTIC & PARTIC_EXPT) Hi All , I need to know how these Payroll Interface tables (PI_PARTIC and PI_PARTIC_EXPT) get populated when we process an export/import . How does these two tables work when they are in compare process . What does EXPORT_ROW field of PARTIC_EXPT contains after the process . Can anyone out there explain me the process related to these tables as PS doc does not have sufficient info. That would be a great help . Thanks in advance , raghu ***************** End Of Article ****************** Rajan posted Message 144 in Message Board Dated : October 28, 1999 at 04:29:31 EST Subject: Invoke Import Manager If I need to invoke Import Manager from an external application/ batch process how exactly can I do it? Even though PeopleSoft Documentation tells us to use calling psimp with certain parameters, when I try to do it it's giving error. Can somebody tell me the correct way to do it? Thanks ***************** End Of Article ****************** Salil Baig posted Message 145 in Message Board Dated : October 28, 1999 at 04:42:30 EST Subject: Import Manager does not invokes from external application Problem : I have been unsuccessfully trying to invoke Import Manager from an external application through psimp.exe with some command line parameters. This is the message which greets me every time in a modal window. "Missing or invalid version of SQL library PSSBS (0,0)" I'll appriciate any help or leads in debugging this out. Salil Baig. ***************** End Of Article ****************** Tony DeLia posted Message 146 in Message Board Dated : October 28, 1999 at 11:44:46 EST Subject: Re: conversion to packed decimal format Dan, I posted some Mainframe conversion routines on my site... http://www.sqrtools.com A) TDNUMMF.SQC - Mainframe Signed Number Conversion (Inbound/Outbound) This converts To/From Packed-Display Format using the standard overpunch in the last digit... note this is not actual packed data... B) TDUNPK.SQC - SQR Unpack Routine (Converting TRUE packed data to ASCII)... Example: ()+ or x'28292B' translates to -28292 You can navigate directly using the Latest Updates section or look under the Techniques section of the site... Tony DeLia PS - More updates to follow... : While sending data from PeopleSoft to IBM mainframe, I need to convert number to packed decimal format. Has anyone ever known the best way to handle this problem. : Thanks. ***************** End Of Article ****************** Rohit posted Message 147 in Message Board Dated : October 28, 1999 at 14:49:28 EST Subject: Re: Web enabling Peoplesoft 7.5 Hi Matthew, To begin with, you have to have a 3-Tier environment for deploying the web client. 2 Tier will NOT do. When you start up your tuxedo server processes through PSADMIN, the JSL and JSH processes facilitate the web client to talk to the database. Make sure you have a web server which has the delivered HTML and Javaclient applet files in its directories. You will have to configure your tuxedo processes & web server and make changes to the HTML files in the web server directories so that the java applets point to the correct port # of the JSL process. I hope this makes some sense. Write to me if you want to know more. Rohit : : I am looking into ways of web enabling PS 7.5 and have heard several techniques are available. I'm completely new to PS and so would appreciate any help available. : Does anyone have opinions on what are the best ways to do this? We are currently running a 2 tier setup with DB2 database, and will be enabling for IE4. : Any opinions on any of the following would be most appreciated, with reasons behind pros and cons, performance issues etc. : x.500 : Peoplesoft's web tools : RCMS : Please email any comments. : Thanks : Matt ***************** End Of Article ****************** walter posted Message 148 in Message Board Dated : November 01, 1999 at 06:03:55 EST Subject: Re: PeopleSoft calling function in C/C++ DLL : Is there a way for PeopleSoft to call a C or C++ function : in a Windows DLL? ***************** End Of Article ****************** Buddy MacDonald posted Message 149 in Message Board Dated : November 02, 1999 at 21:21:29 EST Subject: Interface to Time and Labor Rapid Time. Has anyone written an interface to Time and Labor version 7.5 Rapid Time by Employee tables? Our time is captured in an external time capture module and the plan is to have an SQR load the TL tables. I am looking for a sample SQR to use as a guide. I have not found anything delivered by PeopleSoft. If anyone has something that could help me out I would greatly appreciate it. Buddy ***************** End Of Article ****************** William Kristler posted Message 150 in Message Board Dated : November 12, 1999 at 13:32:51 EST Subject: Fast Database Queries What we are looking to do is get faster "Read Only" queries of the peoplesoft database, but with some security. I know that we could directly access the Oracle database via ODBS (or JDBC), but we would before to do this. Is it possible to access the PSQRYSRV directly? The documentation I've seen so far says to go through PeopleSoft Query (PSQED.EXE), but someone in my group thought they heard of a way to access it via Java directly. Any ideas? Thanks, -Bill ***************** End Of Article ****************** Atul posted Message 151 in Message Board Dated : November 21, 1999 at 04:34:06 EST Subject: Re: upgradation!urgent please! If you have a lot of customizations,You should run a compare report between current production system and vanilla 7.5 This should give you a list of new PS objects and the changed ones. Migrating the new ones is not a problem. For the changed ones, see if it makes sense to use the new 7.5 object and apply your customizations or move the old objects and bring it to speed with the new release. If you want to move from vanilla to vanilla 7.5, you have to follow the PS instructions for Upgrade. I guess this will bring the PS objects to sink by performing a lot of Alter tables, Creates and Drop etc. Before you do this, read the instructions very carefully as it has quite a few twists and turns. ***************** End Of Article ****************** Naveen Vatsavayi posted Message 152 in Message Board Dated : November 22, 1999 at 10:17:34 EST Subject: Data Transfer, using a Message Agent, in PeopleSoft itself. We have an approval process for some of our panels. For example, an employee has the option of giving his tax percentage(according to Govt. laws), through the web. That data should be written to a Temprary table which is a replica of the basd table. Once the manager of that employee Approves the percentage, ONLY then the data should be written to the main tables. This is to stop the flow of unapproved data into the main tables and to the various interfaces from there. When the manager gives his approval, we then want to send the data into the base tables and into the Audit tables. This can be done through Peoplecode, by coding lots of Inserts to different tables, which will turn up to be a Maintenance nightmare on the longer run. Hence we want to use the Message Agent option. I am aware of the process of sending or receiving data from external applications, through the message agents. But i am missing the vital link, ie, how to send data from one panel to another panel(or to a record), through a message agent. As we are sitting on a tight rope here, it would be quite helpful if you can get back to me with any details by close of business today. Please don't bother yourself, if you are quite busy. ***************** End Of Article ****************** Rohit posted Message 153 in Message Board Dated : November 22, 1999 at 16:32:39 EST Subject: Re: Data Transfer, using a Message Agent, in PeopleSoft itself. Navin, I dont know of any way the Message agent puts data from one panel to another. However, there is a way out for you. The Database Agent - which is a combination of a query and message agent. What you need to do is write a Query on the temporary table to select the data that needs to be sent to the correct panels. Save the query as a Database Agent query. Create a business process and insert an activity. In the activity, insert a Database Agent icon and point it to the (Core) panel you want to send the data to. (As you would with the message agent). Perform the Field mapping - each field of the query to a field on the panel. Since you say that the data is going to many tables, if the core panel does not do the entire work for you, you may have to create other Database agent definitions and point to the other panels as well. After you are done, Create a Database agent process definition. Make sure you run the database agent only in a 3tier environment, and you can only run this process on a windows based environment. The DBAG processes can give you quiet a pain in the bu*t, but they are worth it once they get working. Hope this helps. Good luck. Rohit : We have an approval process for some of our panels. For example, an employee : has the option of giving his tax percentage(according to Govt. laws), through the : web. That data should be written to a Temprary table which is a replica of the basd : table. Once the manager of that employee Approves the percentage, ONLY then : the data should be written to the main tables. This is to stop the flow of unapproved : data into the main tables and to the various interfaces from there. : When the manager gives his approval, we then want to send the data into the base : tables and into the Audit tables. This can be done through Peoplecode, by coding : lots of Inserts to different tables, which will turn up to be a Maintenance nightmare : on the longer run. Hence we want to use the Message Agent option. : I am aware of the process of sending or receiving data from external applications, : through the message agents. But i am missing the vital link, ie, how to send data from : one panel to another panel(or to a record), through a message agent. : As we are sitting on a tight rope here, it would be quite helpful if you can get back to : me with any details by close of business today. Please don't bother yourself, if you : are quite busy. ***************** End Of Article ****************** atefnet posted Message 154 in Message Board Dated : November 27, 1999 at 11:28:31 EST Subject: Re: P/S Payroll System Design : i am a student in grade 11 ,my computer project is payroll system design and i need some points to help me in the main structure of my project. ***************** End Of Article ****************** Angela Johanson posted Message 155 in Message Board Dated : December 14, 1999 at 15:06:57 EST Subject: Chrystal Reports Does PeopleSoft have an option to export the data to a Chrystal Report? Thanks. ***************** End Of Article ****************** soft lu posted Message 156 in Message Board Dated : December 15, 1999 at 03:39:58 EST Subject: Configuration for Mail I am studying workflow by myself, but I don't know how to config the ps with lotus notes. I am tring to send email from peoplesoft and I can not get mail in notes. By the way, when running psnotes.exe, system tell me "Can not find nNotes.dll". After copying dll file to system, psnotes.exe shows nothing. Is there any one can give me a config list? ***************** End Of Article ****************** Paddy posted Message 157 in Message Board Dated : December 17, 1999 at 17:18:32 EST Subject: Re: Payroll interface : Does anyone have a list of payroll systems that PeopleSoft can interface with? : Were using Centrepay -Paypoint Vu 2.10.1 : Thanks. Apart from ADP, Payroll Interface v.7.5 has addressed issues to Payplus product. I remember to have read some info from PS resolutions ***************** End Of Article ****************** Martin posted Message 158 in Message Board Dated : January 04, 2000 at 10:52:08 EST Subject: Re: Payroll interface : Does anyone have a list of payroll systems that PeopleSoft can interface with? : Were using Centrepay -Paypoint Vu 2.10.1 : Thanks. PS only provides ADP - but I have implemented an interface to PayPoint. It was mostly very straightforward once you understand how it works ! regards ***************** End Of Article ****************** Guest posted Message 159 in Message Board Dated : January 07, 2000 at 19:21:03 EST Subject: Message Agent and CUSTOMER table I am attempting to add a customer record using message agent. If I add the customer inputting fields that are only found in the CUSTOMER table (level 0) then I have no problems. If I attempt to add a customer with "Bill to Customer" (on panel CUSTOMER_GEN2), "Bill to Address" (on panel CUSTOMER_ADDRESS), and "Primary" (on panel CUSTOMER_ADDRESS) set to "Y", then I get the error "Unable to update value. (54,10)". Table and field are not specified. I don't see that i'm doing anything different from what an online user is doing when adding a new customer. Any thoughts ?? (same occurs for ship-to and sold-to) ***************** End Of Article ****************** David posted Message 160 in Message Board Dated : January 13, 2000 at 13:30:21 EST Subject: T&L - Project Costing integration Has anyone sucessfully done prior period adjustment to project costing from Time and Labor? Did you pass hours AND dollar amounts to Project Costing ? Will you share your knowledge wwith me? Currently on Oracle DB, PTOOLS 7.55, Psoft 7.50 TIA ***************** End Of Article ****************** Kurt Crowley posted Message 161 in Message Board Dated : January 14, 2000 at 13:06:22 EST Subject: version 8, business components, message agent level > 2 This is a somewhat broad (and probably asked) question, BUT, has anyone seen/used the 'business components' or other data access methods of version 8? we struggled with message agent limitations (level 2 + scrolls) and are curious if ps will really deliver complete ps data access WITH business edits. also has anyone used ActiveWorks Adapter for Peoplesoft? ***************** End Of Article ****************** Eugene Vincent posted Message 162 in Message Board Dated : January 23, 2000 at 10:00:28 EST Subject: Re: About Payroll Interface Tables(PARTIC & PARTIC_EXPT) Hi; I will identify and outline the two tables you were asking about. The PI_PARTIC table is used to determine which employees to review (apply compare) in the current payroll interface process. The table is build using two primary factors. 1) The Active Employees for Export (Employment Status Codes) setup for the interface are used to determine the active employees or employees to include in the selection process. The Active Employees for Export are established in the Administer Payroll Interface, Setup, Interface System Table 2 panel. This list of active employee status codes can be overridden through the Run Control Active Employees Check Box. If you turn this check box off, than selection process will include all employment status codes. When this box is checked, than only those employment status codes defined in the Interface System Table 2 panel are used to select employees. 2) When employee is terminated and the terminated status is not included in the active employee list the effective date of the termination must fall within the pay period being processed or the termination status will not be submitted to payroll. The work around for customers with late paper work processing is to always include the termination status codes within the Active Employee list of status codes. There are fixes for this issue,but currently not supported by PeopleSoft. 3) Normally you would include terminated employees during the payroll year, so address changes can be submitted to payroll when applied within PeopleSoft. The basic problem of including terminations is care must be applied, if your payroll vendor deletes terminations (ADP clears terminations in February of new Calendar year for prior year terminations, Pro-Business keeps terminations on file). The PI_PARTIC will include a record for each employee determined to meet the active employee requirements for the Pay Period being processed. If your active employee list includes terminations, than the PI_PARTIC will contain a row for all employees. This table continues to grow for each pay period being processed. The PI_PARTIC table once build is used to drive the rest of the compare process. This table carries basic information about the employee being processed. It will include the Payroll Company (PI_CONFIG_ID), PeopleSoft Company and Paygroup, Payroll Employee Id, PeopleSoft Employee Id, Employment Status and interface processing information. The processing information will indicate if employee has change activity during the process, or triggered a stop event. The PI_PARTIC_STATUS on record will indicate if employee completed compare or had an error message issued during the compare process. The PI_CHANGE_IND has little meaning during the process, but the PI_CHANGE_TYPE is used to indicate if Employee had a Data Change, or if Employee is a new hire,or if employee is rehired or terminated. This field is also used to indicate the stop events (process control indicator). Some special process routines use this field to help handle exporting information for payroll vendor. Mostly, what is delivered is handling the build of ADP/DOS records. The PI_PARTIC table is build during the compare process within the PIPCMPAR COBOL program. After the table is build it is than used to drive the rest of the compare process. During the build process the PI_PARTIC_STATUS is set to "P" (In Progress). During the compare process this field will wither be updated to "C" (Compared) or "E" (Compare Error). Please note that once an employee is issued an "E" the program will not send any change information to the Payroll Vendor. Once, the reason for employee getting error condition is corrected the employee will start sending changes. The PI_PARTIC_EXPT is used to store the selected PeopleSoft Data in what is refered to as the "Payroll Vendor's Image". When employee is selected the PeopleSoft information is obtained (All based on table definitions) and formatted into how the Payroll Vendor expects to see the data. This may mean that the PeopleSoft definitions are tranlsated into Payroll Definitions and Dates are formatted based on the Payroll Vendors required format. Decimals are applied if defined in the table setup to numeric fields. When you think about a field on the PI_PARTIC_EXPT table think of it in an ASCII Payroll Vendor structure. PeopleSoft uses a string structure to build a EXPORT_ROW data. The data is ordered in the EXPORT_ROW based on the order defined in the PI_DEFN_FIELD table. When the 250 bytes are filled, another 250 byte EXPORT_ROW field is established. If a field does not fit on a single 250 byte row, the data is split and the remainder of the data is inserted into the next 250 byte EXPORT_ROW field. Each Record definition will have it's own set of 250 byte EXPORT_ROW transactions. When the EXPORT_ROW is being build each field is started with a change indicator. The change indicator is a 1 byte field that indicates if the field being posted has changed. The indicators will be either 0 (No Change), 1 (Field Changed), or 2 (Field included as Change because it is associated with a Group definition). Grouped fields are fields on the PI_DEFN_FIELDS table that have the same group identifer. These are normally assigned to fields in which the Payroll Vendor has stated that if any field is changed than these other fields must also be included with the primary change (Pay Rate Changed, must also include Rate Type, etc.). So when the fields are strung on the EXPORT_ROW it would look like: cfffffffcffffffcffffffff (Where c would be the change indicator and f would be the field formated per Payroll Vendor requirements. When a record is defined as a multiple to multiple record, each unique occurrance will have separate 250 byte rows established to meet the complete record layout for the record definition. When a employee is compared the program will only create new data in the PI_PARTIC_EXPT table when employee has some type of change activity. When employee has eny type of change, all impacted records are inserted under the new PI_RUN_NUM on the PI_PARTIC_EXPT. If employee does not have any changes for the current Pay Period the PI_PARTIC_EXPT is not changed for employee unless the Compare is being processed using the Run Control Option of Full Set of Records. When this option is used the new PI_RUN_NUM will contain all employees selected from the PI_PARTIC table even if they have no changes for current pay period. Program still keeps track of the fields being changed and still records on the PI_PARTIC table the correct PI_CHANGE_TYPE information to indicate if employee has any changes. When the Payroll Interface gets to the Export process, the PI_CHANGE_IND from the PI_PARTIC_EXPT table is used to select the records that should be used to build the Payroll Vendors Data. If the Full Set of Records run control option is used, than the program will select all of the data for the current PI_RUN_NUM and build all fields and all records, even when no change is recorded for employee. Also, the table setup and formatting determines how much of the data is used to format the employee data. If the Payroll Vendor is using Physical Record layouts, than the field change indicator has not bearing on how the data is formated. Because a Physical Record layout will include all fields. The change indicator on a field is only used when field changes are submitted. If you need additional information about the Payroll Interface Tables, Please E-Mail me at EugeneV863@aol.com or you can call me at (315) 625-4898. Gene Vincent Sr. Tech. Consultant V.I.T., Inc. ***************** End Of Article ****************** Chester posted Message 163 in Message Board Dated : January 24, 2000 at 14:08:28 EST Subject: Re: Registering the Message Agent - Solved I can't seem to find the whitepaper mentioned here. I am developing Active Server Integration on PS 7.5 Message Agent, and intending to use its API. Where is this whitepaper published by Alliance Solution Center, and are there any other sources on how to use the Message Agent. : PeopleSoft has a published whitepaper on a sample message agent implementation with VB. It was published under the Alliance Solution Center. They even have a snipet of sample code illustrating the connect method. ***************** End Of Article ****************** waja posted Message 164 in Message Board Dated : January 25, 2000 at 10:54:31 EST Subject: Re: Chrystal Reports : Does PeopleSoft have an option to export the data to a Chrystal Report? Thanks. Yes.If you write a query ,you can direct the output to Crystal/Nvision(XL) etc... Hope that helps Waja ***************** End Of Article ****************** waja posted Message 165 in Message Board Dated : January 25, 2000 at 11:32:37 EST Subject: Payroll Interface I am intrested in learning INDEPTH about Payroll interface. Peoplebooks donot seem to help. Can someone give me tips(website/books .etc..) where I can learn Payroll Interface. Appreciate your help Waja ***************** End Of Article ****************** tyoer posted Message 166 in Message Board Dated : January 25, 2000 at 15:37:41 EST Subject: Just testing my friends computer HI this is a test ***************** End Of Article ****************** Vishwa posted Message 167 in Message Board Dated : February 02, 2000 at 10:33:24 EST Subject: How to start MESSAGE AGENT ??? Hi , I need some help on Message Agent . I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . Oracle 8.1.5 on Solaris 2.6 & Windows NT 4.0 Server as file Server I am trying to run the Databse Agent from command line .The command line parameters are as following psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . Process Instance=0 Activity Name=Deliver Reports Message Definition Name=Report Delivery Topic Name=//rpt inst:7000 Query Name = _DBAG__REPORT_DELIVERY 15.06.28:run query 15.06.28:fetch rows Message Agent not started 15.06.28:done Now Can you please tell me How do I START a Message Agent ?? I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. Looking forward for help , Warm regards Vishwa ***************** End Of Article ****************** Mathieu LEBRATI posted Message 168 in Message Board Dated : February 15, 2000 at 05:23:37 EST Subject: Re: How to start MESSAGE AGENT ??? Are you sure the PSAPISRV is running on your Application Server ? : Hi , : I need some help on Message Agent . : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : Oracle 8.1.5 on Solaris 2.6 & : Windows NT 4.0 Server as file Server : : I am trying to run the Databse Agent from command line .The command line parameters are as following : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : Process Instance=0 : Activity Name=Deliver Reports : Message Definition Name=Report Delivery : Topic Name=//rpt inst:7000 : Query Name = _DBAG__REPORT_DELIVERY : 15.06.28:run query : 15.06.28:fetch rows : Message Agent not started : 15.06.28:done : : Now Can you please tell me How do I START a Message Agent ?? : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : Looking forward for help , : : Warm regards : Vishwa ***************** End Of Article ****************** Mathieu LEBRATI posted Message 169 in Message Board Dated : February 15, 2000 at 05:30:33 EST Subject: Re: Configuration for Mail The executable for the VIM or MAPI email software must be in the search path so that the system can find it, or you can specify a location in the Configuration Manager Workflow tab. For Lotus Notes, the NOTESDB directory must also be in the path. You'll find all installation steps in PeopleBook PT750ENG.NFO : I am studying workflow by myself, but I don't know how to config the ps with lotus notes. I am tring to send email from peoplesoft and I can not get mail in notes. By the way, when running psnotes.exe, system tell me "Can not find nNotes.dll". After copying dll file to system, psnotes.exe shows nothing. Is there any one can give me a config list? ***************** End Of Article ****************** Jim Mabey posted Message 170 in Message Board Dated : February 17, 2000 at 01:31:13 EST Subject: EDI loading vendor payment request from 3rd party What's the recommended method of transferring payment requests to Peoplesoft from a 3rd party application? Need to process Utility Billing refunds and other misc. payments. Don't want to have to key in manually. Thanks. ***************** End Of Article ****************** Mathieu LEBRATI posted Message 171 in Message Board Dated : February 21, 2000 at 08:27:07 EST Subject: Re: EDI loading vendor payment request from 3rd party You can use standard EDI transaction to load Invoice. See the Application Fundamentals PeopleBooks for more detail about this transaction. : What's the recommended method of transferring payment requests to Peoplesoft from a 3rd party application? Need to process Utility Billing refunds and other misc. payments. Don't want to have to key in manually. : Thanks. ***************** End Of Article ****************** Lalita Kambhampati posted Message 172 in Message Board Dated : February 22, 2000 at 14:41:48 EST Subject: Re: EDI loading vendor payment request from 3rd party You can do that using the Payment Interface option. Refer to the documentation for more details : http://www4.peoplesoft.com/contdoc.nsf/8aed139ec41bb3c1882566fa00055a05/36e11bb5378ce0f88825672e006efe2b?OpenDocument - Lalita : What's the recommended method of transferring payment requests to Peoplesoft from a 3rd party application? Need to process Utility Billing refunds and other misc. payments. Don't want to have to key in manually. : Thanks. ***************** End Of Article ****************** ketan posted Message 173 in Message Board Dated : February 28, 2000 at 18:01:26 EST Subject: Re: How to start MESSAGE AGENT ??? Hi If you are running PeopleSoft in 3-Tier then all the PeopleSoft Client (Web, PeopleSoft Panel or Any other) uses the Message Agent to run the business rules coded in PeopleCode. So, again verify with your DBA or Admin people that you are running all the services to run the PeopleSoft in 3-tier Ketan : Hi , : I need some help on Message Agent . : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : Oracle 8.1.5 on Solaris 2.6 & : Windows NT 4.0 Server as file Server : : I am trying to run the Databse Agent from command line .The command line parameters are as following : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : Process Instance=0 : Activity Name=Deliver Reports : Message Definition Name=Report Delivery : Topic Name=//rpt inst:7000 : Query Name = _DBAG__REPORT_DELIVERY : 15.06.28:run query : 15.06.28:fetch rows : Message Agent not started : 15.06.28:done : : Now Can you please tell me How do I START a Message Agent ?? : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : Looking forward for help , : : Warm regards : Vishwa ***************** End Of Article ****************** ketan posted Message 174 in Message Board Dated : February 28, 2000 at 18:03:10 EST Subject: Re: How to start MESSAGE AGENT ??? Hi If you are running PeopleSoft in 3-Tier then all the PeopleSoft Client (Web, PeopleSoft Panel or Any other) uses the Message Agent to run the business rules coded in PeopleCode. So, again verify with your DBA or Admin people that you are running all the services to run the PeopleSoft in 3-tier Ketan : Hi , : I need some help on Message Agent . : I am trying to run the SAMPLE Database Agent example Remote Report Delivery.Our PS 7.5 Environment is as follows . : Oracle 8.1.5 on Solaris 2.6 & : Windows NT 4.0 Server as file Server : : I am trying to run the Databse Agent from command line .The command line parameters are as following : psdba.exe -ADeliver Reports -MDReport Delivery -TOPICrpt inst -T : When I issue the above command, PeopelSoft Sign-On window appears where I submit my application server name and : Operator id .The trace file DBA*.tmp generated in my C:\temp directory contains the follwoing info . : Process Instance=0 : Activity Name=Deliver Reports : Message Definition Name=Report Delivery : Topic Name=//rpt inst:7000 : Query Name = _DBAG__REPORT_DELIVERY : 15.06.28:run query : 15.06.28:fetch rows : Message Agent not started : 15.06.28:done : : Now Can you please tell me How do I START a Message Agent ?? : I checked up my APPSERV & TUXEDO and they are UP and Running .All the services are running. : : Looking forward for help , : : Warm regards : Vishwa ***************** End Of Article ****************** Vishwa posted Message 175 in Message Board Dated : February 29, 2000 at 04:38:48 EST Subject: Word Macros - Adding a NEW Field Hi I want to include an additional FIElD in the FORM Letter template LTROF1. Can anyone tell me How to add a MERGE field to this WOrd template ? I am not very comfortable with Word Macros ? ***************** End Of Article ****************** Brian posted Message 176 in Message Board Dated : March 01, 2000 at 17:11:53 EST Subject: EDI Integration Quick question: If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? ***************** End Of Article ****************** Dave posted Message 177 in Message Board Dated : March 01, 2000 at 18:06:41 EST Subject: AR EDI Hello all, Did anyone implement EDI in AR? I am planning to implement EDI 820 and I am not getting a list of required fields. Also can I accept incoming payments without a MICR ID or CUST ID with only the the item ID for identification? Will it work ? Thanks in advance Dave ***************** End Of Article ****************** Kasper de Bruin posted Message 178 in Message Board Dated : March 02, 2000 at 03:23:54 EST Subject: Web Requisition Interface I am not a VB, or C programmer. I would like to build a web interface for Requisitions. I can extract data from peoplesoft using odbc, and I can place data in tables using the same method. Is there a way to import requisition data from tables into the peoplesoft system. ***************** End Of Article ****************** Vikram posted Message 179 in Message Board Dated : March 02, 2000 at 10:48:13 EST Subject: Re: EDI Integration You will need an EDI service provider - a VAN. You will also require translation s/w such as Sterlings' Gentran and PS EDI manager. For a list of vendors apporved by PS for EDI check PS site. HTH - Vikram : Quick question: : If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? ***************** End Of Article ****************** Amy Christenson posted Message 180 in Message Board Dated : March 02, 2000 at 12:03:04 EST Subject: Interfacing Outlook and T&L We want to create a form in outlook that our users will use to enter time and labor, then import this data into PS T&L. Can this be done? Any suggestions on the best route ie message agent, sqr... Thanks! ***************** End Of Article ****************** brian posted Message 181 in Message Board Dated : March 02, 2000 at 12:31:56 EST Subject: Re: EDI Integration : You will need an EDI service provider - a VAN. You will also require translation s/w such as Sterlings' Gentran and PS EDI manager. For a list of vendors apporved by PS for EDI check PS site. : HTH : - Vikram : : : Quick question: : : If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? We already have a coomplete EDI infrastructure (hardware, software, VAN, communications,etc..). What I am trying to figure out is if the PS EDI Manager performs the same functions as other EDI software, and if so do I still need to use it, and why? Thanks ***************** End Of Article ****************** Terry posted Message 182 in Message Board Dated : March 11, 2000 at 09:34:44 EST Subject: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy I have a client who has a requirement to interface SAP with a number of other systems including Peoplesoft. The interface needs to be synchronous or asynchronous and it should be able to detect whether the SAP system is down and store the data until the SAP system is back up. I heard about a product from d.d. synergy called CCcom and I was wondering if anyone has any experience with their product? Thank you in advance for any information you might be able to provide. Terry TMHR Consulting ***************** End Of Article ****************** Amy posted Message 183 in Message Board Dated : March 20, 2000 at 16:00:14 EST Subject: Re: T&L - Project Costing integration We successfully passed prior period and dollar amounts to Projects. If you would like more information, please contact me directly. Amy : Has anyone sucessfully done prior period adjustment to project costing from Time and Labor? Did you pass hours AND dollar amounts to Project Costing ? Will you share your knowledge wwith me? Currently on Oracle DB, PTOOLS 7.55, Psoft 7.50 : TIA ***************** End Of Article ****************** Vikram posted Message 184 in Message Board Dated : March 22, 2000 at 17:34:38 EST Subject: Re: EDI Integration : : You will need an EDI service provider - a VAN. You will also require translation s/w such as Sterlings' Gentran and PS EDI manager. For a list of vendors apporved by PS for EDI check PS site. : : HTH : : - Vikram : : : : : Quick question: : : : If you were going to implement exchanging EDI documents with external suppliers, would you use the PS EDI Manager or would it be better to use a third party EDI package (i.e. Gentran, etc.)? : We already have a coomplete EDI infrastructure (hardware, software, VAN, communications,etc..). What I am trying to figure out is if the PS EDI Manager performs the same functions as other EDI software, and if so do I still need to use it, and why? : Thanks The PS EDI Manager and Translation s/w such as Gentran are complimentary and one cannot be replaced by the other. Briefly: When the EDI file comes in Via VAN, Gentran translates the data into PS readable format, this file is the input for EDI manager. This is INBOUND transaction, for OUTBOUND transaction, Gentran converts EDI Manger output into an "EDI transmittable" format. HTH Vikram ***************** End Of Article ****************** kcrowley posted Message 185 in Message Board Dated : March 23, 2000 at 17:10:27 EST Subject: Business rules via Edit mode My question is whether anyone has found a way to "test" PeopleSoft business rules from an external application. Obviously, MessageAgent will verify business rules upon an update , BUT i wonder if anyone has found a method (either on the database level or even dll level (psmas.dll) ) to CHECK a transaction without the implicit commit. Thanks, Kurt ***************** End Of Article ****************** Deanna posted Message 186 in Message Board Dated : March 28, 2000 at 22:16:23 EST Subject: Interface Payroll 7.02 E&G with GL 7.50 E&G We are currently upgrading to FIN 7.5 E&G from FIN 7.01 E&G and have discovered that the delivered Payroll/GL interface is not valid between HR 7.01 and GL 7.50, AND PeopleSoft has no resolution for this. Has anyone else encountered this problem? How have you dealt with it? Any info. at all would be appreciated. ***************** End Of Article ****************** Terry posted Message 187 in Message Board Dated : April 01, 2000 at 13:19:36 EST Subject: Re: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy Thank you for your follow-up message. I was actually able to find some information about CCcom from d.d. synergy. Let me know if you want a copy of their white paper. It should also be up on their web site at: www.ddsynergy.ca. Terry : I have a client who has a requirement to interface SAP with a number of other systems including Peoplesoft. The interface needs to be synchronous or asynchronous and it should be able to detect whether the SAP system is down and store the data until the SAP system is back up. : I heard about a product from d.d. synergy called CCcom and I : was wondering if anyone has any experience with their product? : Thank you in advance for any information you might be able to provide. : Terry : TMHR Consulting ***************** End Of Article ****************** Joe Weessies posted Message 188 in Message Board Dated : April 03, 2000 at 19:01:37 EST Subject: Re: Web Requisition Interface Check out the Application Engine process - REQLOAD. This is a PS built way to enter in requisitions from outside systems. This will show you the tables and the process to be used. You will have to setup some other panels to get this to work but it is all right there to build upon. JoeW : I am not a VB, or C programmer. I would like to build a web interface for Requisitions. I can extract data from peoplesoft using odbc, and I can place data in tables using the same method. Is there a way to import requisition data from tables into the peoplesoft system. ***************** End Of Article ****************** Margot Brown posted Message 189 in Message Board Dated : April 11, 2000 at 09:36:21 EST Subject: Re: Scanning Interface : I'm sure there are more, but the only scanner interface I've dealt with is the Restrac Resume Reader for PeopleSoft. You might be able to get some infor from Restrac's web page. : : Doing some research for our peoplesoft project. I have been searching all over the web, various inquiries, but have not been able to get any information on the scanning interfaces that are available. Any help would be appreciated. ***************** End Of Article ****************** Brian posted Message 190 in Message Board Dated : April 18, 2000 at 16:12:41 EST Subject: Import Orders into OM I am trying to import orders placed over the web into PS Order Management 7.5. What is the best way to import the data into the PeopleSoft dB? We are currently running 3-tier on Oracle dB. Thanks in advance, Brian ***************** End Of Article ****************** Dan posted Message 191 in Message Board Dated : April 21, 2000 at 16:11:45 EST Subject: Re: Interface Payroll 7.02 E&G with GL 7.50 E&G We upgraded our HR and FS at the same time! : We are currently upgrading to FIN 7.5 E&G from FIN 7.01 E&G and have discovered that the delivered Payroll/GL interface is not valid between HR 7.01 and GL 7.50, AND PeopleSoft has no resolution for this. Has anyone else encountered this problem? How have you dealt with it? Any info. at all would be appreciated. ***************** End Of Article ****************** Hunter Praywell posted Message 192 in Message Board Dated : May 11, 2000 at 16:00:03 EST Subject: Purchase Order Interface into Purchasing We use a third party purchasing system issue and manage our purchase orders. These New, Changed and Cancelled POs created in the third party system and interfaced directly into our PSFT PO prod. tables. It works miserably, as it does not perform all the complex data validations when loading external data directly into our production tables. If anyone has built a smooth interface, with necessary validations and reject / clean-up tables, v. 7.5x or higher, can you contact me and give me some hints on how to get these new, changed and cancelled PO transactions into the Purchasing module with maximum validation and minimum PAIN? Req. tables? PO Build tables? Yes, we're looking for a consultant, and we work in Hawaii, but I'll post this in the right forum. 808-838-5464 ***************** End Of Article ****************** Michael W. Kreider posted Message 193 in Message Board Dated : May 18, 2000 at 21:35:40 EST Subject: WMS API Warehouse Management Integration with PkMS We have the WMS API's and have integrated with PkMS from Manhattan Associates. We would like to talk with someone else who has implemented the Peoplesoft WMS API's. We have a need to upgrade the application from 7.52 to 7.53. ***************** End Of Article ****************** rgk posted Message 194 in Message Board Dated : May 24, 2000 at 14:59:33 EST Subject: Re: conversion to packed decimal format : While sending data from PeopleSoft to IBM mainframe, I need to convert number to packed decimal format. Has anyone ever known the best way to handle this problem. : Thanks. My company sells a 3rd party product called REELExchange. It is a UNIX application that allows you to take data from an IBM Mainframe and convert it into standard UNIX data format. We can convert IBM Zoned Decimal and Packed Decimal fields, read tapes that span multiple volumes, read unlabeled data sets, etc. In addition to reading IBM mainframe tapes, we can also write UNIX data to an IBM Standard Label fomats. Cost is $3000 plus $540 per year for support & upgrades. ***************** End Of Article ****************** Hector Hernandez posted Message 195 in Message Board Dated : June 02, 2000 at 15:10:59 EST Subject: Inventory Transactions Interface Hello All, I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? Thank you all in advance. Hector Hernandez. ps: i would appreciate sending me answers via email as well? ***************** End Of Article ****************** TECH_TEAM posted Message 196 in Message Board Dated : June 06, 2000 at 16:37:21 EST Subject: Re: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy A company called Crossworlds provides products to Integrate different ERP systems as well as integrate other sytems like CRMs e.t.c to your ERP. The product for Integrating ERP's is called Crossworld Enterprise vist web site www.crossworlds.com for more information. ***************** End Of Article ****************** christophe ledieu posted Message 197 in Message Board Dated : June 17, 2000 at 13:09:39 EST Subject: Re: Inventory Transactions Interface Hi Hector. There is a bunch of transactions PeopleSoft Inventory can do ! I am not too sure what you actually have to do (putaway, adjustments, MSR, bin-to-bin, ...) but by having faced the problem a couple of times, what I can tell you is not to simulate anything else than a receiving (putaway) using a SQR. Basically, when you don't have staging tables to populate (ex : staged_inf_inv, demand_inf_inv, ...), don't even try to do it, or you'll end up with all the possible discrepancies in your stock. The business rules enforced via the manifold transaction panels are very complicated, and can change based on the setup. And it is a lost of time to even think about figuring them out in a comprehensive way. Instead, try to use a message agent / database agent. Just in case you don't know what that is, it is standard tool that simulates an entry into a panel (like a user would do it). The pros is that all peoplecode business rules are enforced via the panel, even those you are not aware of. The cons is that it's not easy to write, and very slow in terms of processing (for instance, an adjustment or bin-to-bin transfer can take up to 5 seconds to execute. If you have large amounts of data to process on a daily basis, it is probably not a good idea to use this workflow tool...!) Hope this helps. Chris. : Hello All, : I need to interface all inventory transactions from an external system into PeopleSoft. For most transactions, i am pretty sure i am writing the data from flat files into the right set of tables. I am using SQR to do this, i can even visualize the info i am importing into PeopleSoft. But..... when you enter transactions online into Inventory, and save the panel, a bunch of PeopleCodes are executed, these do things like summarize the transaction info for the record PS_TRANSACTION_INV and update my item availble quantities. This i can NOT for my life do with SQR... so, i am importing the data fine, but my inventory status is not being updated!!!!! Anyone knows what i am doing wrong here? or how i could ago about importing all these transactions and getting all those PeopleCodes to run so my inventory gets updated... or anyone has any idea at all that could help me import these transactions correctly???? : Thank you all in advance. : Hector Hernandez. : ps: i would appreciate sending me answers via email as well? ***************** End Of Article ****************** christophe ledieu posted Message 198 in Message Board Dated : June 17, 2000 at 13:21:43 EST Subject: Re: Middlesware for SAP and Peoplesoft - CCcom from d.d. synergy Hi Terry. I've used a tool that does what U need. It is called OSCAR and really cool for real time interfacing. You can call an OSCAR service from a panel (windows) or from a UNIX platform. Hope this helps. Chris. : I have a client who has a requirement to interface SAP with a number of other systems including Peoplesoft. The interface needs to be synchronous or asynchronous and it should be able to detect whether the SAP system is down and store the data until the SAP system is back up. : I heard about a product from d.d. synergy called CCcom and I : was wondering if anyone has any experience with their product? : Thank you in advance for any information you might be able to provide. : Terry : TMHR Consulting ***************** End Of Article ****************** Rob posted Message 199 in Message Board Dated : June 20, 2000 at 16:43:16 EST Subject: ODBC Database Link Does anyone have any ideas on creating a Database link between PeopleSoft (on Oracle) and a legacy system (on SQL Server 7)? I know there is a way to create a DB link using SQL to pass the information. Any ideas? ***************** End Of Article ****************** Kishan posted Message 200 in Message Board Dated : June 27, 2000 at 06:40:42 EST Subject: AP: Document sequencing not working. We are using PeopleSoft 7.5 and loading vouchers from a leagacy system. The Vouchers are being loaded in to the PS_...._EC tables using a home written interface program. The next thing we do is copy the table contents to the work tables using VCHREC. After the VCHREC process all the DOC_... fields are blank or NULLed, with the exception of DOC_TYPE which is set to "VOUCHER". Finally we use the APPBVCHR process to edit the vouchers. What we are finding is that the vouchers Document sequences are not being set, but the document sequence date-time stamp is being set. We've checked that the Business units document sequence option is set. We've checked that the VOUCHER document type has a valid range. We've even created on-line vouchers which have document sequences. Can anyone help us with this problem? ***************** End Of Article ****************** Rob posted Message 201 in Message Board Dated : June 27, 2000 at 16:40:49 EST Subject: Re: AP: Document sequencing not working. Don'y know much about Document sequencing but have ou applied R-MSTERZ-HR5AH : We are using PeopleSoft 7.5 and loading vouchers from a leagacy system. The Vouchers are being loaded in to the PS_...._EC tables using a home written interface program. : The next thing we do is copy the table contents to the work tables using VCHREC. After the VCHREC process all the DOC_... fields are blank or NULLed, with the exception of DOC_TYPE which is set to "VOUCHER". : Finally we use the APPBVCHR process to edit the vouchers. What we are finding is that the vouchers Document sequences are not being set, but the document sequence date-time stamp is being set. : We've checked that the Business units document sequence option is set. : We've checked that the VOUCHER document type has a valid range. : We've even created on-line vouchers which have document sequences. : Can anyone help us with this problem? ***************** End Of Article ****************** Tony DeLia posted Message 202 in Message Board Dated : July 15, 2000 at 19:27:05 EST Subject: FREE Book Preview - Essential Guide to PeopleSoft Development and Customization Hello PeopleSoftFans, I posted some sample PDF files for the "Essential Guide to PeopleSoft Development and Customization" (Manning Publications - Delia, Landres, Rivera, Sankaran) on my website - http://www.sqrtools.com - The book is being printed and will be distributed in a couple weeks... The PDF samples include Chapter 9 (PeopleSoft Application Processor), Chapter 16 (Working with Scrolls), Chapter 35 (What is Application Engine), plus the Table of Contents, Index, Preface, etc... any feedback is, as always, greatly appreciated! Thanks! Tony DeLia http://www.sqrtools.com ***************** End Of Article ****************** Fryslan posted Message 203 in Message Board Dated : July 18, 2000 at 08:32:39 EST Subject: HELP!!!! I don't know where to go with my problem, so I hope that anyone here knows a solution that he or she can e-mail to me. Using Chrystal Reports 4.6, I am trying to create a report based on two tables on a SQL Server. The first two or three fields that I enter are ok, but when I add any more that might exceed the length of the line (option continue on following line is checked) I get this #*&$!! Dr Watson thing or the application just stops running. Who knows what to do here? Please e-mail me instead of submitting a reply here, because this is the first time for me here and I will probably not be able to find this board again. Thank you. ***************** End Of Article ****************** Sharad posted Message 204 in Message Board Dated : July 18, 2000 at 12:48:55 EST Subject: Runnning an Import from the command line I have created an Import File Definition. I need to invoke the Import Manager and run the import definition I have created, directly from the command line(without bringing up the Import Manager screen). What command-line parameters do I need to use. Thanks ***************** End Of Article ****************** ESTELLA langot posted M