How to Delete AP Invoice Data from the Oracle Apps EBS R12.

API “AP_AI_TABLE_HANDLER_PKG.DELETE_ROW” can be used to delete AP Invoice Data.

This Script can be used when invoice accounting is not done.

DECLARE
CURSOR CUR1 IS
SELECT AIA.ROWID,AIA.* FROM AP_INVOICES_ALL AIA WHERE AIA.BATCH_ID <>13000;
BEGIN
MO_GLOBAL.SET_POLICY_CONTEXT(‘S’,101); — CHANGE THE ORG ID AS PER INSTANCE SETUP.
FOR I IN CUR1 LOOP

AP_AI_TABLE_HANDLER_PKG.DELETE_ROW(I.ROWID,’APXINWKB’);
END LOOP;
COMMIT;
END;