tag:blogger.com,1999:blog-34020393.post7381973947289264000..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: Collaborate 2014 ScheduleJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger28125tag:blogger.com,1999:blog-34020393.post-82339943599195217622015-06-18T11:52:07.821-07:002015-06-18T11:52:07.821-07:00@truffing , If you have trace or anything that wil...@truffing , If you have trace or anything that will really help. verify your custom workflow has IB setup too like Message, Queues & the App Package code on what to do for the response email and all that stuff. The complete_flag is set to 'Y' specifying it did parse the email for that transaction and now it triggers urs custom IB message of ur workflow and rest of it. check Oracle support for detail setup. Even I did custom AWE and complete email approval setup from scratch.MAKhttps://www.blogger.com/profile/08478257156684906310noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-31624893589756673702015-06-18T10:27:10.843-07:002015-06-18T10:27:10.843-07:00I think I'm missing something somewhere. We h...I think I'm missing something somewhere. We have setup a custom approval workflow with email approvals. The email approval comes in from the user as expected, and updates a table called EOAWEMC_PND_HDR. The following field is updated in EOAWEMC_PND_HDR, COMPLETE_FLAG = 'Y. The issue I have is the workflow step is never updated with the approval or denial. I'm trying to figure out what I'm missing in my setup to get the email approval\denial to update the workflow step. Can somebody help me with this? Am I missing some setup?truffinghttps://www.blogger.com/profile/05467673553424596972noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-50779229184351965322014-07-11T12:29:53.371-07:002014-07-11T12:29:53.371-07:00@Arun, I am not sure what causes this. You may hav...@Arun, I am not sure what causes this. You may have to file a support case for this. If you have control over the HTML e-mail, you may want to check it for consistency. There are certain inconsistencies in HTML e-mails that cause mail servers and clients to treat them as spam. For example, incorrect headers, missing plain text alternative, etc.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-62982672581586170932014-07-10T10:53:27.425-07:002014-07-10T10:53:27.425-07:00Hello Jim,
We are implementing email Approvals fo...Hello Jim,<br /><br />We are implementing email Approvals for workflows in 9.1 with 8.51 tools. I ran into issue when the approver send his response the EOAWEMC process picks the email from mailbox but treats it as spam and logs the transaction in MCFEM_MAIL_MAIN. The point to be taken is the email was sent in text/html format. But the if the same response is sent in text/plain format, EOAWEMC process picks it and approves the transaction.Could you please help on how to solve this..?<br /><br />Thanks<br />ArunAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-34020393.post-1792994551540366052014-06-25T15:28:22.800-07:002014-06-25T15:28:22.800-07:00@Mani, rows yes , columns no. a work around is to ...@Mani, rows yes , columns no. a work around is to add the rows at design time and hide them. then make them visible when you want them.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-44656062354746840332014-06-25T03:28:32.476-07:002014-06-25T03:28:32.476-07:00Jim,
Is it possible to dynamically add columns to ...Jim,<br />Is it possible to dynamically add columns to a grid using PeopleCode?<br /><br />Like if I wish to add 5 new columns to my grid, would that be doable?Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-5715894910883170522014-05-28T08:31:37.050-07:002014-05-28T08:31:37.050-07:00@Chandu, it may be possible, but not recommended.@Chandu, it may be possible, but not recommended.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-35408432073631445552014-05-28T05:56:39.832-07:002014-05-28T05:56:39.832-07:00we are planning to upgrade our peopletools from 8....we are planning to upgrade our peopletools from 8.52 to 8.53.Our new version of PeopleTools (8.53) comes with Java version 1.7,<br />Is it possible to upgrade to Java version 1.8 while staying on PeopleTools 8.53<br />chanduhttps://www.blogger.com/profile/14230754056268041974noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-31538113831810565952014-05-27T08:36:55.381-07:002014-05-27T08:36:55.381-07:00Thanks a ton, Jim!! :) This is exactly how I did i...Thanks a ton, Jim!! :) This is exactly how I did it and even used the same approach for opening a page in FSCM.<br /><br />Really appreciate your contribution to the PeopleSoft community!!Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-15828613064213345022014-05-27T08:29:48.348-07:002014-05-27T08:29:48.348-07:00@Mani, if you pass values on the URL that match th...@Mani, if you pass values on the URL that match the search record's search keys, then no, you don't need to modify any PeopleCode. It does not matter that the fields differ between the two components.<br /><br />On your next question, it sounds like you are not using a search record, so yes you need to write PeopleCode. I try to avoid PageActivate for data model changes because whether or not a page is visible is usually irrelevant from a data perspective. I reserve PageActivate for visual changes. The most common event for data changes is RowInit. Another thing I noticed from your sample is your date format. The PeopleCode date format is CCYY-MM-DD.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-36850696032387815842014-05-24T08:35:06.140-07:002014-05-24T08:35:06.140-07:00This is what I am doing currently..
&URLString...This is what I am doing currently..<br />&URLString = GenerateComponentRelativeURL(%Portal, %Node, MenuName."MANAGE_PAYROLL_PROCESS_(GBL)", %Market, Component."GP_SS_PSLP_ADMINVW", Page."GP_SS_PSLP_ADMINVW", "U", &rec);<br /><br />and passing level 0 record field's value (not search record)<br /><br />&content1 = "&FROM_DATE=06/29/2014";<br />ViewURL(&URLString | &content1);<br /><br />And in the destination component's page activate, checking if there is any value returned from %Request.GetParameter(FROM_DATE).. If yes, I would assign the new value from the URL.<br /><br />Jim, is there something that I am not doing right?Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-25717673694679862512014-05-24T07:10:28.101-07:002014-05-24T07:10:28.101-07:00Thanks a lot, Jim! :) My issue is now resolved.. :...Thanks a lot, Jim! :) My issue is now resolved.. :) Is there any possible way I can pass values between two different components? Without having to modify anything in the destination component? I have to pass values from a page in one component to a page in another component, which has a different search record and the field which I should populate on the destination component belongs to a different record .. any ideas on how this can be achieved?Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-54327942999436204792014-05-19T09:42:35.875-07:002014-05-19T09:42:35.875-07:00@Mani, yes. Make sure the HCM and FSCM nodes trust...@Mani, yes. Make sure the HCM and FSCM nodes trust each other. After setting up trusted nodes, you will want to update the node definition URL's and create CREF's for the target components.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-1553096021147338072014-05-19T06:45:28.878-07:002014-05-19T06:45:28.878-07:00@Jim : Thank you. That issue is fixed.
Jim, can a...@Jim : Thank you. That issue is fixed.<br /><br />Jim, can an FSCM page be opened from HCM? Similar to how TransferPage works?<br /><br />Thank you!Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-18329213676756452422014-05-13T07:57:30.260-07:002014-05-13T07:57:30.260-07:00@Mani, sub pages share the component buffer, so an...@Mani, sub pages share the component buffer, so any values you change in the sub page are automatically changed in the parent.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-80959762101469143042014-05-13T06:20:02.907-07:002014-05-13T06:20:02.907-07:00Hi Jim,
Would it be possible to pass values from a...Hi Jim,<br />Would it be possible to pass values from a sub-page to the calling page?<br /><br />I have a sub-page and a standard page. When I click on a button on the standard page, I want a fields value in the parent page to be set to a new value. Any help or pointers on this would be greatly appreciated!<br /><br />Thank you!Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-33226979368555891022014-05-06T20:27:59.797-07:002014-05-06T20:27:59.797-07:00@Jim,
Thank you :) I had posted the question on th...@Jim,<br />Thank you :) I had posted the question on the OTN forum :) will wait for a response :)Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-65550563439363387992014-05-06T19:46:30.204-07:002014-05-06T19:46:30.204-07:00@Mani, your index question is a good one to post o...@Mani, your index question is a good one to post on the <a href="https://community.oracle.com/community/developer/english/peoplesoft_enterprise/peoplesoft_general_discussion" rel="nofollow">PeopleSoft General Discussion</a> OTN forum.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-1965741031068232982014-05-06T06:37:47.136-07:002014-05-06T06:37:47.136-07:00Thanks a lot, Jim.. Actually, my app engine cycles...Thanks a lot, Jim.. Actually, my app engine cycles through multiple CreateSQL fetch statements and based on validations, required the PL/SQL to run.<br /><br />I've put the index creation part as a separate SQL object and processed it. <br /><br />Is there anyway I can execute a 'Create Index' statement without using SQLExec? and without placing the DML statement in a SQL action?<br /><br />Your help is much appreciated. Thank you!Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-16108909051480713402014-05-05T10:12:56.962-07:002014-05-05T10:12:56.962-07:00@Mani, I have only done this in App Engines using ...@Mani, I have only done this in App Engines using <a href="http://docs.oracle.com/cd/E38689_01/pt853pbr0/eng/pt/tape/langref_UsingApplicationEngineMeta-SQL-0771d9.html#Execute-0771b6" rel="nofollow">%Execute</a>. A quick Google search for <a href="https://www.google.com/search?q=%22%25Execute%22+SQL+PeopleSoft&oq=%22%25Execute%22+SQL+PeopleSoft&aqs=chrome..69i57j0l2.7385j0j7&sourceid=chrome&es_sm=106&ie=UTF-8" rel="nofollow">%Execute SQL PeopleSoft</a> turns up several examples.<br /><br />From regular PeopleCode I have executed PL/SQL by placing the PL/SQL in a PL/SQL function and then selecting that function as a column.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-43055366636939044012014-05-05T09:19:23.965-07:002014-05-05T09:19:23.965-07:00Thanks for the response, Jim.. I had the same idea...Thanks for the response, Jim.. I had the same idea too. And if I leave out any of the metadata tables that would impact the PS Query..<br /><br />One more question - I am trying to execute a PL/SQL statement from PeopleCode. I have the following code in a SQL object:<br /><br />DECLARE i INTEGER; BEGIN <br /> SELECT COUNT(*) INTO i <br /> FROM DBA_INDEXES <br /> WHERE index_name = %P(:1); IF i = 0 THEN EXECUTE IMMEDIATE 'CREATE UNIQUE INDEX %P(:2) ON %P(:3) (%P(:4)) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 NOPARALLEL NOLOGGING'; END IF; END;<br /><br />:1 and the other 'colon' are bind variables for which I am trying to pass values from PeopleCode. But this doesn't work.. Any idea where I am going wrong? Your help would be much appreciated :)Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-44804242674005684292014-05-05T07:26:14.379-07:002014-05-05T07:26:14.379-07:00@Mani, query information is stored in meta data, s...@Mani, query information is stored in meta data, so it is possible, but very risky.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-22290205307201192742014-05-03T07:36:18.308-07:002014-05-03T07:36:18.308-07:00Jim,
Off-topic : is there anyway a table from a pa...Jim,<br />Off-topic : is there anyway a table from a particular PS Query be replaced by another table?<br /><br />I have two PS Queries to be built - both use the same tables except for one - is there anyway I could build just one PS Query and replace one table with another?Mani Shttps://www.blogger.com/profile/18112893067493995647noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-8830600226227458742014-04-14T08:43:17.377-07:002014-04-14T08:43:17.377-07:00@Kevin, Windows Gadget.@Kevin, <a href="http://stackoverflow.com/questions/902818/how-to-get-started-with-windows-7-gadgets" rel="nofollow">Windows Gadget</a>.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-34014350752028446382014-04-14T07:05:27.388-07:002014-04-14T07:05:27.388-07:00Jim,
What did you call that application that cons...Jim,<br /><br />What did you call that application that consumed a PeopleSoft restful service? I thought you called it a "microsoft widget", but I could not find anything close to what I saw during you presentation when I search Google.<br /><br />Thanks!Kevin Weaverhttps://www.blogger.com/profile/09237087594753403371noreply@blogger.com