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

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