This discussion is archived
2 Replies Latest reply: Nov 16, 2012 5:53 AM by v.eckardt RSS

Setup Manager - List of selection sets

889606 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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