By Toddac-Oracle on Jun 23, 2016
As EBS products have evolved, Oracle has made many Application Programmer Interfaces (APIs) available for general use by the Oracle User community. Wouldn't it be tremendously helpful if you could trace/debug your own API work as you develop code based on the APIs? Well we're here to let you know, you can!
Check out My Oracle Support (MOS) document, How to Enable Trace or Debug for APIs executed as SQL Script Outside of the Applications ? [Video] (Doc ID 869386.1), to see short, complete details on using trace and debug techniques at a SQL command line or in a SQL*Developer session. Both techniques are quite simple to use and very effective tools for helping you to figure out where your code is getting stuck, or why it is returning unexpected results.
With these techniques you may be able to resolve complex error situations without asking Support to assist you (which we will gladly do, of course -- especially if you're really stuck.)
Doc ID 869386.1, includes video demonstrations on these techniques, like:
Doc ID 869386.1 has become one of the most-reviewed documents in our EBS Manufacturing Inventory space. We are certain you'll find this useful. Happy coding, tracing, and debugging!!!