BI Cloud Connector - Missing Source data and EFFs not available in existing PVO

GopiKAutomus

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Darigold Inc.,

Description (Required):

We are currently implementing ERP, Supply Chain, OTM and WMS Cloud foot print at Darigold and building various integrations with EBS and other third party systems like MIT (Ordering portal), IBM (VAN) and other key extensions. For extracting data from SaaS, we are using BICC which is the recommended approach from Oracle but we see more gaps that is preventing us from using BICC and led to using BI PUblisher. We would like to avoid using BI Publisher for scalability and would like to be consistent with the approach for data sync.

Use Case and Business Need (Required):

Some of the key tables missing information that we are looking for are,

 

Missing Data Source for below tables :

• XXICS_CST_COST_INV_ORGS
• XXICS_CST_COST_ORGS_V (we have data model, but we don’t see column COST_ORG_CODE in BICC and hence using BI report.)
• XXICS_INV_UOM_CONVERSIONS
• EGO_ITEMS_EFF_B
• DOO_HEADERS_EFF_B
• DOO_FULFILL_LINES_EFF_B
• INV_GENERIC_DISPOSITIONS
• FND_FLEX_VALUES_VL

 

Missing EFFs with the current PVO

 

• 1.OKC_K_HEADERS_ALL_B
• 2. OKC_K_LINES_B

Enhancement Request / Service Request:

SR 3-31339697461 : Required BICC DataSource for EFF table of EGO_ITEMS_EFF_B

SR 3-31325117391 : Item EFF VO object in BICC

John Pasha Shaik

We are looking for this.Very much needed.

Shweta Bharti

We are looking for this for EFF to available as BICC PVO'S