SQL & PL/SQL

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.

Help with Correcting the Query

795014Sep 23 2011 — edited Sep 23 2011

Hi Gurus,
Could someone let me know if this query is right? When i am building a report i am getting an error that

Incorrectly defined logical table source (for fact table MTL_DESCR_ELEMENT_VALUES) does not contain mapping for [IBE_MSITES_B.ATTRIBUTE10]. (HY000)

Incorrectly defined logical table source (for fact table MTL_SYSTEM_ITEMS_FVL) does not contain mapping for [MTL_DESCR_ELEMENT_VALUES.ELEMENT_VALUE].

from inv.mtl_system_items_b mtlb,
inv.mtl_descr_element_values mtld,
apps.mtl_item_Caterogies_v cat,
apps.mtl_system_items_fvl fvl,
ibe.ibe_msites_b imb,
ibe.ibe_dsp_section_items idsi,
ibe.ibe_dsp_msite_sct_items idmsi
where mtlb.inventory_item_id = mtld.inventory_item_id
AND cat.inventory_item_id = mtlb.inventory_item_id
AND mtlb.inventory_item_id = fvl.inventory_item_id
AND mtlb.inventory_item_id = idsi.inventory_item_id
AND idsi.section_item_id = idmsi.section_item_id
AND imb.msite_id = idmsi.mini_site_id

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2011

Added on Sep 23 2011

2 comments

402 views