Data Migration

I am looking to create a migration job which reserves available material each morning for open material requisition lines. I have followed steps outlined here but could not make the jump from the Customer Order to the Material Requisition. Here is my current setup. I am not sure on the Source Mapping and for some reason  Part_No is not listed as a column name even though I see it when testing the API using Postman. SELECT MRL.QTY_DUE - MRL.QTY_ASSIGNED, MRL.ORDER_CLASS, MRL.ORDER_NO, MRL.LINE_NO, MRL.RELEASE_NO, MRL.LINE_ITEM_NO, MRL.QTY_DUE - MRL.QTY_ASSIGNED, ROWID FROM MATERIAL_REQUIS_LINE MRL WHERE MRL.STATUS_CODE IN ('Released','Reserved','Partially Delivered') AND (MRL.QTY_DUE-QTY_ASSIGNED) >0Select statement OK, parsed and executed for 1 row Length of statement : 289 characters MATERIAL_REQUIS_LINE_API.MAKE_LINE_RESERVATIONS    

Dear IFS Community,someone know how to import user companies with a migration job on IFS CLOUD ?I created migration jobs for users, user permsissons, user sites but no way to make a user companies import for 500 users.View name “COMPANIES_BY_USER” unavailable on migration jobs.I can’t make an import for user passwords also but I think it’s not possible unafortunately.It’s a mess to manage users because we can’t add a field. No way to search with user groups, personally I am forced to have an Excel file with additionnal information to search Identity “user1;user2;user3;user4;user5...” (and it’s not working if there is many users in the search.Thanks

How can the data be migrated into IFS cloud? Like we want to migrate some companies/sites/their users/service requests from legacy system to IFS cloud.

Hi All,We are currently in the process of upgrading from IFS 8.0 to IFS Cloud.In the 8.0 application, we have a modification that allows you to load files directly from excel (xls) to data migration. According to the latest information in IFS Cloud it is impossible.I have a lot of migration tasks which create tables (procedure: Create_table_from_file). Have you some idea how to fulfill this tables using xls files? I don't like csv files.

I am trying to use an end user log in in order to create custom SQL reports using Oracle SQL Developer. Currently the user permission does not allow me to access any of the views or APIs for reference. What permission is necessary to view the tables and APIs? 

IFS 8 Exe Config File and Its Related FilesHi All, currently I have the IFS 8 Exe Config File and Its Related Files, which we are using it to run a batch file job for the migration tasks in IFS 8 however we are migrating over to IFS 10 and thinking about doing the same for IFS 10, does anyone have any idea how do I obtain these same files for IFS 10 ? 

Hello, In Apps 10, I am using the MTK to migrate Customer Orders, and receiving the following error for a collection of about 500 Customer Order Lines: ORA-20124: Error.NULLVALUE: Field [DEFAULT_ADDR_FLAG] is mandatory for Customer Order Line and requires a value. I saw a previous post for this issue, but in that post the OP was running a Simple Tool migration job, not using the MTK. There is no DEFAULT_ADDR_FLAG column in MTK_CUSTOMER_ORDER_LINE_TAB; rather, the value for this column is derived within MTK_CUSTOMER_ORDER_API:  if the Ship Via Code on the Customer Order and Customer Order are the same, DEFAULT_ADDR_FLAG is set to ‘Y’; if they are not the same, DEFAULT_ADDR_FLAG is set to ‘N’. Wondering if anyone has encountered this error before with the MTK. Thank you in advanceBob

Hello, I’m trying to load data into IFS Cloud using Excel Migration. When I load the data to Excel sheet and try to validate the records vis Excel Add-In login, I’m getting the error:Any suggestion, how to fix this error? Thanks

is it possible use select * from 'excel file' then insert into 'table' by plsql script?

HI, does anyone have detailed instructions on how to migrate open fixed assets into IFS Cloud. Thanks

Dears, I am new on IFS CLOUD, MY question is :there is migration job already exist I want add new view like(order-line_stage_billing40) to add new stage How I can do that ? Please I need urgent help.

Hello,Is it possible to set up a Batch external file job to handle dynamic file names?  I tried putting an asterisk (*) at the end of the file name within the External File Template but that produces an error saying the file cannot be found.  

I have some success organizing different task and streamlining the process by using the “Own Process” functionality.It has enabled my team to create custom menus, RMB, conditional formatting, and conditional fields to keep the user experience pretty clean without introducing extraneous options when not applicable. To start, I have had interns work on designing different Own Processes under their own account, as proof of concepts. I don’t want to alter their permissions to allow access to base profiles in order to publish their pages. And I would love not to have to recreate these individually under the base profile as it would be quite time consuming and double work. Is there a way to export these Own Process versions of pages?I know I can save all my RMB separately and import them, as well as any lobby elements we have mapped to forms or pages. Sending these pages to others via “Stream or Email” only send a link to the original configuration of the view. I really need a more efficient

After creating a  external file type & template, when I added another record type with different view and checked for definition validity of template one error message comes up . Besides, external file template turns into invalid. Screenshot is attached here. Could anybody please suggest me about the issue here ??? 

How do I specify a range of dates of type DATETIME in the Excel-Addin search screen of IFS Applications?

Hi, I have customer who is into an Upgrade project from IFS Apps 8 to IFS Cloud.How do we manage the Data Migration of the existing data into IFS Cloud?For Example: We migrate the Inventory Parts, Inventory Stock etc.How about the LotBatchMaster, LotBatch History or Part Serial History windows?Does this needs to be migrated as a part of the Upgrade project?

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 ? 

Hi, I keep getting the error: ORA-06511: PL/SQL: cursor already openwhen executing below, can someone please tell me why:- DECLARE    info_ VARCHAR2(2000);    attr_ VARCHAR2(2000);        newrec_     identity_invoice_info%ROWTYPE;        automatic_pay_auth_flag_db  VARCHAR2(1):= '1';        CURSOR get_supp IS    SELECT * FROM IDENTITY_INVOICE_INFO;       BEGIN  FOR rec_ IN get_supp LOOP     OPEN get_supp;   FETCH get_supp INTO rec_;   EXIT WHEN get_supp%NOTFOUND;   CLOSE get_supp;                Client_SYS.Clear_Attr(attr_);                   Client_SYS.Add_To_Attr('AUTOMATIC_PAY_AUTH_FLAG_DB',automatic_pay_auth_flag_db,attr_);                        IDENTITY_INVOICE_INFO_API.Modify__(info_,rec_.objid,rec_.objversion,attr_,'DO');        END LOOP;    COMMIT;END;

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

Hi All,How we can use Project basic data setup in DMM and how we can import DMM project export file with any sample data and from where we get DMM project file for importRegards

Hello!I am attempting to create a new Excel Migraton job within IFS (Apps 10) and I am running into an issue.  Upon trying to validate any data that I put into my excel sheet for the job I get an error stating “Error loading migration job info User - Defined Exception”.Error When attempting to use the “validate” function.Below is the current configuration of the migration job.  I have tried several different defaults and tried enabling all fields and manually entering them within the job but have gotten the same error every time.  I have successfully created and used several migration jobs in the past but have never seen this error before. Formatting page configurationSource mapping configuration Method list configuration​Rules configurationUltimately, I am trying to create an add-in job that I can use to create new records within a Sales Price List (Below) Any ideas or help would be greatly appreciated.  I do not want to enter all of these entries by hand f I can avoid it.Thank you!

When I loaded data in to out test environment the timeslots are moved to +1 hour. For instance 08:00-16:00 becomes 09:00-17:00. This is not the case on our dev environment so there must be a setting somewhere to change the behavior, but I can not find it.

I have set the file type for 2 views (Header & Line) Material requisition ( MATERIAL_REQUISITION  & MATERIAL_REQUIS_LINE ) but row status unpacked.any suggestion from anyone. how to solve this issue. Please see the steps of data setting after transaction screenshot.   

Hi, As we tested, for Data Migration Tool - Repliation procedure21R1 - exist21R2 - NOTexist22R1 - NOT exist22R2 - exist (again) To be honest , we pretty confused with this Roadmap,so, can we use this feature in 22R2 , what if we Release Update to 23R1 , will it still be there?

Does anyone know how to solve this error?