R12.2: AP: Payment Instruction Register Error -APP-FND-01564: ORACLE Error 904 In Fdlget

(Doc ID 2413105.1)

Last updated on JULY 03, 2018

Applies to:

Oracle Payables - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

On : 12.2.7 version, Pmt PayReports PBatch & Prepay

Payment Instruction Register error - APP-FND-01564: ORACLE error 904 in fdlget

For concurrent request "Payment Instruction Register", error is prompted while selecting the parameter "Payment Instruction" LOV
 The Patch 23752677:R12.IBY.C provided didn't resolve the issue.
     R12: Payment Instruction Register report - No Entries For List Of Values On Payment Instruction Parameter (Doc ID 2171167.1)


the error and found the root caused.
It is due to the error Where/Order by condition of value set IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM.

The version of this value set can be found below:
# $Header: ibycpprg.ldt 120.81.12020000.14 2016/08/01 06:54:00 pratishu ship $

Cause

 BUG 28120912 - VALUE SET IBY_FD_FINAL_PMT_REG_INSTR_REF_NUM ERROR

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