Search Results role2_id




Overview
Explore in AI Chat

Overview

APPS.BIS_MRPGMALL_V is a reportable database view owned by the APPS schema in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It belongs to the BIS (Business Intelligence System / Enterprise Performance Management) product family and is registered in FND Design Data under the internal name BIS.BIS_MRPGMALL_V. The view exposes consolidated business plan and target-level configuration data, presenting, for each plan version, the associated workflow process, timing attributes, three defined performance ranges, and the roles assigned to each range. It is the data foundation used by standard Oracle business-planning reports, particularly those that display target thresholds alongside the role owners responsible for a given range.

Underlying Base Objects

The view is defined over four documented base objects:

No other database object references BIS_MRPGMALL_V; it is a terminal, query-only view rather than a dependency for further database structures. Because no APPS public synonym or direct supported interface exists, the view is intended for consumption by Oracle Applications programs only.

Key Columns

  • WF_PROCESS (VARCHAR2 30) — identifies the workflow process associated with the plan.
  • PLAN_ID / PLAN_SHORT_NAME — the plan identifier and short name; VERSION_NO and CURRENT_PLAN_FLAG distinguish plan versions and the active one.
  • TOTAL_TIME (VARCHAR2 80) — formatted presentation of the plan's time horizon.
  • TARGET (NUMBER) — the target value against which ranges are evaluated.
  • RANGE1_LOW / RANGE1_HIGH, RANGE2_LOW / RANGE2_HIGH, RANGE3_LOW / RANGE3_HIGH — numeric boundaries defining three performance bands around the target.
  • ROLE1_ID, ROLE2_ID, ROLE3_ID — numeric role identifiers for the role assigned to each range. This is the column surfaced by the "role2_id" search term. These IDs correspond to roles defined in Oracle Workflow / role-based access structures.
  • ROLE1, ROLE2, ROLE3 (VARCHAR2 100) — the display names of the corresponding roles for each range.

Common Use Cases and Queries

Typical usage involves retrieving the current plan version along with its range thresholds and role ownership, for example to determine which role owns Range 2 in the active plan:

  • Reporting the three ranges and their associated ROLE_ID/ROLE values for a specific interval.
  • Listing all plans by WF_PROCESS to understand workflow-driven planning assignments.
  • Joining ROLE_ID values to workflow role tables to resolve additional role attributes.

A representative query filtering on the searched column is:

  • SELECT PLAN_SHORT_NAME, VERSION_NO, TARGET, RANGE2_LOW, RANGE2_HIGH, ROLE2_ID, ROLE2 FROM APPS.BIS_MRPGMALL_V WHERE CURRENT_PLAN_FLAG = 'Y' ORDER BY PLAN_SHORT_NAME;

Because Oracle marks this object as internal use only, the supported approach is to access it exclusively from standard Oracle Applications programs rather than from custom code.

  • VIEW: APPS.BIS_MRPGMALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPGMALL_V,  object_name:BIS_MRPGMALL_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPDCDET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPDCDET_V,  object_name:BIS_MRPDCDET_V,  status:VALID, 

  • VIEW: APPS.BIS_INVTURN_ALL_MON_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_INVTURN_ALL_MON_V,  object_name:BIS_INVTURN_ALL_MON_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPOTDET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPOTDET_V,  object_name:BIS_MRPOTDET_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPFEORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPFEORG_V,  object_name:BIS_MRPFEORG_V,  status:VALID, 

  • VIEW: APPS.BIS_FILL_PER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_FILL_PER_V,  object_name:BIS_FILL_PER_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPDCALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPDCALL_V,  object_name:BIS_MRPDCALL_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPDCORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPDCORG_V,  object_name:BIS_MRPDCORG_V,  status:VALID, 

  • VIEW: APPS.BIS_BACKLINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_BACKLINES_V,  object_name:BIS_BACKLINES_V,  status:VALID, 

  • VIEW: APPS.BIS_INVACC_ORG_ALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_INVACC_ORG_ALL_V,  object_name:BIS_INVACC_ORG_ALL_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPOTORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPOTORG_V,  object_name:BIS_MRPOTORG_V,  status:VALID, 

  • VIEW: APPS.BIS_HRMSPOYFTE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_HRMSPOYFTE_V,  object_name:BIS_HRMSPOYFTE_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPITORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPITORG_V,  object_name:BIS_MRPITORG_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPDCPER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPDCPER_V,  object_name:BIS_MRPDCPER_V,  status:VALID, 

  • VIEW: APPS.BIS_CSTMRGLEQTR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_CSTMRGLEQTR_V,  object_name:BIS_CSTMRGLEQTR_V,  status:VALID, 

  • VIEW: APPS.BIS_SHIP_PER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_SHIP_PER_V,  object_name:BIS_SHIP_PER_V,  status:VALID, 

  • VIEW: APPS.BIS_HRMSPOCHEAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_HRMSPOCHEAD_V,  object_name:BIS_HRMSPOCHEAD_V,  status:VALID, 

  • VIEW: APPS.BIS_WIPBIITORGPRD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_WIPBIITORGPRD_V,  object_name:BIS_WIPBIITORGPRD_V,  status:VALID, 

  • VIEW: APPS.BIS_HRMSPOYHEAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_HRMSPOYHEAD_V,  object_name:BIS_HRMSPOYHEAD_V,  status:VALID, 

  • VIEW: APPS.BIS_CSTMRGSCTT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_CSTMRGSCTT_V,  object_name:BIS_CSTMRGSCTT_V,  status:VALID, 

  • VIEW: APPS.BIS_CSTMRGPGTT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_CSTMRGPGTT_V,  object_name:BIS_CSTMRGPGTT_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPPUPER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPPUPER_V,  object_name:BIS_MRPPUPER_V,  status:VALID, 

  • VIEW: APPS.BIS_POACTLKG_ORG_M_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_POACTLKG_ORG_M_V,  object_name:BIS_POACTLKG_ORG_M_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPITPER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPITPER_V,  object_name:BIS_MRPITPER_V,  status:VALID, 

  • VIEW: APPS.BIS_POACTLKG_OU_M_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_POACTLKG_OU_M_V,  object_name:BIS_POACTLKG_OU_M_V,  status:VALID, 

  • VIEW: APPS.BIS_INVTURN_MON_ALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_INVTURN_MON_ALL_V,  object_name:BIS_INVTURN_MON_ALL_V,  status:VALID, 

  • VIEW: APPS.BIS_POASPSAL_ALL_M_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_POASPSAL_ALL_M_V,  object_name:BIS_POASPSAL_ALL_M_V,  status:VALID, 

  • VIEW: APPS.BIS_HRMSPOQFTE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_HRMSPOQFTE_V,  object_name:BIS_HRMSPOQFTE_V,  status:VALID, 

  • VIEW: APPS.BIS_HRMSPOQHEAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_HRMSPOQHEAD_V,  object_name:BIS_HRMSPOQHEAD_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPOTPER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPOTPER_V,  object_name:BIS_MRPOTPER_V,  status:VALID, 

  • VIEW: APPS.BIS_TARGETS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_TARGETS_V,  object_name:BIS_TARGETS_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPFEALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPFEALL_V,  object_name:BIS_MRPFEALL_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPITALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPITALL_V,  object_name:BIS_MRPITALL_V,  status:VALID, 

  • VIEW: APPS.BIS_WIPBIUZORGPRD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_WIPBIUZORGPRD_V,  object_name:BIS_WIPBIUZORGPRD_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPPUDET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPPUDET_V,  object_name:BIS_MRPPUDET_V,  status:VALID, 

  • VIEW: APPS.BIS_INVACC_ORG_MON_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_INVACC_ORG_MON_V,  object_name:BIS_INVACC_ORG_MON_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPFEDET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPFEDET_V,  object_name:BIS_MRPFEDET_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPPUORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPPUORG_V,  object_name:BIS_MRPPUORG_V,  status:VALID, 

  • VIEW: APPS.BIS_HRMSPOCFTE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_HRMSPOCFTE_V,  object_name:BIS_HRMSPOCFTE_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPGMORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPGMORG_V,  object_name:BIS_MRPGMORG_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPPUALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPPUALL_V,  object_name:BIS_MRPPUALL_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPOTALL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPOTALL_V,  object_name:BIS_MRPOTALL_V,  status:VALID, 

  • VIEW: APPS.BIS_DELIVERY_PER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_DELIVERY_PER_V,  object_name:BIS_DELIVERY_PER_V,  status:VALID, 

  • VIEW: APPS.BIS_RETURN_PER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_RETURN_PER_V,  object_name:BIS_RETURN_PER_V,  status:VALID, 

  • VIEW: APPS.BIS_CSTMRGLEYER_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_CSTMRGLEYER_V,  object_name:BIS_CSTMRGLEYER_V,  status:VALID, 

  • VIEW: APPS.BIS_INVACC_ALL_MON_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_INVACC_ALL_MON_V,  object_name:BIS_INVACC_ALL_MON_V,  status:VALID, 

  • VIEW: APPS.BIS_MRPITDET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_MRPITDET_V,  object_name:BIS_MRPITDET_V,  status:VALID, 

  • VIEW: APPS.BIS_CSTMRGLEPRD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_CSTMRGLEPRD_V,  object_name:BIS_CSTMRGLEPRD_V,  status:VALID, 

  • VIEW: APPS.BIS_WIPBIEFORGPRD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_WIPBIEFORGPRD_V,  object_name:BIS_WIPBIEFORGPRD_V,  status:VALID, 

  • VIEW: APPS.BIS_POASPSAL_OU_M_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:BIS.BIS_POASPSAL_OU_M_V,  object_name:BIS_POASPSAL_OU_M_V,  status:VALID,