Submit Accounting and Create Accounting Fails with Format Error - Please Enter Date Value in Correct Format MM/DD/RRRR - APP-FND-00730: This Flexfield Has an Invalid Value Set (Doc ID 1937628.1)

Last updated on NOVEMBER 23, 2021

Applies to:

Symptoms

You have set the Profile Option ICX: Date Format at responsibility level.
After this change, you attempt to run the Submit Accounting program, but receive the following error when attempting to update the parameters:

Please enter date value 30-JUN-2014 in correct format: MM/DD/RRRR

APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed.
If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.

Contact your system administrator or support representative to check and correct the value sets this flexfield uses.

Steps to Reproduce:
Responsibility:  System Administrator
Navigation:  Profile > System
Query Profile Option: ICX: Date format mask
Set as follows:
Site Level: 12/31/1999
Responsibility Level:  31-DEC-1999

Responsibility:  Receivables
Navigation:  Control > Request > Run 
Run Submit Accounting (also occurs if run concurrent program: create accounting)
Enter Ledger Name
Error occurs

Cause

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