Out Of Sync Posted Flags due to bug#3232467

(Doc ID 265086.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Payables - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms