Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

BICC: Fixed Choice list and Dynamic Choice lists data not coming in BICC exports

Submitted
41
Views
4
Comments
Chintak Dholakia
Chintak Dholakia Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Description

Hello,

Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import.

Problem: At this stage, DCL and FCL fields do not show up in BICC exports.

Fix we are looking: We want the ability to have DCL and FCL fields show up in BICC exports so that it is easier

Use Case and Business Need

Hello,

Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import.

Problem: At this stage, DCL and FCL fields do not show up in BICC exports.

Fix we are looking: We want the ability to have DCL and FCL fields show up in BICC exports so that it is easier

More details

Hello,

Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import.

Problem: At this stage, DCL and FCL fields do not show up in BICC exports.

Fix we are looking: We want the ability to have DCL and FCL fields show up in BICC exports so that it is easier

Original Idea Number: a2bea06110

1
Up
1 votes

Submitted · Last Updated

Comments

  • Adam Liu
    Adam Liu Rank 4 - Community Specialist

    We are using BICC to extract custom objects. FCL and DCL are included in our extract.

    Did you include them in your data store?

  • Chintak Dholakia
    Chintak Dholakia Rank 3 - Community Apprentice

    Hi Adam,

    Yes it works for custom object but not for standard objects like Organization / Opportunity etc. 

  • Adam Liu
    Adam Liu Rank 4 - Community Specialist

    Actually, it works for standard objects too. There is problem though - attribute name is not displayed. Instead, actual column is displayed. 

  • Chintak Dholakia
    Chintak Dholakia Rank 3 - Community Apprentice

    This helps, Adam for FCL! Thanks

    I think for DCL, we will have to create custom subject area and then setup BICC accordingly.