BPA Workflow Commit

Hi,

As  per the release notes in 25R2, it supports for pragma autonomous transaction with commit, rollback and save point. But have not tested yet what actually works and not.

Best Regards,
Wasana

thank you. 

the documentation indicate that IFS BPA Workflows now support invoking APIs with Pragma Autonomous blocks in PL/SQL procedures and functions via IFS API tasks.

I was wondering how the non autonomous block will react?

I think It may be the same as before with error.But not tested anything yet.

BR,

Wasana

Hi,

I’ve tested with the API ProjectProcurementHandling.ProjectMiscPartProcurementSet to update the SupplyOption but I’m having the same error about Savepoint, so, I think this is not working still or am I doing something wrong?

Application service update: 25.2.2

Framework service update: 25.2.2

Hi,

In your procedure, you have declared PRAGMA autonomous_transaction as shown below. Now it works because, since 25R2, it is allowed through workflows.

PROCEDURE Example_Procedure___
IS
   PRAGMA autonomous_transaction;
BEGIN
   -- insert sql
   @ApproveTransactionStatement();
   COMMIT;
END Example_Procedure___;

Here, I used a test projection and a test procedure declared with PRAGMA autonomous_transaction. When I debugged this, I found no issues.

However, if you use COMMIT in workflows without PRAGMA autonomous_transaction, like this:

PROCEDURE Example_Procedure___
IS
BEGIN
   -- insert sql
   @ApproveTransactionStatement();
   COMMIT;
END Example_Procedure___;

without PRAGMA autonomous_transaction, according to the Workflow transaction management policy, APIs that have implicit commits, rollbacks, or save points cannot be called through a workflow. You will receive the error:

ORA-00034: cannot COMMIT in current PL/SQL session.