Data Migration

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

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.

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"  

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!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 

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

I have the below Data Migration query from a customer and I wanted to check if there is a standard guidance for this? When a customer goes live half way through an active project which was more than one or two years what is the best mechanism for data migration. -App10 I want to confirm which all connections the customer would need to consider to migrate (Sub Contracts, Sales Contracts, Purchase Orders, etc) and how can they manage open PO’s, Sub contracts? How would you recommend to move the Used/Actual cost? Assuming they wouldn't need detailed historical transactions, would it recommended to create Cutover activities and bring in the values in this new activity? Anything else they would need to consider before they start with this process?

When a customer wants to implement Project Module for the first time, how can they bring in closed POs, Invoiced time transactions, other project transactions to reflect the actual and used costs in the project?

I want to import data into a custom logical unit using Excel Data Migration but one of the fields is a Referenced fields?Data sample to import.Custom object to import into.  Referenced object Migration Job.

Hi, We use 21R2 on IFS Cloud and try to use Excel Data Miogration.I downloaded Excel DataMigr Manifest from IFS but when I try to import it in Excel  I have a certificat error.Do you an idea about this ? Regards, Christophe

Where can I find detailed information on how to perform data migration end to end. There is not much detail at this location: https://docs.ifs.com/techdocs/Foundation1/010_overview/260_data_management/010_fndmig/default.htm

We have created a manifest (xml) from our test environment (IFS Cloud 21R2). Manifest is added to Excel successfully and the user can log on and load the FNDMIG job itself. But when trying to load the data this error occurs: Insufficient privileges, "SE_UNAUTHORIZED".The user has full grants in the instance.  

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

Hi, I get an error when I try to update the parts catalog weight if the number is equal to or less than 0.00001.For Instance: But the same value can be specified in IFS without any problem: The migration job is very simple: Has anyone already had a similar problem?Thanks for your feedback. Kind Regards,Daniele

I am attempting to run a Insert/update into a specific container in the VIM module in Cloud 21R1.  To  ensure I have the right values I have created a lobby source to validate the information.  See attachment lobby data source.   When I unpack the file I get an error message reflecting ‘Error formatting numeric value xxxxx for Seq No  Any assistance on how to address this would be appreciated. on how to get around this challenge 

Data Migration Tool Kit (Have been majorly used in US side)IFS Smart Data Tool (New Migration Tool Launched around 2 months ago)

I want to bulk upload some new parts (part cat, inv part, sales part), structures & routings.I though there were some standard CSV formats & migration import jobs as part of  the “Apps 9 Toolbox Standard Data Migration Jobs” that allow you to just prepare the data in a specified CVS format and then upload using a standard migration job. Is anyone aware of this? Are there such standard upload CSV templates & jobs? Thanks

Hello All. I have some data in a flat file where columns A to C are header information and columns D to G represent line information.  Is it possible to use a master/detail migration on this data to import it into IFS as a header and associated lines without manipulating the data further? The data will come from an external system regularly so minimal manual processing of the data is a requirement.  Has anyone done this before and are you able to share the setup/config you have in the migration jobs?

Hi,Can some one provide the steps for Cutover strategy in IFS and what are key points to be noted prior to data migration in Finance. Thanks & Regards,Srichand 

A customer of has asked whether we can enhance some information displayed in the shop order work-guidelines by including information from a source reference manual.Currently not all operations are contained within a shop order routing or the work-guidelines, however technicians can access these via a Customer RMB into the 3rd party tool as the manuals are not stored in IFS but rather a central repository. The question is therefore is it possible via either Data Migration or IFS connect to fetch source data from an external system and then to insert it directly into the relevant container in IFS Apps10.   The reference needed to be passed between IFS and the source is currently contained on the SO Order Operation as a column.   It is understood that the source is not currently available as xml but rather as structured PDF!.

Hi,Want to know whether external file template or data migration can used as a method to issue inventory material by Material Requisition Bulk.

Hi,  Currently I’m having the need of updating data daily to inventory_part_planning view. And I was recommended to use INSERT_OR_UPDATE procedure for this. How can I selectively update just for some fields, e.g safety stock, order point? Much appreciated if someone has a user guideline for this type of procedure.