A fully qualified URL will do the needful, so yes - IFS supports it.We call it “External Search” and here comes the specificatoin: https://docs.ifs.com/techdocs/foundation1/050_development/022_user_interface/045_ee_dev/080_external_search/default.htm Easy way to get it done: Format the URL as below.HTTPS:\\<SYSTEM_URL>\/client/runtime/Ifs.Fnd.Explorer.application?url=<FORM_URL>?EXTERNAL_SEARCH=<FIELD_ID>=<VALUE>E.g. : https://xxxxxxxx:xxxxx/client/runtime/Ifs.Fnd.Explorer.application?url=ifsapf:tbwOrderQuotationLines?EXTERNAL_SEARCH=INQUIRY_NO=xxxxxx(If you generate this URL programmatically, you can retrieve the SYSTEM URL via the PLSQLAP_ENVIRONMENT_TAB)
You can get this done by querying an Oracle Package Function, where the Function returns a pipelined table functionality. The Oracle Pipelined table functions are table functions that return or “pipe” rows back to the calling query, and the query can be simply look like below.SELECT * FROM <schema>.<API>.<function>(<signature>).E.g.: SELECT * FROM IFSAPP.Custom_API.Get_Emp_Grades(‘&EMP’)Within the function, write your own query to generate the result set and return the table rows as a pipelined table. The SQL output then show the returned rows only.have a read: Pipelined Table Functions (oracle.com) Another idea:If it’s possible, this can be done by using Custom RMB menus, but I’m not sure if it’s convenient. Two menu items on any relevant IFS screen, which perhaps called “Generate EMP GRADE data” and “Run EMP_GRADE QR”, and they do exact as they are named. “Generate EMP GRADE data” will run your logic against the selected record and generate the required da
Hello @Pushpalatha Manually drag-drop custom fields isn’t possible, as the custom fields are known to be an extension of the logical unit, which is the client representation of the corresponding server custom attribute. If the custom field (except type LOCAL) is well programmed, configured and allowed, the user should see it via Properties>Layout(for forms) or Column Chooser (for tables). Most of the framework forms and tables do not allow custom fields.When a custom field is published, the related presentation object is granted to all roles which are granted to any of the views attached to the logical unit which is extended. So, a user who has no access (not granted) to any of those roles will not see this field.Do this and try again.Open the Custom Field configuration window (IFS screen > RMB > Custom Objects > Fields > Overview and make sure that the field is published. Click on the Presentation Object (it’s there in the CF overview header) RMB on Presentation Object
@mohammad.bohlouli67 Hi, you cannot do this in standard 7.5. Easiest way is to do some configuration by introducing a custom event\action, which prevents users from registering (depend on your criteria).
Well, I’m not sure if some of your tokenizing and parameterizing logics are correct. Check again with the usage of the parameter selected_vouchers_.However, once an error is raised, the transaction will rollback to it’s original state right before the failed statement \ logic, hence it’ll not reach to your next LOC. Therefore, I’d use a subprogram with EXCEPTION handling, i.e. something like the below.Begin PROCEDURE exe_(<params>) … <raise the error> ... EXCPTION WHEN OTHERN THEN <do something like logging the error, etc> END;BEGIN FOR i_ in <loop> LOOP exe_(<params>); END LOOP;END;
Can you elaborate? What is the report type? Is it an IFS RD report, crystal, etc.? By Report Key, did you mean the Result Key?Nevertheless, this can be done by creating your desired SQL and using Application Server Tasks. Mind that you need to firmly decide if the data you fetch are from the XML data (XML_REPORT_DATA_TAB) or the tabular data (_RPT) which is more readable and easy format for scripting.
Like @Novacura_jst mentioned, customizing the field PART_NO is an unwanted risk.Instead, you can think of alternatives, like;trying to find a way to incorporate \ transform the PART_NO into a 25 characters long, maybe by a proper change management and master data management process trying to make use of part-to-characteristic (e.g. technical class maybe) combination to identify a unique material trying to introduce another field for the next 15 characters (via customization or configuration) but that involves a considerable amount of customizations \ configurations to achieve the data integrityHope this helps
Make sure that the multiple web instances were created according to the guidelines.Refer Configure Multiple Crystal Web Service Instances.Notes:Make sure to deploy the websites inside IIS as Applications Make sure that the instances are runningHowever, the report formatter will consider only the web instances mentioned in the system parameter called Virtual Directory names given to the Crystal Web Service instances in IIS.Refer Configuring the System ParameterNotes:The instance names should be equivalent to the virtual directory names (folder names) of the additional instancesHope this helps.
Can you please elaborate a bit?What is that API you meant which returns all the custom forms? I’m not sure if there’s business logic function\procedure which returns all the forms, but you can use the following SQL to get the intended output.SELECT PO_ID FROM pres_object_tab t WHERE (PRES_OBJECT_TYPE = 'WIN' OR PO_ID LIKE 'cpg%') AND PO_ID NOT LIKE 'dlg%' ORDER BY PO_ID
@SHAUN_KERSLAKE I’ve provided an answer to a similar case in the following community post. Have a read.Incoming Email from phone system to create a Case in IFS | IFS CommunityIn your case, it’s not possible to trigger an IFS integration by an email received to an external email server like that if there’s no integration method in between. If your email server can create an external file to an accessible (i.e. a location which is accessible for the IFSMWS) this implementation will be quite simple and straight forward. you can then use IFS Connect (IFS’s default integration broker).
Hello @HSELEWU Honestly I’ve not done it before, and that’s why I asked you to “try”, at your risk. Maybe you can follow the below steps on your DEV (or similar none-critical installation). Please keep necessary backups in case if you have to reset.Extract the ifsweb-main.war Add the required images Archive it again to ifsweb-main.war Copy it to \wls_domain\<instance>\servers\MainServer1\stage\ifsweb-main’s latest created folder Log into the IFS Middleware Server Admin Console > Deployments, then try to stop and redeploy ifsweb-main web archive If it doesn’t help, restart the MWS (worst case, a reconfiguration).Hope this helps,
HelloYou can either use a custom Image URL where the URL is accessible via the server machine. If not, try incorporating your company images into the ifsweb-main.war as the local images supported by lobbies are packed into it.Build_home location: \server\apps\main\ifsweb-main.war\images\lobby\element\On instance: \wls_domain\DEV10\servers\MainServer1\stage
Oh, shoot me @DAALLK Damith..!! I did try impersonation and it ended up with the error You do not have privileges to use the "Fnd_Session_API.Impersonate_Fnd_User operation for "Foundation Session Public View. Like a dumb, I concluded the testing and looked out for alternatives.What I actually did was add the impersonation into the PLSQL Developer’s IFSCONNECT session test window for testing. Shame on me..!! Long story short - impersonation works like a charm - you are correct..!There’s no need for my other “fancy and silly” solutions 😁
Hello @bpamlin Use it as follows - works like a charm.Chr(36) || round(SUM(&AO.Customer_Order_Line_API.Get_Base_Sale_Price_Total(ORDER_NO, LINE_NO, REL_NO, LINE_ITEM_NO)),0)
Hello @puzinoj This is a bug in IFS Core released with UPD20. IFS has already fixed this in UPD21.Workarounds:Preview the report from the PC’s default PDF previewer, and then print Execute IFS EE client via a network share (run the exe directly from the WMS instance)If the demand rises, request a solution via your IFS support channel to see the possibility of getting a hotfix or a single patch as preferred.Hope this helps.
Thanks @dsj for the response. That helped me as well.However, I have a similar situation where you can help. I agreed to a concept of implementing an integration between IFS and our support ticket system to automate the user management (creation, grant and revoke permissions, company, site, user group manipulation, etc.). But, the user IFSCONNECT doesn’t have enough privileges to manage the users.In this case, the solution is to grant IFSCONNECT with ADMINISTRATOR or individual roles (ugly, dirty and also is not recommended). If not, another approach is to make the inbound files to update an internal custom table, and execute a scheduled task (by appowner) to read values and execute separately (won’t be the perfect solution).Do you have any suggestion for me?Thank you.
Looks like we have the same issue again with UPD20.This time, none of the above solutions worked, hence the case CS0174987 is created. My investigations confirm that this has something to do with incorrectly handling of the dictionary keys, as well as the mapping between the parameter dialog and the underlying SQL at the runtime.IFS is working on it. I’ll try to keep this thread up-to-date if possible. If you are in APPS10 UPD20, run any SQL quick report via the Quick Report window (with parameters). Then, on the results screen (output screen), use the RMB menu Show SQL to see the underlying SQL at the runtime. You’ll notice that the input parameters are replaced with the client _hWnd object IDs according to the context.Now, on the same window, select the RMB menu Rerun and you’ll end up with the above error. Now, check the SQL again. The parameter mapping is gone. Just FYI.
Hello @Minoshini Fonseka Yes, it’s a bug in UPD20, and I’ve already created a case.The bug is with the context mapping between bind parameters of the SQL and the hWind objects (parameters from the param dialog). We are desperately awaiting for a resolution.Cheers./Manulak
HelloYou cannot prompt such messages for IFS EE users. The two possibilities are either broadcast messages or streams. Broadcast messages: doc linkStreams: doc linkExample:Fnd_Stream_API.Create_Event_Action_Streams(‘IFSAPP’, ‘ALAIN’, 'Attention everyone’, ‘Check email inbox immediately’, ‘www.company.com\notifications’);Hope this helps.
Dear @SMANUEL Unfortunately, IFS EE has a painful history with the OS scaling, and it’s acceptable too. In general, any application that supports auto-sizing and scaling screws up the screens when the Windows scaling is changed.However, I’ve seen users managed scale>100% with different screen resolutions. Please refer the following community post which expresses some experiences that I also agree.IFS Enterprise Explorer in high resolution | IFS CommunityAs there’s no proper guide (because this depends on IFS version, OS version, screen resolution, scaling, etc. and the solution varies with such a lot of parameters) it’s always mostly trial-and-error resolution.
@ronjonx The easiest way is to select the FULL SCREEN button you find on the right bottom of the IEE. That’ll show the hidden control.
@kimia Did you meant o ask if it’s possible to search again over a filtered dataset using a SavedSearch?If so, you can do this by:first, clicking the SEARCH icon to get the SEARCH dialog then, using the Saved Searches drop down, select your desired saved search (this will populate the search dialog fields with the relevant information according to the selected saved search) then, modifying the values of the search dialog as you wish
Hello @savasciftci In general, please copy the code directly in order for anybody to easily read-through and give feedback.However, I just skimmed through your screenshot, and clearly saw that you’ve not created a new Archive instance (Archive_API.New_Instance), which will surely fail the Print Job creation (Print_job_api.Print) because there’s no related Print job contents (Print_Job_Contents_API.New_Instance) created.A successful report print should first create a new Print Job object, and an archive instance, and a job content in order to execute the print. I’d suggest you to follow the below flow to get the job done.Create the print job object (with printer ID via the report attr object) and get the print job ID Create the archive instance (with report ID, archive parameters, etc by feeding report attr and the parameter attr) which returns the new archive ID (result key) Then, create the print job content (feed the job ID [step 1] and result key [step-2] via attr) Print (by provid
Like the IFS Community YouTube channel, IFS insider videos provide important information about latest IFS capabilities. It covers some technical \ developer aspects as well.IFS - YouTubeThe IFS developer Portal contains the development tools as well as certain documentations, etc.IFS Developer PortalTo my awareness, apart from that, there’s no publicly shared set of materials which directly refers to IFS development.
As I know, it’s not possible.The event registry and the corresponding actions run on top of the Oracle Server, and the evaluation and execution totally happens within the database. It has no OS control over individual client machines \ servers.Only Custom Menus can be used to run an external application over a user interaction on the application.However, this is achievable via a series of client modifications or customizations. But, I won’t recommend it as it isn’t worth it, and not reliable as well.
Already have an account? Login
No account yet? Create an account
Enter your username or 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.
