Warning control in Payables Module if the invoice date is 3 months older than GL date or vice versa - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/08/warning-control-in-payables-module-if.html

When New Block Instance
LINE_SUM_FOLDER

Condition:
abs(Months_between(:INV_SUM_FOLDER.INVOICE_DATE,:INV_SUM_FOLDER.GL_DATE)) > 3

Warning
Message: Number of Months between Invoice & GL Date Exceeds 3 Months.


OR, You can put Error on Header. So user cannot proceed with the Invoice.


When Validate Record
INV_SUM_FOLDER

Condition:
abs(Months_between(:INV_SUM_FOLDER.INVOICE_DATE,:INV_SUM_FOLDER.GL_DATE)) > 3

Error
Message: Number of Months between Invoice & GL Date Exceeds 3 Months.