topic Re: Issue on Commit work in Application Development and Automation Discussions

Issue on Commit work

Former Member — Thu, 09 Jul 2009 17:08:10 GMT

Hi Friends ,

I am calling function module where I have created Background Job and Submitted it . In Submit call I am updating the database table . In a LOOP am updating service entry sheets of one Purchase order . (1 PO consists of More than 1 Service entry sheets)

Here I am able to update only First SES when it is processing the Second Service Entry sheet the PO get Locked.

I have used the COMMIT and WAIT command after the updating the Service entry sheet.

Here I am getting PO LOCK error by Same USER.

Can u suggest me in this Scenario.

Thanks in advance.

Jagadeshwar.G

Re: Issue on Commit work

Former Member — Thu, 09 Jul 2009 17:15:28 GMT

Hello,

Try using Lock object (Enqueue and Dequeue) while updating the database table.

Regards,

Jacky.

Re: Issue on Commit work

Former Member — Thu, 09 Jul 2009 17:17:28 GMT

Hi,

Enqueue the Purchase order before updating the Purchase order and after updating the Purchase order Dequeue the Purchase order.

Re: Issue on Commit work

Former Member — Thu, 09 Jul 2009 17:52:14 GMT

Hi Ja,

try to use parameter WAIT = 'X' when you calling the BAPI_COMMIT_WORK FM.

regards,

Rama

Re: Issue on Commit work

Former Member — Thu, 09 Jul 2009 18:03:44 GMT

Use the BAPi - BAPI_PO_CHANGE to change the PO & BAPI_TRANSACTION_COMMIT to commit work.

Re: Issue on Commit work

Former Member — Fri, 10 Jul 2009 08:18:25 GMT

The Actual Message User is getting is 'Purchase order is processing XX user' .

Thanks in advance.

Re: Issue on Commit work

Former Member — Fri, 10 Jul 2009 08:37:02 GMT

Hi, put wait in the commit and after the commit bapi, use the dequeue inside the loop. Hope this helps.

Best Regards,

Benedict

Re: Issue on Commit work

Former Member — Fri, 10 Jul 2009 09:05:51 GMT

hi ,

i also had the alike issue.

i resolved it using this code

syntax:

wait up to 2 seconds.

commitwork.

thanks & regards,

kat

Re: Issue on Commit work

Former Member — Fri, 10 Jul 2009 09:20:36 GMT

pl. paste the BAPI code how your are writing .

regards,

Rama

Re: Issue on Commit work

Former Member — Fri, 10 Jul 2009 09:41:05 GMT

Thanks for information .

Even i have coded as follows .

ITAB records as follows

S1 - Servcice Sheet

P1 PO

X - other flds

S1 P1 X X X

S2 P1 X X X

S3 p1 X X X

Loop at ITAB to WA.

UPDATE <ZTABLE> with .......

commit work and wait.

.............

...........

ENDLOOP.

Error Message : PO is already in process by XXXX.

- This program runs in Background .My problem is I can't test this prg in dev .

Could you please explain the situation u faced so that i can validate it . Thx in advance.

Thx