Data Migration | IFS Community

Data Migration

This will include topics related to data migration.

  • 77 Topics
  • 240 Replies

77 Topics

R
Sidekick (Customer)
ronhuSidekick (Customer)
asked in Data Migration

The Intface Group does not exist

Community, i have this error when creating a migration job, may I know what I did wrong? Thank you.

2
R
Sidekick (Customer)
5 hours ago
A
Do Gooder (Customer)
AO0001Do Gooder (Customer)
asked in Data Migration

IFS Applications - Error when validating rows in migration job

Hi. I get an error when attempting to validate a row in a newly created migration job:The logged in user has permissions to the migration job and the data is OK, I’ve created a few other similar jobs today and all have worked fine.ThanksAO0001

0
A
Do Gooder (Customer)
13 hours ago
D
Do Gooder (Customer)
DHPCALBRECHTDo Gooder (Customer)
asked in Data Migration

Supplier Company Migration

I have been doing these migrations for some time now and never have had an issue where I get no information to migrate.  I am getting not 1 record going into IFS and I just get Not Processed.  Can someone lead me to where I can understand why none of these MTK_SUPPLIER_COMPANY_TAB records are not being migrated.  

0
D
Do Gooder (Customer)
1 day ago
B
Sidekick (Customer)
bldrayiSidekick (Customer)
asked in Data Migration

New Company Creation Error

After company Creation from an existing company it gave in the log the following error  using IFS10 with UPD11:ORA-20111: UserFinance.RECNOTEXIST: Access denied! User IFSAPP is not connected to Company KSA022what id the reason and how it can be rectified?Best Regards,Bilal Drayi

2
B
Sidekick (Customer)
1 day ago
SMANUEL
Sidekick (Partner)
SMANUELSidekick (Partner)
asked in Data Migration

Migration of IFS Users

Is there a way to migrate IFS users from one environment to other (TEST to PROD) ? Thanks in AdvanceSBM

0
SMANUEL
Sidekick (Partner)
1 day ago
WSHAH
Do Gooder (Customer)
WSHAHDo Gooder (Customer)
asked in Data Migration

Data Migration Job Takes time

HiData Migration Job Takes much time, I have to Migrate more than 10 hundred thousand data.For data of 44 Thousands rows/records  job will take time more than 150 minutes.Kindly advise

2
WSHAH
Do Gooder (Customer)
3 days ago
M
Sidekick (Customer)
MatthewSidekick (Customer)
asked in Data Migration

Migration Job - Export to none-DB machine

Hi, Has anyone managed to get an IFS Migration Job (we are Apps 9 but interested in other versions) to export a file directly to a machine other than the DB Machine?Thanks, Matt

0
M
Sidekick (Customer)
5 days ago
udenig
Do Gooder (Partner)
udenigDo Gooder (Partner)
asked in Data Migration

Can Data Migration Tool (APP10) support CLOB Data Type?

Customer needs to create Quick Reports through Data Migration Tool and need to specify the Query column which is a CLOB type, here it won’t allow.  Is there a way to migrate the CLOB data type? 

1
M
Do Gooder (Employee)
8 days ago
C
Do Gooder
cwerzynDo Gooder
asked in Data Migration

Used a migration job to load starting inventory but it doesn't appear in the GL or inventory transaction history. (Inventory Parts in Stock is correct though)

Used a migration job to load starting inventory but it doesn't appear in the GL or inventory transaction history. (Inventory Parts in Stock is correct though) 

1
K
Sidekick (Customer)
9 days ago
K
Sidekick (Customer)
KIMKIMANDREWSidekick (Customer)
asked in Data Migration

Calling an API in DataMig to schedule background job

I am trying to write a two part DataMig (MS_FORECAST_FILE to load the data then MS_FORECAST_MIG to schedule the import for each part) to load data using:level_1_forecast_util_api.Schedule_Import_Forecast  The first job to load the data works fine and I get an IC table ready for the 2nd DataMig job.To test the SQL code for the ATTR values to pass to the API call, I have a working PL/SQL cursor...begin  for ic in (select * FROM IC_MS_FORECAST_FILE IC) loop    level_1_forecast_util_api.Schedule_Import_Forecast__('CONTRACT' ||                                                         CHR(31) ||                                                         IC.CONTRACT ||                                                         CHR(30) ||                                                         'PART_NO' ||                                                         CHR(31) ||                                                         IC.PART_NO ||                                                         CHR(

0
K
Sidekick (Customer)
9 days ago
N
Do Gooder (Customer)
NewbieCoderDo Gooder (Customer)
asked in Data Migration

How to export information source for QIS Importing

Hello, I am wondering if I am able to export current information source in business reporter and import to QIS for a duplicate source with additional information. I tried the export of original information source as .ins and .xml. When I import however to QIS it does not read the .ins and errors the .xml file.

0
N
Do Gooder (Customer)
11 days ago
W
Do Gooder (Customer)
washtonDo Gooder (Customer)
asked in Data Migration

Cannot insert NULL into ("IFSAPP"."PUTAWAY_BIN_TMP"."BAY_ROUTE_ORDER")

Hi,In APPS10, we’re getting this error when trying to perform an inventory movement. Upon checking the inventory location, it appears that it’s because Bay Route Order, Row Route Order and Tier Route Order are NULL.This is odd as the location’s Bay ID, Row ID and Tier ID are populated so I would expect the route orders to have the same value.Bay ID, Row ID, Tier IDBay Route Order, Row Route Order, Tier Route OrderI’m not able to use a migration job to populate these fields as they’re not stored values. Is there a way to almost refresh/re-execute the package methods to update the route order fields with the correct values? The packages used for these fields are:&AO.Warehouse_Bay_API.Get_Route_Order, &AO.Warehouse_Bay_Row_API.Get_Route_Order and &AO.Warehouse_Bay_Tier_API.Get_Route_OrderThis seems to be happening to quite a lot of inventory location records. Any help would be appreciated.

1
W
Do Gooder (Customer)
12 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)
15 days ago
I
Do Gooder (Partner)
israelolDo Gooder (Partner)
asked in Data Migration

Error of Insufficient Privilege while spooling IFS report to excel

Please I am having this IFS error of insufficient privilege while spooling report to excel, and the select privileges on the table have been granted already. This spools correctly when a normal report is run, but fails when I choose Export to ExcelError message: "Excel Plugin Error: ORA-06550: line 11, column 26: PL/SQL: ORA-01031: insufficient privileges"  

2
I
Do Gooder (Partner)
15 days ago
N
Do Gooder (Customer)
Nico13Do Gooder (Customer)
asked in Data Migration

GIS proxy configuration - Background job refresh proxy config

Hi,I am using a GIS server to have a map with objects in IFS.I also configured the GIS proxy in IFS but when I have a look at the documentation it says the new config should be populated with a background job called "GISINT - Refresh proxy configuration" but on my systems this job is missing.How can I populate the new proxy configuration and why is this job missing though it is described in the documentation?Thanks for any hint,best regards,Nico

0
N
Do Gooder (Customer)
16 days ago
P
Do Gooder (Partner)
Peroni79Do Gooder (Partner)
asked in Data Migration

detailed data migration steps

Where can I find detailed information on how to perform data migration end to end. There is not much detail at this location: https://docs.ifs.com/techdocs/Foundation1/010_overview/260_data_management/010_fndmig/default.htm

2
M
Do Gooder
18 days ago
W
Do Gooder (Customer)
WHAPOLDFIELDDo Gooder (Customer)
asked in Data Migration

System set up for shortages.

does anyone know where the system set up is for shortages? , getting following error when trying to load inventory parts - ORA-20110: InventoryPart.NOSHORTAGEHANDLE: Cannot have shortages at part level if System flag is set to No.

2
W
Do Gooder (Customer)
19 days ago
A
Do Gooder (Customer)
aweDo Gooder (Customer)
asked in Data Migration

Use IFSAPP log in Excel Plug in with SSO enabled

Hi!How can we log in to Excel plug in using IFSAPP when we have SSO enabled? non of the checkboxes in the picture makes any differences.Best regardsAlbin 

2
A
Do Gooder (Customer)
20 days ago
P
Do Gooder (Customer)
Prince EmmanuelDo Gooder (Customer)
asked in Data Migration

IFS integration

To extract data from IFS, Is the use of ETL like Boomi prevent the use of other mode of Extraction( flat files extraction ) ? that is to say, if i use Boomi to extract data from IFS i cannot do so using flat file in the same time ?

1
Peter Sketch Boomi
Hero (Partner)
20 days ago
A
Sidekick
Amitesh_IFSSidekick
asked in Data Migration

migration job with multiple method list

Hi,Is there any way we can achive the below through migration ? I have 2 method calls in method list Method1Method2how can we use the out parameter from Method1 is and use the same in Method2 ? Thanks in AdvanceAmitesh

2
A
Sidekick
27 days ago
O
Sidekick
OzgeSidekick
asked in Data Migration

Status of Structures

Hi all, Can to convert the status of structures from Tentative to Buildable in one move? Best regards,Ozge

6
O
Sidekick
1 month ago
Jan Siekmann
Sidekick (Partner)
Jan SiekmannSidekick (Partner)
asked in Data Migration

Data Migration privilige

​Hello everyone,I get an error message when I try to load migration job (detail) or to execute job with my personal user in Cloud:How can I assign this privilege to a user?I cannot find it in the list:Thanks for a feedback.BR,Jan​

4
Jan Siekmann
Sidekick (Partner)
1 month ago
T
Do Gooder (Partner)
TimVascoSDo Gooder (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 

0
T
Do Gooder (Partner)
1 month 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 

0
G
Sidekick (Customer)
1 month ago
A
Do Gooder (Employee)
amithelaooDo Gooder (Employee)
asked in Data Migration

Data Migration for a live project

I have the below Data Migration query from a customer and I wanted to check if there is a standard guidance for this? When a customer goes live half way through an active project which was more than one or two years what is the best mechanism for data migration. -App10 I want to confirm which all connections the customer would need to consider to migrate (Sub Contracts, Sales Contracts, Purchase Orders, etc) and how can they manage open PO’s, Sub contracts? How would you recommend to move the Used/Actual cost? Assuming they wouldn't need detailed historical transactions, would it recommended to create Cutover activities and bring in the values in this new activity? Anything else they would need to consider before they start with this process?

0
A
Do Gooder (Employee)
2 months ago

Badges

Show all badges
Terms & ConditionsCookie settings