Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Hi,When I click Crtstal Runtime Files link on Add-ons, then I’m getting this{"error":{"code":"SE_UNAUTHORIZED","message":"Insufficient privileges."}}It seems I need to add permissions to my profile, what permissions do I have to add to install crystal runtime file? thanks,Narsi.

Hi,I’m new to IFS, I do not know where we can add a new catagory in Catogories of Quick Report.  Please let me know if anyone knows  Thanks,Narsi.

Hello,I want to learn how to “Extract Data” processes works.For example when i try peg to part lines from “Available Source Lines” to “Part Lines” at “Incoming Dispatch Advice” screen, i see two different ways for extract data on debug.The first one from i_hWndFrame.tbwDispatchAdviceAvailableSourceLines.colsSourceRef1etc (source by receipt_info i think). The second one from i_hWndParent.frmIncomingDispatchAdvice.dfnMessageId etc (source by ext_dispatch_advice i think).In this case i have no message_id and delnote_no parameters at RECEIPT_INFO_ALT view but those are requirement for parameters of the peg procedure. So need to extract that parameters from the screen, how can i do that?You can check the pictures. I need to just a way for pegging from RECEIPT_INFO_ALT on SQL somehow (Normally p0_ and p1_ are null at RECEIPT_INFO_ALT view, but if i extract from screen or forms like debug i can peg easily).Best Regards.A SAMPLE BEFORE THE PEGGING-- Context: tbwDispatchAdviceAvailableSourceLin

Hello Everyone, How to capture transport task creator’s username on transport task screen ? I tried using history log report but it is not efficient. I want to capture username on the transport task screen so that I can query the data by username. Thank you for your help.

Has anyone ever changed the Max String Size parameter in Oracle to Extended?  I know the standard VARCHAR2 limitation in Oracle is 4000 bytes.  I have had a few customers ask for Custom Fields and standard fields to be larger such as the external notes on the service quotation and Long Description for PM Work Orders.  Apparently in Oracle, if you change this parameter to extended it gives you a new max size of 32767 bytes.  I was curious if anyone in the community has done this successfully?  If so, was there any special items you might want to mention?  Did this also work when adding new custom fields after changing the parameter? https://dbaclass.com/article/max_string_size-parameter-oracle-12c/

Hi,I’m working on displaying budget numbers to Department Managers in a lobby.Is there any standard way to limit who can access the budget like in Authorization Combination Rules or Authority Combinations ?Any ideas?

If user have worked in company authorizing invoices it’s not possible to remove access to this company. The connection to  invoice posting authorizer is preventing the removal of company access.The invoice posting authorizer cannot be removed once user have authorized invoices, here you can only phase use out by adding a valid until date.Is there a way around this to block access to this company for the user?In our system we have mulitple companies and as users move around between the companies this becomes an issue. 

We use permissions sets to specify whether users have none, query or full access to screens, but if for example 10 users in a permission set have full access to a screen, whats the easiest way to only allow 1 of them to update a specific field on that screen?   Thanks, Chris.

 Hello;  I want to change the password warning message. Could you help?  

Customer is receiving fixed format csv files as mail attachment. We would like to read file content automatically inside IFS. Is there some way to do this? Data can be stored to custom view or migration table etc. Used version Apps 10

We are upgrading from 7.5 to 10.  We have many IALs that are owned by ifs_info.  Is it possible to access these as datasources in the Lobby Data Source Designer?  If so, how?

Using connect pror query belowhow would you get the QTY_PRE_ASSEMBLEY multiplying as it goes down each level?ORConvert this  EQUATE_THIS coloum I have into as resule i.e *1*8*.022222 becomes 0.16 help   Select  PS.PART_NO As parent_part,  PS.COMPONENT_PART As child_part,  Level,  PS.LINE_ITEM_NO,  Sys_Connect_By_Path(PS.COMPONENT_PART, '\') As STRUCTURE_PATH,  CONNECT_BY_ISLEAF,  Case When PS.QTY_PER_ASSEMBLY < 0 Then 'BY-PRODUCT' Else 'COMPONENTS'  End As TYPE,  PS.QTY_PER_ASSEMBLY As QTY_PER_ASSEMBLY1,  Sys_Connect_By_Path(PS.QTY_PER_ASSEMBLY, '*') As EQUATE_THISFrom  PROD_STRUCTURE_HEAD PSH Inner Join  PART_REVISION PR On PR.CONTRACT = PSH.CONTRACT And PR.PART_NO = PSH.PART_NO    And PR.ENG_CHG_LEVEL = PSH.ENG_CHG_LEVEL Inner Join  PROD_STRUCT_ALTERNATE PSA On PSA.CONTRACT = PSH.CONTRACT And    PSA.PART_NO = PSH.PART_NO And PSA.ENG_CHG_LEVEL = PSH.ENG_CHG_LEVEL And    PSA.BOM_TYPE_DB = PSH.BOM_TYPE_DB And PSA.ALTERNATIVE_NO = '*' Inner Join  PROD_STRUCTURE PS On PS.CONTRACT = PSA

Does anybody know if the HTTP Certificate expiry date is held in a view/table? The reason for asking is I wanted to set up in Application Monitoring a query to advise when the certificate is coming up for expiry, e.g. 30 days notice. Recently, only by carrying out a delivery installation did we get notice that this was due to expire in 9 days.   I don’t want it to be this close again.  I have a notification in Outlook Calendar but just wondered. Thank you for looking.

Hello, IFS has added search capability in the column chooser, and the very handy “go to column” right mouse option.  One place where it would be nice to search is in the search dialog, Configure Search Fields.  Are there any plans to add the “search” option at the top of the available and show columns? 

Customer wants to move to a hosted environment (not cloud). It is possible to host IFS on Nebula(vmware environment). Azure stack does not support IPV6, whereas customer wants an IPV6 supported environment

Hi,In Quick Report, I have to get data FromDate to ToDate using a DateTime columnI used this:WHERE o.REAL_FINISHED BETWEEN TO_DATE('&From_dd/mm/yyyy','dd/mm/yyyy') AND TO_DATE('&To_dd/mm/yyyy','dd/mm/yyyy') I’m getting when we go to view report  It works fine When I export data I’m getting this error:  Excel Plugin Error: Undefined bind variable 'from_dd' in Excel fileAny idea how to sort this issue?

Hi,I am new in IFS system and I have huge implementations that involves many windows. Is there an option to export/import to migrate between many environments?Somebody that works with me told me that I need to replicate manually all my changes in each environment. It’s hard to believe, so anybody can help me?

HiI have created 3 new custom numeric fields, 2 will be manual entries and the 3rd I would like to add the numbers from the first 2 fields. Is this possible in Apps 8?If so does this need to be done via a custom event? Would be much appreciated if it is possible for some to send a screen shot of how. Below is a screen shot of the fields I am referring to, and the one circled is the field I want the calculation to appear. 

Hello all,we want to see the coordinator (authorize_code) of the external customer order in an inter-company process in the shipment-header of the supply site.I created the following three-step-logic which is working ok. But does anyone of you have a smarter way of finding the right coordinator? It is a bid of a mess I have to admit: CF$_C_COORD_PRCPL in supply_order_analysis:select authorize_code from customer_order where order_no in (select order_ref1 from supply_order_analysis where tree_id = :tree_id and node_id = '0') CF$_C_COORD_PRCPL_SPM_LINE in shipment_line_cfv:select CF$_C_COORD_PRCPL from supply_order_analysis_cfv where order_ref1 = :source_ref1 and order_ref2 = :SOURCE_REF2 and order_ref3 = :SOURCE_REF3 Cf$_C_Coord_prcpl_shp in shipment_cfvselect CF$_C_COORD_PRCPL_SPM_LINE from shipment_line_cfv where shipment_id = :shipment_id and rownum<=1 Is there even an API that I did not find so far?Any ideas to fetch the value in a smarter way? Thank you!BestMattis

Hi All,Is there a possibility in IFS to read the attachment from the mail and place the file in the corresponding path by using Mail Reader or by any other mean ?

how can i Priority  waiting ( background job ) execution use Application basics setup

How can i set Permission with IFS screen control for user  (read only  or full control)For example    ------------------Read only Can searchbutCan't saveCan't newuse Permission set ?    How can i do it? 

Is there someone that knowns any problem with sql server and updating of the IFS cube. We use SQL server 2017 and IFS 10? We find that the database is being updated by the scheduled jobs but the cubes aren’nt.

I know the topic of IFS permissions is never as black and white as we would hope, and each business may have a different view on how it should be implemented.We are now required to comply with SOX due to US ownership, so Segregation of Duties (SOD) plays a big part in regular audits! In addition, the existing permission sets developed previously have become unmanageable for the team and is difficult to report on access to management or auditors. This has effectively triggered a re-build of our permission sets across our business. I have started to build new functional permission sets to group specific access together which is common across the business. For example, MANAGE_PUR_ORDER, MANAGE_WORK_ORDER, AUTHORIZE_PO, VIEW_SUPPLIER, APPROVE_INVOICE and MANAGE_CASE which within has all the relevant screen/database access for those areas. We know around Finance, HR and Payroll modules we may need to be more granular with the functional PS controls. These functional permission sets are then

Good morning,I’ll try to explain my problem best as I can  . I need to import my misc. parts data to a spectific project. My problem here is that I need for exemple my activity code and the person that seize has juste the activity ID. My question is: Can I put any kind of logic that allows me to fill out another cell based on the information seized?Exemple: When I seized my project and my activity ID, the cell acitivity code will be fill out automaticly.Let me know if you need more information Thanks,