Data Migration

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 us

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 cha

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:

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.

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.

Hi,when sending a HTTP Post request to IFS REST API I get an 400 error as respone.On the IFS Server I see this log message:2023/10/06 06:31:12 [warn] 96#96: *149147568 [lua] cookie.lua:146: bake(): SameSite value must be 'Strict', 'Lax' or 'None' while connecting to upstream, client: x.x.x.x, server: IFS, request: "POST /main/ifsapplications/projection/v1/LocationHandling.svc/LocationSet HTTP/1.1", host: "IFS"The Post request is initiated by our Lobster middleware, using postman everything is working fine. When doing a HTTP Get to request data it is working as epected.Is there some config missing in IFS regarding SameSite cookies or do we have to configure something ob Lobster-side?Thanks,best regards,Nico

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 

I have a lobby that is working in IEE and returning data. But when migrating from IEE to Aurena. I get an invalid data source definition error. The client type is set to Aurena. IN AURENA IN IEE data source:   Also the elements that are returning data are returning null values. Any ideas why this is?

Hi Community. I am having a first look at the Dat Synchronization functionality on IFS Cloud.Documentation is not bad as overview of different aspects, but as a start point, a bit difficult to follow up.Is anyone out there with experience on setting it up, that would be willing to share that knowledge?Thanks for your time!  

Hi,I am trying to complete the task to Define Installed Environment after completing the Basic Project Data for a Data migration job. I am however getting the below error; How can I change the Thousand Separator Format value? 

Hello,In order to load data from INVENTORY_TRANSACTION_HIST2 to DW, it took a lot of time, actually using OBJVERSION to load a latest one but still taking 2 hours only for this table. Is is possible to add a timestamp field directly to a view INVENTORY_TRANSACTION_HIST2, and if any information change in a row the timestamp will be updated ? 

Hi,When importing the template project file for 23R1 I get below error message.  From Background job error textunable to extend index IFSAPP.DAT_TEMPLATE_LOAD_PK by 128 in tablespace IFSAPP_INDEX     ORA-20110: DatFileOperationUtil.ORA-01654Has anyone encounter the same error or can help to resolve this error please?I was using IFS demo environment https://ifs23r1costestlkp.rnd.ifsdevworld.com/  with Alain credentials to import the template project. Thanks!