2 Replies Latest reply: Nov 16, 2012 7:53 AM by v.eckardt RSS

    Setup Manager - List of selection sets

    889606
      Hi All,

      Can some one help me in finding the list of selection sets (Configuable items) available in Setup Manager. Request you to provide a link or provide me a document which consists of list of Selection sets.
        • 1. Re: Setup Manager - List of selection sets
          Hussein Sawwan-Oracle
          886603 wrote:
          Hi All,

          Can some one help me in finding the list of selection sets (Configuable items) available in Setup Manager. Request you to provide a link or provide me a document which consists of list of Selection sets.
          Please see these docs/links.

          Understanding Oracle iSetup Dependencies for General Foundation, Product Foundation, and Organization Structure Selection Sets [ID 814338.1]
          How to Use iSetup to Load Purchasing Information From One Instance To Another Instance [ID 1096887.1]

          R12 iSetup
          http://docs.oracle.com/cd/B53825_08/current/html/docset.html

          11i iSetup
          http://download.oracle.com/docs/cd/B25516_18/current/html/docset.html

          Thanks,
          Hussein
          • 2. Re: Setup Manager - List of selection sets
            v.eckardt
            This shall do, run it as sysman against your EM DB.

            select
            EBS_AZ_SELECTION_SETS.RELEASE,
            EBS_AZ_SELECTION_SETS.SELECTION_SET_CODE,
            -- EBS_AZ_SELECTION_SETS.STRUCTURE_CODE,
            -- EBS_AZ_SELECTION_SETS.REF_SELECTION_SET_CODE,
            -- EBS_AZ_SELECTION_SETS.ACTIVE,
            -- EBS_AZ_SELECTION_SETS.HIERARCHICAL_FLAG,
            -- EBS_AZ_SELECTION_SETS.PARTIAL_SELECTION,
            EBS_AZ_SELECTION_SETS.SELECTION_SET_NAME,
            EBS_AZ_SELECTION_SETS.SELECTION_SET_DESC,
            EBS_AZ_SELECTION_SETS.SEQ_NUM,
            -- ebs_az_selection_sets.seeded,
            -- EBS_AZ_SELECTION_SET_ENTITIES.SELECTION_SET_CODE,
            ebs_az_selection_set_entities.entity_occurance_name,
            -- EBS_AZ_SELECTION_SET_ENTITIES.ENTITY_OCCURANCE_CODE,
            -- EBS_AZ_SELECTION_SET_ENTITIES.ENTITY_CODE,
            -- EBS_AZ_SELECTION_SET_ENTITIES.FILTERING_PARAMETERS,
            -- EBS_AZ_SELECTION_SET_ENTITIES.SELECTION_FLAG,
            EBS_AZ_SELECTION_SET_ENTITIES.ALLOW_FILTER_FLAG
            -- EBS_AZ_SELECTION_SET_ENTITIES.FILTER_SET_FLAG,
            -- EBS_AZ_SELECTION_SET_ENTITIES.ALLOW_SET_TARGETVAL_FLAG,
            -- EBS_AZ_SELECTION_SET_ENTITIES.UPDATABLE_FLAG,
            -- EBS_AZ_SELECTION_SET_ENTITIES.CHANGE_UPDATABLE_FLAG,
            -- ebs_az_selection_set_entities.seq_num
            -- EBS_AZ_SELECTION_SET_ENTITIES.REF_ENTITY_OCCURANCE_CODE,
            -- ebs_az_selection_set_entities.seeded
            from ebs_az_selection_set_entities,
            ebs_az_selection_sets
            where ebs_az_selection_set_entities.selection_set_code=ebs_az_selection_sets.selection_set_code
            and ebs_az_selection_sets.release='R12'
            and nvl(ebs_az_selection_sets.active,'Y')='Y'
            order by EBS_AZ_SELECTION_SETS.SELECTION_SET_CODE, ebs_az_selection_set_entities.seq_num