R12 Invoice Workbench - Making the project field mandatory when invoice distribution/lines have cert
Hi
We use R12 Oracle Payables and Oracle Projects. Capital projects are mapped a CWIP (Capital work in progress) balance sheet GL account.
Invoices coded to the CWIP account without project numbers causes reconciliation variances between GL and Projects.
In the past, we have used triggers and alerts to force users to enter project numbers in the invoice workbench. Is there standard Oracle functions or other methods to achieve this?
Regards
Michael