Oracle EBS: 修改AR due date

問題: 月結payment term的due date計算有誤, 每月26日之後的交易都少算一個月.

修改:

UPDATE AR_PAYMENT_SCHEDULES_ALL A

   SET A.DUE_DATE = ADD_MONTHS (A.DUE_DATE, 1)
 WHERE customer_trx_id IN (1825819, 1825818, 1825820)
 
 
UPDATE RA_CUSTOMER_TRX_ALL B
   SET B.TERM_DUE_DATE = ADD_MONTHS (B.TERM_DUE_DATE, 1)
 WHERE customer_trx_id IN (1825819, 1825818, 1825820)
 

先治標, 根本問題還要再解.