My Oracle Support Banner

Positive Pay File With Additional Parameters Gets Error While Putting in the Payment Instruction ID (Doc ID 1321688.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.
ibycpprg.ldt


Symptoms


Getting error while trying to input the payment instruction id when the
Positive Pay File with Additional Parameters is run via the concurrent
manager.

Receive the following error:

APP-FND-01564: ORACLE error 1406 in FDFGDF

Cause: FDFGDF failed due to ORA-01406: fetched column value
was truncated
The SQL statement being executed at the time of the error
was: SELECT POSITIVE_PAY_FILE_DIRECTORY
FROM iby_payment_profiles
WHERE payment_profile_id IN
(SELECT payment_profile_id FROM iby_pay_instructions_all
WHERE payment_instruction_id = :a1) and was executed from the file
&ERRFILE.

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.