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 JUNE 07, 2016

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.
EXECUTABLE:ARACCPB - Submit Accounting
EXECUTABLE:XLAACCPB - Create Accounting

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

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