Data Migration

I have created a custom logical unit / custom page to add to the Supplier screen as a custom tab.  Is there an easy way to use the data migration tool (DMT) to populate the underlying custom table?  I’ve seen instructions on setting up the DMT to handle custom fields on a standard IFS screen, but this situation is a little different, in my mind, because it isn’t and extension of a standard method.

HI,I’m trying to update PURCHASE_PART_SUPPLIER.LIST_PRICE with a migration job. Everything looks fine when running the job, but nothing is updated.  Start time - 24-MAY-2022 11:23:36   010_050_010_PRICE_MCreated select  :   FROM IFSAPP.IC_010_050_010_PRICE_F_TAB 10 PURCHASE_PART_SUPPLIER_API        Updated rows  : 9  READ ONLY GRANTS FOR IFSINFO        9 rows selected        0 rows failed Used 0 hours and 0 minutes Average of  540 rows per minute End time - 24-MAY-2022 11:23:36   010_050_010_PRICE_M Any suggestion? 

I have a Migration Job that uses the Excel Add-In and some of the custom fields are linked to views/tables, so I understand that the “_DB” value will be that of the OBJKEY/ROWKEY.  What I don’t understand is why I am receiving an integrity constraint error for NULL entries of the “_DB” columns.  one of my errors: “integrity constraint (IFSAPP.BUSINESS_OPPORTUNITY5_CRK) violated - parent key not found”how can one prevent this for NULL values for non-mandatory custom fields? Sincerely,Vince K.

Whats the different between P and K field flags in a migration job?I thought P stood for Primary key?

We’re trying to get the migration done and we have an structure like this as a CSV:CSV - source fileAfter we finish the first job which is the creation of the table with this data, there’s no error. The error comes after we execute the second job which is the one that migrates data, I get this error:ORA-20124: Error.NULLVALUE: Field [BUSINESS_UNIT_ID] is mandatory for Business Unit Relation and requires a value. Here is what’s been done:To test we only try to migrate one of the rows, the one with POS_CODE=’50000008’ The attribute string we get is: COMPANY_ID=ABCPOS_CODE=50000008POSITION_TITLE=ASSISTANT MANAGERVALID_FROM=2023-06-22-21.29.22VALID_TO=9999-12-31-00.00.00TIME_FORMAT=Minute by minuteASSIGNED_PROTECTED=FALSEEXCLUDE_FROM_EXPORT=FALSEEXCLUDE_FROM_ORG_CHART=FALSEDEFAULT_ACCESS_EXTENSION=FALSEEXPORT_EMPLOYEES=FALSESTRUCT_BU_ID=781BUSINESS_UNIT_TYPE_DB=COMPANY Here the job execution that throws the error:  and the migration job is defined like this: 

Hi There,I am using Attached  excel Data migration tool,After Copying data from Excel, unable to paste in IFS (no Option to paste). it was working fine before OS Upgradation on my DESKTOP. Can somebody help me out please. Warm Regards,Abid 

Hi IFS Community!Upon running the Excel-Add In for Data Migrations on IFS Cloud for a specific job in Production, we get "Unexpected end of JSON file" with no further information as to why this is happening.We migrated the same data to a different environment last week (CFG) with NO errors whatsoever, so we know that the data we are migrating is not the issue.We checked permissions for the user running the migration and it all looks fine as well. Any ideas what could be causing it?

We are a company at the start of our IFS implementation journey. Looking for templates for data migration of data across many different modules from our many different legacy systems. I’m aware of the Data Migration Tool to perform the migration, but looking for the templates, along with field help for the users populating the Excel sheet.  Does IFS offer something like this?

After company Creation from an existing company it gave in the log the following error  using IFS10 with UPD11:ORA-20111: UserFinance.RECNOTEXIST: Access denied! User IFSAPP is not connected to Company KSA022what id the reason and how it can be rectified?Best Regards,Bilal Drayi

Re Data Migration Excel Add-in  Do we need to buy a separate license to use this ?   

HelloWith the latest version of excel, it seems IFS Excel migration does not work. cloud 23R2 version 

I will create and assign 19 end users an excel migration job that allows them to import purchase requisition lines into IFS from Excel.We have only 1 license for data migration excel add-on in our IFS 10 UPD 12. If I understand correctly, the end users who assigned to run a excel migration job don't need a license. We just need to grant them the permission set "FNDMIG_EXCEL_ADDIN" to run the add-in after they install the Add-on. Please advise if I am missing something.

Hello, I have a VPN to the IFS cloud. Now I have noticed that the Select does not show any data on many VIEWS, although data is available there according to the IFS quick report.CUSTOMER_INFO: works fine PURCHASE_ORDER: no Data In IFS-Quickreport i can select all Purchase Orders ! Is there a reason and solution so that I can see data from all VIEWS that I select via Qracle SQL Developer and not just the column names?I have already written the IFSAPP in front of the VIEW names.Thanks for your helpGreetingsMarkus

Hi, This is my first time to use Data Migration/Execute Job function.When I did that, received the following error message.Where should I check for this?"interfaceDetail.NODET:No details found" Thanks!Kind regards,Kokubo

Hello All,We have a lot of Migration Jobs, and we want to migrate all of them in a new IFS Cloud environment.Are there any ways to accomplish this at once? Can we make a Migration Job for this task? Thank you for your help.

My data migration job keeps hanging when ran without CHECKOPTION. It eventually errors with the following message: Error occurred while calling  ../main/admin/plsqlgateway/AccessPlsql/Invoke?frmIntfaceStart. Please contact your system administrator. Error 502 - Bad Gateway   Has anyone come across this before and if so, could you please point me in the right directions.

We’re getting this error when updating a custom field in Customer_Info_Cfv created/added at data migration.It’s a simple update with just the CustomerNo and the new custom field, MS Set.Any ideas what to correct?     

ASystem: IFS Apps 8 (Currently)Hi, I'm new to the community and fairly new to IFS. I have a requirement within the business that on an agreed schedule it will automate a process in IFS, where an external SQL based system produces a file which can be automatically imported into IFS and used to generate new projects. e.g.Step 1@19:00 the External Systems produces an external text file: Pipe Delimited and columns encompassed in double quotes ("")Step 2@19:30 IFS imports the data into a temporary tablestep 3@ 19:45 a scheduled event activates andValidates the imported data in the temporary table creates new Project records based on the data in the temporary table emails users to notify of any failed transactionsSteps 1 and 3 are in place, I’m having problems with step 2I have looked at the data Migration tool and can't see how to schedule and completely automate the steps in completing this, load file, save and importI have also looked at the external file tool and am a totally bemused by

Hi,I have created a simple excel migration job to create customers and address information. In here, am passing the customer id to the second method as below. When i run the job, i am always getting an error :(Without the second method, if i only run the method to create customers it works fine - which means customer gets created without an issue) Is there is anything am missing here? Environment - 22R1 Any help would be appreciated.Thanks!

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?

Issue I'm using Plsql_Rest_Sender_API.Call_Rest_Endpoint_Json to call rest API service. It works fine for POST and GET, but it does not work for PATCH. I'm getting following error message:ExecutionException from Sender thread Caused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending data Caused by: ifs.fnd.base.SystemException: Patch error: 405 (Method Not Allowed)The same PATCH call works fine from Postman, so there is no issue on receiver side.Product Version: 22R2SU8  Resolution Restarting the ifsapp-connect container will the solve the initial issue. Then you might see the below error,ExecutionException from Sender threadCaused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending dataCaused by: ifs.fnd.base.SystemException: Patch error: 201 (Created)This happens because by default IFS Connect Rest Sender doesn’t accept HTTP Code 201 as a success response. REST Sender by default accept only HTTP Code 2

Hello, I have run into a rather interesting challenge I can’t seem to solve.I create a Migration Job for the Excel addin, its purpose is mass change shop order dates.The Source Mapping was auto generated via the default settings on the migration job.When I Open the Migration Job in Excel and use the search and try to search with a date field, the search does not convert the query into the appropriate date logic. Is this something I need to somehow program into the Source Mapping itself?Migration Job:Excel IFS Search:Checking the Advanced Tab to validate and resulting error:Manually correcting this makes it work. This however is not great for the end user as they need to know to make this change when searching for dates and becomes more difficult to use.Looking forward to some possible solutions. 

As I’m learning Data Migration Manager I have created a few projects. For a couple of them, while Mapping Legacy Tables to Migration Object there has not been any Target Tables available in the Smart Mapping assistant and I have had a hard time figuring out why. Am I missing any setup? What are the requirements for Target Tables to be available for Smart Mapping? 

when executing a migration job (procedure type =insert or update ) i’m getting this error ,i’m using 22r2 version.i have set default values for null values in migration job also can anyone help me to solve this ? 

Is it possible to load time data into a Date field?Using a Migration Job, I’m trying to load a time value into Day Type Details (FTIME field) but can’t get the date value (06:00:00.0000000) to parse properly:Error formatting date value 06:00:00.0000000 for FTIME I’ve also tried 06:00 and set the Date Format to hh:mm without success.