Data Migration

Hello Community!How does companies do mass import of inventory parts, purchase parts and supplier for purchase parts to IFS? Companies that has many new and changed parts and needs to update this frequently?  Like create a set of parts with multiple part numbers in one go. I understand that this is possible with migration scripts / tools etc. But when it comes more to a end user function. How are you doing that?

With regards to the deployment of our Microsoft Excel Integration Licenses and Plugin – there is a pre-requisite software required as you know - Visual studio 2010 plugin this is now unsupported by Microsoft and our Customer are not intending to package this up with our Windows SOE based on it being unsupported - https://learn.microsoft.com/en-us/lifecycle/products/visual-studio-2010Can you advise if IFS have issued an alternative to this plugin that is tested with your connector, IFS Data Migration Excel Add-in for APPS 10?

Is there a way to take document text  from supplier to purchase part and have it automatically add to new purchose orders?

Can we use external file assistance for manual supplier invoice  in cloud and i am not getting output option in external file assistance for ExtSuppInv  

Hey, I am trying to fix a broken excel migration job, but it keeps throwing the following error:Expected ',' or '}' after property value in JSON at position 222 (line 1 column 223) My issue is that I don’t know how I can check what the JSON file looks like that is created from the Excel file. Is there a way to see that, perhaps inside the debugger?Please let me know if you need more information regarding this problem to better understand.Thank you for your assistance in advance!

Please any one can tell what this error mean is. ORA-20110: InventoryPartUnitCost.N-0  

Hi database gurus,I work with the data structure in IFS for more than 20 years now.The last days I came across xxx_MV tables and wonder if there is a documentation of databaseobjects and the structure of what meaning do the single part of the names have.TMP = temporary, CFT = custom field table, CFV = custom field view, _TAB at the end of most tables in the ORACLE DB is easy.LOV = list of values, ok but I’m not shure why the IFS developers sometimes use this suffix in the table name, sometimes not. When you use “base data” every thing could be a “list of values”.Especially I’m looking for a meaning for the xx_MV tables today.Thanks in advance and have a nice day.Cu in the communityMichael 

Hi All,I’m trying to import Person records and I get this error:READ ONLY GRANTS FOR IFSINFOThis was working yesterday, so I’m confused.I’m using the view PERSON_INFO_ALL.The Users have migrated for all these records and the Company User records migrated as well.Any Thoughts?Thanks, Rob

Hi Friends!I have a simple question (I guess) related to tracing…If I have a call to the Trace_Sys.Message inside a Custom Event Action. How can I see it?

Me and my colleagues are part of a project to ingest data from IFS to google cloud platform, where we collect and curate data from ifs and other systems in order to gain insights using PowerBI.We would like to access objversion each table in the client API, so that we can load data  hourly both incrementally and idempotently.But this field is not exposed in the API.One option presented to us was to add a custom field from the objversion, but this poses another problem, because custom fields are added in the CFT tabal, which mean they are not part of any index on the table. This means that each request to a table performs a full table scan, which we do not want for two reasons:   1. It is slow and sometimes times out   2. It is too much processing on the database.Another option would be to load the entire table each hour, but that won't cut it for obvious reasons.In our estimation, exposing the objversion as a field in the client API would solve our problem with minimal effort involved.

Hello All,I have created a migration job to export User Grants, but I can’t get the File Mappings to populate.Any thoughts? Thanks,Rob 

Hi All, I’m trying to do same data analyses about direct/indirect hours, therefore i tried accessing data which is shown in screen “Time Registration”. View TIMMAN_JOB_TRANS.I did this by the use of PL/SQL dev. I had not all te results i expected, so i viewed the time registration for another employee in IFS. After i had checked that in IFS, that employee also showed up as result in PL/SQL. So, it seems like the data is stored in the view afther i;'ve viewed it in IFS. Does anyone have an idea how to be able to see the data without opening the time registration screen for every employee one by one in IFS?Or any suggestions for another view is also welcome 😃this is the SQL query: select COMPANY_PERSON_API.Get_Internal_Display_Name(Company_id,EMP_NO),ifsapp.TIMMAN_JOB_TRANS_status.*from TIMMAN_JOB_TRANS_STATUSwhere company_id='***'and account_date= DATE'2024-01-29'and (HOURS_DAY1 >0)

Hi All,When migrating users, I get a strange result in the Description field.  Instead of the User Name, I get the contents of all the fields:I also can’t get the Web_User to populate into the User Email field 

Evening IFS Experts!I wonder if any of you can help me with a migration challenge… In IFS Apps 10 Aurena, manually adding a line to an Instant Invoice causes the “Tax Code” field to be auto populated. Our Sales Objects have no tax code on them, and so the Tax Code is taken from “Customer (page) > Address (section) > Delivery Tax Informant (tab) > Taxes (group) > Tax Code (field)”. When we migrate an Instant Invoice line, we need to replicate this function (i.e. the migration job also needs to read the Tax Code from “Customer > Address > Delivery Tax Informant”) but I’m struggling to work out how to do that. The field help for “Migration (page) > Source mapping (tab) > Default Values (field)” explains that SQL can be used and gives the following examples…substr(SOURCE_COL,1,25)decode(SOURCE_COL _1,'Y','Yes','N','No','No')Part_Catalog_API.Get_Description(SOURCE_PART_NO)Intface_Method_List_API.Get_Sequence_No('<sequenceName>','<valueType>')  I was hopin

Hello All,Has anyone had success with migrating PSO users between environments?

I am trying to import a profile from one user to another new user and keep getting the error  “The file is invalid and cannot be imported .  The user profiles are saved and stored as .XML files    

Hi All,I can’t create a migration job.  What projection am I missing? Thanks,Rob

Hello All,I’m trying to migrate users between environments and I’m missing data.Why can’t I migrate the email address?If so, what do I add to the migration job.The field seems to be part of the same table, but does not get added to the migration job. Thanks,Rob

Hi, I migrated the charges to PURCHASE_CHARGE_SUPPLIER, but I received error message:“ORA-20124: PurchaseChargeSupplier.FORMAT2: Field [DISTRIBUTE_ON_RECEIPT] in Purchase Charge Supplier has an invalid value format. The value is: "FALSE".” File string : 102517;3D;CLO;1;0;1;;;102517;;;23;;;;;;;;FALSE;FALSE;0Attribute string:VENDOR_NO=102517CONTRACT=3DCHARGE_TYPE=CLOSEQ_NO=1CHARGE_AMOUNT=0CHARGED_QTY=1PRINT_PURCHASE_CHARGE=PRINT_PURCHASE_CHARGE_DB=PRINTCHARGE_BY_SUPPLIER=102517DISTRIBUTE_CHARGE_BY=DISTRIBUTE_CHARGE_BY_DB=FEE_CODE=23INTRASTAT_EXEMPT=INTRASTAT_EXEMPT_DB=FALSECHARGE=MIN_ORDER_LEVEL=MAX_ORDER_LEVEL=VALID_FROM=VALID_UNTIL=DISTRIBUTE_ON_RECEIPT=FALSEDISTRIBUTE_ON_RECEIPT_DB=FALSECHARGE_AMOUNT_INCL_TAX=0    Do you know why I have this error ? 

Hello, I currently have an event, an event action, and a workflow. The event action triggers the workflow. I want to export/import this process between environments. I am able to add the event and action to an Application Configuration Package, but I cannot add the workflow itself. This is what my ACP looks like at the moment:  And when I try to import this ACP into a new environment, I see this:  I understand that my workflow design is not imported yet, so therefore the ACP cannot import either. My question is, how do I actually export/import the workflow? I cannot find anything on the “Workflow” page for this. Mark

I'd like to wish you all a very happy new year. I'm creating migration jobs for customer orders where I'd like them to retrieve as much information as possible automatically. At the moment, I only have 3 mandatory pieces of information to enter.   I'd like the order number to be entered automatically, based on the last existing order number. Is this possible? Where do I enter it? For the example, my last order number is "S23000005957".I'd like the order number to be automatically set to "S23000005958" when I run my job, and for the countdown to take place naturally. If I manually recreate an order, my number should be "S23000005959".

Hello All!I need to update (migration task) many lines to personal files table. Which view should I choose to update all fields of the following person views together : PERS, PERSON_INFO, PERSON_INFO_ALLThank to all advices from HCM experts.

Hi guys,Anybody here has a detail procedure how to update my TEST environment using PROD environment data?I already asked this question a long time ago,  but no good answer.Our environment is IFS Cloud 23.2.5, on premises.Thanks,Gianni Neves 

I created migration job named “PURCH_REQ_MIGRATE_MNTJ”. But the user can not see this. How can I activate the migration job to the user.  Or should I confirm the permission set?  

Hello everyone,I need to create a migration job for customer orders. My customer would like a unicity check to be performed on the field CUSTOMER_PO_NO when the job is launched.  If the value already exists on IFS, the line that should be imported by the job should be blocked.   Is it possible to add this control and blocking directly to the migration job? Knowing that, the field is optional.