You are browsing the archive for Setups.

Inventory Module Setups

List of Inventory Module Setups

  • Transactions
    • Source Types
    • Types
    • Reasons
    • Item Transaction Defaults
    • Movement Statistics
      • Economic Zones
      • Parameters
      • Validation Rules
    • Interface Managers
    • Consigned/VMI Consumption
    • Material Status
  • Items
    • Templates
    • Attribute Controls
    • Catalog Groups
    • Categories
      • Category Sets
      • Category Codes
      • Default Category Sets
      • Category Accounts
    • Customer Item Commodity Codes
    • Item Types
    • Status Codes
    • Container Types
    • Delete Constraints
    • Commodities
    • Delete Statements
  • Costs
    • Sub-elements
      • Material
      • Overheads
      • Defaults
    • Activities
    • Cost Types
    • Cost Groups
  • Units of Measure
    • Units of Measure
    • Classes
    • Conversions
    • Lot Specific Conversions
  • Rules
    • Available to Promise
    • Forecast
    • Picking
    • Pick Slip Grouping
  • Organizations
    • Organizations
    • Parameters
    • Locations
    • Employees
    • Calendars
    • Calendar Exception Templates
    • Subinventories
    • Stock Locators
    • Shipping Networks
    • Inter-Location Transit Times
    • Shipping Methods
    • Shortage Parameters
    • Intercompany Transaction Flows
    • Organization Access
    • Purchasing Parameters
    • Receiving Parameters
    • Shipping Parameters
    • Hierarchy
    • Organization Copy
  • Receiving
    • Purchasing
    • Receiving
  • Planners
  • Account Aliases
  • Profiles
  • Flexfields
  • Financials
    • Accounting Calendar
    • Accounting Setup Manager
    • Currencies
      • Daily Rates
      • Period Rates
      • Currency Codes
  • Accounts
  • Lookups
  • Descriptive Flexfield Register
  • Label Printing
  • Freight Carriers
  • BOM Lookups
  • Alpha Lookups
  • Grades
  • Action Codes

Inventory Profile Options

Oracle Inventory Module Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
ONLINE_PROCESSING TP:Server Side Online Processing
BOM_OR_ENG Bom or Engineering
CURRENCY_CONVERSION_TYPE INV: Inter-Organization Currency Conversion
CYCLE_COUNT_APPROVALS_TXN TP:INV Cycle Count Approvals form
CYCLE_COUNT_ENTRIES_TXN TP:INV Cycle Count Entries form
IC_CURRENCY_CONVERSION_TYPE INV: Intercompany Currency Conversion
INTER_ORG_SHIP_TXN TP:INV Inter-organization Transfer form
INV:ENTER_REPLENISH_COUNT TP:INV Enter Replenishment Count form
INV:EXPENSE_TO_ASSET_TRANSFER INV: Allow Expense to Asset Transfer
INV_CCEOI_COMMIT_POINT INV:CCEOI Commit point
INV_CCEOI_WORKERS INV:CCEOI Workers
INV_CTP INV:Capable to Promise
INV_DEBUG_FILE INV: Debug file (Including the complete path)
INV_DEBUG_LEVEL INV:Debug Level
INV_DEBUG_TRACE INV: Debug Trace
INV_DETECT_TRUNCATION INV: Detect truncation on uom conversion
INV_EXT_ATP INV: External ATP
INV_FIFO_ORIG_REC_DATE INV: FIFO for Original Receipt Date
INV_ITEMS_PRODUCT_FAMILY_TEMPLATE INV: Product Family Item Template Name
INV_ITEM_MASTER_FLEX_CODE INV: Item Master Flexfield
INV_MAXIMUM_NUM_TREES INV: Maximum Number of Quantity Trees
INV_MINMAX_REORDER_APPROVED INV: Minmax Reorder Approval
INV_OVERRIDE_NEG_FOR_BACKFLUSH INV:Override Neg for Backflush
INV_PROJ_MISC_TXN_EXP_TYPE INV: Project Miscellaneous Transaction Expenditure Type
INV_PURCHASING_BY_REVISION INV:Purchasing By Revision
INV_STATUS_DEFAULT INV: Default Item Status
INV_UOM_DEFAULT INV: Default Primary Unit of Measure
INV_UPDATEABLE_CITEM INV: Updateable Customer Item
INV_UPDATEABLE_ITEM INV: Updateable item name
ACCOUNT_ISSUE_TXN TP:INV Miscellaneous Issue and Receipt form
RC_LINE_FAILURE INV: Replenishment Count Line Failure
RC_REQUISITION_APPROVAL INV: Replenishment Count Requisition Approval
REPORT_QUANTITY_PRECISION INV: Dynamic Precision Option for Quantity on Reports
SAVE_SEARCH_ITEMS INV: Save Search Items
SUBINV_TRANS_TXN TP:INV Transfer between subinventories form
TRANSACTION_DATE INV: Transaction Date Validation
TRANSACTION_PROCESS_MODE TP:INV Transaction processing mode
TRANSFER_ORDER_TXN TP:INV Move Order Transact Form
UPDATE_AVG_TXN TP:INV Update Average Cost form
USE_NAME_ICG_DESC INV: Use catalog name in the item description
INV_ROUND_REORDER_QTY INV: Round Reorder Qty
INV_EBI_PIM_SPOKE_SOURCE_SYSTEM EBS Integration: PIM Spoke Source System Name
INV_INTERCOMPANY_TRANSFER_PRICE_DATE INV: Intercompany Transfer Price Date
INV_SERIAL_RANGE_VAL INV: Enable Bulk Serial Validation
INV_EBI_DEBUG EBS Integration: Debug Option
INV_EBI_DEBUG_DIRECTORY EBS Integration: Debug Directory
INV_EBI_LANGUAGE_CODES EBS Integration: Language Codes
INV_EBI_PROXY_SERVER_HOST EBS Integration: Proxy Server Host
INV_EBI_BATCH_COUNT EBS Integration: Batch Count
INV_EBI_PROXY_SERVER_PORT EBS Integration: Proxy Server Port
INV_EBI_SERVER_DOMAIN EBS Integration: Server Domain
INV_EBI_SERVER_HOST_PORT EBS Integration Server Host:Port
ENABLE_LEGAL_ENTITY_TIMEZONE Enable Legal Entity Timezone
INV_ALLOW_NON-REPLENISHABLE_KANBAN_CARD_STATUS_CHANGE INV: Allow Non-Replenishable Kanban Card Status Change
AUTO_PICK_CONFIRM_TXN TP:INV Auto Pick Confirm
INV_VALIDATE_RETURNED_SERIAL INV:Validate Returned Serial
INV_TRANS_REASON_SECURITY INV: Transaction Reasons Security
INV_CREATE_LOC_AT INV:Create Locators in Autonomous Mode
INV_USE_QP_FOR_INTERORG INV: Advanced Pricing for Inter-Org Transfers
INV_OVERRIDE_RSV_FOR_BACKFLUSH INV:Override Reservation for Transactions
INV_SUPPLIER_CONSIGNED_GROUPING INV: Summarize consumption releases by Need By Date
INV_RESTRICT_RCPT_LOT INV: Recieve shipped Lot quantity
INV_ALLOW_CC_TXNS_ONHAND_NEG INV: Allow Count Adjustments to Drive Onhand Negative
INV_USE_MODEL_PRICING INV: Use Model & Options for Configuration Pricing
INV_TARGET_PREFERRED_GRADE INV: Target Preferred Grade
INV_BACKORDER_CACHE INV: Use Backorder Caching
ALWAYS_SUFFIX_AP_INVOICE INV: Always suffix inter-Company AP Invoice number
INV_MATERIAL_STATUS INV: Material Status Support
INV_VALIDATE_RETURNED_LOT INV:Validate Returned Lot
INV_FILL_PARTIAL_MOVE_KANBAN INV: Fill Kanban on Partial Move Order Receipt
INV_MAX_TXN_PG_PROCESSES INV: Max # of txn purge processes
INV_BATCH_SIZE INV: Batch Size
INV_CONSIGN_INVENTORY_AGING_ENABLED INV: Consigned Inventory Aging Enabled
INV_VIEW_CATEGORY_PEOPLE_PROFILE INV: View Item Category People
INV_OMFPC2_INSTALLED INV: OMFPC2 Installed
M4U_WLQ_CREATE_CLN_COLLAB M4U: Create CLN Collaboration for WLQ
M4U_SUPP_USER_ID M4U: UCCnet Supplier UserId
M4U_UCCNET_ENVELOPE_XSD M4U: UCCnet Envelope XSD
INV_REPL_MO_GROUPING INV: Replenishment Move Order Grouping
INV_KILL_MOVE_ORDER INV: Fill & Kill Move Order
INV_COMPONENT_PICK_BATCH_SIZE INV: Component Pick Batch Size
INV_SUPPLIER_CONSIGNED_ENABLED INV: Supplier Consigned Enabled
INV:GTIN_CROSS_REFERENCE_TYPE INV: GTIN Cross Reference Type
INV_PICK_SLIP_BATCH_SIZE INV: Pick Slip Batch Size
INV_ITEM_DEFAULT_TEMPLATE INV: Item Default Template
INV_ITEM_FORM_DEFAULT_TAB INV: Item Master Form Default Tab
INV_ITEM_ORG_FOLDER_FLAG INV: Items Form Uses Master Set of Folders in the Org Items Form
INV:CROSS_REFERENCE_TYPE INV:Cross Reference Type
INV_VMI_ENABLED INV: VMI Enabled
INV_MGD_MAX_WORK INV: MGD maximum number of workers permitted
INV_USE_NEWTM INV: Use new Trx.Mngr. for processing
INV_ITEM_FOLDER_CATEGORY_SET INV: Item Form Folder Category Set
INV_USE_QP_FOR_INTERCOMPANY INV:Advanced Pricing for Intercompany Invoice
INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER INV:Intercompany Invoice for Internal Orders
INV_QTY_TREE_TIMEOUT INV:Quantity tree timeout for lock
INV_RESTRICT_RCPT_SER INV: Restrict Receipt of Serials
INV_RPC_TIMEOUT INV: RPC Timeout
GENEALOGY_PREFIX_SUFFIX INV:Genealogy Prefix or Suffix
GENEALOGY_DELIMITER INV:Genealogy Delimiter

Inventory Descriptive Flex Field

Oracle Inventory Module DFF List

DFF View DFF CODE NAME DFF name
MTL_RELATED_ITEMS_DFV MTL_RELATED_ITEMS Item Relationships
MTL_CC_ENTRIES_INTERFACE_DFV Cycle Count Entries Interface Cycle Count Entries Interface
MTL_ABC_ASSIGNMENT_GROUPS_DFV MTL_ABC_ASSIGNMENT_GROUPS ABC groups
MTL_ABC_COMPILE_HEADERS_DFV MTL_ABC_COMPILE_HEADERS ABC Analysis Compile Headers
MTL_ATP_RULES_DFV MTL_ATP_RULES ATP Computation Rules
MTL_CATEGORIES_B_DFV MTL_CATEGORIES Item Categories
MTL_CYCLE_COUNT_ENTRIES1_DFV MTL_CC_ENTRIES_ADDITIONAL_INFO Additional Cycle Count Entry Information
MTL_CYCLE_COUNT_ENTRIES2_DFV MTL_CC_ENTRIES_LOT_NUMBER Cycle Count Lot Number
MTL_CC_SCHEDULE_REQUESTS_DFV MTL_CC_SCHEDULE_REQUESTS Schedule Requests
MTL_COMMODITY_CODES_DFV MTL_COMMODITY_CODES Customer Item Commodity Codes
MTL_CROSS_REFERENCES_DFV MTL_CROSS_REFERENCES Item cross-references
MTL_CROSS_REFERENCE_TYPES_DFV MTL_CROSS_REFERENCE_TYPES Item cross-reference types
MTL_CUSTOMER_ITEMS_DFV MTL_CUSTOMER_ITEMS Customer Items
MTL_CUSTOMER_ITEM_XREFS_DFV MTL_CUSTOMER_ITEM_XREFS Customer Item Cross References
MTL_CYCLE_COUNT_ENTRIES_DFV MTL_CYCLE_COUNT_ENTRIES Cycle Count Entries
MTL_CYCLE_COUNT_HEADERS_DFV MTL_CYCLE_COUNT_HEADERS Cycle count headers
MTL_DEMAND_DFV MTL_DEMAND Item reservations
MTL_DEMAND_INTERFACE_DFV MTL_DEMAND_INTERFACE Demand interface
MTL_GENERIC_DISPOSITIONS_DFV MTL_GENERIC_DISPOSITIONS Account aliases
MTL_INTERCOMPANY_PARAMETER_DFV MTL_INTERCOMPANY_PARAMETERS Intercompany relations
MTL_INTERORG_PARAMETERS_DFV MTL_INTERORG_PARAMETERS Inter-organization parameters
MTL_INTERORG_SHIP_METHODS_DFV MTL_INTERORG_SHIP_METHODS Additional Info ForĀ  Inter-Org Ship Method
MTL_ITEM_CATALOG_GROUPS_B_DFV MTL_ITEM_CATALOG_GROUPS Item Catalog Groups
MTL_ITEM_LOCATIONS_DFV MTL_ITEM_LOCATIONS Stock locators
MTL_ITEM_REVISIONS_B_DFV MTL_ITEM_REVISIONS Item Revisions
MTL_ITEM_STATUS_DFV MTL_ITEM_STATUS Item status
MTL_ITEM_SUB_INVENTORIES_DFV MTL_ITEM_SUB_INVENTORIES Item Subinventories
MTL_ITEM_TEMPLATES_DFV MTL_ITEM_TEMPLATES Item Template Descriptive Flexfield
MTL_KANBAN_CARDS_DFV MTL_KANBAN_CARDS Kanban Cards
MTL_KANBAN_CARD_ACTIVITY_DFV MTL_KANBAN_CARD_ACTIVITY Kanban Card Activity
MTL_KANBAN_PULL_SEQUENCES_DFV MTL_KANBAN_PULL_SEQUENCES Pull Sequences
MTL_LOT_NUMBERS_DFV MTL_LOT_NUMBERS Maintain Lot Numbers
MTL_MANUFACTURERS_DFV MTL_MANUFACTURERS Manufacturers
MTL_MATERIAL_TRANSACTIONS_DFV MTL_MATERIAL_TRANSACTIONS Transaction history
MTL_MFG_PART_NUMBERS_DFV MTL_MFG_PART_NUMBERS Manufacturer Part Number
MTL_MOVEMENT_PARAMETERS_DFV MTL_MOVEMENT_PARAMETERS Movement Parameters
MTL_MOVEMENT_STATISTICS_DFV MTL_MOVEMENT_STATISTICS Movement Statistics
MTL_PARAMETERS_DFV MTL_PARAMETERS Organization parameters
MTL_PHYSICAL_ADJUSTMENTS_DFV MTL_PHYSICAL_ADJUSTMENTS Additional Item/Adjustment Information
MTL_PHYSICAL_INVENTORIES_DFV MTL_PHYSICAL_INVENTORIES Physical Inventory
MTL_PHYSICAL_INVENTORY_TAG_DFV MTL_PHYSICAL_INVENTORY_TAGS Physical inventory tags
MTL_PHYSICAL_INVENTORY_TA1_DFV MTL_PHYSICAL_TAGS_LOT_SERIAL Lot/Serial Number Information
MTL_PLANNERS_DFV MTL_PLANNERS Planners
MTL_RESERVATIONS_DFV MTL_RESERVATIONS Reservations
MTL_RESERVATIONS_INTERFACE_DFV MTL_RESERVATIONS_INTERFACE Reservations Interface
MTL_RTG_ITEM_REVISIONS_DFV MTL_RTG_ITEM_REVISIONS Routing revisions
MTL_SECONDARY_INVENTORIES_DFV MTL_SECONDARY_INVENTORIES Subinventories
MTL_SERIAL_NUMBERS_DFV MTL_SERIAL_NUMBERS Serial numbers
MTL_SHORT_CHK_PARAM_DFV MTL_SHORT_CHK_PARAM Shortage Parameter
MTL_SYSTEM_ITEMS_B_DFV MTL_SYSTEM_ITEMS Items
MTL_TRANSACTIONS_INTERFACE_DFV MTL_TRANSACTIONS_INTERFACE Transaction interface
MTL_TRANSACTION_REASONS_DFV MTL_TRANSACTION_REASONS Transaction Reasons
MTL_TRANSACTION_TYPES_DFV MTL_TRANSACTION_TYPES Transaction types
MTL_TXN_REQUEST_LINES_DFV MTL_TXN_REQUEST_LINES Transfer Order Lines
MTL_TXN_SOURCE_TYPES_DFV MTL_TXN_SOURCE_TYPES Transaction source types
MTL_UNITS_OF_MEASURE_TL_DFV MTL_UNITS_OF_MEASURE Define Unit of Measure
MTL_UOM_CLASSES_TL_DFV MTL_UOM_CLASSES Unit of measure classes
ORG_FREIGHT_TL_DFV ORG_FREIGHT Freight carriers
MTL_TXN_SOURCE_TYPES1_DFV Transaction Source Transaction Source
MTL_LOT_NUMBERS1_DFV Lot Attributes Lot Attributes
MTL_SERIAL_NUMBERS1_DFV Serial Attributes Serial Attributes
MTL_EAM_ASSET_ACTIVITIES_DFV MTL_EAM_ASSET_ACTIVITIES Asset Activity Association
MTL_EAM_ASSET_ATTR_VALUES_DFV MTL_EAM_ASSET_ATTR_VALUES Asset Attributes
MTL_EAM_NETWORK_ASSETS_DFV MTL_EAM_NETWORK_ASSETS Asset Routes Association
MTL_TXN_REQUEST_HEADERS_DFV MTL_TXN_REQUEST_HEADERS Transfer Order Header
MTL_TRANSACTION_FLOW_HEADE_DFV MTL_TXN_FLOW_HEADERS_DFF Transaction Flow Headers DFF
MTL_TRANSACTION_FLOW_LINES_DFV MTL_TXN_FLOW_LINES_DFF Transaction Flow Lines DFF
MTL_ACTIONS_B_DFV MTL_ACTIONS Maintain Actions
MTL_GRADES_B_DFV MTL_GRADES Maintain Grades