Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,520 Replies
615 Topics
B
Do Gooder (Customer)
BABPAULSDo Gooder (Customer)
asked in Data Migration
Excel Migration - Using API Methods

 I am creating an Excel Migration job that will set hundreds of Requisition Authorisation Rules to ‘Planned’.This is very much like the topic I raised and got a very good answer that worked well: Excel Migration - Delete User Sites | IFS Community. On this occasion the same principles are not working for me.Here is the job...For the Action on Seq 10 I have toggled InLoop and NoExecution.For Seq 20, I set these attributes…My source mapping looks like this - I allowed the default Source Columns and assume I don’t need to do anything with the first 4 Method columns…Having tried many variations, the latest result is set to null upon execution…In the debug Trace, I see this error…It looks like it is trying to grab every column and insert the values into the Attr_ variable.I’m out of ideas now

3005
Jens
Hero (Employee)
R
Do Gooder (Customer)
REYGILLISRESDo Gooder (Customer)
asked in Data Migration
External File Load STDVOU ORA-20115 "Ext Load Id Storage" has already been removed

Trying to use an External File to migrate a Trial Balance (GL Transactions) from the legacy system to the new Cloud IFS solution.  File conforms to the STDVOU template with semi-colon separated values all matching the individual fields.  We have several different IFS Cloud environments at the moment (since we are in Implementation Phase), but none of them accepts an STDVOU type file and fails with the following Oracle error message:ORA-20115: ExtLoadIdStorage.The "Ext Load Id Storage" has already been removed by another user.Anyone got any ideas?…  we have already been successful in loading External Files using different Templates (ExtFAObjectImport for example), so doesn’t seem to be a generic issue with the environment as such...

1444
A
Sidekick (Partner)
A
Do Gooder (Customer)
abdelmalek.mecheriDo Gooder (Customer)
asked in Data Migration
Created a new page in MWO

Hello, I created a new page (Work Order Journal) in MWO but it shows an error message. From the designer page of my creation page, the page works correctly but as soon as I leave the designer page the page returns to errorThe goal is for technicians to be able to directly access the “Work Order Journal” page from the MWO application, can you tell me how to do this?     Thank’s

301
Jens
Hero (Employee)
T
Sidekick (Partner)
thprlkARCSidekick (Partner)
asked in Data Migration
Data Tracker IFS Cloud 24R1

Hi All,  Is there a place which I can get the Data Tracker for 24R1? Your assistance is highly appreciated.  Best Regards, Thushila 

1481
Marcel.Ausan
Ultimate Hero (Partner)
N
Do Gooder (Partner)
NIEKDo Gooder (Partner)
asked in Data Migration
Decimal Input Issue in Apps10:

In Apps10 client, when entering decimal values, they are being recorded as comma-separated.For example, I enter 2.5, but it appears as 2,5 and is saved to the database that way. How can this be corrected?

552
N
Do Gooder (Partner)
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration
Contract management change order migration

Hello,I am trying to migrate some data in using the following :I am getting the following error: The issue is that the sequence field in ‘CHANGE_OBJECT_IMPACT_FIN’ needs to be the same as ‘CHANGE_OBJECT’.  How is that done in a migration job please ?

401
Jens
Hero (Employee)
E
Do Gooder (Partner)
emmanilssonDo Gooder (Partner)
asked in Data Migration
Migration Job SUPP_BLK_PART

Hi community, our customer uses Excel add-in for creating and updating parts in different views. We are trying to create a new job including SUPP_BLK_PART view but there it stops and we can´t run the job in excel. If we remove the view it works. We have also tried and add other vires such as ASSORTMENT_NODE and SELF_SERV_PROC_CATALOG without issues but SUPP_BLK_PART cannot be handled. Have anyone any experience in this? BREmma

250
E
Do Gooder (Partner)
H
Do Gooder (Customer)
HDZSTEPHANIEDo Gooder (Customer)
asked in Data Migration
Creating a flat file using Migration Job with Procedure = CREATE_OUTPUT_FILE in 21R1

Trying to create a flat file from a view using Migration Job CREATE_OUTPUT_FILE in 21R1.  No output is being generated and it is sitting at Error but no error message is displayed. 

1363
NiyomalN
Hero (Partner)
E
Do Gooder (Partner)
emmanilssonDo Gooder (Partner)
asked in Data Migration
Excel add in error message

Hi, we are struggling to create an Excel Migration job, when trying to load data we get the following error message and no data is loaded at all. I´ve never seen this error before and cannot figure out what is wrong here? InsertDeleteConflict Thanks! BREmma

671
E
Do Gooder (Partner)
hrdilshan
Hero (Employee)
hrdilshanHero (Employee)
asked in Data Migration
What is the easiest method availabe to Tansfer Basic Data from "Use Place Env" to "Dev Env"

We need to have same Basic Data in Development EnvironemntWhat is the easiest method availabe to Tansfer Basic Data from "Use Place Env" to "Dev Env" 

872
Marcel.Ausan
Ultimate Hero (Partner)
S
Sidekick (Partner)
SowmiyaSidekick (Partner)
asked in Data Migration
IFS CLOUD AUTO SCHEDULING

Hi,Is there an auto-scheduling engine inbuilt in IFS Cloud? Please let me know how to configure it.

210
S
Sidekick (Partner)
V
Sidekick (Customer)
vitoSidekick (Customer)
asked in Data Migration
does anyone know how TEMPORARY_PART_COST_DETAIL is cleaned

we are currently importing data from our former ERP system into IFS Cloud 23R1SU6 and we notice that for instance the TEMPORARY_PART_COST_DETAIL table is just growingDoes anyone know how supposed temporary table is cleaned? is there some cleanup batch to schedule?thank you in advance 

492
V
Sidekick (Customer)
A
Do Gooder (Partner)
ASIFSHAIKHDo Gooder (Partner)
asked in Data Migration
ORA-20110: BasicDataTranslation.PROGNOTEXIST: Corresponding basic data does not exist for attribute key

Hi Community,I was trying to Migrate the Translation for Customs Statistics Number. in screen Basic Data Translation for English and PROG Data will alredy exist.I am trying to migrate the data for french Language via Excel Migration Getting error ORA-20110: BasicDataTranslation.PROGNOTEXIST: Corresponding basic data does not exist for attribute key  Any idea how to solve this error?Thank You

580
A
Do Gooder (Partner)
B
Do Gooder (Customer)
BABPAULSDo Gooder (Customer)
asked in Data Migration
Excel Migration - Delete User Sites

HiI am trying to create an Excel Migration Job that will delete User’s Sites. I would like to use the method USER_ALLOWED_SITE_API.Remove_User_Allowed_Site. It requires only COMPANY and USERID and removes all Sites associated with the given COMPANY for the given USERID. I would like it in Excel so that we can load the specific Users and Companies we need to target.If I run this PL/SQL, it completes successfully…beginUSER_ALLOWED_SITE_API.Remove_User_Allowed_Site('USERID','COMPANY');end;I have tried various configs in the Excel Migration job and it either errors, says it has processed it (but hasn’t) or churns for a while and returns a blank.Any pointers?

1572
B
Do Gooder (Customer)
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.  

9083
NiyomalN
Hero (Partner)
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Data Migration
IFS Cloud 23R2/24R1: Data Migration Manager Template Project file

Hi All, Can anyone share Data Migration Manager> Template Project file for 23R2 and if you have 24R1 as well?

6469
msurasky-price
Sidekick (Customer)
N
Do Gooder (Partner)
NIEKDo Gooder (Partner)
asked in Data Migration
MIGRATION JOB

How can we configure a migration job to accept user inputs?

1302
Jens
Hero (Employee)
M
Do Gooder (Customer)
MUNAJANSEDo Gooder (Customer)
asked in Data Migration
Run IFS Excel Add-in for multiple IFS Cloud environments

Before IFS Cloud you define that environment you want to upload data throught IFS Excel Ad-In, how do you select environment to upload data when running IFS Cloud?

350
M
Do Gooder (Customer)
A
Sidekick (Partner)
AbdessamadSidekick (Partner)
asked in Data Migration
Import PartlyPaidPosted invoice external

Hello,  I want to import invoices to cloud from 7.5 a “PartlyPaidPosted” invoices. Is it possible to have this status automatically  on the imported invoices ?  Best regards

140
A
Sidekick (Partner)
E
Do Gooder (Partner)
ERSADo Gooder (Partner)
asked in Data Migration
When Release Update is applied, the projection permission for '~MigJobHandling' is revoked.

Hi When updating from 23R2SU4 to 24R1SU2, all of the permissions for the projection of '~MigJobHandling', which is the permissions of the migration job, were revoked. Has anyone else experienced the same problem?・Why are permission revoked when Release Update is applied?・What is the workaround?

170
E
Do Gooder (Partner)
B
Do Gooder (Customer)
BenHugDo Gooder (Customer)
asked in Data Migration
PickSelected API

Good morning everyone, I post this topic cause after many hours of research I can’t find a solution about using an API.Here is my problem :  I have to build an flow for make an insertion of data in IFS DB.I did it on the application and use the debug window for see what kind of API is called. After analyse, I see this :   I understood the parameters are checked in the FndTempsLobs API which is genering a LobID and this LobID is the payload of the PickSelected API. My question is : How can I give the inforamtion PICK_LIST_NO, SOURCE_REF1, QTY_TO_PICK, etc… to the FndTempsLobs API ? The documentation show us the only payload is CreatedByModule :  My 2nd question is : The LobID generated contains the previous information ?  Thx a lot for your help and sorry if my explication are confused.  

1724
H
Do Gooder (Customer)
A
Sidekick (Partner)
AbdessamadSidekick (Partner)
asked in Data Migration
Financial migration - General voucher elements

Hello,My question concerns the finance migration to the IFS cloud version.I have a question regarding this process.We have the client's opening balance as of 31.12, and we are planning to migrate elements such as invoices, customers, suppliers, taxes, using external vouchers.However, I am wondering about the general ledger—how can we migrate the remaining elements from the general ledger? Should I request a full general ledger and import it as an external voucher to reach the balance as of 30.09?Thank you for your help. Best regards,

1202
A
Sidekick (Partner)
niklas_larsson
Do Gooder (Customer)
niklas_larssonDo Gooder (Customer)
asked in Data Migration
Invalid identifier SUPPLIER_INFO_GENERAL

Quite new to the Data Migration Tool in IFS I try doing my first Excel migration job using two LU’s. The purpose of the job is to update the SUPPLIER.SUPP_GRP column. As an additional information we will need the ASSOCIATION_NO from the SUPPLIER_INFO_GENEREAL LU but only SUPP_GRP needs to be updateable. I have configured the job as follows: In the method list tab I added the two LU’s:   In the rules tab I added a FETCHCONDITION that seems to work:   supplier_info_general.supplier_id = supplier.vendor_no  And finally I configured the source mapping tab as follows:   Running the job in Excel the Load Data procedure works as expected. One row for each supplier and all field showing the correct existing value. But then edit the SUPP_GRP value on a supplier and the run the Validate procedure I got an “Object does not exists” error in the Result Column. Back to the migration job trying edit and save some information on the SUPPLIER_INFO_GENERAL row in the method list I got the following erro

1243
NiyomalN
Hero (Partner)
T
Do Gooder (Customer)
TecSriniGDo Gooder (Customer)
asked in Data Migration
Projection creation for the error logs

Hi All, We are implementing one integration, which includes, we read csv file from URL and dump the data into custom table. By reading the custom table, we are calling the  API and updating the data into IFS. We get any error with the data from CSV file, then we need to create a projection to log those error. Can anyone please  help me to create the projection to log the errors ?   

150
T
Do Gooder (Customer)
S
Sidekick (Customer)
SAKESidekick (Customer)
asked in Data Migration
NEXTVAL migration job find selected value

Hi All,We're developing a excel migration job for creation of parts.We're using ENG_PART_MASTER_SEQ.NEXTVAL in this job.We would like to see in the excel migration job what the number is.So,  if we want to use the part after creating the part with the migration job, we don't have to search in IFS to find the created part_no.Any idea's how to manage this?   

1091
NiyomalN
Hero (Partner)

Badges

Show all badges
Terms & ConditionsCookie settings