My Oracle Support Banner

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 OCTOBER 13, 2022

Applies to:

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


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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.