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

Hi,Does anyone know why performance of a Crystal Report sometimes is much slower when run from inside IFS Applications then executed as a preview in the Crystal Report application?I create a report and preview it with ok performance.Deploy same report in IFS Applications but then performance is very slow! 

I’m pulling a phone number from Apps8 in Crystal Reports using the following code on an SQL Expession Field(Select Value from prin1app.comm_Method WhereCompany_ID ="CUST_STMT_ACCT_REP"."COMPANY" AND Party_type = 'Company' ANDMethod_ID = 'Phone' ANDMethod_Default = 'TRUE') I get an ORA-00904 invalid identifier for the reference "CUST_STMT_ACCT_REP"."COMPANY" even though this has been selected from the list of fields in the view. The statement works perfectly from different views or if I use a value Company_ID = ‘7’

Dears IFS Heros I’m new to IFS and I’m wondering if it is possible to configure IFS out of the box to use multiple authentication options at the same time.  What I mean is that I want the users to be able to login with basic accounts and if possible link them to google accounts or facebook. So they can use either one to log in to the same account. As if I’m linking a single account with multiple authenitcaitons methods. So If I singed with facebook then I’m logging to the same account as when I signing with using google. Is such thing available in IFS IE, Aurena or B2B? Regards

Our business has a requirement to remove data from a custom tab which contains persistent data - can we use an Excel Migration job to remove specified items ?

We have a lobby that works with the default Site# of W. When we try to run it for other Sites, the first execution throws an error, but then if we run it again it works.Am I formatting the parameter correctly as where contract LIKE NVL('$SITE$','%')? 

Hi AllIm trying to create a custom event which needs to use the Time portion of a DATE field, in this case to run a check against Holiday Request records.  When I put the event code in as follows, it only seems to bring through the Date itself with the Time always being set to 00.00.00.  This is despite the Debug Console showing that the time being put into the database is something else such as 11.30.00.Has anyone had any success with the use of Date and Time in custom events?My event code currently is DECLARE   TIME_TO_         TIMESTAMP := TO_TIMESTAMP('&NEW:TIME_TO', 'YYYY-MM-DD-HH.MI.SS');BEGINerror_sys.Record_General('',TIME_TO_);END;The error shows that only the Date part is filled.  I have tried DATE instead of TIMESTAMP with the same resultCheersGareth

Hi, How to export IFS crystal order report output to excel in IFS 10? Is there any plugin available? Please guide.

Hi,Very often we see background jobs in status ERROR with the message “...object is locked by another user.“.How can I handle this in my PLSQL procedure? There is a lock_sys package and oracle has a v$lock table.The lock_sys takes lock_name_ as a parameter. I don’t know what that is.The second includes an ADDR column. I don’t know what that refers to. Can any of this be used to handle this error, by fx postpone the execution of the job if the object is locked?BR Kresten

Hi, I have the following error when I want to display the customer form in Aurena : ODP_ILLEGAL_STATE: Unable to fulfill the request due to unexpected server state. Debug trace provides “Invalid metadata for projection CustomerHandling” information. There is no custom field on this form. Anyone could help me, please ? Thanks Sébastien.

Is it possible to link to another lobby from a lobby. I tried creating a link element with the page ID of my sub lobby but that didn’t seem to work

Hello,I get the following Error when we try to get Aurena interface up and running with new permission sets and a new Base Profile.I alredy tried the FND_WEBENDUSERMAIN and that one did not do the trick. 

Hello,We are in the process of upgrade from IFS 8 to IFS 10. I noticed Customer_Info_Comm_Method_Api is no more available in IFS 10. I am looking for function get_default_phone(customer_no),before i rewrite it in IFS 10 for our internal use, i wanted to check if someone knows whether IFS added this function in some other API or any replacement for Customer_Info_Comm_Method_Api.If someone have some document where IFS disclose such db changes, that might be helpful too.ThanksUzma 

I’m adding a Yes/No custom field to a custom table to show whether or not a row is active.I’m using the default FndYesNo enumerationSo far so normal However, the field, when displayed on a custom table page is not editable.If I view it on a custom form page it is What am I missing?

Looking for feedback on an easy method to view and copy access from one user to another.  For example, when a new employee is created they need added in many different areas of the IFS system before they can perform their job.  I’ve listed a few as an exampleDocument Management Basic Data Approvals Quality  Shop Floor Employee Basic Data Users per User Group Purchase Requisitions user Site Settings WADACO processes Maintenance Resource Time Clock TerminalIs there a method in IFS to run a report that shows you where a user ID is used in these areas so if there is a new hire, or role change - you can make the necessary changes in the system?  I imagine you could get this data from the User Security Report or Object Security Report with the right criteria.

Hi,Last sunday we cloned the PROD database to our TEST enviroment. After that the TEST enviroment is not working anymore. When I start IFS test the following error pops up:  THE URI: https:"LINK_OF_IFS_TEST_AS”:58080/fndext/clientgateway/ cannot be found. Please contact your sys admin. Error 404 - Not Found. Does anyone recognized this problem or knows the solution? Best regards,Bram

Hello, I have created a saved search that uses Sum and Grouping. I’ve built the Lobby element, and it is rendering correctly. However, I’ve updated the Navigation to give the user the ability to be taken to the saved search data when they click the Lobby element. When I click the Lobby element, it takes the user to the IFS screen, however, it seems to be dropping the Sum and Grouping. Is this simply a limitation of the Lobby navigation, or is there additional configuration that is needed on the Lobby element? Any help would be greatly appreciated. 

Can I see which screen of the IFS User is currently open?On which screens I want to see users who are currently connected to the system.

    Server error messages:96e44bfa-30b5-4251-b4a4-1ecbad98b48fIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01031: insufficient privilegesFailed executing statement (ORA-01031: insufficient privilegesORA-06512: at line 21ORA-06512: at "IFSINFO.IAL_OBJECT_SLAVE_API", line 144ORA-06512: at line 1ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2993ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2997ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2151ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2195ORA-06512: at line 14)   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation,

I have a custom Field in the Sales Price List part window. Now i am trying to update/insert using a Migration Job. Using usual migration job using procedure (Insert/Update from File) gives error (ORA:01003: No Statement parsed.) But i did go through the Migration data into CF but i was not able to get it done. What i understand is that First the data from the file must insert into a TABLE and then migrate into the custom field LU using (Migrate Source Data procedure.) This Excel Migration Guideline document only show EXCEL Migration method but after creating the Mig Job i am not able to execute or start it. I guess it works using Excel Add-ins. Any help would be appreciated.

Hi All,Does anyone knows if there any limitation on number of rows we can add under DB/Client value within Custom enumeration please?I know it’s not advisable to use lengthy lists but just wondering about the limitation. Started getting below after certain rows:  ThanksDinesh

I am looking to Add a new output channel so that it goes straight to a excel spreadsheet and not in a CSV format. I am wondering if its possible to set it up so that it outputs to a .xlsx format?I have tried doing it but it wants me to click ‘csv’ , ‘xml’, ‘txt’ or HTML even once I have clicked ‘use other extension’. Anyone got any ideas on whether this is possible or not ? ThanksCameron

We have interfaces running, which occasionally fail because an object has been modified by another user (ORA-20114 Error)When this happens, we have a process to re-send failed items but its often overlooked.Is there an event anyone has that fires on the background job sending a notification the user/app owner when these jobs are in a ‘Warning’ or ‘Error’ state??Thansk

Hi,I have prepared a new group via Page Designer within IFS10 upd 9 Aurena.Then I noticed that I didn’t want it. I want to remove it, but am not allowed to:The delete icon is missing.I can’t remember that I attached it to a page. Nor do I know how to check to which page or other element it is connected.Question for now: how to delete this group?Thanks in advance,Steve

Hi All, Have you found an easier way of replicating an existing IEE Permission Set to an Aurena Permission Set. i.e. Grant same screens on IEE (Permission Set) to whatever pages that are similar to on Aurena? Thank you

We have a set of businessrules which determine what type of time_commit to add to a task.When the time_commit is added, the commit time is calculated based on a user_def field, which subtracts the field from the set task duration.As per the documentation, the commit_dttm field can be changed, as we are trying to do via a businessrule.Our issue is that the time_commit is automatically expiring on the original commit_dttm, and not the new commit_dttm.The update on the task time commit is showing the new commit_dttm as expected.XML used to update the time commit:<time_commit>    <tc_id>@tc_id</tc_id>    <commit_dttm>@expression[request_ext.required_end_date-Minutes(task.plan_task_dur_min)]</commit_dttm>    <update /></time_commit> I’ve found some messages in the log indicating that SME is running expire on the time_commit, long before it should expire:Timestamp: 2020-09-25T12:48:07.1243093+02:00Message: SME SendNewMessageInbound msg.Id=6a4ded03-94