In a DEV enviroment, we just did a test upgrade from APPS10 UDP 7 to APPS10 UDP 19 and after the update, when I checked for invalid objects, there were two. However, I can’t get them to recompile. I’ve try doing it with the RMB option in IFS as well as directly on the DB. Still, I am getting the error 565 PLS-00201: identifier 'COMPONENT_TRVALL_SYS.INSTALLED' must be declared 564 PL/SQL: Statement ignored 565 PLS-00174: a static boolean expression must be used
Seeing objects that get invalidated after a some sort of deployment is not unusual. It’s hard to say why you would see some all of a sudden without any change in the system without looking at the actual error before compiling.
Since the issues that you have are specific to a custom component that is not a core component, you would need to look at the code in the package that is going to error to start with. Looking at the component registration you attached, all the other components seems to have been updated correctly.
Did you get any deployment errors during the actual UPD application? I would also take a look at the installed components page to make sure that all the components are actually in the new UPD level and nothing has been missed.
Looking at the name of the invalid packages it appears as if they are customizations rather than core packages so you might need to check the logic
I did get an issue during the UDP application. At some point during the upgrade, I got an error message saying that a specific database object could not be compiled with a prompt offering to try to recompile it. When I clicked to recompile, it seems to have gone through since I did not get the error again.
Furthermore, when I looked at the the invalid objects today, there were many more than the moment I made the post on the community forum. There were dozen of objects. I was able to recompile them except for the two MTK objects as shown in my original screenshot.
So I wonder if it is a usual behaviour for objects to get invalidated and need to be recompiled? I’m not a DBA and we do not have any at our company. Thus my questioning
Lastly, attached, a CSV file with all the components that are installed.
Seeing objects that get invalidated after a some sort of deployment is not unusual. It’s hard to say why you would see some all of a sudden without any change in the system without looking at the actual error before compiling.
Since the issues that you have are specific to a custom component that is not a core component, you would need to look at the code in the package that is going to error to start with. Looking at the component registration you attached, all the other components seems to have been updated correctly.
Does anyone have any kind of installation guide , how to apply UPD in IFS 10? I will be doing UPD for the first time, so it would be great to have some installation guide (where steps are mentioned what to do)
It’s very important that you take a full backup of both the database and ifs_home before deploying an UPD delivery. These in nature are large and includes Oracle Web Logic patches so you need to make sure there is at least 25GB or so free space in the drive where ifs_home is located and not stressed for CPU/Memory during the deployment.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
