Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,520 Replies
615 Topics
M
Sidekick (Customer)
MelKingSidekick (Customer)
asked in Data Migration
ORA-20110: Final Posting Proposals - Invoice has already been posted

On our Accounts Payables lobby screen there are 21 invoices showing errors on the final posting proposals page that have been locked in there for years and they will not clear. They are all paid posted, however they all include this error: (Apps 10 EE) We are moving to Cloud in February and have a testing space currently where they also migrated over to this environment. I had read that it could be a bug, but it wasn't the same specific error so i’m not 100% sure. If this is the case and it is a bug, will it resolve itself once we fully transition to Cloud?   

681
Marcel.Ausan
Ultimate Hero (Partner)
S
Do Gooder (Customer)
SPierpointDo Gooder (Customer)
asked in Data Migration
Mig job - Org units error

HI, I have been trying to migrate data into the Organisation Units screen and im getting the below error, even though it has a value in the temp table. ORA-20124: Error.NULLVALUE: Field [SUP_ORG_CODE] is mandatory for Company Org and requires a value. select * FROM IFSAPP.IC_BTG_ORG_UNIT_LOAD_TAB Please help?ThanksStacy

555
S
Do Gooder (Customer)
M
Do Gooder (Employee)
MartynaDo Gooder (Employee)
asked in Data Migration
Null Values in Excel Migration to Prevent Overwriting

Hi everyone,I’m currently facing an issue with Excel migration where empty values from the Excel sheet are overwriting existing data in our IFS application. Specifically, I want to prevent fields from being updated with empty values. For example, if the “DUNS No” field (column F) is empty, I don’t want it to overwrite the existing value in the application.Here’s a simplified example to illustrate the problem:Example Data: ID Name Address City Country DUNS No 1 Company A 123 Street Kraków Poland 123456 2 Company B 456 Avenue Warsaw Poland   3 Company C 789 Boulevard Gdańsk Poland 789012  In this example, for row 2, I want to update the application with the data from columns B-E for the corresponding ID, but leave the “DUNS No” field unchanged if it is empty, regardless of whether data exists in this field in the application or not.Has anyone encountered a similar issue or have any suggestions on how to handle this in the migration process?Than

1073
M
Do Gooder (Employee)
H
Hero (Customer)
HypervoxHero (Customer)
asked in Data Migration
Migration of non-inventory sales parts with JUST a tax class

Hi everyone,I’m unable to use a migration job to input a non-inventory sales parts with JUST a tax class.  If I try, I get the following error… I can however, create one with JUST a tax code.The odd thing is that if you debug the sales_part_api call when using IFS, both tax class AND tax code are supplied i.e. from the debug attr'TAX_CODE'||chr(31)||''||chr(30)||'TAX_CLASS_ID'||chr(31)||'1'||chr(30)|| Can anyone share any light on why this is? 

513
Abdul
Superhero (Partner)
E
Do Gooder (Partner)
emmanuelle.rouzieDo Gooder (Partner)
asked in Data Migration
Is the transfer of post-its from IFS Apps to IFS Cloud

Hello, I’m reaching out for your help to find out if :Is the transfer of post-its from version V8 and V9 to IFS Cloud done in the same way?Thank you 

220
E
Do Gooder (Partner)
STMVALENTINE
Sidekick (Customer)
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.

7585
tgurley
Do Gooder (Customer)
G
Do Gooder (Customer)
gsk139Do Gooder (Customer)
asked in Data Migration
Is it possible to make an export to excel?

Hello, I am new to IFS, and I was wondering if you can make an export to excel. For instance I want to make an export of all the: “Part Serials”. And if so, how can you do it?I am currently working with IFSAPP10 (IFS Enterprise Explorer)

1652
G
Do Gooder (Customer)
B
Do Gooder (Customer)
BetaDeveloperDo Gooder (Customer)
asked in Data Migration
Purchase Part Supplier

Hi, Can you help me for Purchase_Part_Supplier Data Migration. We don’t want to write for all rows in excel for column “LINE_NO”. We can arrange it with a select statement but I couldn’t do it. This doesnt work. (selectMAX(line_no)+1 FROM PURCHASE_QUANTITY_PRICE ppsWHERE CONTRACT = pps.contractAND VENDOR_NO = pps.vendor_noand PART_NO = pps.part_no) Thank you. I attached a similar problem from community as well. Excel migration issue with update of purchase_quantity_price | IFS Community  

490
B
Do Gooder (Customer)
A
Do Gooder (Partner)
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

1546
B
Do Gooder (Customer)
G
Do Gooder (Customer)
GoryCox22Do Gooder (Customer)
asked in Data Migration
Excel Migration - Drop Down List and Fetch DB value

Hello, Trying to implement a user available excel migration file and have to solve two problems to make it useable.  problem 1) Want to make one of the columns a drop down with 5 to 6 options for ease of input and formatting. Other values could be manually input but the drop down would contain the most frequently used values. Would prefer to do this using Client Values and not DB values. In this example it would be the Work Task Template ID  - Description - Rev. Problem 2) This specific migration container is to a custom page and the primary values are Contract and Line No. The issue is that the migration file is asking for line DB value and the user will not have access to that information since its not viewable in the client. There is an API call to the OBJKEY on that table which is the DB value for the Line Number. Trying to determine how to have the file fetch the DB value after the user specifies the client value.  I’ve scoured documentation and watched numerous videos with no luc

610
G
Do Gooder (Customer)
msurasky-price
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration
CASCADE References in Data Migration Manager error

The following print-screen show the state of one of my Output Containers, as you can see:It refers to IDENTITY_PAY_INFO It’s key (COMPANY, IDENTITY, PARTY_TYPE_DB) is: TESTCO, ABC0001 and CUSTOMER (respectively) Is in Approved stateIn addition to that, IDENTITY_PAY_INFO is referred by another table PAYMENT_WAY_PER_IDENTITY. On that table, It is expected that the field PARTY_TYPE_DB should exist in IDENTITY_PAY_INFO, as you can see in this Target Table Definition.With this information in mind… then why this row in PAYMENT_WAY_PER_IDENTITY failing if the corresponding record already exist in  IDENTITY_PAY_INFO when I validate basic data?To me the information is already there, so it shouldn’t fail.Also, what does the word “CASCADE” represent in the Reference column in the target table definition (as in this case where the reference is “IdentityPayInfo(company,identity)/CASCADE”)?

560
msurasky-price
Sidekick (Customer)
Srikanth
Superhero (Partner)
SrikanthSuperhero (Partner)
asked in Data Migration
Excel Migration Jobs using Custom API method issue

Hi,We are in middle of upgrading from IFS 9 to Cloud and uplifting all our Migration Jobs. In Cloud, we noticed that the Excel Migration jobs using standard IFS API Methods create a new projection once we update the job and click ‘Re-generate Excel Migration’ option. Granting the projection to the relevant Permission Set allows user to execute the job successfully in Excel.However, the same doesn't happen when we modify Excel Migration Jobs using Custom API Methods as no new Projection appears after clicking Re-generate Excel Migration.When the user tries to run the migration, the attached error occurs:We confirmed the same error for two other Custom API based Excel Mig Jobs.Product Version: 23.1.11

790
Srikanth
Superhero (Partner)
M
Do Gooder (Customer)
Markus S.Do Gooder (Customer)
asked in Data Migration
ORACLE SQL Developer does not show the data for all VIEWS

Hello, I have a VPN to the IFS cloud. Now I have noticed that the Select does not show any data on many VIEWS, although data is available there according to the IFS quick report.CUSTOMER_INFO: works fine PURCHASE_ORDER: no Data In IFS-Quickreport i can select all Purchase Orders ! Is there a reason and solution so that I can see data from all VIEWS that I select via Qracle SQL Developer and not just the column names?I have already written the IFSAPP in front of the VIEW names.Thanks for your helpGreetingsMarkus

36313
M
Do Gooder (Customer)
A
Do Gooder (Customer)
arizzDo Gooder (Customer)
asked in Data Migration
IFS Cloud Excel Migration Mandatory Field Issue

Hello community, I am trying to complete an Excel Migration Job, and once I go to validate/execute the job, I keep facing a very strange issue:When we enter our parameter (SITE1) into the contract field, the migration job doesn't recognize the input. That being said, when we enter SITE2 (another parameter of ours) into the contract field, we get an error that we don't have access to the site - that tells me that the migration job is able to read the field but cannot recognize either SITE1 or SITE9 as being valid. SITE1 is used for most of the objects, and this same result column error appears for creating new objects or validating existing ones, even if nothing is changed on them. This proves the tool recognizes the field The Migration Job (ignore the Note text). I also tried changing the flag attributes of Contract to MIU (for mandatory), but still no good. 

1031
M
Do Gooder (Customer)
H
Do Gooder (Partner)
himasha.abeywickramaDo Gooder (Partner)
asked in Data Migration
Importing large Excel data to IFS

Hello,One of our customers is seeking a solution for handling large Excel files, which they currently enter manually into IFS Apps10 environment. They need a solution capable of processing up to 2 million records in a single upload. Could you suggest any available solutions?

1122
Marcel.Ausan
Ultimate Hero (Partner)
T
Do Gooder (Partner)
TheanDo Gooder (Partner)
asked in Data Migration
Excel Migration column width adjustment

Hi CommunityI have created a Excel Migration for Invoice planning screen.I have given the default value for Invoice sequence- Every time when I load the data to excel the field gets too wider, is there any way to adjust the column width in excel and also to remove the timestamp? Thanks in advance,Thean

190
T
Do Gooder (Partner)
T
Do Gooder (Partner)
TheanDo Gooder (Partner)
asked in Data Migration
Migration job for modifying Project Manager

Hi Community,When I try to modify the Project Manager, I’m encountering the below error message.So, found a alternative way and used to Modify the Project Manager manually from the Change Project Manager window. Now, I want to create a migration job to modify the PM.But unable to call the Project_API.Modify__ method, as it shoes the error “Current user doesnot have access to update project manager”.Can anyone help me out of this.Thanks/Thean Mozhi

1608
T
Do Gooder (Partner)
A
Do Gooder (Partner)
ArcAleksSDo Gooder (Partner)
asked in Data Migration
[Data migration] Set an employee status to active

Hello,I did a test to migrate an employee and it appears with “preliminary status”. How can I migrate it as “active”? It’s for the Cloud version 21R1 and I created a two step job.Thank you in advance,

3143
T
Do Gooder (Partner)
M
Do Gooder (Customer)
mboyce0822Do Gooder (Customer)
asked in Data Migration
IFS Cloud Cloning Environment

 When I try to clone CST to AST it is not showing the target version and no ability to enter it. Any ideas what the issue could be? It works for all other scenarios. 

370
M
Do Gooder (Customer)
eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
asked in Data Migration
Which api generates the project id via id rules?

When migrating project, I want to make use of the Project ID Generation Rules. I leave the project ID in the migrate source job blank, category 1 is filled, Generation rules have been set up for given category 1. All other values are catch all.Still nothing happens when running the migration. So I was wondering which API to call to set the api in the defaul value of the project id, so it would generate the id when migration job runs.Anyone an idea which api to call? I would prefer to know the parameters as well, although less important for now.BTW: rule works perfect when entering a project via the project definition form

854
eqbstal
Superhero (Partner)
msurasky-price
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration
Statuses in Data Migration Manager do not match

My Basic Data Container in Data Migration Manager is saying that these 5 records for countries are in a “Not Deployed” Deploy Status state…  Yet, if I go to the Deployment Container for the same Target Table (ISO_COUNTRY) my 5 rows are in either Deployed With Commit or Deployed state. Why is the discrepancy between the Basic Data Container and Deployment Container Statuses? is this a bug in the User Interface?

200
msurasky-price
Sidekick (Customer)
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Data Migration
IFS Cloud 24R1 - Data Migration Manager - Database Link

Hi All,I created a Database Link in DEV (Build Place) to link to CFG environment using an end user in CFG.I can see a valid Database Link in DEV.However I cannot see created DB link in the application (DEV environment).Location Solution Manager > Data Management > Data Migration Manager > Project Basic Data Setup/Connected environments tab/Database Link name.Any idea as to why I cannot see the DB link from the application  

1592
G
Sidekick (Partner)
A
Do Gooder (Partner)
AccHarprSDo Gooder (Partner)
asked in Data Migration
How to create price lists via migration or file upload

Hello,I am in trouble to create multiple price lists with thousands of Sales parts in IFS Cloud.Can somebody guide me how i can create excel migration job or file update option?

380
A
Do Gooder (Partner)
Siva.Prasad
Sidekick (Partner)
Siva.PrasadSidekick (Partner)
asked in Data Migration
IFS Cloud DB link not showing in drop down list

Hi I have created DB Link in IFS Cloud database as IFSAPP user, but that DB link is not showing in IFS Cloud Migration screen.   

921
InfFilipV
Hero (Partner)
Srikanth
Superhero (Partner)
SrikanthSuperhero (Partner)
asked in Data Migration
Unable to delete lines that don't need migrating (blanks) (could delete on apps 9)

Hi,In Apps 9 whilst using Data Migration Jobs, users were able to delete records after loading data from spreadsheet and before migrating the records into IFS.However, in IFS Cloud (23.1.11) there seems to be no option to delete records like the ones highlighted below:Users need this ability to review and delete records before migrating them into IFS.Is this a case of missing functionality in Cloud that will be added in future updates?

552
Jens
Hero (Employee)

Badges

Show all badges
Terms & ConditionsCookie settings