This discussion is archived
6 Replies Latest reply: Aug 13, 2013 9:04 PM by Nagaraju Cool RSS

How to configure domainValues file for BI apps?

Ashish Gupta Journeyer
Currently Being Moderated

Hi Experts,

 

I am configuring EAM analytics 7.9.6.4 with EBS R12.

I am following http://docs.oracle.com/cd/E35287_01/bia.7964/e35272.pdf


In Section 16.2.2 Domain Values and CSV Worksheet Files for Oracle Enterprise Asset

Management Analytics with Oracle EBS

 

 

It says...

If you have modified or extended a seeded list of values, you must configure the CSV

files for Oracle Enterprise Asset Management Analytics by mapping values from your

source systems to the domain values.

 

Now in one of the files (domainValues_Status_EAMAsset_ora11i) the seeded values are...

 

W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

EAM_ASSET_STATUS,1,ACTIVE,Active,Active,Item is Active

EAM_ASSET_STATUS,510,HOLD,Hold,Hold,Item is on Hold

 

and when i check in my EBS, the values are ..

 

EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

 

 

My Question is should i just add these  new two lines  below the seeded values like this...

 

W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

EAM_ASSET_STATUS,1,ACTIVE,Active,Active,Item is Active

EAM_ASSET_STATUS,510,HOLD,Hold,Hold,Item is on Hold

EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

 

OR Should i modify the existing seeded values like below?

 

W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

 

 

Thanks

Ashish

  • 1. Re: How to configure domainValues file for BI apps?
    Nagaraju Cool Explorer
    Currently Being Moderated

    Hi Ashish,

     

    Fill CSV worksheet with your EBS values only....

     

    W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

    EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

    EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

     

     

    Regards,

    Naga

  • 2. Re: How to configure domainValues file for BI apps?
    Ashish Gupta Journeyer
    Currently Being Moderated

    In the Doc for section 16.2.2.7 How to configure domainValues_Status_EAMAsset_ora11i.csv

    its written..

     

    1. Identify the Enterprise Asset Management Asset Status in your EBS source system

    by using the following SQL:

    SELECT CSI_INSTANCE_STATUSES.INSTANCE_STATUS_ID

    FROM CSI_INSTANCE_STATUSES

    WHERE CSI_INSTANCE_STATUSES.INSTANCE_STATUS_ID IN(1,510)

     

    2. From the $PMServer\LkpFiles directory (for example, INFA_HOME\server\infa_

    shared\LkpFiles), open domainValues_Status_EAMAsset_ora11i.csv file in a text

    editor.

     

    3. Copy the INSTANCE_STATUS_ID to the STATUS_CODE column in the file. The

    data must be copied starting from the 4th line.

     

    4. Map each Status code to one Asset Status (EAM_ASSET_STATUS) domain value.

    Use commas to separate the entries.

    5. Save and close the file.

     

    I was wondering why Oracle has recommended that Data must be copied from 4th line... and which is the correct method...to add from 4th line onwards

    or  to remove all the data and then add values from the 2nd line.

     

    Thanks

  • 3. Re: How to configure domainValues file for BI apps?
    Nagaraju Cool Explorer
    Currently Being Moderated

    Hi Ashish,

     

         I configured HR an Finance,for these both modules i configured only with EBS values.....

    Anyway take a backup of that CSV file and do.

    All the best.....

     

     

    Regards,

    Naga

  • 4. Re: How to configure domainValues file for BI apps?
    AlejandroRosales Newbie
    Currently Being Moderated

    Hi Ashish,

     

    First of all, it is important to understand what you are doing here:

     

    You are mapping a source-specific value (STATUS_CODE / STATUS_NAME) to an Oracle Business Analytics Warehouse domain value (W_STATUS_CODE / W_STATUS_NAME)

     

    This gives the users the ability to report on a source-agnostic value ('Active', 'Expired') rather than the source-specific one.

     

    In your particular scenario, you'll create a problem if you append at the end, because STATUS_CODE = 1 will be mapped to both W_STATUS_CODE 'Active' and 'Expired'

     

    Hence, you'll be better off if you just keep your EBS values. It might be worthwhile double checking this (i.e. that in EBS '1' actually means 'Expired') with one of your subject matter experts from the Assets area.

     

    Regards,

    Alex.-

  • 5. Re: How to configure domainValues file for BI apps?
    Ashish Gupta Journeyer
    Currently Being Moderated

    I am going ahead with EBS values only now..

     

    W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

    EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

    EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

     

    Now what is this column W_STATUS_CLASS? Do we have to punch in its values as EXPIRED OR CREATED  

    ie

    W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

    EXPIRED,1,EXPIRED,Expired,Expired,Item is Expired

    CREATED,510,CREATED,Created,Created,Item is Created


    or just keep it EAM_ASSET_STATUS only? ie

     

    W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

    EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

    EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

     

    Thanks for helping me..

  • 6. Re: How to configure domainValues file for BI apps?
    Nagaraju Cool Explorer
    Currently Being Moderated

    Hi Ashish,

     

         Go with....

    W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,W_STATUS_CODE,W_STATUS_DESC,STATUS_DESC

    EAM_ASSET_STATUS,1,EXPIRED,Expired,Expired,Item is Expired

    EAM_ASSET_STATUS,510,CREATED,Created,Created,Item is Created

     

     

    Regards,

    Naga

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points