Help Needed – Invoice Approval Rule Based on PO Matching at Distribution Level

Apr 25, 2025 8:05AM

Summary:

Hello Oracle Community,

I’m currently trying to define an invoice approval rule based on the following business requirement:

Invoices that are fully matched to a PO (2-way, 3-way, or 4-way match) at the distribution level should be automatically approved.
Invoices that contain at least one distribution not matched to a PO should be routed to an approval group.

I’ve attempted to model this logic using the attached spreadsheet, but my rule continues to fail.

My rules are visible in the attached spreadsheet.

At this point, I’m unsure whether the issue lies in the use of lists, rule blocks, or possibly a syntax error.