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!

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