Can the invoice date X days beyond sysdate be used in BPM to auto-reject invoices?
Oracle allows the Invoice Date field to be FAR future dates, causing issues with aging and payments. We are looking to use BPM Invoice Approvals to auto-reject the invoice if the date is X days beyond the sysdate. (ex: more than 60 days beyond sysdate)
Content (please ensure you mask any confidential information):
Oracle, in the UI and imports, allows the Invoice Date on invoices to be entered far into the future. This is stemming from user typos, either in the application directly, or in a 3rd party system which is imported into Oracle.
We are not looking for Oracle to stop these incorrect dates, but to utilize Invoice Approvals to check the Invoice Date by comparing to the current system date. ex: If the invoice date is less or equal to sysdate + 60, approve. If the invoice date is great than sysdate + 60, then reject.