Data Migration

This will include topics related to data migration.

  • 420 Topics
  • 1,093 Replies

420 Topics

rfedorchuk
Sidekick (Customer)
rfedorchukSidekick (Customer)
asked in Data Migration

Can't create a migration job

Hi All,I can’t create a migration job.  What projection am I missing? Thanks,Rob

7
rfedorchuk
Sidekick (Customer)
3 months ago
L
Sidekick (Partner)
LakmalSidekick (Partner)
asked in Data Migration

How to define Data Archive Object for GL tables?

We need to define Data Archive Object for GL tables (MPCCOM_ACCOUNTING_TAB and GEN_LED_VOUCHER_ROW_TAB) and other related tables. Please help to find a related tables for this task.For example, I’m expecting something like this. 

2
L
Sidekick (Partner)
11 months ago
M
Hero (Customer)
MMcKHero (Customer)
asked in Data Migration

character set for European accents

HiI’m trying to migrate some European addresses which include accents, cedillas and other special characters, for example Île-de-France,  Lérida and straße.I’m using a standalone migration job reading a CSV file (not the Excel add-in).  The characters are displayed correctly in the cs file when viewed in Excel.I’ve tried using the WE8ISO8859P1 character set which I’ve previously used successfully for the degree symbol for temperatures, but the addresses don’t display correctly - Ãle-de-France.Is there a character set which will handle all the main European special characters?Many thanks,Marion

2
Jens
Hero (Employee)
7 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)
23 days ago
S
Do Gooder (Partner)
SandyDo Gooder (Partner)
asked in Data Migration

Connect External Customer invoice with Customer Order

The standard customer invoice templates facilitate to load advance customer invoices. Can they be connected with the customer order number when loading? The reference fields can be used but it will not connect the customer invoice with the customer order.

0
S
Do Gooder (Partner)
2 years ago
E
Sidekick (Customer)
ERPDMORENASidekick (Customer)
asked in Data Migration

IFS Cloud Lead Migration Job

Dear IFS Community;Does anyone know how to import field Phone for a Lead with a Migration Job?I don’t understand why this field is not available in the File Mapping tab for BUSINESS_LEAD view (same issue with Mobile or Email).I try to add manually a field named "PHONE", no error on the execution but it’s not working. Missing Fields in the File Mapping tag for BUSINESS_LEAD viewAdd field PHONE manually (not working)If someone have a solution to this it’s will be very helpfull.Thanks

2
E
Sidekick (Customer)
9 months ago
J
Do Gooder (Partner)
Johannes KopferDo Gooder (Partner)
asked in Data Migration

FNDMIG Export from Apps in IFS Cloud

Hello, does anyone know, if it is possible to export data from an IFS Applications environment via FNDMIG_EXPORT into IFS Cloud environment via FNDMIG_IMPORT? I tried, but it seems, that it doesn´t work. From Apps to Apps it is possible, from Cloud to Cloud as well. Thank you in advance, Johannes

2
J
Do Gooder (Partner)
6 months ago
T
Sidekick (Partner)
TimVascoSSidekick (Partner)
asked in Data Migration

Export voucher entries through External Files

We are upgrading IFS 8 to IFS 10 in a Portuguese customer.Since portuguese localization requires that voucher entries for the current year must be in one software to extract legal reports we need to export data from 8 to 10. Can anyone help us with some documentation or samples?Regards 

1
G
Do Gooder
1 year ago
msurasky-price
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
A
Do Gooder (Customer)
adubeyDo Gooder (Customer)
asked in Data Migration

IFS 7.5 SP6 is supported with 19c DB?

Hi Team,I am trying to upgrade our IFS 7.5 SP6 oracle DB from 11.2.0.3 to 19c. But I am not sure if it is supported. Can you please suggest if I can do upgrade by using export import of DB and then configure IFS 7.5 SP6 application on 19c DB will it work? Does anyone done this. Regards,Ashish Dubey

3
A
Do Gooder (Customer)
5 months ago
R
Do Gooder
RicardoDeLeonDo Gooder
asked in Data Migration

How to add a property at Binding

 Hello good morning team, could you help me with this question pleaseSince property is added to a Binding, I need to put a new property 

1
P
Sidekick (Customer)
4 months ago
M
Do Gooder (Customer)
Manish VermaDo Gooder (Customer)
asked in Data Migration

ETM Event Builder

I am trying to create an ETM Channel to create new Event Builders at Item Level.Fields Usage Type and Event Type are Integers. I tried with value “1” for both fields but it is failing.Can anyone please help me in getting the Usage Type and Event Type values?

1
K
Hero (Customer)
1 year ago
D
Sidekick (Partner)
DominikaM
asked in Data Migration

Excel Input - Cloud 22R1

Hello,in the IFS 10 version we used the excel file (input excel). Was such a file created for the CLOUD 22R1 version?if so - can I ask for this file?

3
M
Hero (Employee)
1 year ago
N
Sidekick
Ngerst
asked in Data Migration

Replication Part

I am looking for a way to run a replication job for Inventory Parts from Contract A to Contract B. However, I want to change the value of a few fields when it goes to Contract B. Overall, we are changing to streamline our part creation process and one of the challenges we have faced was trying to replicate 80% of the inventory part into a new contract, but there are few value changes. Example would be Inventory Part Planner 17 for Contract A = Inventory Part Planner 20 for Contract B. Is it possible to change values of certain fields through the replication job? 

1
EfekanM
Do Gooder (Employee)
7 months ago
D
Hero (Employee)
Devni PanduwawalaHero (Employee)
asked in Data Migration

Migration job for CONTRACT_ITEM fails with an error

When the Migration job is executed, error “ORA-20110: ContractItem.CONSALESVALUEREQD: The Sales Value must have a value since Calculation Type is Sales Value and Calculation Method is Fixed.” occurs.The purpose of this migration job is to allow us to insert data from the user defined table to contract_item_tab. A similar error has been reported here.However, the procedure name used in the current example is MIGRATE_SOURCE_DATA and not procedure INSERT_BY METHOD_NEW  IFS Aurena framework version: 22.1.10.20221205084017.0IFS Aurena client version: 22.1.10.20221205084017.0 Kindly assist in identifying the root cause of this error.

7
D
Hero (Employee)
1 year ago
G
Sidekick (Customer)
golo.naitoSidekick (Customer)
asked in Data Migration

Projection - allowed operations

Hello,I created a custom projection. I added Entities but from the allowed operations, I could only select READ.What do I have to change to also select CREATE, UPDATE and DELETE?Thanks, Golo 

1
D
Do Gooder (Employee)
2 months ago
PhillBronson
Sidekick (Customer)
PhillBronsonSidekick (Customer)
asked in Data Migration

Own Process Share or Export

I have some success organizing different task and streamlining the process by using the “Own Process” functionality.It has enabled my team to create custom menus, RMB, conditional formatting, and conditional fields to keep the user experience pretty clean without introducing extraneous options when not applicable. To start, I have had interns work on designing different Own Processes under their own account, as proof of concepts. I don’t want to alter their permissions to allow access to base profiles in order to publish their pages. And I would love not to have to recreate these individually under the base profile as it would be quite time consuming and double work. Is there a way to export these Own Process versions of pages?I know I can save all my RMB separately and import them, as well as any lobby elements we have mapped to forms or pages. Sending these pages to others via “Stream or Email” only send a link to the original configuration of the view. I really need a more efficient

1
PhillBronson
Sidekick (Customer)
1 year ago
B
Do Gooder (Customer)
brmoDo Gooder (Customer)
asked in Data Migration

Enumerate values

Hello, I want to consult the values of an enumerate in order to export it and add a new values. how can I make it ?. Thanks

1
Link
Superhero (Customer)
1 year ago
Michael Kaiser
Sidekick (Customer)
Michael KaiserSidekick (Customer)
asked in Data Migration

Employee_ID Database_ID

Hi,for external (QlickView) security reasons we need the following format in the DIM_Employee/DIM_Person in the datawarehouse.FirstCharacterSurName+LastName. Like MKAISER (michael.kaiser@company.de)While I’m in the IFS maskSolution Manager > Security > Users > Create UserI will see IDENTITY and Database ID: with the formatting above.The System Info stays empty and the debug console don’t show anything.So any hints, in which View/Table I can find an PERSON_ID and DATABASE_ID in one row? Thanks a lot!All the best. Michael 

2
Michael Kaiser
Sidekick (Customer)
1 year 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)
5 months ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Data Migration

Crystal Report Customer Order Confirmation

We have our Customer Order Confirmations printing through Crystal Reports. We recently set up a new site. These reports are not showing any information for the new site when we print a confirmation. Is there something in IFS I could be missing for the site set up? Or is there a spot in IFS that tells Crystal which site’s are allowed for this? I looked at the crystal report file itself and it doesn’t seem to be doing anything with the site. 

4
C
Sidekick (Customer)
1 year ago
M
Sidekick (Customer)
mmossSidekick (Customer)
asked in Data Migration

Make Line Reservations Migration Job

I am looking to create a migration job which reserves available material each morning for open material requisition lines. I have followed steps outlined here but could not make the jump from the Customer Order to the Material Requisition. Here is my current setup. I am not sure on the Source Mapping and for some reason  Part_No is not listed as a column name even though I see it when testing the API using Postman. SELECT MRL.QTY_DUE - MRL.QTY_ASSIGNED, MRL.ORDER_CLASS, MRL.ORDER_NO, MRL.LINE_NO, MRL.RELEASE_NO, MRL.LINE_ITEM_NO, MRL.QTY_DUE - MRL.QTY_ASSIGNED, ROWID FROM MATERIAL_REQUIS_LINE MRL WHERE MRL.STATUS_CODE IN ('Released','Reserved','Partially Delivered') AND (MRL.QTY_DUE-QTY_ASSIGNED) >0Select statement OK, parsed and executed for 1 row Length of statement : 289 characters MATERIAL_REQUIS_LINE_API.MAKE_LINE_RESERVATIONS    

1
P
Hero (Employee)
1 year ago
msurasky-price
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
msurasky-price
Sidekick (Customer)
2 months ago
S
Sidekick (Customer)
sahangoSidekick (Customer)
asked in Data Migration

How can I activate the migration job to the user.

I created migration job named “PURCH_REQ_MIGRATE_MNTJ”. But the user can not see this. How can I activate the migration job to the user.  Or should I confirm the permission set?  

2
S
Sidekick (Customer)
3 months ago
H
Do Gooder (Customer)
HSGNOSGOODDo Gooder (Customer)
asked in Data Migration

ORA-20105: Dictionary.CLIENTNAME_IS_NULL: Cannot convert the client name [NULL] into a database name

I am getting this error on a migration job.  I have refreshed the dictionary cache and that did not help.  I am currently on Apps 10 Update 16.

2
H
Do Gooder (Customer)
9 months ago

Badges

Show all badges
Terms & ConditionsCookie settings