Reply to thread

Message: <blockquote data-quote="markdcci" data-source="post: 201285" data-attributes="member: 5923">Rauf,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.</blockquote>