BI Publisher: Data Type Of Data Model Element Changes From Integer To String After Reopening Definition (Doc ID 2948937.1)

Last updated on MAY 19, 2023

Applies to:

Symptoms

When creating a data model with simple conditional IF query and setting the result data type to integer, the data type changes to string when reopening the definition.

Steps:

    1. Create a simple Data Set.

    2. Add Elements by Expression - Create a simple expression based on function and returning String value:

        Eg: If (COUNTRY_ID==AR,1,0);

    3. Validate Expression and Click OK, SAVE.

    4. Open it again - Data Type remains as per the initial config: String.

    5. Modify the existing expression to return an Integer value:

        Eg: if (COUNTRY_ID==AR,1,0);

    6. Validate Expression AND Click OK, SAVE.

   7. Open it again - Data Type remains as per the initial config: String and it should be Integer as per the latest config.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.