nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

GBL_DATASOURCE_NUM_ID for EBS Instance R12.2.2

user11203834

Hi Experts,

I am configuring Bi Apps 11.1.1.10.2 with Oracle E Business Suite R12.2.2.

Can anyone tell me where i can find the GBL_DATASOURCE_NUM_ID for EBS Instance R12.2.2 in order for me to configure the Enterprise Calander in BI Apps sourced from EBS.

The Docs for 11.1.1.10.2 says only up to R12.1.3. For your quick ref:

https://docs.oracle.com/applications/biapps102/configref/GUID-7A5F4EDD-640A-4CE3-9C40-D13E7D5A08CC.htm#IT_46

Thanks for your Help!

Find more posts tagged with

Comments

user11203834

An Update:

I have also tried to see if the warehouse has the source system specific values in the table 'W_MCAL_CAL_D' as described in the doc (linked above). However i see that the table is empty.

Also for the info; I haven't done my load yet to the datawarehouse from the EBS instance. Except the domain only extract for SDE and SIL.

Charles M

Hi -

We are on 11.1.1.10.1, with an EBS source of 12.2.5 (originally, it was 12.2.3 when we installed OBIA). I didn't do the functional configuration, but we have a value of '999'.

I didn't see much on MOS for this, but I did find a link to an Oracle blog from a note: https://blogs.oracle.com/biapps/configuring-enterprise-calendar-for-oracle-bi-apps-time-dimension . Take a look at that, it tmay help explain the "999" value ...

Hoep this helps.

Charles

user11203834

Thank for your reply.

The value showing on the screen is the default value. May be in your case you are using a warehouse generated calendar as the warehouse generated enterprise calendar uses the 10000 (for 14 period Calender) and 999 as calander id.

I am trying to get the calendar from source by giving the source specific value for GBL_DATASOURCE_NUM_ID and GBL_CALENDER_ID.

Below is the extract from config doc for the quick ref.

user11203834

I got below answer for this from Oracle. I hope this will be useful for someone else. Thank you.!

You can set 340 as the value for the DATASOURCE_NUM_ID in BIACM for EBS R12.2.2 source

New Announcements

Upcoming Events

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Oracle Analytics Cloud: CEAL Guidance Office Hours - Americas and Europe
Join us this November for Oracle Analytics Cloud (OAC) Office Hours! We’ll explore recently released Data Visualisation (DV), AI features and take a closer look at the Deep Insights Agent—all in one webinar. Through demonstrations and practical examples, we’ll highlight the latest enhancements and explore how these…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: Optimizing FDI Workbook Performance & Showcase of Performance Tools. Learn best practices and optimization strategies for building performant workbooks in Oracle FDI. We’ll share practical tips and lessons learned to help report authors avoid common pitfalls and design workbooks with performance in…