As a Standard Oracle only permits Standard and Credit Memo’s thru the interface. Then how to deal with Debit Memo’s. A bit of tweaking can be done to achieve this. One needs to create at a Credit Memo initially through the interface and then run the update query which wud change the status of it to Debit Memo.

Below Query can be used at form level -

UPDATE AP_INVOICES_ALL
SET INVOICE_TYPE_LOOKUP_CODE
=’DEBIT’,PAYMENT_METHOD_LOOKUP_CODE =’CHECK’,PAYMENT_STATUS_FLAG=’N’
WHERE INVOICE_NUM
=:KPM_DEBIT_NOTE_HEADERS.DEBIT_NOTE_NO||’,'||:KPM_DEBIT_NOTE_HEADERS.DEBIT_N
OTE_DATE||’/'||:KPM_DEBIT_NOTE_HEADERS.invoice_num||’,'||:KPM_DEBIT_NOTE_HEA
DERS.invoice_date;

(Query provided by Kapil Sehdev)