3 Replies Latest reply on Oct 31, 2016 8:03 AM by John_K

    Advisable to put a Commit in an Oracle EBS Concurrent Program?

    Migs_Isip

      i just want to ask if its Advisable to put a Commit inside PL/SQL Procedure being called by an Oracle EBS Concurrent Program? I've always believed its bad practice to put commits inside the program for the following reasons:

      1. If the Program encounters an Exception after the Commit, we cannot Roll it back anymore.
      2. Let the calling application do the implicit commit (in this case, EBS)
      3. As in the case of Oracle Workflows, we should never put Commits inside the WF package as it will disrupt the "rollback" feature of the Workflow.

      However, i keep on seeing Oracle EBS Developers put commits inside a single Concurrent Program. Any thoughts on this?

      Thanks!