Hi @Dharshankumaar Mahendran For that purpose is good training material in the “Technical Documentation for IFS Cloud” available: For example here: https://docs.ifs.com/techdocs/23r2/030_administration/050_data_management/050_data_migration/ or here: https://docs.ifs.com/techdocs/23r2/030_administration/050_data_management/050_data_migration/030_migration_types/ There is also the opportunity to order a success service which is called TAA3 or TAA3P. In the Academy you can find the following training which is based on IFS Applications 10.→ Course ID: SOERPONIDM202212 /Jens
Hi @NishithDas please have a look into the technical documentation of IFS Cloud:https://docs.ifs.com/techdocs/23r1/030_administration/050_data_management/050_data_migration/030_migration_types/030_excel_migration/→ Handling LUs with Custom Fields: Instead of PROJECT_MISC_PROCUREMENT for Execute Seq 10 in the method list you have to select PROJECT_MISC_PROCUREMENT_CFV → The method name will be the same PROJECT_MISC_PROCUREMENT_API. For the Execute Seq 20 I can’t see the method list attributes:You have to delete the lines which are not needed because these are already included in the method list attribute screen for Execute Seq 10 You have to inherit the OBJID_ from Execute Seq 10 and also mappe ATTR_ as a fixed valueExample (copied from the technical documentation): The rule FETCHCONDITION in the tab RULES is not needed for that purpose because of the inheritance defined in the method list attribute screen in Execute Seq 20. Happy migration. /Jens
@rfedorchuk As already written in the following linkMigrating Users in Cloud environments | IFS Communitythe user email is stored in the view fnd_user_property.That means you have to export (CREATE_OUTPUT_FILE) the data of this view as well with the where clause name = ‘SMTP_MAIL_ADDRESS’ and then migrate this into the target environment with a CREATE_TABLE_FROM_FILE and MIGRATE_SOURCE_DATA migration job using the view name fnd_user_property./Jens
Hi @rfedorchuk Does it work now?/Jens
Can you please remove the value <space> in the field column embrace in the migration job TMP_IMPORT_USERS in the tab File Configuration?Afterwards load your csv file again.After the file is loaded and before executing you can press the button Unpack File on the top of the Execute screen. When you press the button then the column Attribute String will be filled. When you click left of this field then you’ll find the column names of your file mapping and the related values of your csv file. Does the field DESCRIPTION= still have the concatenation field values of all fields or only the real value?I‘m still talking about the TMP_IMPORT_USERS job. You can of course also execute TMP_IMPORT_USERS and create a Quick Report with select * from ic_TMP_IMPORT_USERS to see the results. /Jens
Hi @rfedorchuk Ok, your csv-file has comma as column separator. Can you please also provide screenshots of your migration job TMP_IMPORT_USERS (procedure name CREATE_TABLE_FROM_FILE) as requested? Screenshots of the tabs File Configuration, File Mapping and Rules please.In the tab File Configuration you have Comma as column separator defined?/Jens
Hi @rfedorchuk can you please provide a screenshot of the extracted Excel file? That means save the Excel file as a csv-file and only the first two records (header line and data line) are needed. Which IFS data migration tool are you using? I suppose you are the “Data Migration”/”FndMig” tool and not DMM (Data Migration Manager)?If so then I need screenshots of your CREATE_TABLE_FROM_FILE job where you load the raw data into a “temporary” IC-table. Screenshots of the tabs File Configuration, File Mapping and Rules please.Possibly the Column Separator in the tab File Configuration is not correct but let’s see.And then I also need screenshots of your second migration job (MIGRATE_SOURCE_DATA) which fetches the records from this created IC-table. Screenshots of the tabs Database Information, Source Mapping, Method List and Rules please./Jens
Hi @rfedorchuk I suppose you already use the fnd_user db-view to export and import the users.To get the email_address of a user please have a look into the db-view fnd_user_property (filter for name = ‘SMTP_MAIL_ADDRESS’).Identity = user_idname = SMTP_MAIL_ADDRESSVALUE = email address/Jens
Hi @Magdalena Kasjaniuk Additional hint:My recommendation is always to use 2 migration jobs:1. To load the raw data from the legacy file into an IC-Table of IFS Applications (procedure: CREATE_TABLE_FROM_FILE). When your job id has the name CRE_ABC and you load/execute the file/job then a table/view IC_CRE_ABC_TAB/IC_CRE_ABC will be created.2. To fetch the data from the IC-table, e.g. IC_CRE_ABC, and deploy the data into IFS Applications. (procedure: MIGRATE_SOURCE_DATA). In this migration job the mapping will be done and you are also more flexibel regarding transformations, updates/inserts/removes etc.If you have access to the IFS Academy then I recommend to have a look into the course id SOERPONIDM202212 or it's always worth booking a training course (e.g. TAA3 - Data Management best practices) to learn more about that./Jens
Hi @ksebf @Marcel.Ausan @kgray Sequence_name.nextval can be added into the tab Source Mapping and here either in the column “source name” or “default value” to a specific “column name’.But keep in mind:When you’re using a ...nextval functionality (Oracle sequence) then every time you execute your job new records will be created/inserted and not updated because you’re always fetching the next sequence number. If you also want to update already migrated records in that case then you have to ensure that you will update these otherwise you produce records you don’t want to have. Saving these sequences in a conversion list or a key manipulation in the tab method list attribute can be a solution depending on the logical unit you’re using As mentioned in this example the function Order_Coordinator_Group_API.Get_Order_No(‘S’) or Order_Coordinator_Group_API.Get_Cust_Order_No(‘S’) will only fetch the current order number of “Customer Order Number” of the screen Coordinator Groups depending on
Hi @JannetteC I suppose that the following statement is wrong:email_addr_ varchar(2000) := | ; This should be something like that:email_addr_ varchar(2000) := ‘|’ ;ORemail_addr_ varchar(2000) := ’’ ; ‘ = single quotation /Jens
Hi @rfedorchuk the ADDRESS field is a kind of concatenation of the fields ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, ADDRESS5, ADDRESS6, COUNTRY, ZIP_CODE, CITY, COUNTY and STATE based on the “Address Presentation” (search for that in the Client navigator) setup.So if you update one of these fields then the ADDRESS field will automatically be updated as well./Jens
Hi @Ash1807 it seems that the field which shall be indexed is missing in the following SQL statement (in red characters below):CREATE INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB(<FIELD>)I suppose you’re using a migration job with the procedure MIGRATE_SOURCE_DATA or are you using another procedure for that purpose (INSERT_OR_UPDATE, INSER_BY_METHOD_NEW)?Can you please provide me screenshots of the tabs “Rules” and also “Source Mapping”?/Jens
Hi @ksebf the GL (gen_led_voucher and gen_led_voucher_row) will be updated/filled when you use e.g. the functionality GL update.Thats means that vouchers from voucher and voucher_row (so called hold table of GL) will be moved to gen_led_voucher and gen_led_voucher_row.Additionaly the accounting_balance will be updated and also the codestring_comb where the field posting_combination_id have a connection to the posting_combination_id of gen_led_voucher_row and accounting_balance.The issue right now is that probably the field posting_combination id in the gen_led_voucher_row has still the wrong value, the necessary records for the codestring_comb are missing and the accounting_balance doesn’t have the record with the new posting_combination_id.This is nothing which you can repair with any IFS migration tool any more as you already recognized.To repair this constellation in the database is very tricky if you don’t know what to do and I don’t recommend to do this please.It shouldn’t be allo
Hi @ArcAleksS go to the tab Method List of your migration job: Press the 3 dots and choose Method List Attribute.Filter for INVENTORY_PART%Go into EDIT mode, tick off the On Modify flag for INVENTORY_PART_DB and press SAVE. Try again please./Jens
Hi @Johannes Kopfer Yes, I’ve done this several times without any problems.Prerequisite:In the migration job FNDMIG_EXPORT, tab RULES, the rule id DEPLOYFILE must be set to “Inactive”.Questions:Do you get any kind of error when importing the file using the migration job FNDMIG_IMPORT? Do you get an information/window after the import? If so what is the content of this information/window? Which IFS Applications release are you using (10, 9, 8, 7.5,...)? How big is your file to import? Do you probably get a time out by the IFS Cloud client? /Jens
Hi @ArcAleksS I suppose you are using a tax code/fee code where the fee rate is not 0 and taxable for the specific company. Check the Tax Codes overview screen for the specific company please. The reason for your error message can be one of the following settings or both:Please have a look into the purchase part for the specific site. In the GENERAL tab is a field Taxable. Is it TRUE of FALSE? If it's FALSE then you'll get the error based on my initial assumption. Also have a look into the Supplier window -> Invoice -> Tab TAX INFORMATION for your specific company. Has the field TAX LIABILITY the value EXEMPT or TAX? If it's EXEMPT then you'll get the the error. /Jens
Hi @MMcK when loading OnClient then please use UTF8. That means your csv-file must be saved as UTF8 file.When using OnServer then you can choose the same character set in your migration job as your csv file is stored. But for OnServer you need access to a folder on the database server./Jens
Hi @feng possibly the IFS Cloud Technical documentation helps in that case? For 22R2:https://docs.ifs.com/techdocs/22r2/030_administration/010_security/020_permission_sets/007_predefined_permission_sets/ For 23R1:https://docs.ifs.com/techdocs/23r1/030_administration/010_security/020_permission_sets/007_predefined_permission_sets/ /Jens
Hi @SPRRAJ can you show us your migration jobs and also your legacy data (only a few records) please?I suppose you are using 1 migration job (procedure CREATE_TABLE_FROM_FILE) to load your raw data and 2nd migration job (procedure MIGRATE_SOURCE_DATA) to fetch the data from the 1st migration job.You’re trying to migrate a tree/hierarchy and that means you need a kind of master record with no “Belongs to Object” or SUP MCH CODE content and then the tree/hierarchy below this master records which needs this information to the level of this tree above.Example:HQ is my master record (MCH_CODE HC, CONTRACT 501) → Level 1 SERVICE_SITE (and REPAIR) are on the 2nd level→ MCH_CODE SERVICE_SITE, CONTRACT 501→ SUP_MCH_CODE HC, SUP_CONTRACT 501SUP_MCH_CODE = Belongs to objectSUP_CONTRACT= Belongs to site ABC (and DARE) are on the 3rd level→ MCH_CODE ABC, CONTRACT 501→ SUP_MCH_CODE SERVICE_SITE, SUP_CONTRACT 501etc.A SQL can be the following one and this is something you can include in your 2nd mi
Hi @JannetteCCan you please show us your SELECT statement or IAL please?Probably you have to add the schema as prefix of your table.E.g. table is CUSTOMER_INFO_TAB→ IFSAPP.CUSTOMER_INFO_TAB My recommendation is always to use the DB view instead of using the DB table.select * from ifsapp.customer_info/Jens
Hi Siba.ok, don’t use the db view INVENTORY_PART_IN_STOCK or INVENTORY_PART_IN_STOCK_DELIV with the method INVENTORY_PART_IN_STOCK_API directly.Instead of using this keep the view name empty and add the method INVENTORY_PART_IN_STOCK_API.RECEIVE_PART_WITH_POSTING.Example (based on IFS Applications 10 but it is the same for IFS Cloud):After saving go to the tab Source Mapping and map your fields:The field ...TRANSACTION_ must have the value NREC.It’s also not necessary to migrate the serial part numbers separately because these will automatically be created. Kind regards,Jens
Hi @SPRRAJcan you please provide some screenshots of your migration job? I suppose your using the procedure name MIGRATE_SOURCE_DATA in the header of your migration job.If so then please provide screenshots of the tabs Method List and Source Mapping.I think you are migrating directly into the view INVENTORY_PART_IN_STOCK and this is the fault.Kind regards,Jens
Hi @astfarazt Probably it has something to do with the field MIN_DURATION which should have the value -1 Please have a look into another community post where a similar issue occured: /Jens
Hi @hburkettregarding the migration of custom fields please have a look into the Technical Documentation for IFS Applications 10:https://docs.ifs.com/techdocs/https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/003_data_migration_in_custom_objects/ I suppose your second topic is related to the field TEST_PNT_SEQ of the db view EQUIP_OBJ_PARAM.The issue in that case is that you are not aware of the value for TEST_PNT_SEQ because this will be generated by the system and if you want to do an update it will not find your existing record.My recommendation is (we call it a key manipulation):go to the tab “Method List” RMB on the line with the view EQUIP_OBJ_PARAM Change the flag for TEST_PNT_SEQ from “K” to “-” (minus sign) Now we need another unique primary key because at the moment we only have the field PARAMETER_CODE defined as a keyfield (Flag: K) Change the flags for the fields CONTRACT, MCH_CODE, TEST_POINT_ID also to “K” Execute your
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
