In OA, if you must specify a date in a concurrent program and its value is either set to SYSDATE or not specified, the agent plug-in sets the SYSDATE to the corresponding date format.
OA uses flex value sets, such as FND_STANDARD_DATE, to validate the date format. By default, the flex value set has a date format. For example, FND_STANDARD_DATE has the format YYYY/MM/DD. The flex value set named Date has a character format, but the agent plug-in recognizes this flex value set as a date. However, there can be other flex value sets that the agent plug-in does not recognize as a date. Therefore, you can configure the agent plug-in to specify a date format for a given flex value set.
To specify a date format for a given flex value set
oa.flexValueSet.dateFormat.value_set_name=date_format
Specifies the flex value set in OA.
Examples: Date, FND_STANDARD_DATE, FND_STANDARD_DATE_REQUIRED, CST_SRS_TO_DATE_STANDARD, FND_STANDARD_DATETIME and so on.
Sets the date format to use for a flex value set.
Examples: YYYY/MM/DD, YYYY/MM/DD HH24:MI:SS, DD-MON-RR, DD-MON-YYYY, DD-MON-YYYY HH24:MI:SS, DD-MON-RR HH24:MI:SS, DD-MON-YYYY HH24:MI, DD-MON-RR HH24:MI, HH24:MI:SS, HH24:MI, and so on.
The date format for a given flex value set is configured.
Note: You can also use the oa.flexValueSet.dateFormat.value_set_name parameter to specify date formats for multiple flex value sets at one time.
Example: Set the Date Format for Multiple Flex Value Sets
This example sets the date format for the FND_STANDARD_DATE and FND_STANDARD_DATETIME flex value sets.
oa.flexValueSet.dateFormat.FND_STANDARD_DATE=DD-MON-YY oa.flexValueSet.dateFormat.FND_STANDARD_DATETIME=DD-MON-YYYY HH24:MI:SS
|
Copyright © 2011 CA.
All rights reserved.
|
|