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:

Goal

On :  12.1.3.2 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

ERROR
-----------------------
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?

Solution

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