tag:blogger.com,1999:blog-34020393.comments2024-03-15T08:31:05.506-07:00Jim's PeopleSoft JournalJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger4824125tag:blogger.com,1999:blog-34020393.post-21973995011095085052024-03-15T08:31:05.506-07:002024-03-15T08:31:05.506-07:00@Top10+, that is what this post's iScript does...@Top10+, that is what this post's iScript does. You would generate a URL to the iScript, and the iScript would return the binary data.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-90165470101209421832024-02-13T23:04:00.772-08:002024-02-13T23:04:00.772-08:00@Jim "ViewAttachment function is the only met...@Jim "ViewAttachment function is the only method provided by the Attachment API that allows a user to view the contents of an attachment".<br /><br />Hi Jim, how can I get the http URL that the viewattachment function is creating because I want to show a PDF file into a PeopleSoft page using html area and html for that I am using Iframe and src but the problem is how can I get http URL of an attachment.<br /><br />Thank you.Top10+https://www.blogger.com/profile/15436421776211068505noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-12242904984906082562024-02-13T22:42:35.898-08:002024-02-13T22:42:35.898-08:00@Jim Hi Jim Is there are any possible way to get t...@Jim Hi Jim Is there are any possible way to get the http URL of a stored file (database or SFTP), like when we hit view attachment function by giving file location and file name it generates a http URL and open it into new window. How can I achieve this because I want to open a PDF file into a page using HTML Area and HTML Iframe that's why I need src of http type for passing in IFrame .<br /><br />or is there any other way to do this "I want to open a PDF file into a page using HTMLArea and HTML Iframe"<br /><br />Thank you.Top10+https://www.blogger.com/profile/15436421776211068505noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-25448936779228793882024-01-25T20:04:20.539-08:002024-01-25T20:04:20.539-08:00@Robert, that is a really good point. The Java alt...@Robert, that is a really good point. The Java alternatives are usually slower than the native JSON PeopleCode objects, but perhaps the toString methods are faster? All said the performance differences may wash out. What about using the Documents module with Document-based messages? Perhaps it can render the JSON faster?Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-52285104512288958012024-01-22T04:52:45.649-08:002024-01-22T04:52:45.649-08:00I ran into a similar issue with the PeopleCode JSo...I ran into a similar issue with the PeopleCode JSonBuilder class. My file wasn't large enough to cause issues at build time, but calling the ToString method takes about 45-50 seconds on a 5MB file. Looking for ways to improve this method, because I need to return the serialized JSon in my Rest API call.Robert Chasteenhttps://www.blogger.com/profile/04847725361782987944noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-46900922836595706072024-01-19T13:27:04.195-08:002024-01-19T13:27:04.195-08:00Thanks @Gary! We should give the Java reflection a...Thanks @Gary! We should give the Java reflection angle some thought and see if we can develop some sort of wrapper that makes it less painful.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-6857655414801462532024-01-19T13:26:02.141-08:002024-01-19T13:26:02.141-08:00@Jessica, there may be a couple of reasons for thi...@Jessica, there may be a couple of reasons for this. First, Event Mapping requires a content reference. Not all components have content references. Some are accessed through other components, and therefore don't require a CREF. To find out, go to Enterprise Components > Find Object Navigation. Put in the component name, and see if a CREF appears. If one does, make sure the menu name matches as CREFs are Menu/Component combinations. Another challenge with 8.59/8.60 is the Elastic/OpenSearch requirement. A workaround for this is to go to Page and Field Configurator, create a configuration for your component that does as little as possible, and then use the Mapping button to create Event Mapping. Next, use the link within Page and Field Configurator to view the Event Mapping. This will allow you to get to the Event Mapping configuration for that page.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-70997446627895251472024-01-18T12:46:06.302-08:002024-01-18T12:46:06.302-08:00Great job. If they would just simplify the reflect...Great job. If they would just simplify the reflection thing you'd have easy access to a near infinite library of functionality ;-)<br /><br />e.g., you just say <br />javaObject.callmethodwithreflection('method name', 'parameter names', parameter values) or something <br /><br />and the new javaobject they create just does the reflection that you or I would do by hand.<br /><br />This seems like a killer app right? Instantly you can use the full excel writer libraries, etc.Gary Fhttps://www.blogger.com/profile/17908206934819308524noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-33479463400340682682024-01-18T12:12:05.716-08:002024-01-18T12:12:05.716-08:00Hi Jim,
I am trying to create EM for a Fluid comp...Hi Jim,<br /><br />I am trying to create EM for a Fluid component: SCC_ADDR_DTLS_FL_GBL, but I can not find it on Configure Event Mapping (Add Configuration). We are on PTOOLS 8.60. The target is fluid. We plan to put EM after page activate of SCC_ADDRESS_DTL_FL page.<br /><br />Could you please shed some light on it?<br /><br />Thank you!<br /><br />Jessica Jessicahttps://www.blogger.com/profile/08104339793141322463noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-86947171038344971842023-12-12T11:17:44.628-08:002023-12-12T11:17:44.628-08:00@Myron,
It appears to be failing on the eval meth...@Myron,<br /><br />It appears to be failing on the eval method, which is overloaded. Strange that the process scheduler would be fine, but app server wouldn't. They should be the same Java version, etc. I hate to think that it would require reflection, but it might. Usually PeopleSoft can identify methods that use strings. Another idea is to try this:<br /><br />Local JavaObject &jScript = CreateJavaObject("java.lang.String", &script);<br /><br />&engine.eval(&jScript);Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-77469982306353485852023-12-12T11:11:28.166-08:002023-12-12T11:11:28.166-08:00If you just want to display the image, is it possi...If you just want to display the image, is it possible to craft a URL to the system that owns the image? If so, that would be the easiest. If you need to proxy the image into PeopleSoft, then all of the options you mentioned would work as well. I would stay away from MTOM for this. I don't think it is necessary.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-79037483326413167202023-12-12T11:09:54.477-08:002023-12-12T11:09:54.477-08:00Yes, you can send and receive large files. Integra...Yes, you can send and receive large files. Integration Broker may pose a challenge as it usually loads the entire payload document in memory (no stream processing).Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-55394216669323170542023-12-07T21:16:38.050-08:002023-12-07T21:16:38.050-08:00This is an old post, but also a very useful one. ...This is an old post, but also a very useful one. This is the first time I've touched JavaScript, so I really have no idea what I'm doing. But I used it to write some code in an app engine to load data into a file. It works perfectly (as expected). <br><br />However, if I use the same code online with a button, it fails. The error is: <br><br />Calling Java javax.script.ScriptEngine.eval: no overload matches. (2,743) S3_IRCC_VERIFY.GBL.S3_IRCC_WRK.SAD_PB_UPLOAD.FieldChange PCPC:635 Statement:5<br><br /><br />While calling the given Java method, no overload was found with a parameter signature that matches the supplied parameter types.<br><br /><br />Any thoughts on where to start?Myron Wintonykhttps://www.blogger.com/profile/02924818806305743893noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-87245568309129184542023-12-05T21:26:40.757-08:002023-12-05T21:26:40.757-08:00Hi Jim,
Off-topic - is it possible to upload to/do...Hi Jim,<br />Off-topic - is it possible to upload to/download from a third party system, a large file(around 30 MB) using REST services? Or are there best practices for integrating a large file from third party systems using native Integration Broker in PeopleSoft?<br /><br />Any inputs would be much appreciated! Many thanks for your help!<br /><br />Santhttps://www.blogger.com/profile/08539040325021998440noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-28359164804738029922023-11-21T06:01:57.433-08:002023-11-21T06:01:57.433-08:00Hi Jim,
We have a requirement to zip the multiple ...Hi Jim,<br />We have a requirement to zip the multiple reports generated by a BIP report that gets placed on the report manager. We have restricted access to report repository and hence can't access the files. Any other way can we zip the reports before it gets published on report manager. <br /><br />Appreciate your help! Thank you!Sumahttps://www.blogger.com/profile/02506994349140946423noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-53310379768542412462023-11-17T19:17:52.798-08:002023-11-17T19:17:52.798-08:00Hi Jim,
Suppose the images lived in a database ext...Hi Jim,<br />Suppose the images lived in a database external to PS. What are good options for displaying the images in PS? Would we need to move the data to our PS database first or are there ways to display the images without storing the data locally?<br /><br />- Would it be bad practice to create a database link and use the same SQL above to get the base64 string?<br />- I believe we can make calls to a middleware that could use a direct database connection to get the base64 string and return it to PS. <br />- I have looked a little bit at MTOM for receiving data through integration broker. But from what I understand, only asynchronous operations are supported. <br /><br />I'm just not sure about the performance of any of the approaches above. Andyhttps://www.blogger.com/profile/17939193720258679116noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-49969473114662677592023-11-14T07:12:50.767-08:002023-11-14T07:12:50.767-08:00I have a approval Set for line level approval , An...I have a approval Set for line level approval , And it works Great. BUT there is a requirement on changing a line during the process...<br /><br />I have 5 Lines ,, all lines went to multiple steps ... Someone adjusts 2 lines .. So I want to restart the approval process on just those 2 lines .<br /><br /> <br />My Question is how can I Restart Just a line(s) level approval. Leave the header alone since it is not approved. But Resubmit specific Lines ,if those specific lines get changed but not all of them if there is one change.Willhttps://www.blogger.com/profile/12798153440031730922noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-20489711234546347672023-11-03T13:04:50.267-07:002023-11-03T13:04:50.267-07:00Hi Jim,
I have a requirement where i need to Auto...Hi Jim,<br /><br />I have a requirement where i need to Auto Approve the PO based on below criteria:<br /><br />1. If the PO Amount, Category & few fields are same as the Requisition field values from which the PO is created.<br />2. If the AWE approver has some xyz role<br /><br />If the criteria is satisfied, then Auto approve the PO for that particular approver.<br /><br />Any help is appreciated.<br /><br />Thank You,<br />AnshuAnshuhttps://www.blogger.com/profile/15520617777059132724noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-36740000443875385872023-10-26T18:47:44.952-07:002023-10-26T18:47:44.952-07:00@Parth, great question! A JWT is a three-part toke...@Parth, great question! A JWT is a three-part token that uses a modified base64 encoding. The final part contains a signature that we are supposed to verify. Common encryption for the signature uses passphrases (HMAC SHA 256) or certificates. In its simplest form, without signature verification, you would do something like this:<br /><br />Local Array of String &parts = Split (&jwt, ".");<br /><br />Each part would then contain the modified base64. You then decode the part and JSON Parse it using the JsonParser.<br /><br />I have this all documented in our Integration Tools courses, but don't have the algorithm published outside yet.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-5917557363658428512023-10-26T18:40:51.418-07:002023-10-26T18:40:51.418-07:00@Parth, the modern approach would be to use:
Loca...@Parth, the modern approach would be to use:<br /><br />Local JsonParser &p = CreateJsonParser();<br />Local JsonObject &j;<br /><br />&p.parse(&jsonStr);<br /><br />&j = &p.GetJsonObject();<br /><br />This is assuming your JSON is in a string. If your JSON is in a Document-based message, then the code would be different.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-21233827261186336162023-10-17T05:57:25.720-07:002023-10-17T05:57:25.720-07:00We are on 8.58 and planning to consume JSON string...We are on 8.58 and planning to consume JSON string using API. Can someone please help me how to consume JSON using API. This will be invoked through Single -Signon PeopleCode.Parthhttps://www.blogger.com/profile/06816391034598026031noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-47851352154112375082023-10-14T07:46:52.609-07:002023-10-14T07:46:52.609-07:00Hi Jim,
We have a requirement where PeopleSoft ha...Hi Jim,<br /><br />We have a requirement where PeopleSoft has to parse JWT token in Sign-on PeopleCode.<br />Kindly shed some light on this matter. How to achieve it through Peoplecode.Parthhttps://www.blogger.com/profile/06816391034598026031noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-22925844076735718852023-10-05T10:56:48.540-07:002023-10-05T10:56:48.540-07:00One idea is to hook into the PeopleSoft setupTimeo...One idea is to hook into the PeopleSoft setupTimeout2 JavaScript function by replacing it with my own.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-25609124592107238162023-09-29T14:49:07.233-07:002023-09-29T14:49:07.233-07:00Hi,
Tad off topic, but related.
I want to display...Hi,<br /><br />Tad off topic, but related.<br />I want to display a count down timer on the banner to show when the user's session will timeout.<br /><br />I am using PS_TOKENEXPIRE to mark when the countdown starts/resets which works fine - however when the default warning session timeout popup comes up - a new PS_TOKENEXPIRE is being issued, so my counter thinks it should restart rather than resuming...<br /><br />Any suggestions on how I can overcome this issue or different ways to implement the countdown timer?<br /><br />Thank youkane81https://www.blogger.com/profile/14471355777720928832noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-59015850503791668112023-09-19T15:28:41.004-07:002023-09-19T15:28:41.004-07:00Disable the app engine server on the process sched...Disable the app engine server on the process scheduler via psadmin. More commentary is here:<br /><br />https://psadmin.io/2015/11/30/disabling-the-app-engine-server/Banksyhttps://www.blogger.com/profile/05839931395300070482noreply@blogger.com