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
shasikkumar
Messages: 8
Registered: February 2008
Location: India
Junior Member
Hi,

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.


Thanks,
Shasi
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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.

By
Vamsi
Re: Concurrent Program - Oracle Apps [message #307937 is a reply to message #307036] Thu, 20 March 2008 07:31 Go to previous message
Dhruva
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: Tue Dec 06 04:29:15 CST 2016

Total time taken to generate the page: 0.06972 seconds