Hi, Usually in jpy or jdv environmentswe can know the deployment time for applications by clicking some button on top right side. is there any way to know the object deployment time for UBE? just to avoid dbts while testing. thanks in advance.
Check the OMW logging for this object. You should be able to find the last time it was promoted to production. Look for the detail logging to confirm it was indeed promoted to production. Then look for the package builds around this date and see if this object was included.
Not sure you have access to query tables in your database, but if it was last built and deployed in an update package you should be able to query a table in your system library. In my case it is SY920, in your case it might be SY812 or similar. Oracle changed details around package builds in 9.1 so the table may or may not match, but the F9631 holds the detail on all update packages at 9.2 where we are at:
SELECT PDPKGNAME FROM SYxxx/F9631 WHERE PDOBNM ='R55ABC1'
This should give you every update package containing the object. Just pick the last one and make sure it built correctly and was deployed via the package build and deployment applications.
Note that if you built a full pkg after that or if there is no entry in the F9631, make sure the object existed and was checked in before the last full package and the deployment will be from the deployment of the full package.