Data Migration

I would like to migrate the field “Tax Liability” with already existents customers. I use IFSAPP account with IFS_ALL rights (and Excel ADD In). Il create a migration Job (I tried with Two jobs migration, insert or update, or Excel Add-in and i have the same result)I start the job and load the file.But when I want to start online, an error message occurs : “Access denied! User IFSAPP is not connected to Company”However, IFSAPP as a user is connected to all sites and companies. The update is allowed in the basic data migration setup. IFSAPP is a user per all the companies.Don’t know why the access is denied...    

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.

Hi,In the sale quotation, there is a State field and a Status field. The State field corresponds to CLOSED_STATUS/CLOSED_STATUS_DB in the database.accepted values : won / lost / no decision / nullI can't find the Status information in the database, and I need it for data migration.Does anyone have any information on this subject?

HiI have connected to our PROD environment via Oracle Database in Excel but I can’t seem to find the correct views.I have searched within the folders listed but unable to see INVENTORY_PART view for example.Is is possible to query these views in Excel? 

Hello,My name is Tomek and we’re starting to implement IFS Cloud 25R1 at my company.Please check  whether it works for you.I have a migration task with data export to a file in the OnServer directory. The directory was created in Windows and as an Oracle directory. It also has an archive subdirectory (Windows and Oracle). In the migration task rules, I have the FILEBKP rule active, pointing to the Oracle directory (archive)After the task is completed, a file named file.txt should be created in the destination directory (and this works), and according to the rule, a backup file named file*.bkp should be created in the Archive directory. However, this file is not being created. FILEBKP is enabled in the Default Rules.This works very well in IFS8, but not in IFS Cloud.What could be the cause of this?Thank youTomek   

Hi .. I was trying to set-up new migration job to update CUSTOMER_INFO_ADDRESS View for changes in address and postcode values. This supposed to update around 17000+ records so i choose to use Procedure “INSERT_OR_UPDATE” from csv file.As soon as i run the job i am getting below error. I did investigated further into this and noticed actual issue is - Address column value holds multiple comma seperators, which seems to be root cause of this. Is there any way i can mitigate this issue without removing extra commas from address value ? if i add double quotes around this column value, do you think this will insert double quotes also in data ?double quotes  Start time - 19-JAN-2024 11:13:18   CS_SJCB_POSTCODE_CHANGE_MIG - Execution No 0 Insert into CUSTOMER_INFO_ADDRESS_TAB failed - ORA-20111: CustomerInfo.FND_RECORD_NOT_EXIST: The Customer Info does not exist. (Error caused by line: 2)File Path: DATAMIG (F:/DATAMIG2)File Name: CS_SJCB_POSTCODE_CHANGE_test2.csvFile Location: OnServerChar S

I want to know how to get the Sales Price List by API. When registering a Customer Orders in the migration job, I want to use the API to retrieve the sales price from the sales price list. Because the migration job does not appear to be referencing the sales price list.

Dear All, we want to use the Excel Addin as Transport Tool to Create or Update Customer Order / Sales Quotation Lines. Now when we use the Excel Add In we have to do the following Steps:1.Open Excel 2 .Open Excel Addin and Login 3. Choose the Migration Job 4. A Popup Window if we want to Load in Same Sheet or in a new SheetWith these 4 Steps we have then the data entry Colums and van work with Search, Validation an Execution.We want to get rid of the Steps 3 and 4. Furthermore we want to Save an Excel with the alrady loaded Data Entry Colums and already Choosen Data Migration Job.  Has anybody an idea if it it possible to do so? As an Alternative we would like to Automate the steps.Any Ideas? Thanks Stefan

Hi.We’ve created a quick report to fetch some specific data and we’re hoping to schedule said report to run on a weekly basis and e-mail the file to a specific person.I have IFS_ALL permissions as the scheduling user.The report query is as follows:SELECT DISTINCT A.*, B.CF$_CC_SUPPLIERFROM PROD_STRUCTURE_CFV AINNER JOIN MULTI_LEVEL_STRUCTURE_CFV B ON A.COMPONENT_PART = B.COMPONENT_PARTWHERE A.QTY_PER_ASSEMBLY = 1 AND A.PRINT_UNIT = 'm' AND A.CONTRACT = 'ULV'AND B.CF$_CC_SUPPLIER = '5808'The report itself executes just fine within Cloud, and we can manually export the resulting data, but when we try and schedule it, the background job ends in an error. The errors listed in the Background Job details are as follows:ORA-31011: XML parsing failedORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 305ORA-19202: Error occurred in XML processingLPX-00007: unexpected end-of-file encounteredORA-06512: at "SYS.XMLTYPE", line 272ORA-06512: at line 1ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_R

 I have created a migration job which is used to migrate data into some custom fields in a core table. this included some reference fields as well. I have mapped the objkey for those reference fields and everything seems ok. But when I execute the job, core method get executed and during the execution of the customer method I get the below error. any idea on this ?"ORA-20105: Message.ATTRNOTFOUND: Attribute "SQL" does not exist in message "..."”  

Hi Community, I have tried to add the Excel migration Add-in (IFS Excel Add-in - 21.2.0.2) using both Excel windows client and office 365 web client for IFS Cloud. When I click the IFS Excel Add-in icon in the Excel, I am getting the ADD-IN ERROR.For the window client, I have opened the Excel as ‘Run as  Administrator’. so this is not a privilege issue.  Any idea on how to resolve this issue? Best Regards,Kapilan

Hi,I’m trying to load Functional Objects using the Equipment_Functional_API. But I’m unable to set the “Belongs to Object” or SUP MCH CODE via this API and view Equipment_Functional_UIV. Any suggestions, how do this under Data Migration Job? Thanks

Hi,We have a requirement to create Functional Objects via Migration Job.  The job should also insert Belongs to Object and Contract.In Cloud, while creating Migration Job (tried with Excel and Migrate Source Data) on EQUIPMENT_FUNCTIONAL, the columns SUP_MCH_CODE (Belongs to Object) and SUP_CONTRACT (Belongs to Site) not at all visible in Column mapping.We tried using modify Method to update these columns, but still it is not updating and Migration Job ending with an error as belowAPI Methods used: EQUIPMENT_OBJECT_PARTY_API.Modify__ Also used this method, EQUIPMENT_FUNCTIONAL_API.MODIFY__ , but in both cases it ended with same errorError:ORA-06550: line 1, column 43:PLS-00225: subprogram or cursor 'MODIFY__' reference is out of scopeAny thoughts or idea really helpful on thisThanks,Nishith

Good morning everyone, I post this topic cause after many hours of research I can’t find a solution about using an API.Here is my problem :  I have to build an flow for make an insertion of data in IFS DB.I did it on the application and use the debug window for see what kind of API is called. After analyse, I see this :   I understood the parameters are checked in the FndTempsLobs API which is genering a LobID and this LobID is the payload of the PickSelected API. My question is : How can I give the inforamtion PICK_LIST_NO, SOURCE_REF1, QTY_TO_PICK, etc… to the FndTempsLobs API ? The documentation show us the only payload is CreatedByModule :  My 2nd question is : The LobID generated contains the previous information ?  Thx a lot for your help and sorry if my explication are confused.  

Hello everyone, I want to update the supplier association number using a data migration job.I have identified the relevant package to use: Supplier_Info_General_API.Modify__.When I call this package through a PL/SQL script, it works as expected and successfully updates the value.the package is called by the crud_update method :supplier_handling_svc.crud_update(                '*',                v_supplier_id,                'ASSOCIATION_NO' || chr(31) || v_association_no || chr(30),                'DO',                supplier_info_general## => ''            );However, when I run the same operation through the data migration job, no changes occur. Any idea why please?The select statement generated by the datamigration job do return the correct value : Datamigration Job Details : The ATTR_ value used is :  'ASSOCIATION_NO'|| chr(31)|| IC_I_SUPP_ASSOC_UPDATE_TAB.association_no|| chr(30)

Hi, From where I can find the IFS Cloud 23R1: Data Migration Manager Template Project file?I have found a community post for 22R1 and a post related to an 23R1 Internal file only.When the releases are made,  is there a public URL where these templates are made available to  downloaded from?Thank you

Hi everyone,I’m unable to use a migration job to input a non-inventory sales parts with JUST a tax class.  If I try, I get the following error… I can however, create one with JUST a tax code.The odd thing is that if you debug the sales_part_api call when using IFS, both tax class AND tax code are supplied i.e. from the debug attr'TAX_CODE'||chr(31)||''||chr(30)||'TAX_CLASS_ID'||chr(31)||'1'||chr(30)|| Can anyone share any light on why this is? 

Hello All frnds,      Could you explain us different types of data migration in ifs 10.     how can achieved data from .csv,text file into IFS tables.     If  possible then share some docs or screenshot as well. Thanks in advance.

Hi,I downloaded and installed the configuration analyzer tool from the IFS developer portal(https://developer.ifs.com/tools/confanalyzer).The tool installed successfully but when I launched the tool, The application opens and within a few seconds it closes immediately.Do you have any ideas why this happens?Thank you

We are trying to migrate Approved suppliers but the default status after the data migrated is set to not approved , I am trying to change the status to “ Approved “ using the below method name but getting the error saying this list doesn’t exist ,is there a source to show valid “method name” for API’s please to make this sort of changes  

Hello everyone, I would like to know if the screen below exists on IFS cloud 21R2 and how does it work?Have a nice day

Hello the community,A customer is looking for a tool to integrate Ifs with MS Dynamics 365 CRM.He found this tool “Commercient” (https://www.commercient.com/product/sync-integration-for-ifs-and-microsoft-dynamics-365-crm/#tab-id-4) Any advice/experience is welcome :-)Thanks. 

We found and issue while attempting to migrate PROD_STRUCTURE rows using the Data Migration Manager.In essence, once we reach the Deployment Container screen and when we click on Deploy, nothing gets deployed. Even worse, there is no error message or anything to indicate if the deployment failed or something else is preventing the action to complete.Because a video is easier to show this condition I uploaded this video on YouTube so you can see what exactly is going on. https://youtu.be/5z6YtX-Cz4sAny idea as to what could be happening?

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_);   

Hello,in the IFS 10 version we used the excel file (input excel). Was such a file created for the CLOUD 22R1 version?if so - can I ask for this file?