My Oracle Support Banner

R12 Create Printed Payment Instructions: Cannot Select Payment Document While Selecting Payment Process Profile (PPP) (Doc ID 840468.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payments - Version: 12.0.1 and later   [Release: 12.0 and later ]


After processing a PPR(s), prepare to submit the Created Printed Payment Instructions request from Payments Manager. In Step 2, select Payment Process Profile (PPP) as Standard Check Format, and then select the Internal Bank Account. However, nothing can then be selected for Payment Document,even though several payment Document have been setup under the specified internal bank account which reference the Payment Instruction Format: Standard Check Format. Searches for Payment Document in Step 2 of Create Printed Payment Instructins produce only 'No Items found'.

A verification was performed manually in the application and via running the following SQL query,to be certain that the target payment Documents were not in use on other Payment Instructions:
select payment_instruction_id "WIP Pmt Instruction"
, Substr(payment_document_name,1,15) "Document Name"
from ce_payment_documents cpd, ce_bank_accounts cba
where cpd.internal_bank_account_id = cba.bank_account_id
and bank_account_name ='<InternalBankAccountName>';

So why is it impossible to select a payment Document in step 2 of Create Printed Payment Instructions?


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

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