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
Last updated on DECEMBER 13, 2017
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
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
Navigation: Control > Request > Run
Run Submit Accounting (also occurs if run concurrent program: create accounting)
Enter Ledger Name
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