- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
IFS Solutions
Data Migration

Data Migration

This will include topics related to data migration.

414 Topics
1,081 Replies

When you subscribe we will email you when there is a new topic in this category

414 Topics

Recently active

Most replies Most views Newest first

VT_VKOLBDo Gooder (Customer)

asked in Data Migration

Migration Job (Excel) - Not Performing Updates

I have the exact same Excel Migration Job over BUS_OBJ_REPRESENTATIVE in our DEV and TEST environments and they do not perform the same. The migration job in DEV will perform a modification as expected and return the “Updated” result.The migration job in TEST will not perform the requested update and returns a result of “Business Object Representative already exists”. of course it exits, I want to update the “Representative Type” associated with the record.We have check all permissions and have no idea what would be causing the difference in functionality.Any help is greatly appreciated. Sincerely,Vince

JannetteCHero (Customer)

asked in Data Migration

Data Migration Manager - transformation rules

Hello all, I have just started using the IFS Cloud data migration tool, I am struggling to find out to set a concatenation rule on a column in the input container. I have tried doing as it suggests but the results are not correct. Hoping someone can advise.

DHCRADPASidekick (Customer)

asked in Data Migration

Basic Data Synchronization - Apps 10

I have one company (not the source one) which does not appear in the Target companies list. How can I include all existing companies in this window?

ksebfSidekick (Partner)

asked in Data Migration

Migration PM action calendar plan

Hello, Is it possible to migrate PM action calendar plan without using the intervals ?My customer would like to put in the migration job precise dates, but the system refuses this forced migration and asks us to generate the work order from the header of the PM action.

mmossSidekick (Customer)

asked in Data Migration

Make Line Reservations Migration Job

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

ERPDMORENASidekick (Customer)

asked in Data Migration

User Companies Migration Job

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

anushakhSidekick (Customer)

asked in Data Migration

data migration in IFS cloud

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.

addperpesDo Gooder (Partner)

asked in Data Migration

Excel migration issue with update of purchase_quantity_price

Hi,I have issues with running an Excel Migration job updating valid to date on the current price line on supplier price list (purchase_quantity_price). I get the familiar error “Object does not exist”, but I have all key attributes present and the same job works in another IFSAPP10 database for the same customer. The job is set so that the only attribute to be updated is “VALID TO DATE”. Has anybody had issues with updating purchase_quantity_price?I can say that creating new records works fine. B.RPer

bkpskoczylasDo Gooder (Customer)

asked in Data Migration

Data Migration in Cloud - xls file

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.

mmossSidekick (Customer)

asked in Data Migration

How to view tables or packages without IFSAPP

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?

asked in Data Migration

Retrieving IFS 10 Exe Config File and Its Related Files

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 ?

bgardnerDo Gooder (Partner)

asked in Data Migration

Apps 10 - Migration ToolKit - CUSTOMER_ORDER migration - Error on MTK_CUSTOMER_ORDER_LINE_TAB rows

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

SPRRAJDo Gooder (Customer)

asked in Data Migration

Excel Migration Error

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

lionDo Gooder (Customer)

asked in Data Migration

select * from 'excel file' then insert into 'table' by plsql

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

traceybooDo Gooder (Customer)

posted in Data Migration

Migrating Open fixed assets

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

NorahmfSidekick (Customer)

asked in Data Migration

IFS Cloud migration job

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.

chrisbriggSidekick (Customer)

asked in Data Migration

Dynamic file names for external batch file

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.

PhillBronsonSidekick (Customer)

asked in Data Migration

Own Process Share or Export

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

MohsinDo Gooder (Partner)

asked in Data Migration

External File Definition Validity Issue

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

Ryo AsadaSidekick (Partner)

asked in Data Migration

specify a range of dates of type DATETIME in the Excel-Addin

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

manjunath.rao01Do Gooder (Partner)

asked in Data Migration

Data Migration in Upgrade Project

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?

Tom_LuciferDo Gooder (Partner)

asked in Data Migration

ORA-20105: Dictionary.CLIENTNAME_IS_NULL: Cannot convert the client name [NULL] into a database name.

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 ?

signilsSidekick

asked in Data Migration

Cursor error - cursor already open

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;

asked in Data Migration

GIS proxy configuration - Background job refresh proxy config

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

WSHAHDo Gooder (Customer)

asked in Data Migration

Data Migration Manager

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

1
...
6
7
8
9
10
11
12
...
17

Page 9 / 17

Badges

hany45has earned the badge 1st Topic
neromehas earned the badge 1st Topic
jinefarhas earned the badge 1st Topic
menauohas earned the badge 1st Topic
loratehhas earned the badge 1st Reply

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK