Exception Handling Interface
Background
I see the below kind of issues raised for many cases and giving one such case of many, as the example:
https://community.oracle.com/ideas/6201#comment-1042466
Suggested Resolution
With the kind of technology strength oracle has, there is a need for standard Exception handling interface to handle all such cases to fix the failed transactions.