Developer Community

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issue with Applying Transformation in DataCube CPQ XML Mapping

Harshal KalaNov 4 2024

I’m encountering an issue with applying a transformation in my DataCube CPQ XML mapping file. Specifically, I want to change the value of a float attribute to NULL if it is zero. but it is not working.

<document var_name="transaction" db_name="QUOTE">
    <!-- Other attributes -->
    <attribute var_name="float_attribute" db_name="FLOAT_ATTRIBUTE" clob="false">
        <Transformation>
            <![CDATA[
                CASE 
                    WHEN FLOAT_ATTRIBUTE = 0 THEN NULL 
                    ELSE FLOAT_ATTRIBUTE 
                END
            ]]>
        </Transformation>
    </attribute>
    <!-- Other attributes -->
</document>

Added on Nov 4 2024

0 comments

93 views