Generate Flexfield Database Items FF-1605210 The Data Type Is Invalid (Doc ID 2255389.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

PROBLEM STATEMENT
=================
Receives an error when attempting to run the Generate DFF Database Items


ERROR
-----------------------

Error:
inside FlexDBIGenerationEssJob
Going to call fastAm.maintainFFDynamicEntities
Exception in the execute method of FlexDBIGenerationEssJob
:oracle.jbo.RowValException: JBO-FF:::FF_FFCR_DBI_DATATYPE_MULTIROW:
FF-1605210The data type is
invalid.The data type for an
array database item must be TN (text values and number indexes array), NN
(number values and number indexes array), or DN (date values and number
indexes array).

STEPS TO REPRODUCE
==================
1. Payroll
2. Checklist
3. Submit a process or report
4. Generate Flexfield
5. Database Items

EXPECTED BEHAVIOR
=================
No error to be raised.

BUSINESS IMPACT
===============
Due to this issue, users cannot finish their ADP set up to have their Third party Payments completed

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