insert date value using form personalization in Descriptive flexfield has value set(FND_STNDRD_DATE)
We are using Oracle Applications : 12.2.7
Purchasing module
Requirements are :
1- create flexfield in approved list supplier the type of it to be Standard date
2- insert default value when create record in the form in this flexfield to be sysdate+30 days
Steps Done :
1- I created new flexfield in approved list supplier and added value set (FND_STANDARD_DATE)
2- Create personalization in approved list supplier to default value of this flexfield to be sysdate+30
Behavior :
The value defaulted in flexfield will be in wrong format
So How can we set the value in flexfield So that it will be stored correctly based on FND_STANDARD_DATE