Is the custom code in the post_data_process_handler_pkg.pkb retained after applying a patch or does the code have to be manually copied after applying the patch?
No patches won't wipe out custom code in the post_data_process_handler_pkg.pkb or any other customization's unlike upgrade. However it's worth to note that some times patches may contain bugs and things may not follow the text book trajectory.
Hi vishwanath babali
I was under the impression that patches may delete customizations from DB packages.
Let's take for example a scenario where the engineering team wants to make changes to this specific DB package.
Then most likely the patch will include a modified package and during the upgrade it will overwrite the existing package along with the customization.
I don't know how patch will be applied when this specific package itself is updated by Engineering. They may also update only delta changes. May be some one from Engineering wants to answer this. As far as I remember from previous experience patches did not overwrite any customization from post_data_process_handler_pkg.pkb.
I have also seen the customization being preserved across patches until I applied P16 on 6.9.1 and then the code wasn't preserved. Hence my question - which behavior is expected and which is a bug to reported.
Retrieving data ...