Payables and Cash Management - EBS (MOSC)

MOSC Banner

During AP Invoice Purging, data moved to ap_history_invoices_all table but the same data was not del

edited Apr 2, 2019 5:04AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

For one of my users, during AP Invoice Purging in one specific TEST instance, data moved to 'ap_history_invoices_all' table but the same data was not deleted from 'ap_invoices_all' table. During preliminary iterations in other TEST instance, this issue did not occur.

I could not find any MOS documents or bugs for such issue.

Ran below delete script for organization facing issue (data not getting purged)

delete from ap_history_invoices_all where purge_name in ('ABCD', '1234');

Reinitiated purging process for few Orgs and found that the data is getting purged from ap_invoices_all table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center