Deploying Shipping Descriptive Flexfield (DFF) - WSH_NEW_DELIVERIES Raises an Error: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp (Doc ID 2242864.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.1.11.1.0 to 11.13.17.09.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Aug 2017 - Checked for Relevance - Release 11 and 12 Specific***

Symptoms

An error is encountered when deploying the WSH_NEW_DELIVERIES Descriptive FLexfield (DFF).

13:02:36]
[13:02:36] Deploying usage for oracle.apps.scm.shipping.shipConfirm.deliveries.model.entity.DeliveryEO
[13:02:36] Retrieving flexfield information...
[13:02:36] Flexfield identified.
[13:02:36] Flexfield table usage identified.
[13:02:36] Flexfield entity usages loaded.
[13:02:36] Flexfield global segments loaded and processed.
[13:02:36] Flexfield context-sensitive segments loaded and processed.
[13:02:36]
[13:02:36] java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = CCL_DATE Details : TABLE_NAME :WSH_NEW_DELIVERIES ENTITY_OBJECT :oracle.apps.scm.shipping.shipConfirm.deliveries.model.entity.DeliveryEO Exception Stack :java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = CCL_DATE Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = CCL_DATE java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = CCL_DATE java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = CCL_DATE at oracle.apps.fnd.applcore.flex.runtime.util.common.Validator.getValidationRules(Validator.java:163) at oracle.apps.fnd.applcore.flex.runtime.util.common.ValidatorUtilDate.getValidationRules(ValidatorUtilDate.java:36) at oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.createSegmentValidators(FlexfieldEntityP13n.java:920) at oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.createSegmentPersonalization(FlexfieldEntityP13n.java:396) at oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.newInstance(FlexfieldEntityP13n.java:1200) at oracle.apps.fnd.applcore.flex.runtime.util.AbstractBCModeler.personalizeFlexfieldEntity(AbstractBCModeler.java:2287) at oracle.apps.fnd.applcore.flex.runtime.util.DFFBCModeler.buildInternal(DFFBCModeler.java:139) at oracle.apps.fnd.applcore.flex.runtime.util.AbstractBCModeler.build(AbstractBCModeler.java:369) at oracle.apps.fnd.applcore.flex.runtime.util.BCModeler._run(BCModeler.java:400) at oracle.apps.fnd.applcore.flex.runtime.util.BCModeler.run(BCModeler.java:311) at oracle.apps.fnd.applcore.flex.runtime.util.BCModelerTaskGroup$1.perform(BCModelerTaskGroup.java:148) at oracle.apps.fnd.applcore.flex.runtime.ModelerTaskGroup.runTasks(ModelerTaskGroup.java:778) at oracle.apps.fnd.applcore.flex.runtime.ModelerTaskGroup.perform(ModelerTaskGroup.java:609) at oracle.apps.fnd.applcore.flex.deployment.FlexfieldDeploymentController.deploy(FlexfieldDeploymentController.java:384) at oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator.deployFlex(DeploymentProgressIndicator.java:2408) at oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator.access$900(DeploymentProgressIndicator.java:126) at oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator$DeployThread.run(DeploymentProgressIndicator.java:1586) at java.lang.Thread.run(Thread.java:682)
[13:02:36] Deployment completed with errors. Elapsed time: 0 minutes 0 seconds.


This issue can be reproduce by executing the following steps:

1. Navigate to Setup and Maintenance
2. Search for and select the task - Manage Descriptive Flexfields
3. Search for Module = Ship Confirm
4. Edit WSH_NEW_DELIVERIES flex-field
5. Create new Segment of Data type = Date
6. Save and deploy flex-field
7. The error is raised

Cause

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