Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FAW: SME Warning/Error Banner Notification - There Are Errors In Your current Semantic Extensions

165
Views
3
Comments

Customer’s might see below notification banner in SME tile - this message banner is a proactive notfication to inform customers of any missing columns which are used in SME which should be reviewed and corrected. This message should not have any SME/user impact.

image.png

Please click Learn More on the Banner Message to get error details as following: this message will continue to appear untill all objects/columns/sme listed are reviewed and updated/fixed.

For example In this test instance we can see following warning/errors:

image.png

Above error/warning messages are generally to notify that there are some columns which don’t exists but are used in SME steps and should be corrected as soon as possible.

Scenario 1: These warning/errors should not cause any functional impact on the FAW application. Please go through each error message and validate the columns if they exist as shown in following validation example –

image-5aa7b74ec0fcb-83b4.png

PERSON_ID Column Missing From Augmentation DW_EB_X_RCRTMNT_EVENT_F

Next as per above error we can go and check Augmentation DW_EB_X_RCRTMNT_EVENT_F

As we can see in following this augmentation doesn’t exists and needs to be removed from "Core"."Dim - Custom_DW_EB_X_RCRTMNT_EVENT_F"

image-fc095f3b17dee-01ce.png

All Scenario 1 errors should be reviewed fixed by customers.

Scenario 2: In the following example where in support validation we found a scenario in DA where column does exists :

image-f8d9cd9024f92-995b.png

ATTRIBUTE1 Column Missing from Augmentation DW_FA_X_ZEFT

Next we go and check the augmentation for the above message.

image-cf1c42e896951-ffd7.png

We can see the above augmentation exists. To check the column, we will edit the augmentation:

image-531a24b3e0f33-e84d.png

We can see ATTRIBUTE1 Column is available in Augmentation DW_FA_X_ZEFT

If you find that the column does exists in Data Augmentation and the particular warning needs support review then please raise a support SR with all the details for valid column pasted in a word document so that support can validate and guide on next steps.

For more details please review Support KM : FAW/FDI/FDIP: DA For EPCM Connector Export Failed (Doc ID 3020158.1)

Tagged:

Comments

  • Jose Cordoba
    Jose Cordoba Rank 3 - Community Apprentice

    Thank you for all the information, I have a question how can I remove "Core"."Dim - Custom_DW_EB_X_RCRTMNT_EVENT_F"

    image-fc095f3b17dee-01ce.png

    I already remove the branch and the data augmentation with the column that is missing.

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Jose Cordoba - We would recommend starting a separate thread for the issue giving this one as reference as this is an FYI discussion post for end user's benefit. Also, newer threads get more exposure to audience of community. Kindly mention in detail what "Core"."Dim - Custom_DW_EB_X_RCRTMNT_EVENT_F" is? Is it a subject area? If yes, how was it created, through augmentation or SME etc.. Thanks.

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    @Jose Cordoba Since this augmentation doesn’t exist, it needs to be removed from "Core"."Dim - Custom_DW_EB_X_RCRTMNT_EVENT_F" SME Step.