We have a business requirement to change many of our top level project ids. It looks like this is a primary key on the project_tab table, so it sounds like it might be messy.
Can anyone help provide guidance on approaches to changing project ids, if there is a third party tool, or if it would be possible using any of the built-in migration tools.
We are on apps10 if it matters.
TIA
Hi
As far as I know, there is no such inbuilt-tool.
If you change the project ID in project_tab, you have to make the same change in the other related locations associated with that primary key. It's a very complicated job.
see the answer below for similar discussion
database - Change primary key value in Oracle - Stack Overflow
Please note that these ID’s are also in the GL Vouchers, preposting information, Purchase order Header (in case of Project Unique Procurement) etc etc. I would suggest to make a dumb custom field with the new value and generate the new projects with the new sequence.
BR/Marten
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.