Get Started with Redwood: Oracle Cloud SCM and Purchasing
How to Validate Duplicate DFF Values Across PO Lines for the Same Supplier?
in Purchasing
Hi Oracle Community,
I have a requirement to validate duplicate invoice numbers entered via a DFF on Purchase Order lines in Oracle Fusion Procurement.
The Issue:
Users enter invoice numbers on PO lines using a DFF segment. The same invoice number should not be allowed more than once for the same Supplier — whether on the same PO or across different POs for that supplier.
- Classic UI — Would a SQL Table-Validated Value Set on the DFF segment be the right approach? The query would check PO_LINES_ALL filtering by Supplier ID and the DFF attribute column to block duplicates. Has anyone implemented cross-PO DFF validation this way?
0