Thanks a lot. That works. Can I ask one more question? Which one disable Reset Current View option? Thank you again. It’s controlled by GUI Settings - Table Column Reorganisation (GUI_COLREORG). Note that other Options (Optimize column width, Auto Size) will also disabled along with this. /Damith
GUI Settings - Page layout configurations (EE_PAGELAYOUT_CONFIG) is the permission which controls the column chooser. Keep in mind that this permission should be excluded from all permission sets which user is granted in order to have the effect.As I remember, this is enabled by default in FND_ENDUSER permission set. Therefore be cautious if user is granted FND_ENDUSER since it will re-enable after UPD installation or perhaps a patch installation which affect FNDBAS component. Hope it helps!Damith
This might also help: https://docs.ifs.com/techdocs/Foundation1/050_development/040_core_server/027_base_server_dev/030_mechanisms/ Nice! Seems it’s public and therefore really useful
Hi @dsj Thanks for providing this, It doesn’t make sense that the difference between APPROVAL_ROUTE_REJECTED and STEP_REJECTED_NODOC Could you please elaborate? Thanks, Narsi. Hi @Narsi, APPROVAL_ROUTE_REJECTED is dedicated for the Documents and STEP_REJECTED_NODOC is for other type of objects which are setup with approval process.Approval for object is system defined for some objects like Engineering Part Revision, Project Item where you have a dedicated tab to define Approval steps (Image 1) or it can be configure for any object using Object Connections (Image 2) Image 1: Approval in Eng Part RevisionImage 2: Approval Process setup as Object Connection Hope it helps to clarify the difference between two events /Damith
Hi, Could you please anyone eloborate reagrding “ApprovalRouting” on Application defined Events? I know STEP_READY_FOR_APPROVAL fires for next approver if anyone current step aprroved, it’s not firing first step approver STEP_REJECTED_NODOC fires if anyone rejected a step I need to know about these STEP_APPROVED, APPROVAL_ROUTE_COMPLETE and APPROVAL_ROUTE_REJECTED events Thanks, Narsi. Check below link (or your local IFS technical documentation) for technical details regarding approval routing events. https://evrydemo10a.atifs.com:48080/ifsdoc/f1doc/foundation1/020_installation/400_installation_options/130_add-on_cmp/docman/misc.htm Cheers! Damith Seems I have mistakenly added a URL of an internal environment in above reply. Please use below path in your local IFS technical documentation to find the relevant resource.
Hi @dsj Thanks for your replay Your link is redirecting to this page. I do not have login deatails for this. To see your link, do I need login details for it? If so how can I get? Thnaks, Narsi. Hi @Narsi , If you have a IFS portal account, then you can login with that credentialsUsername: corpnet\<IFS Portal account id> Otherwise, you can check the same in your local IFS technical documentation in the given path Cheers!Damith
Hi, Could you please anyone eloborate reagrding “ApprovalRouting” on Application defined Events? I know STEP_READY_FOR_APPROVAL fires for next approver if anyone current step aprroved, it’s not firing first step approver STEP_REJECTED_NODOC fires if anyone rejected a step I need to know about these STEP_APPROVED, APPROVAL_ROUTE_COMPLETE and APPROVAL_ROUTE_REJECTED events Thanks, Narsi. Check below link (or your local IFS technical documentation) for technical details regarding approval routing events. https://evrydemo10a.atifs.com:48080/ifsdoc/f1doc/foundation1/020_installation/400_installation_options/130_add-on_cmp/docman/misc.htm Cheers!Damith
Hi @Narsi , If you are new to IFS, IFS documentation is the best place to start with.For your question, there’s decent explanation about IFS system defined functions and their usage is defined here.https://wit.ifsworld.com/f1docs/apps10/Foundation1/050_development/040_core_server/027_base_server_dev/030_mechanisms/ To understand how everything works underneath, debug console is the best tool to start with.Open the debug console aside and then do some transaction in IFS. You can see which server calls made with parameters in the console. By this way it’s easy to understand the IFS call sequence. Cheers!Damith
Outlook doesn’t support base64 encoded images. https://stackoverflow.com/questions/16242489/send-a-base64-image-in-html-email Hi @durette , This SO question seems to be seven years ago and maybe it was a limitation back then base64 encoded images in html formatted mail body is supported by most of the mail clients and one issue could be that the image is blocked due to un-trusted sender. https://support.microsoft.com/en-us/help/4538673/how-to-send-an-email-with-an-embedded-image Cheers! Damith
Hi @jkmy_semco , Thanks! I still didn’t get a chance to give a try to connect WSO2 with IFS REST api but it shouldn’t be difficult since WSO2 has default support for address endpoints. If I come with a good example with IFS, I’ll make sure to write about it /Damith
Hi @jkmy_semco , I have done several prototypes with IFS with WSO2. I also made a WSO2 connector for IFS which integrates IFS with WSO2 using IFS Java access provider SDK. It’s published in github and you can find it in https://github.com/knakit/wso2-esb-connector-ifs This connector consist of 3 operations which covers all DML operations in IFS using standard logic. Execute SQL statement and retrieve records from IFS Execute PL/SQL base method for NEW, MODIFY, REMOVE Execute PL/SQL block and retrieves the values assigned for bind variables I made some interesting PoC with this connector including a facebook chatbot which can create IFS Service Requests. Below blog post contains how to build a simple REST api for IFS using the WSO2 connector https://dsj23.me/2019/08/09/build-a-restful-api-for-ifs-with-wso2-and-knak-it-connector/ Attached herewith is a presentation I made about this connector, how it works and an example (chat bot), hope you’ll find it interesting. Pls
Thanks Garak and Damith, the only issue I see now is the length of the base64 coded string. If you are in Apps10, Command_Sys.mail supports the mail text as CLOB so size of the base64 converted image should not be a problem.
Most convenient way is to embed the image as base64 in the email body. I have seen some customers using CID tag but some mail clients will consider that as attachments so may be not the optimal solution. Attached herewith is a sample code with base64 embedded image in the mail body. base64 string used in this example generated with https://www.base64-image.de. Problem with embedding base64 encoded image is the size of the string if you are attaching large images. I have seen a customer who developed a custom LU to store base64 strings of images and other html tags so they can create email body dynamically. Cheers! Damith
Yes, this makes the code run, with the background job always committing before the event action. It also halt the UI. For the scenarios where we what to do something before saving, this might work. I have been running with queue=4 (touch app push). It execute nearly instant. When the background job has to run after the event action (like the example above), I think another approach is needed. As always @dsj, excellent. Thanks @Hans Andersen, Unfortunately I think this is the far we can go with events since event action logic triggers during the main transaction and background job created via autonomous transaction won’t ‘see’ the data change. One way to overcome this is to look for a mutually exclusive transaction created from your data change. (Eg: adding a history record, creation of a new revision) and add event to that, so that you can ensure the data is already changed. In Estimate window I see Log and History tabs. May be you can play around a little to find
Just tried this. Not working. It is not possible to have the commit anywhere inside the event action. Sorry for the noob mistake. You should put the background job creation logic inside an inner function with AUTONOMOUS_TRANSACTION Version #3 of the example. Hope it works this time. -- Created on 6/29/2020 by DSJ declare -- Local variables here id_ NUMBER; run_ BOOLEAN := TRUE; status_ VARCHAR2(32000); --inner funtion with pragma to create background job function create_bg RETURN varchar2 IS PRAGMA AUTONOMOUS_TRANSACTION; idx_ NUMBER; begin Transaction_SYS.Deferred_Call(idx_, <METHOD>, 'PARAMETER', <PARAMETER ATTR>, 'Background job description'); COMMIT; return idx_; end create_bg;begin id_ := create_bg(); WHILE run_ LOOP status_ := deferred_job_api.get_state_db(id_); DBMS_OUTPUT.put_line(id_ || '-' |
Nice idea. Can you do a commit in an event though? Not sure if i remember that correctly but wasn’t there some restriction? If this is implemented you should probably run the background job in a dedicated queue to make sure it is processed as fast as possible. It will slow down a simple modify either way. I will try this next time a requirement like this comes up. Thanks Damith /Johannes. Thanks for the comment @Novacura_jst I haven’t tried but also agree it’s not possible to commit inside the event action. As an alternate, you can put the call to post background job in a dynamic statement. I’ve modified the code stub with the change. declare id_ NUMBER; run_ BOOLEAN :=TRUE; status_ VARCHAR2(32000); stmt_ VARCHAR2(2000);begin stmt_ :='BEGIN Transaction_SYS.Deferred_Call(:id_,:method_, :type_ ,:parameters_, :description_); commit; END;'; EXECUTE IMMEDIATE stmt_ USING OUT id_, IN <M
@eqbstal The problem with background jobs is that you cannot control when they will be executed. And there is no callback. With a little tweek, you can create a callback for background job and halt the transaction until background job is finished. Given below is what I came with. Try and see if it works for you declare id_ NUMBER; run_ BOOLEAN :=TRUE; status_ VARCHAR2(32000);begin Transaction_SYS.Deferred_Call(id_,<OTHER PARAMS>); COMMIT; WHILE run_ LOOP status_ := deferred_job_api.get_state_db(id_); IF (status_ = 'Created' OR status_ = 'Posted' OR status_ = 'Executing') THEN DBMS_LOCK.sleep(1); -- add sleep not to overload system END IF; IF (status_ = 'Ready') THEN run_ := FALSE; END IF; IF (status_ = 'Error' OR status_ = 'Incomplete' OR status_ = 'Warning') THEN ERROR_SYS.Appl_General('LuName', 'BGERROR: something wrong with the job.')
Hi @gerwal If user can add note but can’t see, may be it’s due to lacking of permission. Check whether your permission set have FND_NOTE_BOOK granted. May be it will solve the issue. /Damith
Found that there’s a more comprehensive answer on this topic already available. Pls check https://community.ifs.com/technology-all-about-the-nuts-and-bolts-that-make-it-work-50/how-to-enable-sticky-notes-for-users-112
Hi @gerwal , Notes are controlled from Presentation Object EE_NOTES_CONFIG BR, Damith
I’m not sure what’s the best way to handle this during the upgrade. We had the similar issue in HR module during an upgrade and had to spend so much time to troubleshoot and correct events Apps10. One option to check the IFS version is by the component version. Eg: IF module_api.get_version(‘SHPROD’) = ‘13.0.0’ --Apps10 WORK_INSTRUCT_PRINT_COUNT IF module_api.get_version(‘SHPROD’) = ‘12.1.0’ --Apps9 WORK_INSTRUC_PRINTED If you come with a nice idea where to use this, please share :)
Hi @Hans Andersen Seems in Apps 10, work_instruc_printed field is replaced by WORK_INSTRUCT_PRINT_COUNT. Have you tried with that? /Damith
Hi Damith, I’m trying to test calling a custom API with a SOAP message. As I’m therefore not using a BizAPi or Handler, how would I go about testing this? This is a new area to me so any advice would be brilliant!! Hi @RyanIbbitson , Can you please explain what you meant by custom API? Is it a PL SQL method which you intended to call via a routing address (valid for App10) or any other business flow? /Damith
Hi @krestensb , Try to define additional header parameters in KEY=VALUE format. Eg: Content-Type=application/json
Thanks for taking some of the magic out of this process! I was not aware that the .xls file is just a XLST script to format XML into somthing else. w3schools.com has a tutorial, and I’ll go home and read it and see where that brings me. It don’t seem to complicated. https://www.w3schools.com/xml/xsl_intro.asp I don’t think there will a need for any java code. Yeah, it’s not hard at all to play with xslt transformer. For the record, java transformer ‘really’ don’t need the developer studio also. I’ll try to find an example and post it soon
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
