topic BAPI_ACC_DOCUMENT_POST mass postings with single commit in Application Development and Automation Discussions

BAPI_ACC_DOCUMENT_POST mass postings with single commit

venu_001 — Wed, 05 Aug 2020 07:57:44 GMT

Hi Experts,

I have a requirement to post 1000+ GL documents which are in single file, and if any error in one of the 1000 documents then I want to rollback all 1000 documents.

For that I am using BAPI_ACC_DOCUMENT_POST and commit work/Rollback work is at end of the process, is there any issue if all 1000 documents are committed or rollback in single shot? Please advise.

Best Regards,

Re: BAPI_ACC_DOCUMENT_POST mass postings with single commit

juanitogonzales28 — Wed, 05 Aug 2020 08:13:57 GMT

Hi venugopalreddy.sagamredi,

It is a best practice to use exclusive lock to the record you wish to modify to avoid data inconsistency with other users.

Please perform the following steps:

- Set exclusive locks for the data you wish to change or process.

- If exclusive lock is successful, read the current data in the database (To ensure up-to-date data).

- Change the data and update the data in the database (Database Commit).

- Release the lock

** Please take note not to set the lock for too long to allow other users to do there work.

In addition, to Commit/Rollback 1,000 records in one shot is the recommended practice in terms of performance because the Application Layer connects to the Database Layer only once which will lessen the burden to the DBMS.

Hope this helps.

Re: BAPI_ACC_DOCUMENT_POST mass postings with single commit

GK817 — Wed, 05 Aug 2020 08:16:19 GMT

Hi Venu,

I think you will have to do it one by one.

Have you tried creating 5-10 document postings with single commit/rollback, does that work?

Gaurav

Re: BAPI_ACC_DOCUMENT_POST mass postings with single commit

juanitogonzales28 — Wed, 05 Aug 2020 08:23:29 GMT

Hi gaurav.karkara3,

I think it would be possible if he uses IN UPDATE TASK.

Thanks,

Gonzales, Juanito III Roa

Re: BAPI_ACC_DOCUMENT_POST mass postings with single commit

GK817 — Wed, 05 Aug 2020 08:33:49 GMT

Probably 'SET UPDATE TASK LOCAL' before BAPI call will help, but for such huge numbers i foresee some issues. I remember facing some.

Gaurav

Re: BAPI_ACC_DOCUMENT_POST mass postings with single commit

venu_001 — Wed, 05 Aug 2020 09:52:22 GMT

Hi Gaurav,

I have tried with 5 documents it's working, but not sure how it behaves for large number of documents.

Best Regards,

Re: BAPI_ACC_DOCUMENT_POST mass postings with single commit

GK817 — Wed, 05 Aug 2020 11:09:33 GMT

Good Venu!

There could be locking issue but i can't be sure of that. So, In certain, I think i won't advise on this.

Gaurav