6 Replies Latest reply: Aug 13, 2013 11:04 PM by Nagaraju Cool RSS

    How to configure domainValues file for BI apps?

    Ashish Gupta

      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

          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

            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

              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

                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

                  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

                    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