Quest Q and A Spring 2010 : Page 9
lesoft http://blogs.hexaware.co 6. Q: I want to know why the events are ordered in this way: 1. SavePreChange 2. Workflow <> 3. SavePostChange <> My SavePostChange Code is resulting in error. The data is getting rolled-back but my Workflow code triggers the mail - which should not happen when transaction fails, right? A: PeopleSoft gives us the option to validate all business rules before saving data into the database which can be written in SavePreChange. Now, since all your data’s are saved a WorkFlow event is triggered to inform about the activity in the current transaction. If there is any SavePostChange you have to handle it first, in SavePreChange. There is no way you can rollback it. You have three options: validate every scenario in SavePreChange, don’t use WorkFlow instead can use AAF (Active Analytic Framework) or use by CI trigger the WorkFlow event in SavePostChange once all your data is saved. 7. 8. 9. Q: Can you teach me how to display the date in a particular format in the CSV file? The users want the date in ‘YYYY-MM-dd’ format, but once I generate the CSV using AE then it is displayed as the default excel format. Please help! A: Store it as text format instead of Date; just concanet ‘in front of your data for each row. Now, Microsoft Excel will not change the format. Q: Is it possible to use “In List” in the Query using Query viewer dynamically? If not, is there is any other alternative to achieve the “In List” criteria in the Query dynamically? A: The “In List” cannot be a dynamic prompt; instead you can use this “In List” with a subquery which can give dynamic values to the list. The subquery can be built in such a way that you group the values of the “In List” with some criteria which can be selected using prompt. Q: How do you execute external software (exe) from PeopleSoft? The software is installed on another system which is in network (but not on the PeopleSoft server). It is able to run from Command Prompt, but not with PeopleSoft Exec function. A: For running external software: 1) Since the software is installed on an external system, we need to map the network drive and give absolute path to run the command, or 2) Create a batch file (which runs the same way as he is doing it from Command Prompt) and call the batch file from PeopleSoft. However, this option needs to be tested out before posting. 10. Q: Hi! I am working on delivered CI_JOB_dATA in HRMS 8.8. When I dragged the delivered CI in to an App Eng and tried to validate, it gives an error for “End-for”. On further investigation, I found that “End-for” is not generated in the PeopleCode for JOB_JR and COMPEnSATIOn collection which is expected. After adding the “End-for” PeopleCode works fine for this CI code. I tried the same in HRMS 8.9.9.0 instances and got the same error. Is this the PeopleSoft bug? A: The End-For for the collections you have mentioned is correct - it is required but not generated. Maybe we need to ask PeopleSoft for a resolution, but a developer can easily understand that the End-For is required at certain collections, which is missing. 11. Q: I’m facing a problem with the worklist. When I enter a particular component through the menu navigation, the component launches. But when I try to enter to the component through a worklist entry, it shows “you are not authorized for this page”. And this occurs only for a particular User Id. What might be the problem? A: This should not happen in case of worklist even. The only possibility is that the worklist is directing you to some other Page/ Component. Please investigate further to confirm that you are checking the correct component/page. If this doesn’t solve your issue, please let me know the component name and the worklist so that I can check it at my end. 9
Publication List
