Data Migration

I want to create Purchase order line via  PURCHASE_ORDER_LINE_API.New__.when I pefrom  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'CHECK');” no error message. but I change to  “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'DO');” it dispaly  “4246591008” is not a valid integer value.my script as beolowDECLARE          info_ VARCHAR2(32000);          objid_ VARCHAR2(2000);          objversion_  varchar2(300);          attr_ VARCHAR2(32000);          BEGIN        -- TBOOLENSTRING:=TRUE;         Client_SYS.Clear_Attr(attr_);      --Client_SYS.Add_To_Attr('BUYER_CODE','3HB03', attr_);-      Client_SYS.Add_To_Attr('ORDER_NO','10112', attr_);      Client_SYS.Add_To_Attr('BUY_QTY_DUE','100', attr_);      Client_SYS.Add_To_Attr('DATE_ENTERED',sysdate, attr_);      Client_SYS.Add_To_Attr('LAST_ACTIVITY_DATE',sysdate, attr_);      Client_SYS.Add_To_Attr('PLANNED_DELIVERY_DATE',sysdate, attr_);      Client_SYS.Add_To_Attr('PLANNED_ARRIVAL_DATE',sysdate, attr_); 

Hello, in IFS10, can I run a scheduled task once a file has been uploaded to a folder? ThanksRoss

Hello the community,A customer is looking for a tool to integrate Ifs with MS Dynamics 365 CRM.He found this tool “Commercient” (https://www.commercient.com/product/sync-integration-for-ifs-and-microsoft-dynamics-365-crm/#tab-id-4) Any advice/experience is welcome :-)Thanks. 

Hi All, From where can I find IFS Cloud 22R1 Template Project file for Data Migration Manager?  I am new to Data Migration Manager and my idea is to create a Project Template and load a pre-built Template file copied into DM server location , drill down into details of the project and understand how it is set up instead of creating a Data Migration Project from scratch.

Hi Experts,Search , validate and execute functions are not working in below migration job. Appreciate it if any one could help to resolve this issue.   Best regards,Theja

Hi -  I can create 2 data migration jobs to create a Purchase Order. - One to create the header and one to create the lines. I am looking to create a single Migrate Source Data DM Job to create header  and lines based on an imported table of data. So the stage 1 imported Data would be simplified as something like.. Supplier Part No Qty  Stage 2 to Create a PO for the distinct list of Suppliers and then create the attached lines Anyone think this is possible without custom code? Thanks for looking..  

I am looking for recommendations on how best to manage the migration of documents (300gb+) from an Apps9 database to Cloud. Primary concern is the ‘what to avoid’ type scenarios and also how to monitor during the migration process that the process did not stop or error out and, if it did, what to do next.

Hi everyone,I'm trying to migrate the view "PART_SERIAL_CATALOG" which holds the history data for the inventory parts in stock.My approach was to first create a temporary table with a .csv file and then migrate the source data. the second step isn't working, I'm getting the error: "ORA-20132: PartSerialCatalog.NOTHANDLED2: Operation "" is not allowed for Part Serial Catalog objects in state "". There's no problem migrating the inventory parts in stock, but they can't be used if the Part Serial Catalog is not available.Can anyone help me with this error?I'm grateful for any help, thanks in advance!Kind regards.Joshua ps: here you can find a Screenshot of the File Mapping for the migrate source data Migration Job 

Hi All,“Copy Part” screen seems to only allow us to copy one part at a time, is there a way to bulk copy this? They can’t use migration jobs.Does anyone have scripts handy or a tweak for this? I rather not write it from scratch as there is very limited time for this.

Hi All,I am trying to do export of IFS database from oracle source server to destination server using oracle user ‘SYSTEM’. I see the export import completed fine. But while starting the application the background_jobs is not running and looks like it is trying to run these jobs with ‘SYSTEM’ user which was used for importing the database. I am getting below error can you please suggest anyone faced this? do I need to impersonate ‘SYSTEM’ user? If yes how can I do it these are all background jobs triggered by application during configuration automatically. Below is the error I am getting. Fnd_Session_Util_API.Impersonate_Fnd_User_ Could not impersonate Foundation User .========================================== Could not impersonate Foundation User .========================================== Fnd_Session_Util_API.Reset_Fnd_User_ ========================================== Foundation User is not reset. Foundation user is .Fnd_Session_Util_API.Impersonate_Fnd_User_ ORA-20111: FndUser.NOTEX

I need to update update a custom field in Inventory_part_cfv at the same time as creating the Inventory part. Under method list, I specified Inventory_part_cfp.CF_New__ and it's of type Migrate Source data that fetches information from an IC table.I am assuming that's not enough because it doesn't update it and throws an error stating ROWKEY cannot be null.What other steps are needed? 

Hello,I receive below error when trying to execute a Excel Migration,Any idea why?

Hello,I want to change the structure status from “tentative” to “buildable”. I am using a two step job and I am looking for the right method. I was trying with this one (screenshot), but I get the message that the method is not righT. could you please advise?Thank you!Aleksandra

Hello,I am trying to update a line in the Purchase Order (view PURCHASE_ORDER_LINE_PART). I want to update a price for several lines at the same time. Every time when I am trying to do that I have the following error message:Entering a new line works perfectly, but the update of existing line doesn’t work. Has anybody encountered the following problem? Is it possible to update the Purchase Line with the Excel Add-In? Thank you in advance,

Hello,I am trying to create a migration job to change in mass the status of project header from ”Initialised” to “Released”. Here is the IFS Page:I created the following job:I am testing it for a specific example of an existing project (PROJECT_ID provided in the where clause) with the status “initialized”.Still, I am getting the following error:“ORA-20114: Project.FND_MODIFIED: The Project record has already been changed. Please refresh the record and reenter your changes.”Thank you in advance for your help,

Hello,I am trying to migrate the Supplier for Purchase Part in IFS Cloud.I encountered the following error:“ORA-20110: TaxHandlingUtil.INVTAXCODE2: You are not allowed to use Tax Codes of type Tax with percentage greater than 0%.”I think that the problem is that for one site the field Tax Code is blocked:As for the other site, the field is “unblocked”:Is there any specific setup on site level that needs to be done to have this field avaliable for the Supplier for Purchase Part page? Thank you in advance,

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

In Apps 9 we had a Custom Tab (Provision - LU (CCustOrdCommReceiver)) in the Customer Order, in that we manually insert Values.Over this Data we run a Commission Note to identify the commission per Commission Receiver. This Custom LU got uplifted to the Cloud but was not implemented on the Page.I created the needed Projection Configuration:I created the needed List “Provision” under “All Elements”And implemented the List on the Page:But every time I open the new Tab I receive the following Error:I also tried to only add the Order no without the other Custom Fields but I received the same Error: IFS Web Version: 22.2.11.20230802081957.0Date: 2023-10-23T06:40:24.679ZCustomerOrder/Form (server error)An internal server error occurred. Contact administrator.Error details: [{"code":"EXPRESSION_PROPERTY_NOT_IN_TYPE","message":"The property 'CCustOrdCommReceiver_C_Comm_Receiver_Ref', used in a query expression, is not defined in type 'CustomerOrder'."}]Request Id: 1a9b7995-fdd2-44e6-b868-70b9e

Does anyone know if there is a limitation on number of rows when migrating using Excel Add-In?I have done a few tests and it seems to be limited to 5000 rows??  

hi All,I can insert or update the schedule in Employee schedule from IFS client , but I can only insert a record in WORK_SCHED_ASSIGN using DMM and update will give an error at the deployment container.My requirement is to use DMM tool to update the schedule from C to B in below IFS window. the CSV file is attached and it looks like : at the deployment container I get below error and the record did not get updated.Method NEW failed : ORA-20110: WorkSchedAssign.INSOVERLAP: Overlapping date intervals. Has anyone used DMM tool to update schedule in WORK_SCHED_ASSIGN?Does anyone know why I am getting below error and how to resolve this?Or is this a limitation in DMM? Thank you! 

Hi Experts, at the moment we are trying to configure DMM too to do the migration for a new implementation. The customer hosting the 23R1 version on premise and we are having some hard time to get the DB links works for  non production environment. We have setup the Template project in PROD and then created a project based on the template projects. However, not clear about how we can create DB links to add non production environments as connected environments.  can someone help me to find out the proper way of doing it  like what user we need to use here and stuff like that. Kind Regards!Niyomal.

Morning everyone. I’m working with 11.3.9 and we are going to archive events out of an existing database to standup a new initiative. I want to reset the starting reference numbers for all event types. I know that the event reference numbers for Problems is determined based on the problem_hk table and that the change_hk table determines the event reference numbers for service requests and changes. The incident_hk is used to determine the incident_id (not the incident rerfernce). I also know that Incident, Task and Decisions are sequential and I would assume use the same table to determine the next reference number.My question is this, what table is used to determine the event reference number of Incident/Task/Decision events.

Does anyone know of a way to make this column non mandatory in data migration manager?  Not sure why it would be created this way.  I imported the IFS template.  Version is 23R1 

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

Hey everybody, I am trying to set up an Excel Migration Job for with custom fields. Unfortunately it doesn´t work. Without the CFs I am able to upload data in the master. With the CFs it seems to work (validation and execution works without errors), but the record set doesn´t update. I am curious if someone of you faced the same issue. Name and Cepi have been updated. Validation looks good.After execution it looks also good.The fields in IFS aren´t updated. Without the custom field data is updated.    Thank you in advance, Johannes