This discussion is archived
2 Replies Latest reply: Sep 6, 2013 6:11 AM by Hoek RSS

Facing an issue in accessing a sequence concurrently

RajendraSowani Newbie
Currently Being Moderated

Working on the order integration using staging schema between ERP and CRM.

Facing an issue :- Used one procedure to integrate the data from CRM to ERP and which is being called in two different order type simultaneously. In this procedure I have used a sequence which will be a primary key. The logic written is 1. fetching value from a sequence and 2. creating a record in the table.

In the above scenario, it is being observed that some times it is getting same sequence no in both the jobs and hence the result of the same triggers to failure of the transaction.

Need help to resolve this issue.

 

Regards,

Rajendra

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points