We have had similar issues with APPS 10 UPD16.it seems to creep up randomly. here is the full error stack.Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> System.ComponentModel.Win32Exception: Error creating window handle. at System.Windows.Forms.NativeWindow.CreateHandle(CreateParams cp) at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.OnVisibleChanged(EventArgs e) at System.Windows.Forms.ScrollableControl.OnVisibleChanged(EventArgs e) at System.Windows.Forms.Control.OnParentVisibleChanged(EventArgs e) at System.Windows.Forms.Control.OnVisibleChanged(EventArgs e) at System.Windows.Forms.ScrollableControl.OnVisibleChanged(EventArgs e) at System.Windows.Forms.Control.OnParentVisibleChanged(EventArgs e) at System.Windows.Forms.Control.OnVis
@Curious_User When creating Engineering Parts it automatically creates a part number if you keep the Part Number field blank. If you fill out the Part Number field then Part will create with the part number you want. @AanHGTS, can this function be turned off?
The below code is the PL/SQL Block Solution that has worked for my Custom Right Click Menu that will only add data into the Custom LU Table if it is missing without duplication. DECLARE p0_ VARCHAR2(32000);p1_ VARCHAR2(32000);p2_ VARCHAR2(32000);p3_ VARCHAR2(32000);Q_ORDER_ VARCHAR2(32000);P_ORDER_ VARCHAR2(32000);P_VIN_ VARCHAR2(17);C_ORDER_ VARCHAR2(32000);C_VIN_ VARCHAR2(17);CURSOR PLANNED_VINS ISSELECT DISTINCT col.ORDER_NO, CASE WHEN col.CF$_PLANNED_VIN IS NULL THEN 'P_VIN_ERROR' ELSE col.CF$_PLANNED_VIN END AS CO_VIN, Case when trk.CF$_FULL_VIN is NULL then 'ERROR' else trk.CF$_FULL_VIN end as CH_VINFROM agil1app.customer_order_line_CFV col LEFT OUTER JOIN agil1app.C_L_U_CHASSIS_TRACKER_CLV trkON col.ORDER_NO=trk.CF$_ORDER_NO and trk.CF$_FULL_VIN=col.CF$_PLANNED_VINWHERE col.ORDER_NO = Q_ORDER_ and LENGTH(col.CF$_PLANNED_VIN) <= 17 and col.State <> 'Cancelled';BEGINQ_ORDER_ := &ORDER_NO;OPEN PLANNED_VINS;LOOPFETCH PLANNED_VINS INTO P_ORDER_, P_VIN_, C_VIN_;EXIT WHEN
The excel tool does not handle date formatting very well and required that the base field formatting is being used. e.g. using >'01-JAN-23' for dates bigger than Jan 1st 2023, in addition surrounding it with single quotes. Lastly if only a single date is used then no quotes are needed.
I have solved this myself.
@Curious_User Were you able to solve this with an event action? I'm on the brink of looking into such a situation (other assistant page however)? In my situation it is for an IFS10 environment, so no BPA available. I was not, since page designer is not supported i stopped looking into Aurena, the Software is still not mature enough. In IFS 10 EE you can make them mandatory as its normal functionality. We will stick to IFS 10 for the foreseeable future before considering a move to Aurena due to the lack of major functions and user QOL features.
I would be interested in seeing an answer on this too.I am trying to do the same by trying to get a dropdown for ISO_UNIT for Units of Measure in another table for the Excel Migration.
Thank you @Saman K, this sounds like our system has a bug that needs to be addressed which might have been fixed in UPD14 already.
Thank you for the reply @Manoj Ruwanhewa , I just checked and we run IOS 14.8 and it does not function on there. we only have 8th Gen iPads.What is the difference between IFS Aurena and IFS Aurena Native?
I really hope someone can help me on this.Do we need a 3rd party EDI software to make this work?
Thank you @Björn Hultgren and @Jonas Feigl. I will try the event action as a work around. I Hope IFS makes this available soon.
Thank you for the quick response @Krishantha.Since I don't see “Asset/Equipment Data Collection” in our IFS Instance (APPS 10 - UPD 11), I am guessing it is an additional module we would need to Purchase first?
Hello @william.klotz ,We are planning to send Purchase Orders from IFS 10 to IFS 9 which generates Customer Orders if accepted in the Incoming Customer Orders section, then send Confirmations back to IFS 10 from IFS 9.We would follow the same logic as Inter company/Site transactions if you are familiar with them with the exception that we would use 2 separate IFS Instances at this point. (i know it is not ideal but am looking at options to supportthe users)I would expect there to be minor differences in either table or column names.
I have solved this error.IFS Aurena is uncapable to use usernames with more than 15 characters, which caused an internal function error to result in a null value return. Reducing the Usernames to 15 or below solved the error.
Hi @majose ,we are currently running on UPD 9 of IFS 10, which Update fixes this version?
Hmm interesting. I did end up with some positive backlog, but i still don't understand why the Actual backlog shows negative in period 11 year 2020 after adding the forecast and operations plan.can you help elaborate on why it would be like that a bit more please?Please see snapshot below.
Hi, At a customer they use it to load opportunities in CRM. It builds the heading and the part lines. This is due to the fact that header and line info are in the same Excel row. Not only is it used to import new information, also updating the data is done in the same way. In this situation, the responsible key user of an opportunity uses Excel Migration Tool only for their own opportunities. Another situation is to load supplier for purchase part price lists. One Excel is used to retrieve the open lines (using search icon), the lines get a valid until date and are updating the data in IFS. The second Excel migration job is used to generate new price list lines. Works great and highly efficient. There is also a situation that sales prices are loaded. The downside is that there is no audit trail when someone has used this tool. Using a standard migration job, the last usages is reported in the information of the migration job and there is the history when several times the same job was
Thank you for the info. I have security question related to the Excel tool. Is the Tool accessing the Oracle Database directly from Excel to write/update/Delete the tables data or is it using the API calls just like the IFS software interface the users are seeing when interacting within IFS?
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.
