How To Not Allow Date Format Change To Avoid Charge Generation Failed Due To FND_FLEX_EXT.GET_CCID() Has Been Called Incorrectly. An Invalid Format For Validation Date String Has Been Passed Into This Function
(Doc ID 2584758.1)
Last updated on SEPTEMBER 09, 2019
Applies to:Oracle iProcurement - Version 126.96.36.199 and later
Information in this document applies to any platform.
On : 188.8.131.52 version, Requisition Creation
R12.1.3 iProc checkout Charge Account - Account generation failed due to date format
Some users getting an error on the account generation
Row 1 Charge Account - Account generation failed. Contact Purchasing Administrator if necessary. (MDIA_WF_ERR_MSG (MSG_TOKEN= Accrual: Unable to get code combination Program error: Please contact your support representative. The server PLSQL function FND_FLEX_EXT.GET_CCID() has been called incorrectly. An invalid format for validation date string has been passed into this function. Please refer to the Flexfields Server-Side Validation documentation for proper use of this function.<charge account number>))
Row 1 Charge Account - Charge account is invalid. (Program error: An error has occurred while looking up a flexfield segment combination. Please inform your support representative that: The FND_FLEX_SERVER validation function has encountered a null or negative combination ID () while trying to look up the segment values for this combination. This may indicate an invalid entry in the unique ID column of the combinations table.).
The issue is due to changing the date format under the Preferences tab.
When the date format is set to MM/dd/yyyy(08/01/2019) the following error 'An invalid format for validation date string has been passed into this function.' is observed
If the Date Format is set to dd.MMM-yyyy (01-Aug-2019) the Account Generation is successfully
Is there any way to protect this Date Format field and Number Format field from the change in the Preferences?
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