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 ]

Goal

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?

Solution

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