FDMEE Data Load Error Due To Specific Characters in Data Load Mappings (Doc ID 2136054.1)

Last updated on MAY 13, 2016

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.100 to 11.1.2.4.200 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When user load data files into FDMEE, they have some error due to specific characters.
Log Error
BLANK............. Line is blank or empty.
NN................ Non-Numeric, Amount field contains non numeric characters.
TC................ Type Conversion, Amount field could not be converted to a number.
ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.
SKIP FIELD.............. SKIP field value was found
NULL ACCOUNT VALUE.............. Account Field is null
SKIP FROM SCRIPT.............. Skipped through Script


[TC] - [Amount=NN] Dep Priority Source Market Project Department Entity Account Curr Budget Item Transaction Date PR_PO Reference Account GL Journal Entry Pure USD Vendor Name Part Description Month 1 Month 2 Month 3
[TC] - [Amount=NN] ... No �"�� ��.�� ��.��.�� 0.00 0.00 100.00
[TC] - [Amount=NN] ... No �"�� ��.�� ��.��.�� 0.00 0.00 200.00
[TC] - [Amount=NN] ... �"�� ��.�� ��.��.�� 0.00 0.00 900.00
[TC] - [Amount=NN] ... No �"�� ��.�� ��.��.�� 0.00 0.00 100.00
[TC] - [Amount=NN] ... No �"�� ��� ���� ����� 123.27 0.00 0.00
[TC] - [Amount=NN] ... No �"�� ��� ���� ����� 1141.19 0.00 0.00
[TC] - [Amount=NN] ... No .�"�� ����� (3000) .�.� 5252.37 0.00 0.00
[TC] - [Amount=NN] ... No .�"�� ����� (3000) .�.� 365.34 0.00 0.00
[TC] - [Amount=NN] ... No �"�� ������ ����� ���� 0.00 0.00 1001.60
[TC] - [Amount=NN] ... No �"�� ������ ����� ���� 0.00 0.00 883.61
[TC] - [Amount=NN] ... No �"�� �������� ����� ������ 0.00 0.00 1297.42
Rows Loaded: 123
Rows Rejected: 12

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