Data Migration

463 Topics

WSHAHDo Gooder (Customer)

Documents on IFS Data Migration Tool Kit/IFS Smart Data Tool

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

2 years ago

TomBeresfordDo Gooder (Customer)

asked in Data Migration

Apps 9 Toolbox Standard Data Migration Jobs

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

2 years ago

Chriswharton22Sidekick (Partner)

asked in Data Migration

Flat File - Data Migration

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?

2 years ago

SrichandSidekick (Partner)

asked in Data Migration

Cut over strategy

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

3 years ago

ADTonyDo Gooder (Employee)

asked in Data Migration

Fetch source data from 3rd party product

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

3 years ago

Venkat04Sidekick (Partner)

asked in Data Migration

Issue material in bulk - MR

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

3 years ago

hazelmsSidekick (Customer)

asked in Data Migration

INSERT OR UPDATE procedure of data migration

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.

3 years ago

TAPSUDJAYSidekick (Customer)

asked in Data Migration

Data Conversion Issue in Data Migration Job

We are in need of migrating employee clocking information from a client’s system to IFS. I’m trying to set up migration jobs to get the data into TIMREP_TRANSACTION. However I seem to have an issue getting the time stamp info due to the data format. In the view and the DB table, Time stamp (REG_STAMP) is of DATE type. To have the date and time in that format I had to use custom option in format cells in Excel. When I do that, I have to have the corresponding field in the migration job to get the data into the intermediate table as VARCHAR2. I tried DATE format but then the data cannot be loaded due to a format error.But then I get the following error, when I try the second migration job I’ve set up to get the data from the intermediate table to the actual database table.The source data migration job has the field as DATE type. Clearly I need some sort of data conversion in between. But I’m struggling as I cannot figure out how to do it. I would really appreciate it if anyone has some

3 years ago

MR10Hero (Employee)

asked in Data Migration

Excel Data Migration Task Pane

Maybe a stupid question, but what do I need to do in order to get back the task pane from the Migration Jobs when they are gone in Excel? When I close this screen, I need to disconnect and connect to get this back, I can't imagine this is the prescribed way to do this.

3 years ago

KIMKIMANDREWHero (Customer)

asked in Data Migration

Data Migration of CLOB fields

I’m trying to copy a CLOB field from one table row to another.Is this possible with Data Migrations?

3 years ago

AIDTrevorJDo Gooder (Customer)

asked in Data Migration

Automated import of external file to data load table

ASystem: IFS Apps 8 (Currently)Hi, I'm new to the community and fairly new to IFS. I have a requirement within the business that on an agreed schedule it will automate a process in IFS, where an external SQL based system produces a file which can be automatically imported into IFS and used to generate new projects. e.g.Step 1@19:00 the External Systems produces an external text file: Pipe Delimited and columns encompassed in double quotes ("")Step 2@19:30 IFS imports the data into a temporary tablestep 3@ 19:45 a scheduled event activates andValidates the imported data in the temporary table creates new Project records based on the data in the temporary table emails users to notify of any failed transactionsSteps 1 and 3 are in place, I’m having problems with step 2I have looked at the data Migration tool and can't see how to schedule and completely automate the steps in completing this, load file, save and importI have also looked at the external file tool and am a totally bemused by

3 years ago

CedDinesYSidekick

asked in Data Migration

Data Migration with multiple default values

Hi Guys Wondering if someone can help me with a data migration query.Scenario:As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery and Document which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE) Created a migration job to insert new Customers, Addresses and Address types (third highlighted view as below) Migration job works fine and creates first default value i.e. Pay But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice? Thanks in advance/D

3 years ago

DevBobSidekick (Customer)

asked in Data Migration

Migrate Job: Execution Error...

We’re getting this error when updating a custom field in Customer_Info_Cfv created/added at data migration.It’s a simple update with just the CustomerNo and the new custom field, MS Set.Any ideas what to correct?

3 years ago

CheHiroyKDo Gooder (Partner)

asked in Data Migration

Data Migration/Execute Job function error message

Hi, This is my first time to use Data Migration/Execute Job function.When I did that, received the following error message.Where should I check for this?"interfaceDetail.NODET:No details found" Thanks!Kind regards,Kokubo

3 years ago

satwikgsDo Gooder (Partner)

asked in Data Migration

Data Migration

HiNeed to understand in FSM whether or not possible to migrate the Historical data. I mean to say that Previous year all requests which are even closed /completed along with its transactions from’ Request to Invoice’ can this be done. As the customer wants to decommission the old systems and data to be ported back on to IFS FSM.Any inputs to this will be of great help.Thanks in advanceSatwik G S

3 years ago

RutJWhalenSuperhero (Partner)

asked in Data Migration

Delete records using Data Migration

Is it possible to delete records from WORK_SCHED_ASSIGN using Data Migration and WORK_SCHED_ASSIGN_API.Remove__ Can anyone please advise how this is done.

3 years ago

Abid MujawarSidekick

asked in Data Migration

DATA MIGRATION TOOL EXCEL

Hi There,I am using Attached excel Data migration tool,After Copying data from Excel, unable to paste in IFS (no Option to paste). it was working fine before OS Upgradation on my DESKTOP. Can somebody help me out please. Warm Regards,Abid

3 years ago

harshamc00Sidekick

asked in Data Migration

IFS North America data migration toolkit (MTK) auto loaded basic data

We are using the North American Migration toolkit for a data migration and some missing basic data get loaded automatically. (For example Organization codes). We need to get the list of these records and does anyone know about a view or report which can be used to fetch this information ?(** Note that “Data Migration Applications\Reporting\Auto-loaded Basic Data\Auto-Loaded Detail” does not show anything and I’m not sure whether this is bug**)

3 years ago

AdarshSidekick

asked in Data Migration

Anyone have ppt of Data Migration and integration (IFS 10)?

Hello Guys, Very appreciate for us, if someone share PPT of above subjected line.

3 years ago

atvanstSidekick (Customer)

asked in Data Migration

Access to data migration table

Does anyone knowwhat needs to be granted for end user to be able to query the table created by migration load job, these tables are created with format IC_XXXX_TAB ?

3 years ago

RutJWhalenSuperhero (Partner)

asked in Data Migration

Data Migration Job keeps hanging when ran without CHECKOPTION

My data migration job keeps hanging when ran without CHECKOPTION. It eventually errors with the following message: Error occurred while calling ../main/admin/plsqlgateway/AccessPlsql/Invoke?frmIntfaceStart. Please contact your system administrator. Error 502 - Bad Gateway Has anyone come across this before and if so, could you please point me in the right directions.

3 years ago

matkarDo Gooder (Customer)

asked in Data Migration

Parameters in Data Migration where clause?

Hi!Does anyone know if it’s possible to use any kind of input parameters in a Data Migration where clause? In case you want to run the same job multiple times but using different input parameters without the need of edit the where clause statements every time..\Mats

3 years ago

STMVALENTINESidekick (Customer)

asked in Data Migration

Media Items in Media Library - Mass Import

I am using IFS Apps 9 and would like to know if there is a way to mass import media items (images) in a folder and then associate them with inventory parts. The images are named by the inventory part number.Could this be a data migration job…?Anyone done this type of import before, or similar?Any help would be appreciated.

3 years ago

evrpatrinDo Gooder (Partner)

asked in Data Migration

Excel Data Migration Tool

Hi,I’ve used Excel Data Migration Tool before. But now I got this problem that when I try Validate or Execute, Excel-Add-In reads everything to the first column. I have a simple example with 2 columns A and B. But Excel-Add-In reads both column A and B to the first column. So the value for column A is getting to long and the value for column B is left empty.Is there some configuration for this. Thankful for ideas.BR,Patric

3 years ago

BartMaasDo Gooder (Partner)

asked in Data Migration

Migration of Closed Purchase Orders

Hi all, I received the below question from one of our APPS8 customers. They want to migrate closed PO's from their old ERP system into APPS8 (Customer recently aqcuisitioned new business).. My idea was to migrate the PO's with No Parts instead of Part lines, but I'd like to double check with the community!-------------------------------The question is if there is a way to migrate closed POs and what is the impact to postings. We will only go for a migration of No Part POs. If we are migrating POs with the status closed is there a posting connected to the status? Is this on kicking of the system functionality of posting a GRNI? If there is no posting linked to the status in the data migration, how is the matching of the invoice to the PO working? We will post an opening balance in IFS which is the closing balance of the old system. In this one we have the GRNI amount from the closed POs of the old system. So now we need to reduce this balance when we match an invoice to the closed PO wh

3 years ago

Page 18 / 19

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded