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
Hi @ERPDMORENA The fields email, phone, mobile etc. must be migrated into BUSINESS_LEAD_CONTACT.The DB view BUSINESS_LEAD is fetching this information from the DB view BUSINESS_LEAD_CONTACT./Jens
Hi @signils can you try ‘NULLVALUE’ please (incl. the apostrophes)? /Jens
Hi @sashikant I suppose you’re talking about an Oracle database clone where normally all data will be copied.And what do you mean by “Some of the custom filed is not showing”?Can’t you see these fields in the IFS Client (IEE) or can you see these fields without any content?Can you please have a look into the database and do a SELECT statement on a relevant custom_field_table (...CFT) or custom_field_view (...CFV)? Will you find the data or not? I'll move this topic to another group as this has nothing to do with data migration per se. /Jens
Hi @Lakmal what is the reason and the target for archiving the General Ledger?I know there might be many reasons, e.g. saving storage, legal requirements, decrease the amount of records before performing a technical upgrade etc.Why not using the standard functionality within IFS Applications: This will move the records of GEN_LED_VOUCHER/GEN_LED_VOUCHER_ROW for a specific company, year and period from the IFSAPP_DATA tablespace to the IFSAPP_ARCHIVE_DATA tablespace.This functionality also exists for the internal ledger (INTERNAL_HOLD_VOUCHER/INTERNAL_HOLD_VOUCHER_ROW).The good thing is that you are able to see the archived data within the IFS client.Dou only want to archive GL or also the related sub ledgers (e.g. fixed assets, payed customer/supplier invoices/payments)?Another option could be to think about Oracle Partitioning but for this an Oracle Enterprise Edition is needed./Jens
Hi @ERPDMORENA can you try out ABSENCE_REGISTRATION please?/Jens
Hi @RyanK please have a look into the IFS Technical Documentation of IFS Applications 10: https://docs.ifs.com/techdocs/ The necessary information can be found here: Direct link:https://docs.ifs.com/techdocs/foundation1/040_administration/260_data_management/050_data_migration/002_migration_types/010_file_migration/020_create_table_from_file/...and within that page search for “Create table from file - OnServer” please. I also recommend to use 2 migration jobs for your purpose:First migration job (CREATE_TABLE_FROM_FILE) which will load your file Second migration job (MIGRATE_SOURCE_DATA) which will fetch the data from the first migration job. Set the rule CONNJOB to active and add the name of your first migration job into the field rule value. Afterwards you can schedule the second migration job.Prerequisite: File Location OnServer in your first migration job and a fixed file name must be used. /Jens
Hi @ksebf when you migrate a purchase_order or a purchase_order_line then in both cases the field pre_accounting_id will be filled automatically with a number value.Every record in purchase_order or purchase_order_line has a unique number value.The reference view to this pre_accounting_id is the view pre_accounting where account, code_b etc. can be stored.That means you have to fetch this pre_accounting_id and you must also migrate the view pre_accounting using the method pre_accounting_api.You can create a new job to migrate this pre_accounting based on the pre_accounting_id for the migrated purchase_order (for purchase_order_line you must create a second job)ORyou can add this pre_accounting view with the method pre_accounting_api to your existing purchase_order/purchase_order_line migration job and must inherit the pre_accounting_id from the purchase_order (for example exec seq 10 in the method list) to your pre_accounting view (e.g. exec seq 30) in the method list attribute screen
Hi @Vinoy Heshan it would be fine if you could provide some screenshots of your migration job please. → Formatting, Source Mapping, Method List and Method List Attribute/Jens
Hi @ERPDMORENA ,good to hear that it works. If you need a TAB then you can try CHR(09) /Jens
Hi @ERPDMORENA you can use the REPLACE function in the column name (tab file FIle Mapping) of your CREATE_OUTPUT_FILE migration job. e.g. REPLACE(notes,CHR(13)||CHR(10),null) as notes_new)notes=old fieldnotes_new=alias for your new fieldCHR(13)=CR (Carriage Return)CHR(10)=LF (Line Feed) You must doble-check if CHR(13) and/or CHR(10) are the right values for your purpose please. /Jens
Hi @SinaR please have a look into the technical documentation for IFS Cloud. There is a really good example for your request. https://docs.ifs.com/techdocs/22r1/030_administration/050_data_management/050_data_migration/030_migration_types/010_file_migration/030_create_output_file/ If you also want to have a header line in your output file then set the rule FILEHEAD in your migration job to Active. /Jens
Hi @E.Mamcasz which migration tool did you use in IFS Applications 10?If you used the standard migration tool within IFS Applications 10, we call it FndMig (Foundation Migration tool) then you can still use it within IFS Cloud.It’s important to mention that it isn’t 100% clear how long this migration tool will exist or will be supported by IFS. At the moment it is planned at least until IFS Cloud 24R2.But there is already another migration tool in the core of IFS Cloud available which is called DMM (IFS Data Migration Manager).Documentation for both migration tools can be found in the documentation of IFS Cloud:https://docs.ifs.com/For IFS Cloud 22R2 please have a look into this documentation where you’ll find both migration tools:https://docs.ifs.com/techdocs/22r2/030_administration/050_data_management/ For DMM (IFS Data Migration Manager) is also an IFS Academy Training available as a starting point which is called “Smart Data Manager Essentials”.My recommendation in general is to or
Hi @Hanane can you try this possibility in your client of IFS Applications 10 please? /Jens
Hi @russellclaytonplease have a look into the Technical Documentation of IFS Cloud: https://docs.ifs.com/ Update Allowed means you are also allowed to modify the migration jobs.“Update NOT Allowed” means you are only allowed to execute the migration job.Prerequisites:The migration job is granted to the user /Jens
Hi @chrisbrigg no, this is only possible with a customization/modification.Without a customization/modification you can think about using the migration tool executing this External File assistant and updating this file name automatically before the needed method/procedure for this External File Assistant will be executed.The migration tool can handle dynamic file names with a workaround. You need at least 2 migration jobs. Only as an idea and the migration jobs will not migrate data in this case :1st MIGRATE_SOURCE_DATA job who is reading the content of a directory and which is putting the file_name into the second migration job (yes, a migration job can update another migration job) 2nd MIGRATE_SOURCE_DATA job which will execute the method of your external file assistant incl. the file_name of the first migration job/Jens
Hi,press + for New add for example Execute Seq 35, add the view name ORDER_LINE_STAGED_BILLING, choose Prefix Option ViewNameUnique, tick on New and Modify, and then save this row.After that you’ll have the view name ORDER_LINE_STAGED_BILLING35 and then you’re able to map the fields in the tab Source Mapping.But I suppose you also have to do something else besides of the mapping in the tab Source Mapping because of the Key field (K) STAGE.As you can see this view has 5 Key fields (Flags P and K): I deleted the row for Pos 290 and created a new one including the view name as a prefix. If you don’t do that and you have a view name more than once in the method list then you’re not able to map the key fields because the key fields will only be shown without the view name as a prefix in the source mapping.So in your case/example you probably want to migrate 3 ORDER_LINE_STAGED_BILLING records for 1 customer order line and that means you want to map ORDER_LINE_STAGED_BILLING20 with value 10
Hi @SPRRAJ ,can you please add a screenshot of the migration job (Tab Formatting) and when does this error exactly occurs?Normally when you choose “File Location:” OnServer then the file name must already be stored in the field “File Name:” before executing the job. I suppose you already have the “File Name:” and “File Path:” filled out with values.The “File Path:” should be an ORACLE-DIRECTORY which refers to a folder on the database server.So for example the name of the ORACLE-DIRECTORY is MIGRATION and MIGRATION refers to the folder D:\MyFiles on the database server.File Path: → MIGRATIONFile Name: testfile.txt (which is stored in the folder D:\MyFiles on the database server)
@jporter Hi,this is a success service which can be order at IFS. Please reach out to your IFS partner success manager./Jens
Hi @ynwkm .Yes, there is a good foundation documentation about tips and tricks available as @anmise already mentioned.If you’re not so familiar about data migration at IFS then I recommend to order a training, e.g. TAA3P, where you’ll get much more information about this topic./Jens
Hi @orscdpiercethat error messge means that you have to define/create external payment parameters for the external payment interface first and this has to be done in the following screen: Extract of the online help: /Jens
Hi @jtobin ,why not creating a simple migration job (procedure name MIGRATE_SOURCE_DATA) instead of wrting a PL/SQL program for this purpose?Migration tool (search for “Migration Job” in the Navigator).Source_name: SALES_PARTWhere clause: contract=’SITE1’In the tab “Method list” insert the view_name SALES_PART (the target).Go to the “Source mapping” tab and change the value of the source column for CONTRACT to SIT99.Execute your job.You can also join other database views in the “source_name” or add other “Where clauses” if you want./Jens
Why not using the procedure FND_USER_PROPERTY_API.Modify__ instead of using hard updates on the table for this purpose? The best way is to use the “Data Migration” tool in IFS Applications 10 (search for Migration Job in the navigator).Procedure name = MIGRATE_SOURCE_DATASource_name = FND_USER_PROPERTY (you can also add a WHERE clause in this screen)Tab Method list: View Name = FND_USER_PROPERTY (Method Name FND_USER_PROPERTY_API will be automatically filled)/Jens
Hi @pknight SELECT IDENTITY, VALUE FROM fnd_user_propertyWHERE NAME='SMTP_MAIL_ADDRESS' IDENTITY is the Identity fieldVALUE is the Email address /Jens
Hi @lpktysack,the are two problems in this case:ROWID and CLOB are data types which you can’t use in the migration tool and a known limitation, only NUMBER/VARCHAR2/DATE are valid data types.By the way: ROWID is a valid datatype in Oracle.For your example you can use the procedure BUSINESS_OPPORTUNITY_API.Write_Note_Excel__ but keep in mind that you only have 4000 characters available for your notes field.I hope this will solve your problem./Jens
Already have an account? Login
No account yet? Create an account
Enter your 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.
