Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent Program - Oracle Apps (Oracle Applications 11.5.10)
Concurrent Program - Oracle Apps [message #307036] Mon, 17 March 2008 11:31 Go to next message
Messages: 8
Registered: February 2008
Location: India
Junior Member

As per the Oracle Applications Guideline - We should not issue commits in our concurrent program.

Is there any situation where it is needed to give a commit within the concurrent program and also is that documented in Guideline that in these situations we might need to give commit in our program.

Re: Concurrent Program - Oracle Apps [message #307111 is a reply to message #307036] Mon, 17 March 2008 19:01 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
I didn't hear anything about it. Where did you read about the restriction on commit?

Concurrent Programs can have many types of executables. And we normally use them for reporting purpose. May be in this scenario what you have read is correct.

But I have seen many cases (like stored procedure executables), where we use commit.

Re: Concurrent Program - Oracle Apps [message #307937 is a reply to message #307036] Thu, 20 March 2008 07:31 Go to previous message
Messages: 9
Registered: August 2007
Junior Member
We use Commit mostly in Interfaces and Conversion programs.
But there is no such hard and fast rule that you should not use commit.

But you have to decide how many times you want to use commit.After each insert or may be after 50 inserts just to enhance performace.
Previous Topic: Query to display menus, submenus & functions attached to responsibilities
Next Topic: Pick To Order Documentation
Goto Forum:

Current Time: Thu Jul 20 22:03:42 CDT 2017

Total time taken to generate the page: 0.16574 seconds