Out Of Sync Posted Flags due to bug#3232467 (Doc ID 265086.1)

Last updated on JULY 01, 2022

Applies to:

Symptoms

-One or more orgs have invoice/payment rows with out of sync posted flags.

-A payment will not account because one of the invoices paid on the payment has out of sync/incorrect posted flags.

-Invoices/Payment incorrectly reported on the Period Close Exceptions Report and the Unaccounted Sweep report.

If the following queries return any rows you may have this issue:

select asp.org_id, substr(asp.accounting_method_option,1,15) primary, asp.set_of_books_id psob,
substr(asp.secondary_accounting_method,1,15) secondary, asp.secondary_set_of_books_id ssob,
accrual_posted_flag, cash_posted_flag, posted_flag, count(*)
from ap_invoice_distributions_all aid, ap_system_parameters_all asp
where asp.org_id = aid.org_id
and posted_flag = 'N'
and (accrual_posted_flag != 'N' or cash_posted_flag != 'N')
group by asp.org_id, asp.accounting_method_option, asp.set_of_books_id,
asp.secondary_accounting_method, asp.secondary_set_of_books_id,
accrual_posted_flag, cash_posted_flag, posted_flag;

select asp.org_id, substr(asp.accounting_method_option,1,15) primary, asp.set_of_books_id psob,
substr(asp.secondary_accounting_method,1,15) secondary, asp.secondary_set_of_books_id ssob,
accrual_posted_flag, cash_posted_flag, posted_flag, count(*)
from ap_invoice_payments_all aip, ap_system_parameters_all asp
where asp.org_id = aip.org_id
and posted_flag = 'N'
and (accrual_posted_flag != 'N' or cash_posted_flag != 'N')
group by asp.org_id, asp.accounting_method_option, asp.set_of_books_id,
asp.secondary_accounting_method, asp.secondary_set_of_books_id,
accrual_posted_flag, cash_posted_flag, posted_flag;

Changes

None

Cause