R12: AP/IBY: Payment Process Stuck In Formatting Status (Doc ID 2292485.1)

Last updated on AUGUST 05, 2017

Applies to:

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

Symptoms

Payment Process Request is stuck in Formatting status and cannot be confirmed.

The following query returns the PPR

select iby_pay.PAYMENT_PROCESS_REQUEST_NAME
, count(distinct iby_docs.CALLING_APP_DOC_UNIQUE_REF2)
from ap_invoices_all ai,
ap_payment_schedules_all ps,
iby_docs_payable_all iby_docs,
iby_payments_all iby_pay
where ai.invoice_id = ps.invoice_id
and to_char(ps.invoice_id) = iby_docs.CALLING_APP_DOC_UNIQUE_REF2
and to_char(ps.payment_num) = iby_docs.CALLING_APP_DOC_UNIQUE_REF3
and iby_docs.DOCUMENT_STATUS = 'PAYMENT_CREATED'
and iby_pay.payment_id = iby_docs.payment_id
and iby_docs.CALLING_APP_DOC_UNIQUE_REF2 not in
( select v.invoice_id
from ap_selected_invoices_all v
where v.checkrun_id = iby_docs.CALLING_APP_DOC_UNIQUE_REF1)
group by iby_pay.PAYMENT_PROCESS_REQUEST_NAME;

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