Data Migration

This will include topics related to data migration.

  • 415 Topics
  • 1,081 Replies

415 Topics

S
Sidekick
signilsSidekick
asked in Data Migration

Cursor error - cursor already open

Hi, I keep getting the error: ORA-06511: PL/SQL: cursor already openwhen executing below, can someone please tell me why:- DECLARE    info_ VARCHAR2(2000);    attr_ VARCHAR2(2000);        newrec_     identity_invoice_info%ROWTYPE;        automatic_pay_auth_flag_db  VARCHAR2(1):= '1';        CURSOR get_supp IS    SELECT * FROM IDENTITY_INVOICE_INFO;       BEGIN  FOR rec_ IN get_supp LOOP     OPEN get_supp;   FETCH get_supp INTO rec_;   EXIT WHEN get_supp%NOTFOUND;   CLOSE get_supp;                Client_SYS.Clear_Attr(attr_);                   Client_SYS.Add_To_Attr('AUTOMATIC_PAY_AUTH_FLAG_DB',automatic_pay_auth_flag_db,attr_);                        IDENTITY_INVOICE_INFO_API.Modify__(info_,rec_.objid,rec_.objversion,attr_,'DO');        END LOOP;    COMMIT;END;

3
T
Superhero (Employee)
1 year ago
H
Sidekick
harshamc00Sidekick
asked in Data Migration

IFS North America data migration toolkit (MTK) auto loaded basic data

We are using the North American Migration toolkit for a data migration and some missing basic data get loaded automatically.  (For example Organization codes). We need to get the list of these records and does anyone know about a view or report which can be used to fetch this information ?(** Note that “Data Migration Applications\Reporting\Auto-loaded Basic Data\Auto-Loaded Detail” does not show anything and I’m not sure whether this is bug**)  

0
H
Sidekick
3 years ago
C
Sidekick (Partner)
chrisellistonSidekick (Partner)
asked in Data Migration

Excel Data Migration - Dates

When using the Excel Data Migration Add-in if any fields contain dates IFS brings them into Excel in the form DD/MM/YYYY HH:MI:SS. If you do nothing and try to Validate the row, the result column seems to insist that the field doesn’t contain anything (if mandatory).  If you click in the field and then out again Excel re-presents the field as YY/MM/YYYY HH:MI and right aligns it.  It then validates ok. Obviously if you have a lot of records you can’t click in every field to ensure the formatting corrects itself. Does anyone know how to solve this ?

4
C
Sidekick (Partner)
4 years ago
C
Sidekick (Customer)
Christian CordiusSidekick (Customer)
asked in Data Migration

Excel Migration Job - Help to delete/remove records

Hi Community,Is it possible to delete/remove records using an excel migration job? I’m trying to delete/remove users for WaDaCo processes but unfortunately i cannot solve it.. I have added ‘DATA_CAPT_CONF_VALID_USER_API.Remove__’ in the Method List. An example could be to delete/remove all users for our scanner ID6: The migration job has the current setup:   I’ve also tried different setups. Example in the method lists to use ‘%’ in Column value and DUMMY in Column Name.  

2
C
Sidekick (Customer)
1 year ago
D
Sidekick (Customer)
DevBobSidekick (Customer)
asked in Data Migration

Migrate Job: Execution Error...

We’re getting this error when updating a custom field in Customer_Info_Cfv created/added at data migration.It’s a simple update with just the CustomerNo and the new custom field, MS Set.Any ideas what to correct?     

9
D
Sidekick (Customer)
3 years ago
B
Sidekick (Customer)
bldrayiSidekick (Customer)
asked in Data Migration

New Company Creation Error

After company Creation from an existing company it gave in the log the following error  using IFS10 with UPD11:ORA-20111: UserFinance.RECNOTEXIST: Access denied! User IFSAPP is not connected to Company KSA022what id the reason and how it can be rectified?Best Regards,Bilal Drayi

3
E
Sidekick (Customer)
1 year ago
R
Superhero (Partner)
RutJWhalenSuperhero (Partner)
asked in Data Migration

Data Migration Job keeps hanging when ran without CHECKOPTION

My data migration job keeps hanging when ran without CHECKOPTION. It eventually errors with the following message: Error occurred while calling  ../main/admin/plsqlgateway/AccessPlsql/Invoke?frmIntfaceStart. Please contact your system administrator. Error 502 - Bad Gateway   Has anyone come across this before and if so, could you please point me in the right directions.

4
O
Do Gooder (Customer)
3 years ago
A
Do Gooder (Customer)
AIDTrevorJDo Gooder (Customer)
asked in Data Migration

Automated import of external file to data load table

ASystem: IFS Apps 8 (Currently)Hi, I'm new to the community and fairly new to IFS. I have a requirement within the business that on an agreed schedule it will automate a process in IFS, where an external SQL based system produces a file which can be automatically imported into IFS and used to generate new projects. e.g.Step 1@19:00 the External Systems produces an external text file: Pipe Delimited and columns encompassed in double quotes ("")Step 2@19:30 IFS imports the data into a temporary tablestep 3@ 19:45 a scheduled event activates andValidates the imported data in the temporary table creates new Project records based on the data in the temporary table emails users to notify of any failed transactionsSteps 1 and 3 are in place, I’m having problems with step 2I have looked at the data Migration tool and can't see how to schedule and completely automate the steps in completing this, load file, save and importI have also looked at the external file tool and am a totally bemused by

2
A
Do Gooder (Customer)
3 years ago
E
Do Gooder (Partner)
evrpatrinDo Gooder (Partner)
asked in Data Migration

Excel Data Migration Tool

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 

4
R
Superhero (Partner)
3 years ago
A
Sidekick
AdarshSidekick
asked in Data Migration

Anyone have ppt of Data Migration and integration (IFS 10)?

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

7
Yasas Kasthuriarachchi
Superhero (Employee)
3 years ago
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration

Schedule a quick report

Hello all, Hoping someone can help with this.  I am trying to schedule a quick report so the first thing I do is create the ‘Application server task’.  However when I save and RMB I get the following :I select yes, then get the following:How can I resolve this issue please ?

2
GISANCAR
Sidekick (Customer)
5 months ago
C
Do Gooder (Partner)
CheHiroyKDo Gooder (Partner)
asked in Data Migration

Data Migration/Execute Job function error message

Hi, This is my first time to use Data Migration/Execute Job function.When I did that, received the following error message.Where should I check for this?"interfaceDetail.NODET:No details found" Thanks!Kind regards,Kokubo

11
AkilaR
Hero (Partner)
3 years ago
J
Sidekick (Customer)
jtobinSidekick (Customer)
asked in Data Migration

ORA-20112: SalesPart.FND_RECORD_EXIST: The sales part already exists

Hello, We are using Apps 10, UPD13. We have sales parts in SITE1 (approx. 500K) and are trying to create the same sales parts in SIT99 using the script below but are getting an error message that the part already exists. They already exist as inventory parts in both SITE1 and SIT99.  Is anyone able to help us with resolving the error and creating the sales parts in SIT99 that already exist in SITE1? Thank you,Joann DECLARE  p0 VARCHAR2(32) := NULL;  p1 VARCHAR2(32) := NULL;  p2 VARCHAR2(32) := NULL;  attr_ VARCHAR2(32000);  action_ VARCHAR2(30) := 'DO'; CURSOR get_part_info_ IS    SELECT i.CONTRACT, i.PART_NO, p.CF$_SALES_GROUP    FROM  inventory_part i     left outer join sales_part s     on i.part_no = s.part_no     and i.contract = s.contract     left outer join    PRODUCT_CODE_X_REF_CLV p    on i.second_commodity = p.cf$_comm_group_2    and i.part_product_code = p.cf$_product_code    where     i.contract = 'SIT99'     and i.part_no like '%2'     and length(i.part_no) = 11     and s

4
J
Do Gooder (Employee)
1 year ago
S
Sidekick (Partner)
sfaureSidekick (Partner)
asked in Data Migration

Migration data : "Access denied! * not connected to Company"

I would like to migrate the field “Tax Liability” with already existents customers. I use IFSAPP account with IFS_ALL rights (and Excel ADD In). Il create a migration Job (I tried with Two jobs migration, insert or update, or Excel Add-in and i have the same result)I start the job and load the file.But when I want to start online, an error message occurs : “Access denied! User IFSAPP is not connected to Company”However, IFSAPP as a user is connected to all sites and companies. The update is allowed in the basic data migration setup. IFSAPP is a user per all the companies.Don’t know why the access is denied...    

4
R
Do Gooder
11 months ago
T
Sidekick (Customer)
TAPSUDJAYSidekick (Customer)
asked in Data Migration

Data Conversion Issue in Data Migration Job

We are in need of migrating employee clocking information from a client’s system to IFS. I’m trying to set up migration jobs to get the data into TIMREP_TRANSACTION. However I seem to have an issue getting the time stamp info due to the data format. In the view and the DB table, Time stamp (REG_STAMP) is of DATE type. To have the date and time in that format I had to use custom option in format cells in Excel. When I do that, I have to have the corresponding field in the migration job to get the data into the intermediate table as VARCHAR2. I tried DATE format but then the data cannot be loaded due to a format error.But then I get the following error, when I try the second migration job I’ve set up to get the data from the intermediate table to the actual database table.The source data migration job has the field as DATE type.  Clearly I need some sort of data conversion in between. But I’m struggling as I cannot figure out how to do it. I would really appreciate it if anyone has some

1
Z
Do Gooder (Employee)
2 years ago
A
Sidekick (Customer)
atvanstSidekick (Customer)
asked in Data Migration

Access to data migration table

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 ? 

3
A
Do Gooder (Customer)
3 years ago
T
Do Gooder (Customer)
Thomas RebmanDo Gooder (Customer)
asked in Data Migration

Is there an issue with the fixed assets import?

Import fixed asset is not working properly.  Below is the test plan:Create an FA object with valid from date 8/30/2016, assigned to an object group with SL BP for 7y0m. Import the object with acc. Depreciation value for year 2022, period 12. Post the import transactions. Create a new depreciation proposal for the object above for year 2023, period 1, review the proposal, you will notice the depreciation will fully depreciate the object with the remaining residual value.  That is incorrect.  The object should still have another 8 months to depreciate. If you would like to review our data, object id TEST2 is done via external template, object id TEST3 is created in the system, both with the same issue.  The testing data is on my UAT database (URL: IFS Cloud). We are currently on IFS Apps 8 but not using the fixed assets module.  

16
F
Superhero (Partner)
1 year ago
S
Sidekick (Customer)
sttSidekick (Customer)
asked in Data Migration

webinar video access

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

4
S
Sidekick (Customer)
3 years ago
J
Do Gooder (Customer)
jenna.kussmanDo Gooder (Customer)
asked in Data Migration

Excel Migration job (w/ custom field) -- Error Message Help

Hi All -- hoping for some help with a migration job issue I’ve been struggling with. I need another pair of eyes to see what I’m overlooking.I’ve got a job containing two separate views, plus the custom field view for one. Validating my job results in “Validate OK”, however upon execution I receive “The Sales Part Base Price already exists.”  I’m trying to update the custom field (CF$_ACCEPTABLE_USE_CODE_DB) or any field in the line, and not create a new one. Attaching screenshots of everything I can think of… I’m also a rookie when it comes to data migration.  

3
Jens
Hero (Employee)
1 year ago
A
Sidekick
Amitesh_IFSSidekick
asked in Data Migration

migration job with multiple method list

Hi,Is there any way we can achive the below through migration ? I have 2 method calls in method list Method1Method2how can we use the out parameter from Method1 is and use the same in Method2 ? Thanks in AdvanceAmitesh

2
A
Sidekick
2 years ago
H
Do Gooder (Customer)
HasepDo Gooder (Customer)
asked in Data Migration

Migration not working PURCHASE_PART_SUPPLIER

HI,I’m trying to update PURCHASE_PART_SUPPLIER.LIST_PRICE with a migration job. Everything looks fine when running the job, but nothing is updated.  Start time - 24-MAY-2022 11:23:36   010_050_010_PRICE_MCreated select  :   FROM IFSAPP.IC_010_050_010_PRICE_F_TAB 10 PURCHASE_PART_SUPPLIER_API        Updated rows  : 9  READ ONLY GRANTS FOR IFSINFO        9 rows selected        0 rows failed Used 0 hours and 0 minutes Average of  540 rows per minute End time - 24-MAY-2022 11:23:36   010_050_010_PRICE_M Any suggestion? 

3
Jens
Hero (Employee)
1 year ago
Chriswharton22
Sidekick (Partner)
Chriswharton22Sidekick (Partner)
asked in Data Migration

Flat File - Data Migration

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?

4
durette
Superhero (Customer)
2 years ago
alanbclark
Sidekick (Partner)
alanbclarkSidekick (Partner)
asked in Data Migration

Does any have a set of Apps 10 data migration jobs for IFS 2004 data?

I am setting up a data migration project for a client running IFS 2004 migrating into Apps 10 UPD8. In the Apps 10 database I have created local VIEWs in a separate schema named IFS2004 using a database link to their IFS 2004 database. This makes it easy to use the FNDMIG input of using a VIEW/TABLE as the data source. Its fast and easy. Does anyone have any pre-built data migration (FNDMIG) jobs for customers, suppliers, etc. that you can export and share (PL/SQL format preferred please)? Your assistance will keep me from having to re-invent the wheel. Thank you for your help!

3
eqbstal
Superhero (Partner)
3 years ago
G
Do Gooder (Customer)
GDFMNICHOLSDo Gooder (Customer)
asked in Data Migration

How to remove double quotes from a CSV integration when opened with notepad++

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.

1
G
Do Gooder (Customer)
1 year ago
S
Sidekick (Employee)
Sayeef.MSidekick (Employee)
asked in Data Migration

Copying Bookmarks from User to User

Hello All,I have a simple question.Is it possible to copy bookmarks for one IFS Cloud user and paste them across all the user profiles for a client? Is it possible to use the Cloud Data Migration screen to achieve this?  A client wants to avoid setting up the bookmarks manually for each of their users.Thanks in advance!Best Regards,Sayeef

4
S
Sidekick (Employee)
8 months ago

Badges

Show all badges
Terms & ConditionsCookie settings