Data Migration

Hello Community,Question:  how can I “Connect” in Excel when the Excel user is Local and the IFS instance is set to SSO?  That is, the Excel user’s Dir ID does not include the “@domain.com”.  Thanks,  Troy

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? 

Hi Everyone, We are looking at populating the Custom Stat No field with the HS codes (unless anyone advises otherwise).We’ve identified around the HS codes for around 100,000 parts so far (with many more to go). Does anyone know if there is a way to change them on bulk to add the code to the part (the field will be empty at present)?

 Hello,How to include multiple views on replication job? We have already replication job that replicates item data from one site to another sites. There’s only INVENTORY.PART view included in this replication job and it’s working, but now there’s also need to include PART_REVISION data to this same replication but I cannot figure out how this can be achieved. Here’s the original replication job with only one view. This works ok.  Here’s how I have tried to create new replication job with two views. INVENTORY_PART and PART_REVISION. Firstrly I’m not sure how should I use the “Source Name” field. I guess I should use join clause here but not sure how should I format it. I have tried with these guides but with no success..Internal Replication (ifs.com)Db-Links, JOINS (ifs.com)Replication tab of the new replication job Source Mapping tab:And Method list 

Are there any steps for migrating excel data into customer order line using latest IFS excel migration.

Good afternoon all,  I am after a little help/advise. My company are looking to add the Harmonized System (HS) codes to the inventory Part Record using the Customs Stat No field (unless anyone can advise me differently). We have identified over 100,000 inventory parts tariff codes and I wondered if anyone knows of a way to bulk upload them from an excel spreadsheet? At present the field is blank.  

Community, i have this error when creating a migration job, may I know what I did wrong? Thank you.

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

I have been doing these migrations for some time now and never have had an issue where I get no information to migrate.  I am getting not 1 record going into IFS and I just get Not Processed.  Can someone lead me to where I can understand why none of these MTK_SUPPLIER_COMPANY_TAB records are not being migrated.  

Is there a way to migrate IFS users from one environment to other (TEST to PROD) ? Thanks in AdvanceSBM

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

Hi, Has anyone managed to get an IFS Migration Job (we are Apps 9 but interested in other versions) to export a file directly to a machine other than the DB Machine?Thanks, Matt

HiData Migration Job Takes much time, I have to Migrate more than 10 hundred thousand data.For data of 44 Thousands rows/records  job will take time more than 150 minutes.Kindly advise

Customer needs to create Quick Reports through Data Migration Tool and need to specify the Query column which is a CLOB type, here it won’t allow.  Is there a way to migrate the CLOB data type? 

I am trying to write a two part DataMig (MS_FORECAST_FILE to load the data then MS_FORECAST_MIG to schedule the import for each part) to load data using:level_1_forecast_util_api.Schedule_Import_Forecast  The first job to load the data works fine and I get an IC table ready for the 2nd DataMig job.To test the SQL code for the ATTR values to pass to the API call, I have a working PL/SQL cursor...begin  for ic in (select * FROM IC_MS_FORECAST_FILE IC) loop    level_1_forecast_util_api.Schedule_Import_Forecast__('CONTRACT' ||                                                         CHR(31) ||                                                         IC.CONTRACT ||                                                         CHR(30) ||                                                         'PART_NO' ||                                                         CHR(31) ||                                                         IC.PART_NO ||                                                         CHR(

Hello, I am wondering if I am able to export current information source in business reporter and import to QIS for a duplicate source with additional information. I tried the export of original information source as .ins and .xml. When I import however to QIS it does not read the .ins and errors the .xml file.

Used a migration job to load starting inventory but it doesn't appear in the GL or inventory transaction history. (Inventory Parts in Stock is correct though) 

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.

The standard customer invoice templates facilitate to load advance customer invoices. Can they be connected with the customer order number when loading? The reference fields can be used but it will not connect the customer invoice with the customer order.

Please I am having this IFS error of insufficient privilege while spooling report to excel, and the select privileges on the table have been granted already. This spools correctly when a normal report is run, but fails when I choose Export to ExcelError message: "Excel Plugin Error: ORA-06550: line 11, column 26: PL/SQL: ORA-01031: insufficient privileges"  

Hi,I am using a GIS server to have a map with objects in IFS.I also configured the GIS proxy in IFS but when I have a look at the documentation it says the new config should be populated with a background job called "GISINT - Refresh proxy configuration" but on my systems this job is missing.How can I populate the new proxy configuration and why is this job missing though it is described in the documentation?Thanks for any hint,best regards,Nico

does anyone know where the system set up is for shortages? , getting following error when trying to load inventory parts - ORA-20110: InventoryPart.NOSHORTAGEHANDLE: Cannot have shortages at part level if System flag is set to No.

Hi,Is there any way we can achive the below through migration ? I have 2 method calls in method list Method1Method2how can we use the out parameter from Method1 is and use the same in Method2 ? Thanks in AdvanceAmitesh

Hi all, Can to convert the status of structures from Tentative to Buildable in one move? Best regards,Ozge

Hi!How can we log in to Excel plug in using IFSAPP when we have SSO enabled? non of the checkboxes in the picture makes any differences.Best regardsAlbin