R12 Create Printed Payment Instructions: Cannot Select Payment Document While Selecting Payment Process Profile (PPP)
Last updated on MARCH 08, 2017
Applies to:Oracle Payments - Version: 12.0.1
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms