Data Migration

I am trying to do a CSV integration export in which when opened in Notepad ++, it doesn’t have leading quotes (“). I am trying to send this file every week to a customer via EDI for billing and the testing keeps failing because of this.Attached is the integration I am testing and the file with the issue.

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

As I’m learning Data Migration Manager I have created a few projects. For a couple of them, while Mapping Legacy Tables to Migration Object there has not been any Target Tables available in the Smart Mapping assistant and I have had a hard time figuring out why. Am I missing any setup? What are the requirements for Target Tables to be available for Smart Mapping? 

Hello everyone,I'm trying to migrate customer orders and customer order lines. Everything's working fine, no problem. However, I'm trying to migrate the CODE_C of the lines using another job for pre_accounting, and retrieving the pre_accounting_id of a line, but I get an error I don't understand: ORA-20111: Site.NOTEXIST2: The Site object does not exist.Strange, because in the job, this indication does not appear, and only the pre_accounting_id seems mandatory.   How can I make these jobs work easily? 

Does anyone knowwhat needs to be granted for end user to be able to query the table created by migration load job, these tables are created with format IC_XXXX_TAB ? 

Apps 10 update 12:I am trying to load some new Inventory Locations.  The migration job is pretty straight forward, see below.When I try and execute, the first row is successful but second and subsequent rows fail.  The error is:Insert into WAREHOUSE_BAY_BIN_TAB failed - ORA-20112: WarehouseBayBin.FND_RECORD_EXIST: The Warehouse Bay Bin already exists. (Error caused by line: 3)It appears that there is a LOCATION_SEQUENCE which retrieves from a sequence (if the field is empty in the attribute string).  Looking at the output of the failures, it is trying to use the same LOCATION_SEQUENCE value for each record.  Anybody have any ideas or have been successful in data migrating inventory locations?Thanks in advance,Dom

Hi,I’ve used Excel Data Migration Tool before. But now I got this problem that when I try Validate or Execute, Excel-Add-In reads everything to the first column. I have a simple example with 2 columns A and B. But Excel-Add-In reads both column A and B to the first column. So the value for column A is getting to long and the value for column B is left empty.Is there some configuration for this. Thankful for ideas.BR,Patric 

Hello Guys,    Very appreciate  for us, if someone share PPT of above subjected line.      

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 IFS Community,does anyone have a solution to export csv file without line breaks?I’ve seen topics about line breaks for data import but not for data export.I guess we need to replace line breaks with IFS but I can’t do that with the procedure CREATE_OUTPUT_FILE.There is no transformation option on FILE MAPPING tab.Maybe we need to use a rule like CALLEXTPROC (Call external procedure after each row) but I didn’t found information about this.If I have a solution to replace line breaks it will be possible to replace semicolons too and build a clean csv file.Migration Job RULES tabThanks

I am using the command_sys.mail command and passing a string which has 3 usernames as follows:but when I look in application message it has only passing 1 email address, am I doing something wrong ?

 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 first 4 Method columns…Having tried many variations, the latest result is set to null upon execution…In the debug Trace, I see this error…It looks like it is trying to grab every column and insert the values into the Attr_ variable.I’m out of ideas now

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_); 

I am trying to migrate a small customer file (only 4 records for testing) and am getting the following error:  Failed to initialize job ORA-20110: IntfaceDetail.NODET: No details found for HMH_CUSTOMER_INFO Any ideas out there?THanks,Stephanie

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,

Hi, I’m migration Parts with Serial Nos into Inventory Part in Stock table in IFS using Data Migration Job. But my Part & Serial Nos are not reflecting in Part Serial screen. But if I create them manually, they reflect in Part Serial screen. How can see them in Part Serial screen using Migration Job?

Afternoon,Has anyone created a data migration which will import a file from a specified file location on a daily basis? If so, could you share how you did it?  Scope:This migration job will pickup a file from a specified location, import the file and then archive the file upon completion. This job will run on a daily basis at 11pmI can create the data migration job to import the file using the usual manual methods however, haven’t figured out how to automate the pickup from a location.We’re currently using IFS Apps 10 however, looking to go to cloud in the near future.API to be triggered; PROJECT_TRANSACTION_API Thanks!Ryan

Hello All. I have some data in a flat file where columns A to C are header information and columns D to G represent line information.  Is it possible to use a master/detail migration on this data to import it into IFS as a header and associated lines without manipulating the data further? The data will come from an external system regularly so minimal manual processing of the data is a requirement.  Has anyone done this before and are you able to share the setup/config you have in the migration jobs?

I want to import data into a custom logical unit using Excel Data Migration but one of the fields is a Referenced fields?Data sample to import.Custom object to import into.  Referenced object Migration Job. Error when I try to execute.integrity constraint (IFSAPP.ARE_WATER_JET_PART_GRP1_CRK) violated - parent key not found  Can this be done?  How should I setup?  I think I need to get the OBJKEY for the referenced field?Need help. Thank you,

Hi,I’m trying to load Functional Objects using the Equipment_Functional_API. But I’m unable to set the “Belongs to Object” or SUP MCH CODE via this API and view Equipment_Functional_UIV. Any suggestions, how do this under Data Migration Job? Thanks

Hi all,I’m running ifs-cloud-23.1.6-penyzy3-3.5.0I’m trying to import the data from CUSTOMER_INFO_ADDRESS but the CREATE_TABLE_FROM_FILE job is splitting the ADDRESS field like so:ADDRESS=4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA In Excel export it looks like this:4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA How do I keep the information in the same record?I’m assuming it’s processing a Hidden Tab from Excel .csv file Thanks,Rob

How can access below webinar video?https://community.ifs.com/events/ifs-apps-10-ifs-data-migration-excel-add-in-overview-demo-20  

Hello All,I’m trying to migrate users between environments and I’m missing data.Why can’t I migrate the email address?If so, what do I add to the migration job.The field seems to be part of the same table, but does not get added to the migration job. Thanks,Rob

Hi All,I’m trying to import Person records and I get this error:READ ONLY GRANTS FOR IFSINFOThis was working yesterday, so I’m confused.I’m using the view PERSON_INFO_ALL.The Users have migrated for all these records and the Company User records migrated as well.Any Thoughts?Thanks, Rob

 I have created a migration job which is used to migrate data into some custom fields in a core table. this included some reference fields as well. I have mapped the objkey for those reference fields and everything seems ok. But when I execute the job, core method get executed and during the execution of the customer method I get the below error. any idea on this ?"ORA-20105: Message.ATTRNOTFOUND: Attribute "SQL" does not exist in message "..."”