Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,521 Replies
615 Topics
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

8795
durette
Superhero (Customer)
P
Do Gooder (Customer)
Peter SuhajdaDo Gooder (Customer)
asked in Data Migration
IFS Excel Add-in: Source Mapping Column missing from Search

Good day,I’m sure it’s a simple thing that I have overlooked, but I don’t have one of the Source Mapping Columns present in the Search function. I’m using IFS Cloud, and I believe COMPANY is the attribute of CUSTOMER_CREDIT_INFO.Missing column​Here is what the Source Mapping looks like: Here is what the Method List looks like: And lastly, the fetch condition is the following:CUST_ORD_CUSTOMER.CUSTOMER_NO=CUSTOMER_INFO_ADDRESS.CUSTOMER_ID and CUST_ORD_CUSTOMER.CUSTOMER_NO=CRM_CUST_INFO.CUSTOMER_ID and CUSTOMER_INFO_ADDRESS.CUSTOMER_ID=CUST_ORD_CUSTOMER_ADDRESS.CUSTOMER_NO andCUSTOMER_INFO_ADDRESS.ADDRESS_ID=CUST_ORD_CUSTOMER_ADDRESS.ADDR_NO and CUSTOMER_CREDIT_INFO.IDENTITY=CUST_ORD_CUSTOMER.CUSTOMER_NO Add-in version: 23.1.5.0Thank you!

700
P
Do Gooder (Customer)
C
Do Gooder (Partner)
CajethDo Gooder (Partner)
asked in Data Migration
Reading dynamic file name format for On Server data migration

The requirement is to read csv file from FTP folder for 'On Server' Data Migration. The file format should be dynamic name (file name concatenated with current date, for example PartMaster_&DATE.csv). But the 'On Server' migration is working with static file name format (PartMaster.csv) but not with dynamic name.  IFS responded that R&D team has identified this as the expected behavior of the IFS Cloud applications and as of now it only allows to write data to a on-server file with the extensions.The import functionality might be included in near future as an enhancement of the application.

661
Nirogini Janstin
Do Gooder (Employee)
P
Do Gooder (Customer)
Prakash FernandoDo Gooder (Customer)
asked in Data Migration
Configuration Analyzer closes automatically after launching

Hi,I downloaded and installed the configuration analyzer tool from the IFS developer portal(https://developer.ifs.com/tools/confanalyzer).The tool installed successfully but when I launched the tool, The application opens and within a few seconds it closes immediately.Do you have any ideas why this happens?Thank you

743
P
Do Gooder (Customer)
A
Do Gooder (Partner)
Anurag RamanDo Gooder (Partner)
asked in Data Migration
Is Batch User Creation implemented in IFS Cloud ..?

Are we able to create batch user in IFS Cloud  

951
S
Superhero (Customer)
F
Sidekick (Customer)
Frank HSidekick (Customer)
asked in Data Migration
Analysis Model Environment Parameters

Is it possible to have multiple SSIS catalog folders in the environment parameters within IFS Cloud.  We would like to keep our data separated for various reasons.

491
S
Hero (Employee)
K
Do Gooder (Employee)
kzieseDo Gooder (Employee)
asked in Data Migration
Data Migration Manager unable to map new target table

Using DMM, I have setup a migration object for Customers.  I’ve added all the target tables and performed some of the mappings.  I then realized I forgot a specific target table, so I created it and added it to the Migration Object.  You can then go to Mapping where you can add it to Legacy Tables With Locked Loads no problem.  However, when you go to mapping detail, it never shows up in the list of target tables.  I always have to create a new migration object separately to do the mapping and migration of this.  Anyone else run into this?

1132
K
Do Gooder (Employee)
Darshana Herath
Hero (Former Employee)
Darshana HerathHero (Former Employee)
asked in Data Migration
Clone Used Place to Build Place

Has Anyone transferred Used Place data into Build Place for Testing purpose?What kind of options available for this (NOT for PROD to non-Prod, Need PROD to Build Place)?  

1221
K
Hero (Partner)
Dharshankumaar Mahendran
Superhero (Partner)
Dharshankumaar MahendranSuperhero (Partner)
asked in Data Migration
Migration Job

Hi All,I’m looking for a documentation in Apps 10 and IFS cloud which would provide the process of setting up and executing a migration job for insert or modify function. Highly appreciate if anyone could provide a step by step document. Thanks in advance.

1041
Jens
Hero (Employee)
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration
Where an IAL is used

Hello,Is there a way to find out where an IAL is being used (quick report, package etc etc ….)Thanks 

310
J
Hero (Customer)
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration
Custom fields layout

I have created some custom fields on the Project screen (using Apps 10 UPD17).  I have added them to the Margin tab and all looks ok. However, when I go to the General tab the fields are also showing there and hiding some necessary fields, is there a way for them appearing there as well ?? Thanks

1132
J
Hero (Customer)
F
Sidekick (Partner)
FPayabSidekick (Partner)
asked in Data Migration
Customer Ownership error

When creating an order line i get this error, the line does have Ownership, when i check the ownership on line it is correctly picked as  “Customer Owned” and Owner is also picked correctly but the Owner Name is not picked. After re-selecting the Owner from the LOV i can save the order line. But why does it not pick the Owner name when order line is created. Please assist. (the Customer accs were newly migrated) 

742
F
Sidekick (Partner)
MWitczak
Hero (Customer)
MWitczakHero (Customer)
asked in Data Migration
List of fields for IFS Cloud pages

Is there any “master list” of fields for all pages/modules in IFS Cloud with the field’s purpose?  Or at the very least, the following:Inventory Part/Part Maintenance/Part Record Customer/ Customer Maintenance/ Customer Record Supplier/Vendor Maintenance/ Supplier RecordAs we prepare for our 3rd wave of implementation, our top level decision makers would like this information in order to make sure the proper people are assigned responsibility for these items, and I’m just curious if anything already exists to help this.

1293
S
Superhero (Customer)
J
Do Gooder (Customer)
JWieczorekDo Gooder (Customer)
asked in Data Migration
Schedule report - Missing Access

Good afternoon,Where can I provide access to this function “Schedule Report?” When I am trying to create the Schedule I am getting this error: 

370
J
Do Gooder (Customer)
M
Do Gooder (Partner)
MhpHaralEDo Gooder (Partner)
asked in Data Migration
Data Migration Manager unable to deploy Migration Object Customer

Not seeing Migration object in the deployment containerI have used the 22R01 template for the DMM.The upload worked fine and all steps went fine until the Output ContainerI was able to approve data in the Output container for the Mig Obj “Customer”Unfortunally in the Deployment conter I can not select the object Customer.Does someone know a way out  ThanksHarald

1003
A
Do Gooder (Partner)
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 

1183
Jens
Hero (Employee)
DHCRADPA
Hero (Customer)
DHCRADPAHero (Customer)
asked in Data Migration
Does anyone face issues with part numbers longer than 25 characters (IATA/ATA S2000)?

Does anyone face issues with part numbers longer than 25 characters (IATA/ATA S2000)? Version is 23R1 or after, cloud setup. While using ATA Spec 2000, the part-number field should be kept as concise as possible. While there is no strict character limit, it’s essential to avoid unnecessary complexity. Unfortunately, in IFS the part # field is limited to 25 characters. Are there any work arounds anyone used to overcome this limitation?

690
DHCRADPA
Hero (Customer)
M
Do Gooder (Partner)
mciarameDo Gooder (Partner)
asked in Data Migration
Excel Migration Login Issue

For IFS Cloud 23R2, after installing the Add-In from the manifest file for the Excel Migration, the user gets error 400 - Bad Request when the Login button is pressed. Some users can login at times and other times it is not possible.

530
M
Do Gooder (Partner)
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? 

240
mcmaf1
Do Gooder (Customer)
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! 

1660
Y
Do Gooder (Customer)
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

260
A
Do Gooder (Partner)
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

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

1421
Fikret
Do Gooder (Employee)
H
Do Gooder (Partner)
HarshaDo Gooder (Partner)
asked in Data Migration
Smart Data Manager Mapping Parent Child Relationship in generated keys

We are using Smart Data Manager to migrate “EQUIPMENT_SERIAL” and “EQUIPMENT_OBJECT_TEST_PNT” which has a parent child relationship using field “EQUIPMENT_OBJECT_SEQ”  This field value is an auto generated value and in the EQUIPMENT_SERIAL and there is no way to put newly generated  “EQUIPMENT_SERIAL.EQUIPMENT_OBJECT_SEQ”  to “EQUIPMENT_OBJECT_TEST_PNT.EQUIPMENT_OBJECT_SEQ” Is there a built in way in the tool to resolve this  

1862
T
Hero (Partner)
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. 

1201
M
Hero (Employee)

Badges

Show all badges
Terms & ConditionsCookie settings