Data Migration

Edit: Sorry, for some reason this post cannot be made in the Assyst discussion board. Hi, all! I am currently trying to get ETM to import a .CSV file of our hardware, but I’m having trouble getting Assyst to import the file. My current setup is:A hardware list is generated by another program and a .csv file is created. That file is emailed to ETM via a MS Graph Import Channel formatted for .csv files. That .csv file is mapped to our hardware import datamapper.Whenever the email is sent to ETM, however, it fails to interact with the attached .csv file in the email. Is there any way for ETM to receive an email and then utilize an attached file, or do I need to come at this from a different angle? I’d greatly appreciate any input, thanks!

Hi Community,We are currently facing a challenge with our Build environment, which gets reset or vanishes after a certain time frame. As a result, we have to manually reconfigure key master data such as Company, Site, Supplier, and Customer each time.This manual setup is quite time-consuming and repetitive. We do have another environment with the required data already in place, and we are exploring possibilities to move or copy that data into the Build environment.Could you please advise if there is an easier or recommended method to achieve this data transfer efficiently?IFS Version- Cloud 24R1Thank you in advance for your support.

in 24R1, i have met the error message  below in Excel    Thanks in advance for your help. BR/Emmanuel 

Hello,while executing WO creation via migration job (procedure name: MIGRATE_SOURCE_DATA) i received such information: There is no information about any errors, but the WO record is not created in the application.Maybe someone knows what does such information means?Thank you beforehand!!!!

Is anyone facing an issue of being unable to add an address for a customer after the 25R1 update in IFS Cloud?I am facing this issue, and this does not work even through data migration.

HiWe are using IFS Cloud. I’m trying to load Cost Breakdown structures and want to make them active, suing Migration jobs, Alternately, Use a Background job to set them as Active.Is this possible?I’ve tried using Cost_Structure_API.Activate__ but cannot get this to work in an anonymous block.Here is my code:  DECLARE   attr_   VARCHAR2(5000);   job_id_                        NUMBER;CURSOR get_structures IS SELECT cost_structure_id,objid, objversion FROM cost_structure WHERE state = 'In Progress' ;BEGIN   FOR c_get_structures IN get_structures   LOOP      client_sys.clear_attr(attr_);--      client_sys.add_to_attr('INFO_',       'NULL' ,                        attr_);      client_sys.add_to_attr('OBJID_',      c_get_structures.objid ,      attr_);      client_sys.add_to_attr('OBJVERSION_', c_get_structures.objversion , attr_);      client_sys.add_to_attr('ATTR_',       '' ,                        attr_);      client_sys.add_to_attr('ACTION_',     'DO' ,                        attr_);   

Hey everybody, I am facing a problem with Excel Add In in IFS Cloud. The search functionality has changed from Apps to Cloud. Eg “%” or “;” doesn´t work anymore (at least it seems). Is there any documentation about search possibilities that can be used? Is there a possibility to use SQL statements in the search bars? Thank you in advance, Johannes

Hi all,We are in the process of deploying the 24R2 (IFS CLOUD). Our current solution is in 22R2.We currently have 32 permissions sets, and many of them are “CUSTOM”.With 24R2, a lot of projections have been added, and I realize how difficult it is to analyze.So, is there a way to quickly compare permissions sets (entity action Grants & projection action Grants) between 2 environnements (22R2 vs 24R2).Thanks!! Soumia

I am using the Smart Data Manger concept in IFS Cloud, Navigation : Solution Manager > Data Management > Data Migration Manager > Project Basic Data  DB link is created from IFS Cloud db to fetch data from the Source (tried IFS Apps10 and from FSM Database)But in Project Basic Data - Under connected environment : Database link is listed only if the DB Link source is created from IFSMIG User (Tried both in IFS app10 and in FSM database)But IFSMIG Schema is introduced only from IFS Cloud versions, not available in Apps10 and obviously not available in FSM db, so how do we connect the legacy database of Apps10 or FSM DB?Need assistance on using Smart Data Manager for Data Migration task to fetch data from Apps10 or FSM db.Please confirm if this approach is possible using SDM  DATA Migration :IFS Cloud ← Data from IFS APPS10 or IFS Cloud ← Data from FSM DB

 Hi Team,Could you please advise on the way to add an additional book for fixed assets that have already been imported? We have tried the following way as described in the below post, but it does not work in IFS Cloud. Importing Depreciation for an Existing Object/Asset | IFS Community Please see below our migration error message:  Thank you in advance for your support. Regards,Yentl

Hi Experts. We plan to use Data Migration Manager.We would like to import data from the legacy system in JSON format.Is there any way to do this? 

We have migrated our IFS production database (Oracle 12c) to our client’s AWS cloud environment. The  was migrated to Oracle 19c.We are encountering issues similar to what occurred when our DEV environment was migrated, where the FND roles were missing supporting sub-role grants. We have fixed most of them manually, but there are a few new issues where we are getting errors like ORA-20105: "FND_WEBRUNTIME" is non existing grantee. There are others that have similar errors: BA_ADMINISTRATOR, BA_BARS_ADMIN, BI_VIEW_ACCESS, BR_FULL_IS_VIEW_ACCESS, FNDSCH_RUNTIME, and CUSTOM_OBJECTS_ADMIN.We tried to export/import the roles from our on-prem database and importing them, but still get the above error.What happened during the migration? How do we correct it?

Our company is on cloud version 24R2 and we have missing capabilities for our admins. We need access to Data Management > Migration Jobs with permissions sets FNDMIGRATION_JOB (limited access) and FNDMIGRATION_JOB_MANAGER (full access) which I do not see. Would someone please provide us a step by step solution to get this resolved?

I'm trying to import current supplier ordersI'm getting the following error: No revision found for inventory part 303406This applies to all products. What I did:1. Imported the order headers: OK2. Added the product-supplier links for the corresponding order lines: OK3. Added the order lines (PURCHASE_ORDER_LINE_PART) for which we have the product number: KOI tried putting 1 or nothing in the ENG_CHG_LEVEL (Revision No) column.With 1: ORA-20110: ChangePurchaseOrderLine.NOREVFOUND: No revision found for inventory part 303406Empty: ORA-20110: ChangePurchaseOrderLine.NOREVFOUND: No revision found for inventory part 303406If you have any ideas, you're welcome.

I know that the Entity configuration has changed from Apps9 ‘WoRoleSrvQuo’ to IFSCloud ‘JtTaskSrvQuoResource’.I would like to know 'ROW_NO' in Apps9 ‘WoRoleSrvQuo’ corresponds to which item in IFSCloud ‘JtTaskSrvQuoResource’.I would also like to know the conditions for linking Apps9 ‘WoRoleSrvQuo’ data to IFSCloud ‘JtTaskSrvQuoResource’ when migrating the data from Apps9 ‘WoRoleSrvQuo’ in a core upgrade.

I am receiving the following error when trying to create inventory parts from engineering parts : Invalid value for property 'PartNos'.Any idea what might be the issue?

Hello,I try to upload Purchase Order lines. As there is no particular notes, I let empty the Note_id field.This brings the following error : ORA-01400: cannot insert NULL into ("IFSAPP"."PURCHASE_ORDER_LINE_TAB"."NOTE_ID")Any idea about how to avoid such error ?Thanks in avance

Hi all,We want to add custom menu on Execute Job page but when I try to create new projection configuration I can’t find entity name of IntfaceHeader. Is there any specific reason why I cant find it. Does any one know how can we solve that?  

We are in the process of transporting data from IFS database into an organization internal Data warehouse. We are needing a list of IFS database objects that have PII information. Please let us know if there is a some kind of have a dictionary or data guide that helps to identify where sensitive entities/fields/etc may be in the databaseProduct Version: 24.2.5Business Impact: Unable to proceed with setting up the ETL process to transport data from IFS database to the internal Datawarehouse

hi, İ wanna create an excel migration about Cost/Revenue Element per Code Part Value.i select view name - PROJECT_COSTREV_CODE_PART source mapping coming is empty. i want to try add but i am getting the following error. how to make an excel migration to match cost/revenue and code parts.  

Hi Community,I am facing an issue when i am trying to transfer legacy data to input container with the date field. other date field mapping like valid_until and acquisition date are working just fine. The error i am getting is for the VALID_UNTIL column which has a value as 30.12.2049. the value for other column are also in the same format. The error is am getting is “Unable to start IC_ADD_AND_META_VALID - ORA20110: DatInputContainerUtil.EXEERR: Error while selecting data from legacy file(s). ORA01861: literal does not match format string”. Can anyone please explain me why this is happening.I even checked the training video but there is not much information on handling date column when transferring data to input container.I would Appreciate your input on solving this. Tank you

We have some information stored in technical attributes for equipment object that would like to migrate to Service Notes, but that was not as easy as I though since Notes are a CLOB field.We are currently on 24R1 SU4 and I found this workaroundExcel Migration - Technical Documentation For IFS CloudBuisness_Lead_API have a procedure Write_Note_Excel__, but Request_Contact_Note_Api does not have a similar procedure in our version. Could some see if the Api been improved with such a procedure in 24R2 or 25R1?      

Hello,I noticed that Engineering part transfer actions do not check wether the engineering revision already exist on destination site until a first transfer is made.I’m having an issue with a customer where inventory parts & engineering part revisions have been created via data migration. However, now each time a une an existing part revision in a new engineering structure, when I transfer the top code it creates revisions for all the components … This means the setup of Product structures (issue to location, conumption type, alternatives,  ...) needs to be made every single time a component is transferred for the first time, for all the parts already in destination site. I tried to tag the transfer actions as ‘transferred’ but couldn’t reach my goal. => Has everyone encountered such an issue ? How could this be fixed ?Thank you,//Pierre 

The PROJECT INVOICE should  have direct access to the Customer details with hyperlink. This is already in place and active with the CUSTOMER INVOICE.  

Hi, We have a business requirement to import attachments (all doc formats and JPEG, PNG, JPG, etc) into IFS Cloud work task template, functional object from an external non IFS system application. We came across FsMig Tool (File Sharing Migration Tool) which is used only to import attachments from IFS Applications to IFS Cloud. is there some tool or any better way to import attachments from other systems to IFS cloud, open to suggestions.