ApproveAdjustment - SQL Script to identify which BPM rule is used

Sep 9, 2026 5:30AM

Summary:

Hi

We have configured several rules for the BPM flow ApproveAdjustment.

Can you please share a script to identify which rule is used in a specific approval flow?

Regards, Bo

For comparison I'm using this script to identify rules in AP Invoices:

SELECT INVOICE_ID, HISTORY_TYPE, APPROVAL_HISTORY_ID,

NVL(ACTION_DATE, CREATION_DATE) AS ACTION_DATE,

TO_CHAR(NVL(ACTION_DATE, CREATION_DATE), 'MM/DD/YYYY HH24:MI:SS') AS ACTION_DATE_24H_FORMATTED,

RESPONSE, APPROVER_ID, AMOUNT_APPROVED, LINE_NUMBER, HISTORY_HASHCODE, RULE_NAME, APPROVAL_STEP

FROM AP_INV_APRVL_HIST_ALL

WHERE INVOICE_ID = TO_CHAR(5599268)