My Oracle Support Banner

R12:AP:AP Purge Hooks To Allow Deletions From XLA/IBY Tables (Doc ID 2760014.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Oracle Payables - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Purge Issues in Payment

ACTUAL BEHAVIOR
---------------
Custom hooks included in Purge standard package does not clear or remove the IBY and XLA payment data

EXPECTED BEHAVIOR
-----------------------
Custom hooks included in Purge standard package should clear or remove the IBY and XLA payment data

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Purge Program after including custom hooks to delete IBY and XLA payment data

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete purge process successfully for IBY and XLA payment data.

Changes

Modified  call to custom hook AP_CUSTOM_PURGE_PKG.PURGE_EXTERNAL_DATA prior to deletion of payment base tables in ppurgeb.pls file that is called in standard purge process ,this helped to resolve the issue.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
 Modified  call to custom hook AP_CUSTOM_PURGE_PKG.PURGE_EXTERNAL_DATA prior to deletion of payment base tables in ppurgeb.pls file that is called in standard purge process ,this helped to resolve the issue.
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.