Data Migration

This will include topics related to data migration.

  • 403 Topics
  • 1,065 Replies

403 Topics

mcmaf1
Do Gooder (Customer)
mcmaf1Do Gooder (Customer)
asked in Data Migration

Loading a new aircraft that we have had before in our system

Has any operators out there transferred an aircraft to another company and then tried to add it back to your fleet using the loader sheets and run into problems. Because there are historic tasks that remain in our system from the first time we operated it, the loader sheet validation is giving us an error message.AL-TASK-023 The task identified by SERIAL_NO_OEM, PART_NO_OEM, MANUFACT_CD, TASK_CD, and COMPLETION_DT already exists in MaintenixType: CRITICALIs there a way to get around this error to allow us to load the current dates/times/and cycles of the previous operators LDND? 

0
mcmaf1
Do Gooder (Customer)
5 hours ago
Y
Do Gooder (Customer)
YTC_MSTEINBRUCKDo Gooder (Customer)
asked in Data Migration

Voucher is not balanced in accounting currency issues

Hi, I’m currently trying to load some GL entries into IFS Cloud 10, and I’m having troubles with balancing the voucher, and I think it has to do with having very large numbers inside the .csv file that I’m trying to load. I’m including an image below to show that although the column does sum to zero according to excel, I am still getting the balance error when I try to load. There are four entries in this column that are extremely large, for example one of them is “206177399998227” so the .csv file does some formatting to it (scientific notation, showing as ######## if I don’t expand the column, etc.) and I believe this is what is throwing off the load. I was able to load other GL entries that didnt contain these super large numbers with no issues. I think this is more of an excel question, but I wanted to see if anyone here has had similar issues, and if so how were they resolved. Thank you! 

0
Y
Do Gooder (Customer)
1 day ago
N
Do Gooder (Partner)
NishithDasDo Gooder (Partner)
asked in Data Migration

Excel Migration with Custom field not working in IFS Cloud

In method list tab have added Custom view name and _CFP.CF_NEW__ method and kept only custom fields and INFO_, OBJID_, ATTR_CF_, ATTR_, ACTION_ but unable to add fetch condition below in RULES tab“PROJECT_MISC_PROCUREMENT.OBJKEY=PROJECT_MISC_PROCUREMENT_CFV.OBJKEY”getting below error while trying to add the fetch condition 

2
N
Do Gooder (Partner)
2 days ago
A
Do Gooder (Partner)
ArcAleksSDo Gooder (Partner)
asked in Data Migration

Migrating a package part to sales quotation via job

Hello,I am trying to migrate the Sales Quotation line with a package part and the following error appears:I set up the Line_Item_No as “-1”. I also indicated ORDER_SUPPLY_TYPE_DB and CATALOG_TYPE_DBas “PKG”.I think the cost should be fetched from the existing Package Part Structure.Could you please help

0
A
Do Gooder (Partner)
3 days ago
B
Do Gooder (Customer)
BABPAULSDo Gooder (Customer)
asked in Data Migration

Stock Tak-on

HiWhat would be the best way to take on Customer Owned Stock priced at zero cost?We manage serialised inventory and equipment and need a method of enabling our users to enter inventory where they stumble across it without any Req or PO.Is there a good API to use in an Excel Mig Job? Is there an IFS screen that I haven’t yet found 😀We are using Apps 9 SP11

2
B
Do Gooder (Customer)
9 days ago
A
Do Gooder (Customer)
ayagmurDo Gooder (Customer)
asked in Data Migration

Migration of users IFSAPPS9 to the Cloud

Hi everyone,I am currently working on a migration project which is happening IFSAPPS9 to the Cloud. I am having some difficulties with migrating the Users we have in the apps9. I have migrated those we will use partially. What I meant while saying “partially” is some of parts are missing (IAM user), and that’s made those not functional users. In order to migrate the other data I couldn’t find the related table in the database (at least the view name which is written in the debug console). After that I though maybe I can add the columns in the source mapping. However, I don’t know the flags and constraints, It was mapped wrong I believe (Because of entering wrong flags). Overall,1- Where can I find the table name in database for IAM or at least how can extract the data?2- If I have the flags, Can I do that migration with migration job or your advice will be something else?3- What is the best practice for migration of users depends on your experiences?Besides that I am open for any advic

1
Fikret
Do Gooder (Employee)
9 days ago
B
Do Gooder (Customer)
BlertaDo Gooder (Customer)
asked in Data Migration

Code String issue for Fixed Asset object

I have created External voucher for Fixed Asset object. When try to approve there is error Object has existing accounting transactions with code string that differs from the transaction to be created.How Can I delete or amend the line with error? I can’t do it on external load information. 

1
M
Hero (Employee)
13 days ago
A
Do Gooder (Customer)
AO0001Do Gooder (Customer)
asked in Data Migration

Sales Quotation Mig Job - Issue since UPD20

We have an existing migration job that worked until Update 20 was applied. The job adds lines to a sales quotation. Now the lines are added successfully only for rows where the customers price list has a value in the Discount Type field for the part in question. The job looks like this:The error returned is “Field [DISCOUNT_TYPE] is mandatory for Order Quote Line Discount and requires a value.”. The migration job doesn’t currently include a method list entry for the Order Quote Line Discount view so it isn’t possible to add a default value for this field: What we would like is to be able to add a default value if there isn’t one on the price list. Is there a way of doing this?

0
A
Do Gooder (Customer)
14 days ago
F
Do Gooder (Customer)
Fiona.KerrDo Gooder (Customer)
asked in Data Migration

Use 1 Data Migration job to Create a Maint Material Req Line with a link to Technical Attrubutes with 2 attributes

I have a file that I load using a MIG job of the type CREATE_TABLE_FROM_FILE.  The file contains a Task Sequence, Part, Quantity, Delivery required Date and 2 attributes that go on a Technical Class.I want to create one Mig job to load all the data into the MAINT_MATERIAL_REQ_LINE, the TECHNICAL_OBJECT_REFERENCE and 2 instances of the TECHNICAL_SPECIFICATION.I have triedbut it stops at the TECHNCAL_OBJECT_REFERENCE when it cannot set the KEY_VALUE correctly as it is MAINT_MATERIAL_ORDER_NO@10 || ‘^’ || LINE_ITEM_NO@10||’^’ and I cannot enter || in the Method  List Attributes Fixed Value column.I currently have this split across 4 jobs as I also struggled to get it to add 2 TECHNICAL_SPECIFICATION records when trying to group the TECHNICAL_OBJECT_REFERENCE and 2 instances of the TECHNICAL_SPECIFICATION only.  It kept wanting to update the same attribute instead of the second attribute. Any help greatly appreciated.

0
F
Do Gooder (Customer)
14 days ago
A
Sidekick (Partner)
ArcElhadCSidekick (Partner)
asked in Data Migration

ERROR - ODP_RESOURCE_NOTFOUND - (ODP_RESOURCE_NOTFOUND Error): Object has already been deleted by another user. Resource not found.

Hello Ifs communityI have created migration job to load data in Part Based tab for sales price list page.Lines are inserted but when i want to deleted or updated it i get this errorAnd when i try to modify one column of this line insert through migration job i had this error message :but I have no problem deleting or modifying manually created lines. I only have this problem for lines loaded via data mig job.This is my migration job source mapping : thank you in advance for your help.  Regards.  

8
A
Sidekick (Partner)
14 days ago
T
Do Gooder (Partner)
tanu.daveDo Gooder (Partner)
asked in Data Migration

Updating Communication Method via DMM in IFS Cloud

When we create Person in IFS Cloud Person>Communication Method is populated with email ID of that person. Now I have to update PERSON_INFO_COMM_METHOD2 view with information like Name, Description and validity. When i am updating it via DMM it is inserting a new record instead of updating it. I have also tried change source to ACC but then i am encountering error: -Method NEW failed : ORA-20110: CommMethod.METHODEX: Communication method E_MAIL with this value already exists for this name and address ID.I have also tried same with migration Job and used rule INSUPD and defined rule as update and then it is updating.I have also attached the Legacy File I tried to migrate.Any ideas on how to do it via DMM?

1
Nirogini Janstin
Do Gooder (Employee)
22 days ago
NPGIFSJOMAII
Sidekick (Customer)
NPGIFSJOMAIISidekick (Customer)
asked in Data Migration

Mass creation of parts

Hello Community!How does companies do mass import of inventory parts, purchase parts and supplier for purchase parts to IFS? Companies that has many new and changed parts and needs to update this frequently?  Like create a set of parts with multiple part numbers in one go. I understand that this is possible with migration scripts / tools etc. But when it comes more to a end user function. How are you doing that?

2
M
Hero (Employee)
27 days ago
macrau
Do Gooder (Employee)
macrau
asked in Data Migration

IFS Data Migaration Add In Apps 10

With regards to the deployment of our Microsoft Excel Integration Licenses and Plugin – there is a pre-requisite software required as you know - Visual studio 2010 plugin this is now unsupported by Microsoft and our Customer are not intending to package this up with our Windows SOE based on it being unsupported - https://learn.microsoft.com/en-us/lifecycle/products/visual-studio-2010Can you advise if IFS have issued an alternative to this plugin that is tested with your connector, IFS Data Migration Excel Add-in for APPS 10?

1
C
Do Gooder (Employee)
27 days ago
K
Sidekick (Partner)
ksebfSidekick (Partner)
asked in Data Migration

Migration Job - How to insert pre-accounting information

Hello everyone,I'm trying to migrate customer orders and customer order lines. Everything's working fine, no problem. However, I'm trying to migrate the CODE_C of the lines using another job for pre_accounting, and retrieving the pre_accounting_id of a line, but I get an error I don't understand: ORA-20111: Site.NOTEXIST2: The Site object does not exist.Strange, because in the job, this indication does not appear, and only the pre_accounting_id seems mandatory.   How can I make these jobs work easily? 

5
K
Sidekick (Partner)
24 days ago
Z
Do Gooder (Customer)
ZhanHaoDo Gooder (Customer)
asked in Data Migration

IFS Excel Add In - Search Function Not working?

Hello everyone,I am trying to use the search function in IFS Excel Add-In but it keep loading non stop. Any idea why?Thanks. 

3
M
Hero (Employee)
27 days ago
D
Do Gooder (Customer)
doolankDo Gooder (Customer)
asked in Data Migration

supplier for purchase part

Is there a way to take document text  from supplier to purchase part and have it automatically add to new purchose orders?

3
D
Do Gooder (Customer)
1 month ago
P
Do Gooder (Customer)
pacharryDo Gooder (Customer)
asked in Data Migration

IFS Cloud Excel Add-in 23R2

Hi,We are currently upgrading from IFS to IFS Cloud.  We currently have a number of Excel migration jobs to support users in their daily work.I have overcome most of the issues encountered so far aside from the following:The Search functionality always throws a Malformed Request error.  Thereafter, nothing related to the Excel add-in works anymore without logging off/on again.Has anyone else encountered and found solutions to these issues? Thank you.  

5
P
Do Gooder (Customer)
1 month ago
A
Do Gooder (Partner)
Anurag RamanDo Gooder (Partner)
asked in Data Migration

Can we use external file assistance for manual supplier invoice in cloud

Can we use external file assistance for manual supplier invoice  in cloud and i am not getting output option in external file assistance for ExtSuppInv  

4
C
Do Gooder (Customer)
1 month ago
D
Do Gooder (Customer)
dvidanageDo Gooder (Customer)
posted in Data Migration

PART MIGRATION

Please any one can tell what this error mean is. ORA-20110: InventoryPartUnitCost.N-0  

6
Marcel.Ausan
Superhero (Partner)
1 month ago
mdehalim
Do Gooder (Customer)
mdehalimDo Gooder (Customer)
asked in Data Migration

Employee Transfer from one company to another

HI!How i transfer my all employee from one company to another company. Please give me suggestion and working process. when i transfer one by one using ifsapp UI it will huge time to be done.

7
SaaAvinak
Do Gooder (Customer)
16 days ago
P
Do Gooder (Customer)
Peter SuhajdaDo Gooder (Customer)
asked in Data Migration

How to see the JSON file for an Excel Migration Job?

Hey, I am trying to fix a broken excel migration job, but it keeps throwing the following error:Expected ',' or '}' after property value in JSON at position 222 (line 1 column 223) My issue is that I don’t know how I can check what the JSON file looks like that is created from the Excel file. Is there a way to see that, perhaps inside the debugger?Please let me know if you need more information regarding this problem to better understand.Thank you for your assistance in advance!

11
P
Do Gooder (Customer)
1 month ago
Michael Kaiser
Sidekick (Customer)
Michael KaiserSidekick (Customer)
asked in Data Migration

List of ORACLE database object names

Hi database gurus,I work with the data structure in IFS for more than 20 years now.The last days I came across xxx_MV tables and wonder if there is a documentation of databaseobjects and the structure of what meaning do the single part of the names have.TMP = temporary, CFT = custom field table, CFV = custom field view, _TAB at the end of most tables in the ORACLE DB is easy.LOV = list of values, ok but I’m not shure why the IFS developers sometimes use this suffix in the table name, sometimes not. When you use “base data” every thing could be a “list of values”.Especially I’m looking for a meaning for the xx_MV tables today.Thanks in advance and have a nice day.Cu in the communityMichael 

1
M
Hero (Employee)
1 month ago
M
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration

Trace_Sys.Message: where does it show up?

Hi Friends!I have a simple question (I guess) related to tracing…If I have a call to the Trace_Sys.Message inside a Custom Event Action. How can I see it?

3
M
Sidekick (Customer)
1 month ago
rfedorchuk
Sidekick (Customer)
rfedorchukSidekick (Customer)
asked in Data Migration

Migration error - READ ONLY GRANTS FOR IFSINFO

Hi All,I’m trying to import Person records and I get this error:READ ONLY GRANTS FOR IFSINFOThis was working yesterday, so I’m confused.I’m using the view PERSON_INFO_ALL.The Users have migrated for all these records and the Company User records migrated as well.Any Thoughts?Thanks, Rob

7
J
Sidekick (Customer)
1 month ago
rfedorchuk
Sidekick (Customer)
rfedorchukSidekick (Customer)
asked in Data Migration

Migration - User Grants

Hello All,I have created a migration job to export User Grants, but I can’t get the File Mappings to populate.Any thoughts? Thanks,Rob 

6
rfedorchuk
Sidekick (Customer)
2 months ago

Badges

Show all badges
Terms & ConditionsCookie settings