Data Migration

This will include topics related to data migration.

  • 407 Topics
  • 1,069 Replies

407 Topics

J
Do Gooder (Customer)
jonathanBRUGEREDo Gooder (Customer)
asked in Data Migration

Database Task error because no found path

Hello,  I would to shedule a task pour generate a XML.in the first picture we can see a parameter of my reporting.Creation of database task et then sheduling with parameter​my problem is the PATH parameter. I put the output path of my file .xmlWhen i run my task , IFS can’t find the path \\vm-data-grp\bureautique\Extractions\IT i try to make or not the name of xml , same result.Is the syntax good ? I can go to this path too when i’am connected since database serveur. I don’t know why the path is wrong... Thank you For information i execut this process in the database task. The folder exist :  

1
M
Do Gooder (Employee)
1 year ago
S
Do Gooder (Customer)
SondrumDo Gooder (Customer)
asked in Data Migration

Changing Units of Measure

Hello;        I’m new to IFS & I’m quite surprised at the difficulty there is in changing a unit of measure. I’m a designer, & a portion of my former company was acquired by another who uses IFS. In the process there was a lubricant that got transferred & the unit of measurement was a pail. I’m not sure what the correct unit is but that wasn’t the unit it was supposed to be. Instead of being able to correct the unit, my main division of the company is saying the only thing we can do is create a new part no. with the correct unit of measure. This lubricant is used all over the place in 103 boms & 93 drawings which would have to be changed. Is this a limitation with IFS, & if it is, why would it be. I believe with our former system using CMS, we would have just revised the unit, & been done with it. I should add, it has already been used which seems to make it more of an issue.Thanks for any input in advance. SonDrum

4
S
Do Gooder (Customer)
1 year ago
J
Do Gooder (Customer)
jpartanenDo Gooder (Customer)
asked in Data Migration

Migrating data to custom field from different site

 Hello, How should I approach this kind of data migration / Custom object usage? The need is to show inventory part’s newest revision from on inventory part main page. I have created Custom object like this to General page of “Inventory Part“ The problem is that in our environment this Revision information is saved only on different site (So called Master site) and 90% of users do not have access this site. Would it be possible to use somekind of migration job to get Revision data from master site part revision tab and save it to this custom field? Revision information on Inventory Part Revisions Tab Custom field “Revision”. Data is from Master Site and without user’s access right to Mast site, this does not work.   

0
J
Do Gooder (Customer)
1 year ago
eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
asked in Data Migration

Use of Excel Migration Jobs

In a number of threads I've read that regular (older) Migration Jobs (FndMig) are not the favorite anymore. One better uses Data Migration Manager.Where does that leave Excel migration jobs? They are linked to FndMig, as far as I know.If FndMig is deprecated and may not be available anymore in coming versions, where does that leave the implementation/explanation of Excel migration jobs?Is it better for consultants not to mention that it exists?Is it better for customer not to start using them or trying to remove them from the possible functionality to use in IFS Cloud?I'm interested in your thoughts,Steve

1
ERHEUS
Do Gooder (Employee)
1 year ago
P
Do Gooder
peak0610Do Gooder
asked in Data Migration

Creating an Excel Migration job (IFS Applications 10)

Hi When I try to create an Excel Migration job, I got an error as below. What is the base view. Why the SITE_INVENT_INFO is not a base view.Thanks & RegardsPeak 

3
T
Do Gooder (Partner)
1 year ago
ynwkm
Do Gooder (Customer)
ynwkmDo Gooder (Customer)
asked in Data Migration

ORA-20124: Error.INVALIDKEYVALUE2

ORA-20124: Error.INVALIDKEYVALUE2: Character [5] is not allowed as key value [PART_NO].Does anyone know what the error above refers to?This happens when I try MTK.

0
ynwkm
Do Gooder (Customer)
1 year ago
T
Sidekick (Partner)
TopDeepaWSidekick (Partner)
asked in Data Migration

Data Migration - Invoicing Plan

Hi, I'm trying to migrate invoice plans details using migration job. But it is not loaded Sub project ID and Activity ID columns to the File mapping tab. What would be the reason for that?    

1
S
Do Gooder (Employee)
1 year ago
ynwkm
Do Gooder (Customer)
ynwkmDo Gooder (Customer)
asked in Data Migration

Error in Select: ORA-00904 Invalid Identifier

Why is this error popping up?Would love help on this.Thank you!

5
W
Hero (Partner)
1 year ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Data Migration

Crystal Report Customer Order Confirmation

We have our Customer Order Confirmations printing through Crystal Reports. We recently set up a new site. These reports are not showing any information for the new site when we print a confirmation. Is there something in IFS I could be missing for the site set up? Or is there a spot in IFS that tells Crystal which site’s are allowed for this? I looked at the crystal report file itself and it doesn’t seem to be doing anything with the site. 

4
C
Sidekick (Customer)
1 year ago
C
Sidekick (Customer)
Christian CordiusSidekick (Customer)
asked in Data Migration

Excel Migration Job - Help to delete/remove records

Hi Community,Is it possible to delete/remove records using an excel migration job? I’m trying to delete/remove users for WaDaCo processes but unfortunately i cannot solve it.. I have added ‘DATA_CAPT_CONF_VALID_USER_API.Remove__’ in the Method List. An example could be to delete/remove all users for our scanner ID6: The migration job has the current setup:   I’ve also tried different setups. Example in the method lists to use ‘%’ in Column value and DUMMY in Column Name.  

2
C
Sidekick (Customer)
1 year ago
ynwkm
Do Gooder (Customer)
ynwkmDo Gooder (Customer)
asked in Data Migration

The IntFace Detail Already Exists

Would like help on why this error pops up.I have refreshed the page before trying to create this Migration Job The Job ID does not exist in the Migration Jobs pageThank you

2
ynwkm
Do Gooder (Customer)
1 year ago
V
Do Gooder (Customer)
VT_VKOLBDo Gooder (Customer)
asked in Data Migration

Excel Migration Job - integrity constraint error

I have a Migration Job that uses the Excel Add-In and some of the custom fields are linked to views/tables, so I understand that the “_DB” value will be that of the OBJKEY/ROWKEY.  What I don’t understand is why I am receiving an integrity constraint error for NULL entries of the “_DB” columns.  one of my errors: “integrity constraint (IFSAPP.BUSINESS_OPPORTUNITY5_CRK) violated - parent key not found”how can one prevent this for NULL values for non-mandatory custom fields? Sincerely,Vince K.

6
V
Do Gooder (Customer)
1 year ago
S
Sidekick (Partner)
sfaureSidekick (Partner)
asked in Data Migration

Excel Add In : Not able to modify/create/delete users

Hello,In migration Job, I would like to create a quick excel migration to modify a value of the field Tax_Liability in the LU Customer_Delivery_Tax_Info.But impossible tu update this field, excel add in refuse to let me modify this value. “Access denied. User SFAUR is not allowed to add/edit/delete users in the company”I tried with IFSAPP but same result… What is the option to grant me the right to update this kind of field !?

5
J
Do Gooder (Employee)
1 year ago
J
Sidekick (Customer)
jtobinSidekick (Customer)
asked in Data Migration

ORA-20112: SalesPart.FND_RECORD_EXIST: The sales part already exists

Hello, We are using Apps 10, UPD13. We have sales parts in SITE1 (approx. 500K) and are trying to create the same sales parts in SIT99 using the script below but are getting an error message that the part already exists. They already exist as inventory parts in both SITE1 and SIT99.  Is anyone able to help us with resolving the error and creating the sales parts in SIT99 that already exist in SITE1? Thank you,Joann DECLARE  p0 VARCHAR2(32) := NULL;  p1 VARCHAR2(32) := NULL;  p2 VARCHAR2(32) := NULL;  attr_ VARCHAR2(32000);  action_ VARCHAR2(30) := 'DO'; CURSOR get_part_info_ IS    SELECT i.CONTRACT, i.PART_NO, p.CF$_SALES_GROUP    FROM  inventory_part i     left outer join sales_part s     on i.part_no = s.part_no     and i.contract = s.contract     left outer join    PRODUCT_CODE_X_REF_CLV p    on i.second_commodity = p.cf$_comm_group_2    and i.part_product_code = p.cf$_product_code    where     i.contract = 'SIT99'     and i.part_no like '%2'     and length(i.part_no) = 11     and s

4
J
Do Gooder (Employee)
1 year ago
J
Sidekick (Partner)
jporterSidekick (Partner)
asked in Data Migration

22R1 - New Employment Assistant error message

When trying to add employees through New Employment Assistant, upon clicking Finish button, an error message appears that states "The Employee Employed Period already exists." We think this is related to challenges with the DMM Data Migration tool.  The issue has to do with the EMP_EMPLOYED_TIME table. That table has a SEQ_NO field in it that is the primary key and was loaded during data migration. The Aurena client has a reference somewhere to a SEQ_NO that increases by 1 each time we try and save a new employee record. Somehow (possibly through the data migration process), the value in the client came out of sync with the underlying database. If you click save enough times (several thousand based on our load), it will eventually work and go through as the console log shows that each time someone clicks save, the SEQ_NO value in Aurena increments by 1. We need to have a way to reset the SEQ_NO for the EMP_EMPLOYED_TIME table that is stored in the Aurena client and set it to the next v

0
J
Sidekick (Partner)
1 year ago
M
Do Gooder (Customer)
mdeantonDo Gooder (Customer)
asked in Data Migration

Migrate activities to new project

We are doing a project re-organization and need to move activites under newly created projects. Would this be possible using the data migration tool or is it even possible?

0
M
Do Gooder (Customer)
1 year ago
T
Sidekick
TAHERSidekick
asked in Data Migration

migration on risk assessment page

hi every one I have issue on migration job for inserting data to risk assessment / hazards I cant insert data for frequency and severity fields   pls help!!! 

1
M
Hero (Employee)
1 year ago
H
Do Gooder (Partner)
HVeonDo Gooder (Partner)
asked in Data Migration

Apps 10, User use Aurena to run FNDMIG job

In Apps 10, the set up for a Migration Job is in IEE.  Is there any way for a user to run an existing job from the Aurena interface?

1
M
Hero (Employee)
1 year ago
G
Sidekick (Customer)
GDrysdaleSidekick (Customer)
asked in Data Migration

Sales Price List Part - Data Migration Error

HiI am migrating into Sales Price List Part (SALES_PRICE_LIST_PART)Method List is set to New and Modify.Ran the migration job and all records were imported.When I re-run the Migration Job I get an error ORA-20112: SalesPriceListPart.EXIST2: The Sales Price List Part object already exists.Does anyone know why I get this error? teh record does exist so it should be doing an update now, not an insert!Cheers,Graham 

2
G
Sidekick (Customer)
1 year ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Data Migration

IFS 10 Upgrade

We recently found an issue where we had to turn on a Data Mart Source. I noticed that all of them are set to inactive. Should they be active after an upgrade to 10 from 9?  Thanks!

0
C
Sidekick (Customer)
1 year ago
T
Do Gooder (Customer)
Thomas RebmanDo Gooder (Customer)
asked in Data Migration

Is there an issue with the fixed assets import?

Import fixed asset is not working properly.  Below is the test plan:Create an FA object with valid from date 8/30/2016, assigned to an object group with SL BP for 7y0m. Import the object with acc. Depreciation value for year 2022, period 12. Post the import transactions. Create a new depreciation proposal for the object above for year 2023, period 1, review the proposal, you will notice the depreciation will fully depreciate the object with the remaining residual value.  That is incorrect.  The object should still have another 8 months to depreciate. If you would like to review our data, object id TEST2 is done via external template, object id TEST3 is created in the system, both with the same issue.  The testing data is on my UAT database (URL: IFS Cloud). We are currently on IFS Apps 8 but not using the fixed assets module.  

16
G
Superhero (Partner)
1 year ago
E.Mamcasz
Do Gooder (Partner)
E.MamcaszDo Gooder (Partner)
asked in Data Migration

Migration Job for Object Measurements

Has anyone ever created a Migration Job for Object Measurements in IFS App10? We are trying in various ways and still no success.I would like someone to share their experience. 

2
E.Mamcasz
Do Gooder (Partner)
1 year ago
O
Do Gooder (Customer)
orscdpierceDo Gooder (Customer)
asked in Data Migration

ORA-20111: ExtPayParameter.NOTEXIST2: The Ext Pay Parameter object does not exist.

Trying to set up an External File Template to import Customer Payments.  Whether I use a system-provided template or one I set up on my own using the great advice in this community, I get this error:  “ORA-20111: ExtPayParameter.NOTEXIST2: The Ext Pay Parameter object does not exist.”  For example, I’ve tried the system template CUP_USCUSCHK.  Does anyone know what this error means???Thanks.

2
O
Do Gooder (Customer)
1 year ago
G
Do Gooder (Customer)
GDFMNICHOLSDo Gooder (Customer)
asked in Data Migration

How to remove double quotes from a CSV integration when opened with notepad++

I am trying to do a CSV integration export in which when opened in Notepad ++, it doesn’t have leading quotes (“). I am trying to send this file every week to a customer via EDI for billing and the testing keeps failing because of this.Attached is the integration I am testing and the file with the issue.

1
G
Do Gooder (Customer)
1 year ago
H
Do Gooder (Customer)
HDZSTEPHANIEDo Gooder (Customer)
asked in Data Migration

Getting Failed to initialize job ORA-20110: IntfaceDetail.NODET: No details found for HMH_CUSTOMER_INFO

I am trying to migrate a small customer file (only 4 records for testing) and am getting the following error:  Failed to initialize job ORA-20110: IntfaceDetail.NODET: No details found for HMH_CUSTOMER_INFO Any ideas out there?THanks,Stephanie

4
V
Do Gooder (Customer)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings