Data Migration

We were in progress of debugging why a certain data migration job was not importing data correctly and we got a couple of issues/bugs while debugging.  Attribute string fieldWe wanted to use the attribute string to verify if the data was read correctly BUT it looks like the attribute string is cuttoff at a certain size? (1922 chars?)This is quite tricky as we could not debug if the data went in or not? View Temporary table created by job?When creating a job with CREATE_TABLE_FROM_FILE it seems its impossible to view the table created by this job? For example with Quick reports?   

I am looking to extract the email addresses from user accounts in sqldeveloper but do not know the location of the field.Using version 10It is showing on the create User screen  but system info shows only as Control: textboxEmailWhats this ID: labelEmail.Any help appreciated  

Hi All -- hoping for some help with a migration job issue I’ve been struggling with. I need another pair of eyes to see what I’m overlooking.I’ve got a job containing two separate views, plus the custom field view for one. Validating my job results in “Validate OK”, however upon execution I receive “The Sales Part Base Price already exists.”  I’m trying to update the custom field (CF$_ACCEPTABLE_USE_CODE_DB) or any field in the line, and not create a new one. Attaching screenshots of everything I can think of… I’m also a rookie when it comes to data migration.  

Is there a way to do mass part uploads on sales campaign or in customer agreement at deal per part level. Regards, Urvaksh 

I am using FSM with a SQL database and wish to produce a new Test DB from my existing PROD DB. I have tried restoring a backup of the Prod DB to the test DB and this doesn't work as it says DB not available. I have tried doing and export from the Prod DB to the Test DB but I get an error about writing to a read only table. Does anyone have any advice? 

Does anyone know if it is possible to use the Excel Plugin to access multiple data bases?I have a customer who want to be able to update both test and Prod.Not both at the same time, but be able to switch between the two. 

Hi everyoneI’m trying to migrate manual customer invoices using a MIGRATE_SOURCE_DATA migration job and I’m using Man_Cust_Invoice_Item for the lines.  I’m getting an error that the DIV_FACTOR is mandatory and requires a value even though it has actually been set.  I’ve tried setting it using the default value and via a source column but I get the same error in both cases.  I’m using Cloud 21R2.  Does anyone have any items on how to resolve this?Thanks!

Hello IFS Community! I’m assessing a strategy for a legacy ERP migration into a PRODUCTION IFS APPS 10 (UPD16). This is a multi-tenant  instance (many companies are running on this IFS instance). There is already one company operational and I am migrating company #2.My question is this: we are considering two strategiesMigrate this new company (let’s call it, company “A”) into PRODUCTION where the current company (company “B”) is operational. Do the migration and QA work directly in PROD. Once the GO-NO GO decision is made (if GO) then just start using PROD with no further delays. In this approach there is no freeze period for company “B” Migrate this new company in a staging environment that we will clone off PRODUCTION (so all of company’s “B” data is there), freeze PROD during migration (tell users of company “B” site is off-limits for now). Do the migration and QA work there (in staging). Once the GO-NO GO decision is made (if GO) then clone back the staging into PROD and unfreeze

Hi, I am trying to export at list of customers to Excel. However, I can see that I am limited to these columns fro the customer table:Is i possible, using an advanced SQL query, to include the address columns of Address Identity ‘10’ in the export?  Br,Nielf

How could I migrate data from a GPE environment to a PPE environment? The goal is to migrate parts of the whole data set: customers, companies and some other transactional data.

I am trying to export SRV_REQUEST_CFV using the procedure FNDMIG_EXPORT and when I execute it, it returns an empty file.  I have one record that I have entered into the table, but it is not pulling it.  Any ideas? 

Hello,I am trying to migrate the work location for the emplyee file. I tried it via template EmployeeWorkLocation, but I didn’t manage. The two-step job works fine, but the field “work location” is empty.I am using the Cloud version 22R1I appreciate any help on the subject!Kind regards,Aleksandra 

Need to know if anybody load actual hours on project? I am using the voucher entry load for historical information but what can be use to impact the used/actual hours as well?

I am trying to migrate Customer_info where the Creation Date is today’s date.  The migration does not like the format:  1000001 ABAN ABRAHAM PTE LTD 11/16/2022 1000001 CUSTOMER United States of America en 1000041 SEADRILL OFFSHORE AS - EUROPE OPERATIONS 11/16/2022 1000041 CUSTOMER United States of America en 1000342 TURKIYE PETROLLERI A.O. 11/16/2022 1000342 CUSTOMER United States of America en 1000457 TRANSOCEAN DRILLING LTD 11/16/2022 1000457 CUSTOMER United States of America en                                                          

Can anyone describe the difference between using the Data Migration tool vs the Data Migration Manager Tool?

We are upgrading IFS 8 to IFS 10 in a Portuguese customer.Since portuguese localization requires that voucher entries for the current year must be in one software to extract legal reports we need to export data from 8 to 10. Can anyone help us with some documentation or samples?Regards 

Hi. I get an error when attempting to validate a row in a newly created migration job:The logged in user has permissions to the migration job and the data is OK, I’ve created a few other similar jobs today and all have worked fine.ThanksAO0001

Hello all, I am getting the error message: class intfaceFile does not exist when trying to select a file, does anyone have any ideas what the issue is please.

What setups are necessary to use the IFS Smart Data Manager?   I do not see the permission sets SDT_CLOUD_FULL and SDT_CLOUD_MIGR_FULL.  Is there something that has replaced these?  We are on 21r1.

Hi,Does anybody have knowledge how it is possible to get adjust batch size function done during migration of recipe structure lines? It looks like it is not done during setting structure buildable. Is there an own migration job/script for that or should it be part of migration of each recipe structure line?Best regards,Kirsi  

Hi everyone,  My need would be to migrate WBS Projects and automatically import the structure of the Project such as allowed by the standard API PROJECT_API.COPY_PROJECT_ATTR.This API is related to standard command “Copy Project”:There are a lot of parameters to be set up in the client when using this wizard, but I can’t manage to identify all of them properly using the SQL debug console as well as triggering the Method in a Data Migration Job.I am in IFS 21R2 Cloud Version.Here are the parameters that I managed to retrieve from the SQL debug console in IFS APPS 10 for the attribute OPTIONS_ATTR_ :'PROJ'||chr(31)||'YES'||chr(30)||'SITE'||chr(31)||''||chr(30)||'SUBPRO'||chr(31)||'YES'||chr(30)||'RUNINBACKGROUND'||chr(31)||'NO'||chr(30)||'COPYSITE'||chr(31)||'FALSE'||chr(30)||'ACTIVITY'||chr(31)||'YES'||chr(30)||'TASK'||chr(31)||'NO'||chr(30)||'PROGRESS_TEMPLATE'||chr(31)||'NO'||chr(30)||'DOCPACK'||chr(31)||'NO'||chr(30)||'DOCOVERVIEW'||chr(31)||'NO'||chr(30)||'P3CONSTRAINTS'||chr(31)||'

Hi All, I tried creating a Migration job for custom table using the procedure INSERT_OR_UPDATE When tried to Execute Job it throws the below errorExecuteJobError  

Hello, I am trying to configure Oracle (or any compatible) ODBC connection for an IFS database.I have no setup details for the database and have had no success mirroring existing computers.  The existing computers that can refresh reports in excel have Oracle19c installed. I am open to doing anything and have full access to the sql server. I am just looking for some guidance. Thanks! 

Hi,In APPS10, we’re getting this error when trying to perform an inventory movement. Upon checking the inventory location, it appears that it’s because Bay Route Order, Row Route Order and Tier Route Order are NULL.This is odd as the location’s Bay ID, Row ID and Tier ID are populated so I would expect the route orders to have the same value.Bay ID, Row ID, Tier IDBay Route Order, Row Route Order, Tier Route OrderI’m not able to use a migration job to populate these fields as they’re not stored values. Is there a way to almost refresh/re-execute the package methods to update the route order fields with the correct values? The packages used for these fields are:&AO.Warehouse_Bay_API.Get_Route_Order, &AO.Warehouse_Bay_Row_API.Get_Route_Order and &AO.Warehouse_Bay_Tier_API.Get_Route_OrderThis seems to be happening to quite a lot of inventory location records. Any help would be appreciated.

I am trying to create an ETM Channel to create new Event Builders at Item Level.Fields Usage Type and Event Type are Integers. I tried with value “1” for both fields but it is failing.Can anyone please help me in getting the Usage Type and Event Type values?