Expenditure Batch Approval Based on Positive and Negative Transaction Amounts

Summary: Need guidance on configuring separate approval workflows for positive and negative expenditure transactions within the same expenditure batch.

Content:

Hi Team,

We have a business requirement to route expenditure transactions through different approval paths based on whether the transaction amount is positive or negative.

Requirement:

Positive expenditure transactions should follow Workflow A.
Negative expenditure transactions should follow Workflow B.

Currently, we are using Project Expenditure Batch Approval workflow. In some scenarios, a single expenditure batch contains both positive and negative lines. For example:

Transaction 1: +100
Transaction 2: -100

When the batch is submitted for approval, Oracle appears to evaluate the net batch amount (0 in this example) rather than each individual expenditure line. As a result, we are unable to route positive and negative transactions through separate approval workflows.