Payables and Cash Management - EBS (MOSC)

MOSC Banner

SIMPLE Invoices are not getting purged

edited Dec 23, 2014 10:00AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered

Hello Dev Team,

SR 3-9978966471

SIMPLE Invoices are not getting purged due to below condition: we have pa_addition_flag='N' for the list of invoices which are not getting purged.

-- Retest PA Invoices
/* https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=11722321bug 11722321  incorporating changes of https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=8842960bug 8842960  and 8979828 in R12 start */
     UPDATE ap_purge_invoice_list PL
     SET PL.double_check_flag = 'N'
     WHERE PL.double_check_flag = 'Y'
     AND EXISTS (
        SELECT 'Invoices are not transfered to PA'
        FROM ap_invoices I,
             ap_invoice_distributions D

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