Data Migration

This will include topics related to data migration.

  • 418 Topics
  • 1,085 Replies

418 Topics

B
Do Gooder (Customer)
bpamlinDo Gooder (Customer)
asked in Data Migration

Exporting Aurena Context to another environment

Is there a way to export a context and all its configuration from a test instance to PROD?Please advise. Thank you!

0
B
Do Gooder (Customer)
8 months ago
F
Sidekick (Employee)
fengSidekick (Employee)
asked in Data Migration

What are the permissions required to display all the items of Data Management?

Hi  What permissions do I need to add in order to be able to display all menus of Data Management?Thanks & Best regards! 

5
F
Sidekick (Employee)
9 months ago
S
Do Gooder (Customer)
SPRRAJDo Gooder (Customer)
asked in Data Migration

Data Migration

Hi,I’m trying to load Functional Objects using the Equipment_Functional_API. But I’m unable to set the “Belongs to Object” or SUP MCH CODE via this API and view Equipment_Functional_UIV. Any suggestions, how do this under Data Migration Job? Thanks

4
T
Superhero (Employee)
5 months ago
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration

Creating an IAL

Hello - I am trying to create an IAL but it keeps failing with the following (Failed executing statement (ORA-00903: invalid table name).  I can run the same code in SQL developer with no issues, can someone tell me what I am doing wrong please ?

2
NiyomalN
Hero (Partner)
9 months ago
B
Do Gooder (Customer)
brammarissinkDo Gooder (Customer)
asked in Data Migration

In-place upgrade OS

Hi all,Our IFS Application en Database servers are running on Windows 2012R2. We are currently in the process of updating those servers to Windows Server 2019. Before we proceed, we would like to hear from anyone who has experience with performing in-place upgrades to either Windows Server 2016 or 2019.Our team is considering the in-place upgrade route as it offers the advantage of retaining existing settings, configurations, and applications. However, we are aware that this process can be complex and potentially risky, so we are seeking insights and advice from those who have gone through this upgrade journey before.If you have successfully completed an in-place upgrade from IFS servers running 2012R2 to either Windows Server 2016 or 2019, we would greatly appreciate hearing about your experiences. Thank you in advance!

1
G
Do Gooder (Customer)
8 days ago
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

3
A
Do Gooder (Partner)
13 days ago
M
Do Gooder (Partner)
MikeB_ECDo Gooder (Partner)
asked in Data Migration

Multiple Orders in one XML file

Is it possible for the receive_customer_order XML file to contain multiple orders?  From the same customer or from different customers?

0
J
Do Gooder
9 months ago
S
Do Gooder (Customer)
SPRRAJDo Gooder (Customer)
asked in Data Migration

Data Migration issue

Hi, I’m migration Parts with Serial Nos into Inventory Part in Stock table in IFS using Data Migration Job. But my Part & Serial Nos are not reflecting in Part Serial screen. But if I create them manually, they reflect in Part Serial screen. How can see them in Part Serial screen using Migration Job?

4
S
Do Gooder (Customer)
9 months ago
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration

How to move External File Templates from one environment to another

Hi All,I would like to know what is the best way to move an External File Template from one environment to another ( Ex. STG to CFG) in IFS CLOUD 23R1? Thank you!

0
Disna Marakkala
Sidekick (Employee)
9 months ago
pasana
Sidekick (Employee)
pasanaSidekick (Employee)
asked in Data Migration

RestApi Outbound Call with http PATCH method does not work

Issue I'm using Plsql_Rest_Sender_API.Call_Rest_Endpoint_Json to call rest API service. It works fine for POST and GET, but it does not work for PATCH. I'm getting following error message:ExecutionException from Sender thread Caused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending data Caused by: ifs.fnd.base.SystemException: Patch error: 405 (Method Not Allowed)The same PATCH call works fine from Postman, so there is no issue on receiver side.Product Version: 22R2SU8  Resolution Restarting the ifsapp-connect container will the solve the initial issue. Then you might see the below error,ExecutionException from Sender threadCaused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending dataCaused by: ifs.fnd.base.SystemException: Patch error: 201 (Created)This happens because by default IFS Connect Rest Sender doesn’t accept HTTP Code 201 as a success response. REST Sender by default accept only HTTP Code 2

1
ashen_malaka_ranasinghe
Hero (Employee)
8 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
A
Hero (Partner)
astfaraztHero (Partner)
asked in Data Migration

Excel Migration Job - Modification Issue

I’ve created an Excel migration job to modify values on a Sales Price List, but it seems that each time that I execute the job, a new record is created instead of updating the record that already exists. For this particular migration job, there will never be a requirement to insert new values, only update existing.   Any ideas what I am doing incorrectly? Environment: 23R1 SU 1 Source Mapping:Method List Attributes: 

2
A
Hero (Partner)
9 months ago
T
Sidekick (Customer)
TaMaSidekick (Customer)
asked in Data Migration

Fixed asset and acquisition value imported, even it was a new asset

Hi Acquisition value was done with process import even this was a new asset. There is a acquisition value but when running the depreciation proposal there is no value. Can we cancel this import?

0
T
Sidekick (Customer)
9 months ago
A
Do Gooder
ashwanikumarDo Gooder
asked in Data Migration

Equipment object does not exist error in Migration job

Hi,I am facing an error “ORA-20105: MaintenanceConnection.INVEQUIPOBJ: The Equipment Object does not exist” when trying to migrate the prepare work order.The object ID, i am using is already available in functional object screen.Data migration screen snap 

1
NiyomalN
Hero (Partner)
8 months ago
H
Do Gooder (Partner)
hburkettDo Gooder (Partner)
asked in Data Migration

Migration Job for Functional Object Testpoints and Parameters

Hi,I am trying to run a migration job to import a large number of test points and parameters on functional objects. I am experiencing two issues:1. Testpoints: for some reason I cannot migrate into the custom fields I have set up on Testpoints (EQUIPMENT_OBJECT_TEST_PNT). Any idea’s why the migration job will not let me migrate into my persistent custom fields?2. Parameters: When I run the second method of my migration job (EQUIP_OBJ_PARAM), it updates the Parameter for the Default testpoint not my newly created Testpoint. Anyone had a similar issue or has a solution? Any help would be much appreciated. Thanks,Harry

1
Jens
Hero (Employee)
9 months ago
S
Sidekick
signilsSidekick
asked in Data Migration

Using migration job to upload images

Hi,Does anyone have a migration job or script for mass uploading documents, images into IFS? Instead of having to do it one by one using “Upload Document” screen

1
A
Superhero (Employee)
9 months 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
N
Do Gooder (Partner)
NishithDasDo Gooder (Partner)
asked in Data Migration

Restrict Auto Generation ID in case value available in Legacy Data

Hi All,We are Migrating Employee Records using DMM. As per requirement we would need Person ID to be generated automatically if person id in legacy data is blank, in case if any person id provided in legacy record, then DMM shouldn’t generate the ID. We have enabled Auto Generation feature for Person ID column in PERSON_INFO target table. It is working fine where Person ID is blank in legacy records, but it do generate ID for records where Person ID is not blank. Any feature available to restrict generating the ID incase legacy record have any value passedThanks,Nishith 

0
N
Do Gooder (Partner)
10 months ago
S
Sidekick
signilsSidekick
asked in Data Migration

Use migration job to update null values

Hi,I need my mig job to update null values against a custom field since we inserted the wrong values against it the first time around.I have put the default value as NULL against the custom field in the mig job but it isn’t updating it

1
Jens
Hero (Employee)
10 months ago
N
Do Gooder (Partner)
NishithDasDo Gooder (Partner)
asked in Data Migration

Unable to create customer in Connected Env via Data Migration Manager

Hi,We are deploying customer via DMM onto a connected environment. But we are getting below error. Any idea what permission is missing here. Please note with the same user I am able to create customer manually in the same connected environment Method NEW failed : ORA-20110: CustomerInfo.NOACCESSTOCREATECUSTOMER: You have no permission to create customers of category CustomerORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 354ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 2442ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 2459ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 677 Thanks,Nishith 

5
L-PINTA
Do Gooder (Customer)
7 months ago
J
Sidekick (Partner)
jasahuSidekick (Partner)
asked in Data Migration

App9 UPD11 - Data Archiving performance problems - doing it parallel?

The customer has lots of data in some tables - mostly quality assurance related, traceability - and keeps only last 3 months of data in the main tables.They have already setup archiving which works okay, except it started to get too slow mainly because it takes the rows in the head table one by one.As it does not put a big load on the storage we tried find some option to do it parallel, meaning several archiving jobs (orders) could run for these tables with different filters at the same time.But we found that the jobs are executed one after another:Is there a way to make them run parallel? 

0
J
Sidekick (Partner)
10 months ago
C
Do Gooder (Customer)
CherylLausDo Gooder (Customer)
asked in Data Migration

Data Migration SYNCDETAILS Rule

Has anyone successfully used the SYNCDETAILS Rule in a Migration Job? I made the header fields in my file the same what shows in to “Column Name” in File Mapping but when I unpack the file I get Column “xxxx” does not exist.  I am using a csv with double quotes as the Column Embrace and would expect this to apply to the headings as well. 

2
C
Do Gooder (Customer)
10 months ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Data Migration

Crystal Reports / Database Replacement

Hello, After moving a copy of our database to our test environment, we realized our crystal reports are grabbing data from our production environment. Where do I redirect crystal reports to look at our other server in IFS? Thanks!!!

1
Manulak
Hero (Customer)
10 months ago
lescobar
Do Gooder (Partner)
lescobarDo Gooder (Partner)
asked in Data Migration

Error in migration job - Org Position Structure

We’re trying to get the migration done and we have an structure like this as a CSV:CSV - source fileAfter we finish the first job which is the creation of the table with this data, there’s no error. The error comes after we execute the second job which is the one that migrates data, I get this error:ORA-20124: Error.NULLVALUE: Field [BUSINESS_UNIT_ID] is mandatory for Business Unit Relation and requires a value. Here is what’s been done:To test we only try to migrate one of the rows, the one with POS_CODE=’50000008’ The attribute string we get is: COMPANY_ID=ABCPOS_CODE=50000008POSITION_TITLE=ASSISTANT MANAGERVALID_FROM=2023-06-22-21.29.22VALID_TO=9999-12-31-00.00.00TIME_FORMAT=Minute by minuteASSIGNED_PROTECTED=FALSEEXCLUDE_FROM_EXPORT=FALSEEXCLUDE_FROM_ORG_CHART=FALSEDEFAULT_ACCESS_EXTENSION=FALSEEXPORT_EMPLOYEES=FALSESTRUCT_BU_ID=781BUSINESS_UNIT_TYPE_DB=COMPANY Here the job execution that throws the error:  and the migration job is defined like this: 

1
NiyomalN
Hero (Partner)
10 months ago
ismigulay
Do Gooder (Customer)
ismigulayDo Gooder (Customer)
asked in Data Migration

Refreshing the current form.

Hello,A repopulate can be accomplished by calling the DataSourcePopulate method on a window or a child table. Doing this on a form window will repopulate the window, and add newly created records and remove deleted records from the record selector. For table windows and child tables new records will be added and deleted records will be removed from the table.Forms can be refreshed by calling the DataSourceRefresh method. This will re-fetch only the record currently selected in the record selector, with its objid. DataSourceRefresh can be called on table windows but that will do a repopulate rather than a refresh.How do I use this in visual studio?

0
ismigulay
Do Gooder (Customer)
10 months ago

Badges

Show all badges
Terms & ConditionsCookie settings