My Oracle Support Banner

E1: DB: Transaction, Transaction Processing, Commit and Rollback (Doc ID 1208208.1)

Last updated on JANUARY 11, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
Information in this document applies to any platform.

Purpose

In industry, a transaction is a transformation of state which has the properties of atomicity (all or nothing), durability (effects survive failures) and consistency (a correct transformation).  The transaction concept is key to the structuring of data management applications. The concept may have applicability to programming systems in general.

More commonly, ACID (Atomicity, Consistency, Isolation, Durability) is known as database transaction properties. That is, All or Nothing for critical commitment.  So it is important to understand what is a Transaction not only in EnterpriseOne but also industry common.  This document contains some possible questions you may have when getting errors such as the ones described here.

Example of Error Message:

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Transaction and Transaction Processing
 Transaction:
 Type of Transaction
 Transaction Processing:
 Benefit of Transaction Processing:
  Transaction Isolation Level:
 Master Business Functions and Transaction Processing:
 Locking
 Transaction and Locking
 How to get information on Transaction and Locking?
 How strong it locks?
 Blocking and Deadlock:
 Minimize Deadlock:
 Rollback
 Rollback:
 Memory and Rollback:
 Other Reference
 Transaction and ACID criteria (Atomicity, Consistency, Isolation, Durability):
  Possible cause of Commit Fail:
 Timeout settings:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.