Data Migration

Hi,I have issues with running an Excel Migration job updating valid to date on the current price line on supplier price list (purchase_quantity_price). I get the familiar error “Object does not exist”, but I have all key attributes present and the same job works in another IFSAPP10 database for the same customer. The job is set so that the only attribute to be updated is “VALID TO DATE”. Has anybody had issues with updating purchase_quantity_price?I can say that creating new records works fine. B.RPer

Hello, Trying to implement a user available excel migration file and have to solve two problems to make it useable.  problem 1) Want to make one of the columns a drop down with 5 to 6 options for ease of input and formatting. Other values could be manually input but the drop down would contain the most frequently used values. Would prefer to do this using Client Values and not DB values. In this example it would be the Work Task Template ID  - Description - Rev. Problem 2) This specific migration container is to a custom page and the primary values are Contract and Line No. The issue is that the migration file is asking for line DB value and the user will not have access to that information since its not viewable in the client. There is an API call to the OBJKEY on that table which is the DB value for the Line Number. Trying to determine how to have the file fetch the DB value after the user specifies the client value.  I’ve scoured document

The following print-screen show the state of one of my Output Containers, as you can see:It refers to IDENTITY_PAY_INFO It’s key (COMPANY, IDENTITY, PARTY_TYPE_DB) is: TESTCO, ABC0001 and CUSTOMER (respectively) Is in Approved stateIn addition to that, IDENTITY_PAY_INFO is referred by another table PAYMENT_WAY_PER_IDENTITY. On that table, It is expected that the field PARTY_TYPE_DB should exist in IDENTITY_PAY_INFO, as you can see in this Target Table Definition.With this information in mind… then why this row in PAYMENT_WAY_PER_IDENTITY failing if the corresponding record already exist in  IDENTITY_PAY_INFO when I validate basic data?

Hi,We are in middle of upgrading from IFS 9 to Cloud and uplifting all our Migration Jobs. In Cloud, we noticed that the Excel Migration jobs using standard IFS API Methods create a new projection once we update the job and click ‘Re-generate Excel Migration’ option. Granting the projection to the relevant Permission Set allows user to execute the job successfully in Excel.However, the same doesn't happen when we modify Excel Migration Jobs using Custom API Methods as no new Projection appears after clicking Re-generate Excel Migration.When the user tries to run the migration, the attached error occurs:We confirmed the same error for two other Custom API based Excel Mig Jobs.Product Version: 23.1.11

Hello, I have a VPN to the IFS cloud. Now I have noticed that the Select does not show any data on many VIEWS, although data is available there according to the IFS quick report.CUSTOMER_INFO: works fine PURCHASE_ORDER: no Data In IFS-Quickreport i can select all Purchase Orders ! Is there a reason and solution so that I can see data from all VIEWS that I select via Qracle SQL Developer and not just the column names?I have already written the IFSAPP in front of the VIEW names.Thanks for your helpGreetingsMarkus

Hello community, I am trying to complete an Excel Migration Job, and once I go to validate/execute the job, I keep facing a very strange issue:When we enter our parameter (SITE1) into the contract field, the migration job doesn't recognize the input. That being said, when we enter SITE2 (another parameter of ours) into the contract field, we get an error that we don't have access to the site - that tells me that the migration job is able to read the field but cannot recognize either SITE1 or SITE9 as being valid. SITE1 is used for most of the objects, and this same result column error appears for creating new objects or validating existing ones, even if nothing is changed on them. 

Hello,One of our customers is seeking a solution for handling large Excel files, which they currently enter manually into IFS Apps10 environment. They need a solution capable of processing up to 2 million records in a single upload. Could you suggest any available solutions?

Hi Community,When I try to modify the Project Manager, I’m encountering the below error message.So, found a alternative way and used to Modify the Project Manager manually from the Change Project Manager window. Now, I want to create a migration job to modify the PM.But unable to call the Project_API.Modify__ method, as it shoes the error “Current user doesnot have access to update project manager”.Can anyone help me out of this.Thanks/Thean Mozhi

Hello,I did a test to migrate an employee and it appears with “preliminary status”. How can I migrate it as “active”? It’s for the Cloud version 21R1 and I created a two step job.Thank you in advance,

 When I try to clone CST to AST it is not showing the target version and no ability to enter it. Any ideas what the issue could be? It works for all other scenarios. 

When migrating project, I want to make use of the Project ID Generation Rules. I leave the project ID in the migrate source job blank, category 1 is filled, Generation rules have been set up for given category 1. All other values are catch all.Still nothing happens when running the migration. So I was wondering which API to call to set the api in the defaul value of the project id, so it would generate the id when migration job runs.Anyone an idea which api to call? I would prefer to know the parameters as well, although less important for now.BTW: rule works perfect when entering a project via the project definition form

My Basic Data Container in Data Migration Manager is saying that these 5 records for countries are in a “Not Deployed” Deploy Status state…  Yet, if I go to the Deployment Container for the same Target Table (ISO_COUNTRY) my 5 rows are in either Deployed With Commit or Deployed state. Why is the discrepancy between the Basic Data Container and Deployment Container Statuses? is this a bug in the User Interface?

Hi All,I created a Database Link in DEV (Build Place) to link to CFG environment using an end user in CFG.I can see a valid Database Link in DEV.However I cannot see created DB link in the application (DEV environment).Location Solution Manager > Data Management > Data Migration Manager > Project Basic Data Setup/Connected environments tab/Database Link name.Any idea as to why I cannot see the DB link from the application  

Hello,I am in trouble to create multiple price lists with thousands of Sales parts in IFS Cloud.Can somebody guide me how i can create excel migration job or file update option?

Hi I have created DB Link in IFS Cloud database as IFSAPP user, but that DB link is not showing in IFS Cloud Migration screen.   

Hi,In Apps 9 whilst using Data Migration Jobs, users were able to delete records after loading data from spreadsheet and before migrating the records into IFS.However, in IFS Cloud (23.1.11) there seems to be no option to delete records like the ones highlighted below:Users need this ability to review and delete records before migrating them into IFS.Is this a case of missing functionality in Cloud that will be added in future updates?

 I am creating an Excel Migration job that will set hundreds of Requisition Authorisation Rules to ‘Planned’.This is very much like the topic I raised and got a very good answer that worked well: Excel Migration - Delete User Sites | IFS Community. On this occasion the same principles are not working for me.Here is the job...For the Action on Seq 10 I have toggled InLoop and NoExecution.For Seq 20, I set these attributes…My source mapping looks like this - I allowed the default Source Columns and assume I don’t need to do anything with the firs

Trying to use an External File to migrate a Trial Balance (GL Transactions) from the legacy system to the new Cloud IFS solution.  File conforms to the STDVOU template with semi-colon separated values all matching the individual fields.  We have several different IFS Cloud environments at the moment (since we are in Implementation Phase), but none of them accepts an STDVOU type file and fails with the following Oracle error message:ORA-20115: ExtLoadIdStorage.The "Ext Load Id Storage" has already been removed by another user.Anyone got any ideas?…  we have already been successful in loading External Files using different Templates (ExtFAObjectImport for example), so doesn’t seem to be a generic issue with the environment as such...

Hello, I created a new page (Work Order Journal) in MWO but it shows an error message. From the designer page of my creation page, the page works correctly but as soon as I leave the designer page the page returns to errorThe goal is for technicians to be able to directly access the “Work Order Journal” page from the MWO application, can you tell me how to do this?     Thank’s

Hi All,  Is there a place which I can get the Data Tracker for 24R1? Your assistance is highly appreciated.  Best Regards, Thushila 

In Apps10 client, when entering decimal values, they are being recorded as comma-separated.For example, I enter 2.5, but it appears as 2,5 and is saved to the database that way. How can this be corrected?

Hello,I am trying to migrate some data in using the following :I am getting the following error: The issue is that the sequence field in ‘CHANGE_OBJECT_IMPACT_FIN’ needs to be the same as ‘CHANGE_OBJECT’.  How is that done in a migration job please ?

Hi community, our customer uses Excel add-in for creating and updating parts in different views. We are trying to create a new job including SUPP_BLK_PART view but there it stops and we can´t run the job in excel. If we remove the view it works. We have also tried and add other vires such as ASSORTMENT_NODE and SELF_SERV_PROC_CATALOG without issues but SUPP_BLK_PART cannot be handled. Have anyone any experience in this? BREmma

Trying to create a flat file from a view using Migration Job CREATE_OUTPUT_FILE in 21R1.  No output is being generated and it is sitting at Error but no error message is displayed. 

Hi, we are struggling to create an Excel Migration job, when trying to load data we get the following error message and no data is loaded at all. I´ve never seen this error before and cannot figure out what is wrong here? InsertDeleteConflict Thanks! BREmma