Oracle calculating due date incorrectly on POs
In R11i we are having an issue in which Oracle calculates the Due Dates on invoices associated with POs incorrectly. The incorrect due dates cause the POs to pay late.
For example, invoice date 02-Mar-2009 terms Net 45 should pay 16-Apr but Oracle calculates a due date of 25-Apr.
The variance in the due date is between 1 and 44 days late or longer. We have noted that in the table
APPS.AP_PAYMENT_SCHEDULES_ALL if the field DUE_DATE contains a date-time stamp then the invoices will pay late; if the DUE_DATE field contains only a date, then the invoice will pay on time.