My Oracle Support Banner

R12: AP/IBY: Payment Process Stuck In "Formatting" or "Submitted for Printing" Status (Doc ID 2292485.1)

Last updated on MARCH 08, 2023

Applies to:

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

Symptoms

After submitting a Payment Process Request (Payments -> Enter -> Payment Manager -> Submit Single Payment Process Request) the Request is stuck in "Formatting" or "Submitted for Printing" status and cannot be confirmed.
An error similar to

****************** AP_IBY_PMT_MISMATCH TECHNICAL DETAILS ********************

The payments could not be marked as printed due to a Payment Mismatch Error.
Please contact the System Administrator and report the payment(s) listed
below. You can process the remaining payments by initiating stop and
confirming stop on the payment reference number(s) listed below.

The following document(s) payable exists in iby_docs_payable_all but not in
ap_invoice_payments_all or ap_selected_invoices_all:
  
  Payment Reference Number: 666666
  --------------------------------------------
        Technical Details: 
           PAYMENT_ID: 7777777
           PAYMENT_INSTRUCTION_ID: 8888
           INVOICE_ID: 99999999
           PAYMENT_NUM: 1

The following query returns the PPR

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.