You are browsing the archive for SCP.

Oracle Material Requirements Planning Tables

Oracle MRP module – List of database tables

  • MRP_AD_BOMS
  • MRP_AD_CTO_ORDER_DEMAND
  • MRP_AD_DEMAND
  • MRP_AD_DEPT_RESS
  • MRP_AD_DSCR_JOBS
  • MRP_AD_FLOW_SCHDS
  • MRP_AD_FORECAST_DATES
  • MRP_AD_FORECAST_DSGN
  • MRP_AD_INV_COMPS
  • MRP_AD_MTRX_TMP
  • MRP_AD_OH_QTYS
  • MRP_AD_OPERATION_COMPONENTS
  • MRP_AD_OPR_NETWORKS
  • MRP_AD_OPR_RESS
  • MRP_AD_OPR_RTNS
  • MRP_AD_OPR_SEQS
  • MRP_AD_ORDER_LINES_ALL
  • MRP_AD_PROCESS_EFFECTIVITY
  • MRP_AD_REPT_ITEM_DEMANDS
  • MRP_AD_REPT_ITEM_SUPPLIES
  • MRP_AD_REPT_SCHDS
  • MRP_AD_RESOURCE_REQUIREMENTS
  • MRP_AD_RES_CHNGS
  • MRP_AD_SCHD_DATES
  • MRP_AD_SI_CAPA
  • MRP_AD_SUB_OPR_RESS
  • MRP_AD_SUPPLY
  • MRP_AD_U_DEMAND
  • MRP_AD_U_SUPPLY
  • MRP_AD_WIP_COMP_DEMANDS
  • MRP_AD_WIP_COMP_SUPPLIES
  • MRP_AD_WLINES
  • MRP_AD_WOPRS
  • MRP_AD_WOPR_RESS
  • MRP_AD_WREQ_OPRS
  • MRP_AGGREGATE_RATES
  • MRP_AMONG_VALUES
  • MRP_AP_APPS_INSTANCES
  • MRP_ASSEMBLY_OPERATIONS
  • MRP_ASSIGNMENT_SETS
  • MRP_ATP_DETAILS_TEMP
  • MRP_ATP_SCHEDULE_TEMP
  • MRP_ATP_SUPPLY_DEMAND
  • MRP_AUDIT_SQL_STATEMENTS
  • MRP_AVAILABLE_TO_PROMISE
  • MRP_BIS_FORECAST_WB
  • MRP_BIS_INV_DETAIL
  • MRP_BIS_PLAN_PROFIT
  • MRP_BIS_RES_SUMMARY
  • MRP_BOM_COMPONENTS
  • MRP_CACHE_SEQ
  • MRP_COMPONENT_SUBSTITUTES
  • MRP_CRITERIA
  • MRP_DERIVED_SO_DEMANDS
  • MRP_DESIGNATORS
  • MRP_END_ASSEMBLIES
  • MRP_EXCELS
  • MRP_EXCEL_COLUMNS
  • MRP_EXCEL_COMPONENTS
  • MRP_EXCEPTION_DETAILS
  • MRP_FILES
  • MRP_FLOW_DEMANDS
  • MRP_FORECAST_DATES
  • MRP_FORECAST_DESIGNATORS
  • MRP_FORECAST_INTERFACE
  • MRP_FORECAST_ITEMS
  • MRP_FORECAST_UPDATES
  • MRP_FORM_QUERY
  • MRP_FULL_PEGGING
  • MRP_GROSS_REQUIREMENTS
  • MRP_I2_ACTIONS
  • MRP_I2_ACTION_SETS
  • MRP_I2_AGGREGATE_RESOURCE
  • MRP_I2_BC_RESULTS
  • MRP_I2_BOM
  • MRP_I2_BOM_NET
  • MRP_I2_BOM_TEMP
  • MRP_I2_DEBUG_MSG
  • MRP_I2_FORECASTS
  • MRP_I2_MFG_ORDER_OUTPUT
  • MRP_I2_ONHAND_INVENTORY
  • MRP_I2_OP_RESOURCE
  • MRP_I2_PARAMETERS
  • MRP_I2_PART_MASTER
  • MRP_I2_PART_MASTER_NET
  • MRP_I2_PART_SUPPLIER
  • MRP_I2_PENDING_BACKFLUSH
  • MRP_I2_PO_EDC
  • MRP_I2_PROCUREMENT
  • MRP_I2_PROC_BY_PART
  • MRP_I2_PROD_SCHEDULE
  • MRP_I2_RESOURCE
  • MRP_I2_RESOURCE_CALENDAR
  • MRP_I2_ROUTING
  • MRP_I2_ROUTING_NET
  • MRP_I2_SAFETY_STOCK
  • MRP_I2_SALES_ORDER
  • MRP_I2_UNAVAIL_RESOURCE
  • MRP_I2_WIP
  • MRP_I2_WORK_ORDERS
  • MRP_I2_WO_DELTAS
  • MRP_I2_WO_OP_OUTPUT
  • MRP_INVENTORY_LOTS
  • MRP_ITEM_EXCEPTIONS
  • MRP_ITEM_PURCHASE_ORDERS
  • MRP_ITEM_SOURCING
  • MRP_ITEM_SUPPLIERS
  • MRP_ITEM_WIP_ENTITIES
  • MRP_KANBAN_DEMAND
  • MRP_KANBAN_PLANS
  • MRP_LOAD_PARAMETERS
  • MRP_LOAD_SELECTIONS
  • MRP_LOW_LEVEL_CODES
  • MRP_MATERIAL_PLANS
  • MRP_MESSAGES_TMP
  • MRP_NET_RESOURCE_AVAIL
  • MRP_ONHAND_QUANTITIES
  • MRP_PARAMETERS
  • MRP_PENDING_ENG_CHANGES
  • MRP_PLANNED_RESOURCE_REQS
  • MRP_PLANNER_TASKS
  • MRP_PLANNING_EXCEPTION_SETS
  • MRP_PLANS
  • MRP_PLAN_ORGANIZATIONS
  • MRP_PLAN_SCHEDULES
  • MRP_RECOMMENDATIONS
  • MRP_RELIEF_INTERFACE
  • MRP_REPETITIVE_PERIODS
  • MRP_REPETITIVE_SCHEDULES
  • MRP_RESERVATIONS
  • MRP_RHX_USEUP_INFO
  • MRP_SAFETY_STOCK
  • MRP_SALES_ORDER_UPDATES
  • MRP_SCHEDULER_MESSAGES
  • MRP_SCHEDULE_CONSUMPTIONS
  • MRP_SCHEDULE_DATES
  • MRP_SCHEDULE_DESIGNATORS
  • MRP_SCHEDULE_INTERFACE
  • MRP_SCHEDULE_ITEMS
  • MRP_SCHEDULING_RULES
  • MRP_SELECTION_CRITERIA
  • MRP_SNAPSHOT_TASKS
  • MRP_SOURCING_HISTORY
  • MRP_SOURCING_RULES
  • MRP_SO_LINES_TEMP
  • MRP_SQLLOAD_PARAMETERS
  • MRP_SR_ASSIGNMENTS
  • MRP_SR_RECEIPT_ORG
  • MRP_SR_SOURCE_ORG
  • MRP_SUB_INVENTORIES
  • MRP_SUGG_REP_SCHEDULES
  • MRP_SUPPLIER_CAPACITIES
  • MRP_SUPPLIER_FLEX_FENCES
  • MRP_SYSTEM_ITEMS
  • MRP_WIP_COMPONENTS
  • MRP_WIP_RESOURCES
  • MRP_WORKBENCH_BUCKET_DATES
  • MRP_WORKBENCH_CRITERIA
  • MRP_WORKBENCH_DISPLAY_OPTIONS
  • MRP_WORKBENCH_QUERY

Oracle MRP Forms

Oracle Master Scheduling / MRP Forms:

FORM SHORT CODE ORACLE FORM NAME
MRPATPRS Resource Supply for ATP
MRPCHORG Change Organization – MRP
MRPFDDSR Define Sourcing Rules
MRPFDSRA Define Bills of Distribution
MRPFFCFN Define Forecast Sets
MRPFFDIF Enter Forecast Entries
MRPFFLIF Load Forecast
MRPFPCMN Define MRP Names
MRPFPDES Define Planning Exception Sets
MRPFPDKD Define Kanban Plans
MRPFPDPN Define Planner Names
MRPFPKWB Kanban Workbench
MRPFPPMR Launch Planning Process
MRPFPVPS Define Plan Parameters
MRPFSDMS Enter Master Schedule Entries
MRPFSLMS Load Master Schedule
MRPFUDAY View Work Dates
MRPFUDPP Define Planning Parameters
MRPFUSSM Start Planning Manager
MRPFVSAH View Sourcing Assignment Hiearchy
MRPFVSCB View Supply Chain Bill
MRPSCHRS Define Scheduling Rules
MRPSCPWB Supply Chain Planner Workbench
MRPSLSWB Line Scheduling Workbench
MRPSQLDR Sql*Loader Parameters

MRP Profile Options

Oracle MRP/Master Scheduling Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
MRP_SNAP_SUBSTITUTES MRP:Snapshot Substitute Parts
MRP_RHX_CHECK_PROFILE_FP MRP: RHX Check Profile
MRP_REC_ACTION_IN_PTF MRP:Recommend action within PTF
MRP_IGNORE_ALTERNATES MRP: Ignore Alternate BOM/Routing
MRP_ALTERNATE_SQL MRP: Use Alternate SQL for Daily Cleanup
MRP_CALC_SUPDT_FROM_NBDT MRP:Derive PO supply date from need by date
MRP_UPD_REQ_DATE_REL MRP: Update Requested Completion Date when Releasing Reschedules
MRP_IGNORE_ZERO_QTY_DEMANDS MRP: Ignore Zero Quantity Demands in Calculating First Bucket for Statistical Forecasting
MRP_EXPLODE_ATO MRP: Compute Standard Mandatory Components for ATO Models
MRP_ROUND_SOURCE_ENTRIES MRP: Round Source Entries
MRP_NEW_PLANNER_BACK_COMPATIBILITY MRP_NEW_PLANNER_BACK_COMPATIBILITY
MRP_EXPL_DEM_THROUGH_PHANTOM MRP: Explode Demand Through Phantom Component
MRP_ATP_PROGRESS_BAR MRP: Use Progress Bar for Backlog Workbench
MRP_PLNG_MGR_FIRST_TIME MRP: Planning Manager Run First Time
MRP_OLD_SO_CUTOFF_DAYS MRP: Old Sales Orders Cutoff Days
MRP_CUTOFF_HISTORY_DAYS MRP: Cutoff History Days
MRP_FIRM_OE_XFERRED_INTERNAL_REQ MRP: Firm Internal Req Transferred to OE
MRP_CALCULATE_PLAN_PERFORMANCE MRP: Calculate Plan Performance
MRP_SCHED_MGR_BATCH_SIZE MRP:Planning Manager Batch Size
MRP_SCHED_MGR_MAX_WORKERS MRP:Planning Manager Max Workers
MRP_SCH_RCP_USEUP MRP:Include Schd Rcpts in Use-up
MRP_SHIP_ARRIVE_FLAG MRP:Use Ship Arrived Flag
MRP_SNAPSHOT_PAUSE_FOR_LOCK MRP:Snapshot Pause for Lock (Minutes)
MRP_SNAPSHOT_WORKERS MRP:Snapshot Workers
MRP_SRA_CATEGORY_SET MRP:Sourcing Rule Category Set
MRP_TRACE MRP:Trace Mode
MRP_DMD_PRIORITY_FLEX_NUM MSC: Demand Priority Flexfield Attribute
MRP_FIRM_ORDER_TF MRP:Create Time fence
MRP_ATP_CALC_SD MRP: Calculate Supply Demand
MRP_ATP_SUB_COMP MRP:Include Substitute Components
MRP_BALWB_CATEGORY_SET MRP: Category Set for Backlog Form
MRP_BALWB_TIMEOUT MRP:Backlog Progress Timeout
MRP_ATP_ASSIGN_SET MRP:ATP Assignment Set
MRP_ATP_DATABASE_LINK MRP:ATP Database Link
MRP_BIS_AV_DISCOUNT MRP: Plan Revenue Discount Percent
MRP_BIS_PRICE_LIST MRP: Plan Revenue Price List
MRP_CALC_EXCESS_EXCEPT MRP:Calculate Excess Exceptions on Time Fence
MRP_COMPUTE_SO_CHANGES MRP:Compute Sales Order Changes
MRP_CONSUME_FC_SET_SUMMARY MRP:Consume Fcst Set Summary
MRP_CUTOFF_DATE_OFFSET MRP:Cutoff Date Offset Months
MRP_DEBUG MRP:Debug Mode
MRP_DEFAULT_ASSIGNMENT_SET MRP:Default Sourcing Assignment Set
MRP_DEFAULT_DRP_NAME MRP:Default DRP Plan Name
MRP_DEFAULT_FORECAST MRP:Default Forecast Name
MRP_DEFAULT_FORECAST_DATE MRP:Default Forecast Date
MRP_DEFAULT_PLAN MRP:Default Plan Name
MRP_DEFAULT_SCHEDULE MRP:Default Schedule Name
MRP_DEMAND_TF MRP:Demand Time Fence Days
MRP_DIRECT_LOAD MRP:Use Direct Load Option
MRP_FILES_PATH_ENV_VAR MRP:Environment variable to set path for MRP files
MRP_FIRM_PO_TF MRP:Firm Planned Order Time Fence
MRP_FIRM_REQS_WITHIN_TF MRP: Net All Purchase Orders Prior To Requisitions
MRP_FORECAST_CONSUMPTION MRP:Consume Forecast
MRP_INTERFACE_HISTORY_DAYS MRP:Interface Table History Days
MRP_LOAD_REQ_GROUP_BY MRP:Requisition Load Group Option
MRP_MDS_CONSUMPTION MRP:Consume MDS
MRP_MPS_CONSUMPTION MRP:Consume MPS
MRP_MPS_RELIEF_DIRECTION_CONTROL MRP:MPS Relief Direction
MRP_MPS_TIME_FENCE_WARNING MRP:Time Fence Warning
MRP_ORIGINAL_SCHEDULE_VERSION MRP:Maintain Original Schedule Version
MRP_PLANNING_MANAGER_IN_LOADS MRP:Perform Planning Manager Functions in Loads
MRP_PURGE_BATCH_SIZE MRP:Purge Batch Size
MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY MRP:Retain Dates Within Calendar Boundary
MRP_PURCHASING_BY_REVISION MRP:Purchasing By Revision