Customers Workbench: View DFF Dates Error 'Please Enter Data Value 20120714 In Correct Format YYYY/MM/DD HH24:MI:SS' (Doc ID 1536891.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 11.5.10 to 12.1.3, users are having an issue with the dates on the Customer Information Descriptive Flexfield (DFF) which is using 'FND_STANDARD_DATE'.
The attribute contains context sensitive data of this format: 'YYYY/MM/DD'.

The following error message is received when viewing the Customer Information DFF for Review Date (which is an attribute that uses FND_STANDARD_DATE value set for the context value 'AIR MOVING'):

Error Codes
---------------------------------------------------
Please enter data value 20120714 in correct format YYYY/MM/DD HH24:MI:SS

The issue only happens for customers that are upgraded from 11i.

Steps to Reproduce:
Responsibility:  Receivables Manager
Navigation:  Customers > Customers
Query for a customer that was upgraded from 11i.
Click on Details icon for the account.

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