FA: SCM: Shipping: DFF Deployment WSH_DELIVERY_DETAILS Fails Due TO JAVA.SQL.TIMESTAMP
(Doc ID 2909420.1)
Last updated on NOVEMBER 17, 2022
Applies to:
Oracle Fusion Inventory Management Cloud Service - Version 11.13.22.10.0 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement
When attempting to Deploy Shipping Descriptive Flexfields WSH_DELIVERY_DETAILS the following error occurs.
Error
[03:12:18] Flex Deployment Started
[03:12:18] Flex deployment processing server : UIServer_1
[03:12:18]
[03:12:18] Deploying usage fororacle.apps.scm.shipping.shipConfirm.deliveries.model.entity.DeliveryLineEO
[03:12:18] Retrieving flexfield information...
[03:12:18] Flexfield identified.
[03:12:18] Flexfield table usage identified.
[03:12:18] Flexfield entity usages loaded.
[03:12:18] Flexfield global segments loaded and processed.
[03:12:18] Flexfield context-sensitive segments loaded and processed.
[03:12:20]
[03:12:20] java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE Details : TABLE_NAME :WSH_DELIVERY_DETAILS ENTITY_OBJECT :oracle.apps.scm.shipping.shipConfirm.deliveries.model.entity.DeliveryLineEO Exception Stack :java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE oracle.apps.fnd.applcore.flex.runtime.util.common.Validator.getValidationRules(Validator.java:180) oracle.apps.fnd.applcore.flex.runtime.util.common.ValidatorUtilDate.getValidationRules(ValidatorUtilDate.java:36) oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.createSegmentValidators(FlexfieldEntityP13n.java:997) oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.createSegmentPersonalization(FlexfieldEntityP13n.java:404) oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.newInstance(FlexfieldEntityP13n.java:1304) oracle.apps.fnd.applcore.flex.runtime.util.AbstractBCModeler.personalizeFlexfieldEntity(AbstractBCModeler.java:2573) oracle.apps.fnd.applcore.flex.runtime.util.DFFBCModeler.buildInternal(DFFBCModeler.java:121) oracle.apps.fnd.applcore.flex.runtime.util.AbstractBCModeler.build(AbstractBCModeler.java:402) oracle.apps.fnd.applcore.flex.runtime.util.BCModeler._run(BCModeler.java:399) oracle.apps.fnd.applcore.flex.runtime.util.BCModeler.run(BCModeler.java:310) oracle.apps.fnd.applcore.flex.runtime.util.BCModelerTaskGroup$1.perform(BCModelerTaskGroup.java:189) oracle.apps.fnd.applcore.flex.runtime.ModelerTaskGroup.runTasks(ModelerTaskGroup.java:792) oracle.apps.fnd.applcore.flex.runtime.ModelerTaskGroup.perform(ModelerTaskGroup.java:625) oracle.apps.fnd.applcore.flex.deployment.FlexfieldDeploymentController.deploy(FlexfieldDeploymentController.java:402) oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator.deployFlex(DeploymentProgressIndicator.java:2744) oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator.access$800(DeploymentProgressIndicator.java:141) oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator$DeployThread.run(DeploymentProgressIndicator.java:1902) java.lang.Thread.run(Thread.java:750)
[03:12:18] Flex deployment processing server : UIServer_1
[03:12:18]
[03:12:18] Deploying usage fororacle.apps.scm.shipping.shipConfirm.deliveries.model.entity.DeliveryLineEO
[03:12:18] Retrieving flexfield information...
[03:12:18] Flexfield identified.
[03:12:18] Flexfield table usage identified.
[03:12:18] Flexfield entity usages loaded.
[03:12:18] Flexfield global segments loaded and processed.
[03:12:18] Flexfield context-sensitive segments loaded and processed.
[03:12:20]
[03:12:20] java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE Details : TABLE_NAME :WSH_DELIVERY_DETAILS ENTITY_OBJECT :oracle.apps.scm.shipping.shipConfirm.deliveries.model.entity.DeliveryLineEO Exception Stack :java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE java.lang.IllegalArgumentException: Values of data type DATE cannot be assigned to an attribute of java.sql.Timestamp: Value-Set Code = HRC_STANDARD_DATE oracle.apps.fnd.applcore.flex.runtime.util.common.Validator.getValidationRules(Validator.java:180) oracle.apps.fnd.applcore.flex.runtime.util.common.ValidatorUtilDate.getValidationRules(ValidatorUtilDate.java:36) oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.createSegmentValidators(FlexfieldEntityP13n.java:997) oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.createSegmentPersonalization(FlexfieldEntityP13n.java:404) oracle.apps.fnd.applcore.flex.runtime.util.FlexfieldEntityP13n.newInstance(FlexfieldEntityP13n.java:1304) oracle.apps.fnd.applcore.flex.runtime.util.AbstractBCModeler.personalizeFlexfieldEntity(AbstractBCModeler.java:2573) oracle.apps.fnd.applcore.flex.runtime.util.DFFBCModeler.buildInternal(DFFBCModeler.java:121) oracle.apps.fnd.applcore.flex.runtime.util.AbstractBCModeler.build(AbstractBCModeler.java:402) oracle.apps.fnd.applcore.flex.runtime.util.BCModeler._run(BCModeler.java:399) oracle.apps.fnd.applcore.flex.runtime.util.BCModeler.run(BCModeler.java:310) oracle.apps.fnd.applcore.flex.runtime.util.BCModelerTaskGroup$1.perform(BCModelerTaskGroup.java:189) oracle.apps.fnd.applcore.flex.runtime.ModelerTaskGroup.runTasks(ModelerTaskGroup.java:792) oracle.apps.fnd.applcore.flex.runtime.ModelerTaskGroup.perform(ModelerTaskGroup.java:625) oracle.apps.fnd.applcore.flex.deployment.FlexfieldDeploymentController.deploy(FlexfieldDeploymentController.java:402) oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator.deployFlex(DeploymentProgressIndicator.java:2744) oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator.access$800(DeploymentProgressIndicator.java:141) oracle.apps.fnd.applcore.flex.ui.bean.DeploymentProgressIndicator$DeployThread.run(DeploymentProgressIndicator.java:1902) java.lang.Thread.run(Thread.java:750)
Steps to Reproduce
- Manage Shipping Descriptive Flexfields > Flexfield Code: WSH_DELIVERY_DETAILS
- Assign Value Set: HRC_STANDARD_DATE to WSH_DELIVERY_DETAILS.ATTRIBUTE_DATE1 Column
- Deploy Flexfield error happens as follows.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |