Data Migration

This will include topics related to data migration.

  • 413 Topics
  • 1,079 Replies

413 Topics

D
Do Gooder (Customer)
dustin_arpDo Gooder (Customer)
asked in Data Migration

DMM - Post Deployment Tentative to Buildable (Routing/Product Structure)

Anyone have luck using a Post Deployment process to change Routing Alternate or Product Structure Alternate from Tentative to Buildable in Data Migration Manager? I’m trying ROUTING_ALTERNATE_API.BUILD_ in this example. I can’t get it to fire off, no matter what settings I try. The Customer Order Status change is very straightforward in comparison, just requiring the ORDER_NO. I’m wondering if it has something to do with the migration not actually filling anything in for the OBJID or OBJVERSION. No idea what should go in the ATTR or ACTION sections. 

3
Nirogini Janstin
Do Gooder (Employee)
2 months ago
M
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration

Error Handling of errors RAISED on ERROR_SYS

Hello Community!I have the following Code-- In this block we perform the actual change.DECLARE PARTTYPEERROR EXCEPTION; [SOME_OTHER_VARIABLES]BEGIN FOR sale_part_to_update_rec IN ( [SOME_SQL_TO_PERFORM_LOOP] ) LOOP p0_ := NULL; p1_ := sale_part_to_update_rec.OBJID; p2_ := sale_part_to_update_rec.OBJVERSION; client_sys.add_to_attr(name_ => 'SOURCING_OPTION', value_ => sale_part_to_update_rec.SOURCING_OPTION, attr_ => p3_); client_sys.add_to_attr(name_ => 'RULE_ID', value_ => '', attr_ => p3_); p4_ := 'DO'; BEGIN IFSAPP.SALES_PART_API.MODIFY__( p0_ , p1_ , p2_ , p3_ , p4_ ); COMMIT; EXCEPTION WHEN PARTTYPEERROR THEN [MY_ERROR_HANDLING_CODE] END; END LOOP;END;I have noticed that even when the IFSAPP.SALES_PART_API.MODIFY code I execute results in an PARTTYPEERROR Exception...… The block to handle that type of errors is never invoked. The exception

3
dsj
Superhero (Partner)
3 months ago
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration

Transaction_sys Log status

Hello,I have the following syntax in a procedure, but it is failing to compile with the following : Can anyone tell me what I am doing wrong please ?  

2
J
Hero (Customer)
3 months ago
D
Do Gooder (Customer)
Dekforce94Do Gooder (Customer)
asked in Data Migration

Truck Spec Sheet

How do I get to print off a Truck Spec Sheet from IFS? I used to have a shortcut saved but it got deleted.    

0
D
Do Gooder (Customer)
3 months ago
M
Do Gooder (Customer)
manju.mandavaDo Gooder (Customer)
asked in Data Migration

Migration Job Fails for CSV file

Hi .. I was trying to set-up new migration job to update CUSTOMER_INFO_ADDRESS View for changes in address and postcode values. This supposed to update around 17000+ records so i choose to use Procedure “INSERT_OR_UPDATE” from csv file.As soon as i run the job i am getting below error. I did investigated further into this and noticed actual issue is - Address column value holds multiple comma seperators, which seems to be root cause of this. Is there any way i can mitigate this issue without removing extra commas from address value ? if i add double quotes around this column value, do you think this will insert double quotes also in data ?double quotes  Start time - 19-JAN-2024 11:13:18   CS_SJCB_POSTCODE_CHANGE_MIG - Execution No 0 Insert into CUSTOMER_INFO_ADDRESS_TAB failed - ORA-20111: CustomerInfo.FND_RECORD_NOT_EXIST: The Customer Info does not exist. (Error caused by line: 2)File Path: DATAMIG (F:/DATAMIG2)File Name: CS_SJCB_POSTCODE_CHANGE_test2.csvFile Location: OnServerChar S

4
M
Do Gooder (Customer)
3 months ago
Z
Sidekick (Customer)
zwallSidekick (Customer)
asked in Data Migration

Data Migration Excel Add-in "Object does not Exist" error

After making a few updates in the excel field for the add-in, I validate and get the Object does not exist message. I am using the correct search function to pull in the data and it has worked in the past. Will someone please help me understand what went wrong and how to fix this?

2
Z
Sidekick (Customer)
3 months ago
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration

Resource Details/Connections migration using DMM

Dear All,I would like to know if it is possible to use Data Migration Manager(DMM) tool to migrate 'Resource Deatails' and 'Resource Connections' in IFS. Has anyone done that already?If possible, how do we do that? How do we handle sequence numbers in DMM? Any examples?Can we use 'resource_connection_seq.nextval'?Any reference documentation/materials will also be helpful.Thank you!

0
Disna Marakkala
Sidekick (Employee)
3 months ago
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration

PO print

Hello, I have created an event action as follows, but when I RMB and print order I get the print as expected but also get the default print.  How do I stop the default one ? Thanks

4
J
Hero (Customer)
3 months ago
K
Sidekick (Partner)
ksebfSidekick (Partner)
asked in Data Migration

Data migration : Can I automatically pick the next customer order number

I'd like to wish you all a very happy new year. I'm creating migration jobs for customer orders where I'd like them to retrieve as much information as possible automatically. At the moment, I only have 3 mandatory pieces of information to enter.   I'd like the order number to be entered automatically, based on the last existing order number. Is this possible? Where do I enter it? For the example, my last order number is "S23000005957".I'd like the order number to be automatically set to "S23000005958" when I run my job, and for the countdown to take place naturally. If I manually recreate an order, my number should be "S23000005959".

7
Jens
Hero (Employee)
2 months ago
J
Do Gooder (Partner)
Johannes KopferDo Gooder (Partner)
asked in Data Migration

Excel Add In Search possibilities

Hey everybody, I am facing a problem with Excel Add In in IFS Cloud. The search functionality has changed from Apps to Cloud. Eg “%” or “;” doesn´t work anymore (at least it seems). Is there any documentation about search possibilities that can be used? Is there a possibility to use SQL statements in the search bars? Thank you in advance, Johannes

5
J
Do Gooder (Partner)
3 months ago
rfedorchuk
Sidekick (Customer)
rfedorchukSidekick (Customer)
asked in Data Migration

Migration Import Addresses

Hi all,I’m running ifs-cloud-23.1.6-penyzy3-3.5.0I’m trying to import the data from CUSTOMER_INFO_ADDRESS but the CREATE_TABLE_FROM_FILE job is splitting the ADDRESS field like so:ADDRESS=4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA In Excel export it looks like this:4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA How do I keep the information in the same record?I’m assuming it’s processing a Hidden Tab from Excel .csv file Thanks,Rob

1
Jens
Hero (Employee)
4 months ago
WSHAH
Do Gooder (Customer)
WSHAHDo Gooder (Customer)
asked in Data Migration

Data Archive error on IFS Application 9

I have created a Data Archive Job for Shop Order, I follow the documents properly  by using following documentshttps://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/020_data_archiving/210_general_data_archiving/020_how_to_setup.htm?_gl=1*a5k3p6*_ga*MTk5MzI4Mzk2LjE2Nzc0ODIwMTU.*_ga_H7YJR9R7Q1*MTcwMzIyNDczNC4xMzAuMS4xNzAzMjI2NjI4LjAuMC4w https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/020_data_archiving/210_general_data_archiving/120_data_archive_orders.htm     How we can rectify this issueKindly advise Regards

1
T
Superhero (Employee)
4 months ago
A
Do Gooder (Customer)
Ash1807Do Gooder (Customer)
asked in Data Migration

Updating an existing custom field that is indexed

I am using the Data migration tool in Apps9 to update an existing custom field. This field is indexed and coming up with the error:- Execution No 0Error creating index CREATE  INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB() - ORA-00936: missing expressionDo I need to set up the DM job in a certain way?

1
Jens
Hero (Employee)
4 months ago
K
Sidekick (Partner)
ksebfSidekick (Partner)
asked in Data Migration

Migration modification CODE E VOUCHER

​Hello everyone,I have a tricky problem for you.As part of a go live project with IFS APP10, we migrated the financial data, including the ledgers. We went through external assistant and everything went smoothly.Later, the finance team realised that for many rows the E code was the wrong one. So we modified the E code using Excel Add-in with the GEN_LED_VOUCHER_ROW_UNION_QRY view.This worked well, so the E code has been modified. In the view GL Voucher Rows Analysis, the CODE E is good. All the CODE E are ‘EXTERNE’ But when we look at the view GL Balance Analysis different results from 'EXTERNE' still exist.  When We look at the SQL Query Tool :It is therefore clear that the 'accounting balance' view has not been updated.This table is used to summarise the balance. The balance has therefore not been updated.So I tried to recreate an excel add in to update the values using the ‘ACCOUNTING_BALANCE’ view tu update the balance.But when I want to execute the excel, an error message occurs :

2
Jens
Hero (Employee)
4 months ago
I
Do Gooder (Customer)
isaac.mohamadDo Gooder (Customer)
asked in Data Migration

Change object level

Good afternoonI would like to know how to insert one object inside another, that is, make it a sub item.I think changing the level would work but I don't know how to do it and I would like to ask for help.Best Regards 

0
I
Do Gooder (Customer)
4 months ago
B
Sidekick (Customer)
bhaveshSidekick (Customer)
asked in Data Migration

Function_result not in column name option

Any idea why ifs cloud does not allow function_result@5 in the column name?Column name is a drop list with all the columns from the source mapping tab. 

1
M
Do Gooder (Employee)
4 months ago
Z
Do Gooder (Customer)
ZhanHaoDo Gooder (Customer)
asked in Data Migration

IFS Excel Add-In - Browser version not supported

Hi all,We are trying install IFS Excel Add-In in AWS VM with Windows Server 2019 OS but getting the error.We are using Microsoft 365 (Enterprise). We did reinstall the excel and update the chrome browser version, but it still doesn't work.Below is the documentation we follow.https://docs.ifs.com/techdocs/22r1/070_remote_deploy/400_installation_options/010_data_management/030_data_migration/Can you advise what will be the issue and suggest some method to resolve.Thanks 

2
Z
Do Gooder (Customer)
4 months ago
E
Do Gooder (Customer)
Eesha1753Do Gooder (Customer)
asked in Data Migration

adding a logo to IFS Standard report

Hi,Does anyone know how to add a picture to a IFS apps 10 standard Report, do i also need access to the build place to publish my changes on the report? thanks,

3
A
Sidekick (Customer)
4 months ago
R
Do Gooder (Customer)
rosscortbDo Gooder (Customer)
asked in Data Migration

Run task once file upon detection of new file

Hello, in IFS10, can I run a scheduled task once a file has been uploaded to a folder? ThanksRoss

1
Marcel.Ausan
Superhero (Partner)
5 months ago
R
Do Gooder (Customer)
rosicky.guiDo Gooder (Customer)
asked in Data Migration

PURCHASE_ORDER_LINE_API.New__ not working

I want to create Purchase order line via  PURCHASE_ORDER_LINE_API.New__.when I pefrom  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'CHECK');” no error message. but I change to  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'DO');” it dispaly  “4246591008” is not a valid integer value.my script as beolowDECLARE          info_ VARCHAR2(32000);          objid_ VARCHAR2(2000);          objversion_  varchar2(300);          attr_ VARCHAR2(32000);          BEGIN        -- TBOOLENSTRING:=TRUE;         Client_SYS.Clear_Attr(attr_);      --Client_SYS.Add_To_Attr('BUYER_CODE','3HB03', attr_);-      Client_SYS.Add_To_Attr('ORDER_NO','10112', attr_);      Client_SYS.Add_To_Attr('BUY_QTY_DUE','100', attr_);      Client_SYS.Add_To_Attr('DATE_ENTERED',sysdate, attr_);      Client_SYS.Add_To_Attr('LAST_ACTIVITY_DATE',sysdate, attr_);      Client_SYS.Add_To_Attr('PLANNED_DELIVERY_DATE',sysdate, attr_);      Client_SYS.Add_To_Attr('PLANNED_ARRIVAL_DATE',sysdate, attr_); 

3
hhy38
Hero (Customer)
5 months ago
T
Sidekick (Partner)
ThejSidekick (Partner)
asked in Data Migration

Migration job is not enabling

Hi Experts,Search , validate and execute functions are not working in below migration job. Appreciate it if any one could help to resolve this issue.   Best regards,Theja

0
T
Sidekick (Partner)
5 months ago
DomCotton
Do Gooder (Customer)
DomCottonDo Gooder (Customer)
asked in Data Migration

Warehouse Bay Bin - Migration Job issue

Apps 10 update 12:I am trying to load some new Inventory Locations.  The migration job is pretty straight forward, see below.When I try and execute, the first row is successful but second and subsequent rows fail.  The error is:Insert into WAREHOUSE_BAY_BIN_TAB failed - ORA-20112: WarehouseBayBin.FND_RECORD_EXIST: The Warehouse Bay Bin already exists. (Error caused by line: 3)It appears that there is a LOCATION_SEQUENCE which retrieves from a sequence (if the field is empty in the attribute string).  Looking at the output of the failures, it is trying to use the same LOCATION_SEQUENCE value for each record.  Anybody have any ideas or have been successful in data migrating inventory locations?Thanks in advance,Dom

2
Marcel.Ausan
Superhero (Partner)
5 months ago
matt.watters
Superhero (Partner)
matt.wattersSuperhero (Partner)
asked in Data Migration

Document Migration Best Practices

I am looking for recommendations on how best to manage the migration of documents (300gb+) from an Apps9 database to Cloud. Primary concern is the ‘what to avoid’ type scenarios and also how to monitor during the migration process that the process did not stop or error out and, if it did, what to do next.

0
matt.watters
Superhero (Partner)
5 months ago
S
Do Gooder (Partner)
SanjayaDo Gooder (Partner)
asked in Data Migration

IFS Cloud 23R1: Data Migration Manager Template Project file

Hi, From where I can find the IFS Cloud 23R1: Data Migration Manager Template Project file?I have found a community post for 22R1 and a post related to an 23R1 Internal file only.When the releases are made,  is there a public URL where these templates are made available to  downloaded from?Thank you

3
K
Do Gooder (Partner)
3 months ago
Poulton
Do Gooder (Customer)
PoultonDo Gooder (Customer)
asked in Data Migration

IFS Cloud Example Data

Is there a process to get the system populated with example, demo, or dummy data?We are new to IFS Cloud, and will be starting our implementation process with our partner soon. However, we would like to be able to see what a basic setup would look like.Our prior ERP system had an example database which had the minimal setup with some dummy transactions. This was helpful in exploring functionality not implemented and was helpful to the development process.

4
L
Sidekick (Customer)
7 days ago

Badges

Show all badges
Terms & ConditionsCookie settings