My Oracle Support Banner

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

Last updated on JANUARY 19, 2021

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_pay.PAYMENTS_COMPLETE_FLAG != 'Y'
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;

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.