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 CODEPROFILE OPTION NAME
ONLINE_PROCESSINGTP:Server Side Online Processing
BOM_OR_ENGBom or Engineering
CURRENCY_CONVERSION_TYPEINV: Inter-Organization Currency Conversion
CYCLE_COUNT_APPROVALS_TXNTP:INV Cycle Count Approvals form
CYCLE_COUNT_ENTRIES_TXNTP:INV Cycle Count Entries form
IC_CURRENCY_CONVERSION_TYPEINV: Intercompany Currency Conversion
INTER_ORG_SHIP_TXNTP:INV Inter-organization Transfer form
INV:ENTER_REPLENISH_COUNTTP:INV Enter Replenishment Count form
INV:EXPENSE_TO_ASSET_TRANSFERINV: Allow Expense to Asset Transfer
INV_CCEOI_COMMIT_POINTINV:CCEOI Commit point
INV_CCEOI_WORKERSINV:CCEOI Workers
INV_CTPINV:Capable to Promise
INV_DEBUG_FILEINV: Debug file (Including the complete path)
INV_DEBUG_LEVELINV:Debug Level
INV_DEBUG_TRACEINV: Debug Trace
INV_DETECT_TRUNCATIONINV: Detect truncation on uom conversion
INV_EXT_ATPINV: External ATP
INV_FIFO_ORIG_REC_DATEINV: FIFO for Original Receipt Date
INV_ITEMS_PRODUCT_FAMILY_TEMPLATEINV: Product Family Item Template Name
INV_ITEM_MASTER_FLEX_CODEINV: Item Master Flexfield
INV_MAXIMUM_NUM_TREESINV: Maximum Number of Quantity Trees
INV_MINMAX_REORDER_APPROVEDINV: Minmax Reorder Approval
INV_OVERRIDE_NEG_FOR_BACKFLUSHINV:Override Neg for Backflush
INV_PROJ_MISC_TXN_EXP_TYPEINV: Project Miscellaneous Transaction Expenditure Type
INV_PURCHASING_BY_REVISIONINV:Purchasing By Revision
INV_STATUS_DEFAULTINV: Default Item Status
INV_UOM_DEFAULTINV: Default Primary Unit of Measure
INV_UPDATEABLE_CITEMINV: Updateable Customer Item
INV_UPDATEABLE_ITEMINV: Updateable item name
ACCOUNT_ISSUE_TXNTP:INV Miscellaneous Issue and Receipt form
RC_LINE_FAILUREINV: Replenishment Count Line Failure
RC_REQUISITION_APPROVALINV: Replenishment Count Requisition Approval
REPORT_QUANTITY_PRECISIONINV: Dynamic Precision Option for Quantity on Reports
SAVE_SEARCH_ITEMSINV: Save Search Items
SUBINV_TRANS_TXNTP:INV Transfer between subinventories form
TRANSACTION_DATEINV: Transaction Date Validation
TRANSACTION_PROCESS_MODETP:INV Transaction processing mode
TRANSFER_ORDER_TXNTP:INV Move Order Transact Form
UPDATE_AVG_TXNTP:INV Update Average Cost form
USE_NAME_ICG_DESCINV: Use catalog name in the item description
INV_ROUND_REORDER_QTYINV: Round Reorder Qty
INV_EBI_PIM_SPOKE_SOURCE_SYSTEMEBS Integration: PIM Spoke Source System Name
INV_INTERCOMPANY_TRANSFER_PRICE_DATEINV: Intercompany Transfer Price Date
INV_SERIAL_RANGE_VALINV: Enable Bulk Serial Validation
INV_EBI_DEBUGEBS Integration: Debug Option
INV_EBI_DEBUG_DIRECTORYEBS Integration: Debug Directory
INV_EBI_LANGUAGE_CODESEBS Integration: Language Codes
INV_EBI_PROXY_SERVER_HOSTEBS Integration: Proxy Server Host
INV_EBI_BATCH_COUNTEBS Integration: Batch Count
INV_EBI_PROXY_SERVER_PORTEBS Integration: Proxy Server Port
INV_EBI_SERVER_DOMAINEBS Integration: Server Domain
INV_EBI_SERVER_HOST_PORTEBS Integration Server Host:Port
ENABLE_LEGAL_ENTITY_TIMEZONEEnable Legal Entity Timezone
INV_ALLOW_NON-REPLENISHABLE_KANBAN_CARD_STATUS_CHANGEINV: Allow Non-Replenishable Kanban Card Status Change
AUTO_PICK_CONFIRM_TXNTP:INV Auto Pick Confirm
INV_VALIDATE_RETURNED_SERIALINV:Validate Returned Serial
INV_TRANS_REASON_SECURITYINV: Transaction Reasons Security
INV_CREATE_LOC_ATINV:Create Locators in Autonomous Mode
INV_USE_QP_FOR_INTERORGINV: Advanced Pricing for Inter-Org Transfers
INV_OVERRIDE_RSV_FOR_BACKFLUSHINV:Override Reservation for Transactions
INV_SUPPLIER_CONSIGNED_GROUPINGINV: Summarize consumption releases by Need By Date
INV_RESTRICT_RCPT_LOTINV: Recieve shipped Lot quantity
INV_ALLOW_CC_TXNS_ONHAND_NEGINV: Allow Count Adjustments to Drive Onhand Negative
INV_USE_MODEL_PRICINGINV: Use Model & Options for Configuration Pricing
INV_TARGET_PREFERRED_GRADEINV: Target Preferred Grade
INV_BACKORDER_CACHEINV: Use Backorder Caching
ALWAYS_SUFFIX_AP_INVOICEINV: Always suffix inter-Company AP Invoice number
INV_MATERIAL_STATUSINV: Material Status Support
INV_VALIDATE_RETURNED_LOTINV:Validate Returned Lot
INV_FILL_PARTIAL_MOVE_KANBANINV: Fill Kanban on Partial Move Order Receipt
INV_MAX_TXN_PG_PROCESSESINV: Max # of txn purge processes
INV_BATCH_SIZEINV: Batch Size
INV_CONSIGN_INVENTORY_AGING_ENABLEDINV: Consigned Inventory Aging Enabled
INV_VIEW_CATEGORY_PEOPLE_PROFILEINV: View Item Category People
INV_OMFPC2_INSTALLEDINV: OMFPC2 Installed
M4U_WLQ_CREATE_CLN_COLLABM4U: Create CLN Collaboration for WLQ
M4U_SUPP_USER_IDM4U: UCCnet Supplier UserId
M4U_UCCNET_ENVELOPE_XSDM4U: UCCnet Envelope XSD
INV_REPL_MO_GROUPINGINV: Replenishment Move Order Grouping
INV_KILL_MOVE_ORDERINV: Fill & Kill Move Order
INV_COMPONENT_PICK_BATCH_SIZEINV: Component Pick Batch Size
INV_SUPPLIER_CONSIGNED_ENABLEDINV: Supplier Consigned Enabled
INV:GTIN_CROSS_REFERENCE_TYPEINV: GTIN Cross Reference Type
INV_PICK_SLIP_BATCH_SIZEINV: Pick Slip Batch Size
INV_ITEM_DEFAULT_TEMPLATEINV: Item Default Template
INV_ITEM_FORM_DEFAULT_TABINV: Item Master Form Default Tab
INV_ITEM_ORG_FOLDER_FLAGINV: Items Form Uses Master Set of Folders in the Org Items Form
INV:CROSS_REFERENCE_TYPEINV:Cross Reference Type
INV_VMI_ENABLEDINV: VMI Enabled
INV_MGD_MAX_WORKINV: MGD maximum number of workers permitted
INV_USE_NEWTMINV: Use new Trx.Mngr. for processing
INV_ITEM_FOLDER_CATEGORY_SETINV: Item Form Folder Category Set
INV_USE_QP_FOR_INTERCOMPANYINV:Advanced Pricing for Intercompany Invoice
INV_INTERCOMPANY_INVOICE_INTERNAL_ORDERINV:Intercompany Invoice for Internal Orders
INV_QTY_TREE_TIMEOUTINV:Quantity tree timeout for lock
INV_RESTRICT_RCPT_SERINV: Restrict Receipt of Serials
INV_RPC_TIMEOUTINV: RPC Timeout
GENEALOGY_PREFIX_SUFFIXINV:Genealogy Prefix or Suffix
GENEALOGY_DELIMITERINV:Genealogy Delimiter

Inventory Descriptive Flex Field

Oracle Inventory Module DFF List

DFF ViewDFF CODE NAMEDFF name
MTL_RELATED_ITEMS_DFVMTL_RELATED_ITEMSItem Relationships
MTL_CC_ENTRIES_INTERFACE_DFVCycle Count Entries InterfaceCycle Count Entries Interface
MTL_ABC_ASSIGNMENT_GROUPS_DFVMTL_ABC_ASSIGNMENT_GROUPSABC groups
MTL_ABC_COMPILE_HEADERS_DFVMTL_ABC_COMPILE_HEADERSABC Analysis Compile Headers
MTL_ATP_RULES_DFVMTL_ATP_RULESATP Computation Rules
MTL_CATEGORIES_B_DFVMTL_CATEGORIESItem Categories
MTL_CYCLE_COUNT_ENTRIES1_DFVMTL_CC_ENTRIES_ADDITIONAL_INFOAdditional Cycle Count Entry Information
MTL_CYCLE_COUNT_ENTRIES2_DFVMTL_CC_ENTRIES_LOT_NUMBERCycle Count Lot Number
MTL_CC_SCHEDULE_REQUESTS_DFVMTL_CC_SCHEDULE_REQUESTSSchedule Requests
MTL_COMMODITY_CODES_DFVMTL_COMMODITY_CODESCustomer Item Commodity Codes
MTL_CROSS_REFERENCES_DFVMTL_CROSS_REFERENCESItem cross-references
MTL_CROSS_REFERENCE_TYPES_DFVMTL_CROSS_REFERENCE_TYPESItem cross-reference types
MTL_CUSTOMER_ITEMS_DFVMTL_CUSTOMER_ITEMSCustomer Items
MTL_CUSTOMER_ITEM_XREFS_DFVMTL_CUSTOMER_ITEM_XREFSCustomer Item Cross References
MTL_CYCLE_COUNT_ENTRIES_DFVMTL_CYCLE_COUNT_ENTRIESCycle Count Entries
MTL_CYCLE_COUNT_HEADERS_DFVMTL_CYCLE_COUNT_HEADERSCycle count headers
MTL_DEMAND_DFVMTL_DEMANDItem reservations
MTL_DEMAND_INTERFACE_DFVMTL_DEMAND_INTERFACEDemand interface
MTL_GENERIC_DISPOSITIONS_DFVMTL_GENERIC_DISPOSITIONSAccount aliases
MTL_INTERCOMPANY_PARAMETER_DFVMTL_INTERCOMPANY_PARAMETERSIntercompany relations
MTL_INTERORG_PARAMETERS_DFVMTL_INTERORG_PARAMETERSInter-organization parameters
MTL_INTERORG_SHIP_METHODS_DFVMTL_INTERORG_SHIP_METHODSAdditional Info ForĀ  Inter-Org Ship Method
MTL_ITEM_CATALOG_GROUPS_B_DFVMTL_ITEM_CATALOG_GROUPSItem Catalog Groups
MTL_ITEM_LOCATIONS_DFVMTL_ITEM_LOCATIONSStock locators
MTL_ITEM_REVISIONS_B_DFVMTL_ITEM_REVISIONSItem Revisions
MTL_ITEM_STATUS_DFVMTL_ITEM_STATUSItem status
MTL_ITEM_SUB_INVENTORIES_DFVMTL_ITEM_SUB_INVENTORIESItem Subinventories
MTL_ITEM_TEMPLATES_DFVMTL_ITEM_TEMPLATESItem Template Descriptive Flexfield
MTL_KANBAN_CARDS_DFVMTL_KANBAN_CARDSKanban Cards
MTL_KANBAN_CARD_ACTIVITY_DFVMTL_KANBAN_CARD_ACTIVITYKanban Card Activity
MTL_KANBAN_PULL_SEQUENCES_DFVMTL_KANBAN_PULL_SEQUENCESPull Sequences
MTL_LOT_NUMBERS_DFVMTL_LOT_NUMBERSMaintain Lot Numbers
MTL_MANUFACTURERS_DFVMTL_MANUFACTURERSManufacturers
MTL_MATERIAL_TRANSACTIONS_DFVMTL_MATERIAL_TRANSACTIONSTransaction history
MTL_MFG_PART_NUMBERS_DFVMTL_MFG_PART_NUMBERSManufacturer Part Number
MTL_MOVEMENT_PARAMETERS_DFVMTL_MOVEMENT_PARAMETERSMovement Parameters
MTL_MOVEMENT_STATISTICS_DFVMTL_MOVEMENT_STATISTICSMovement Statistics
MTL_PARAMETERS_DFVMTL_PARAMETERSOrganization parameters
MTL_PHYSICAL_ADJUSTMENTS_DFVMTL_PHYSICAL_ADJUSTMENTSAdditional Item/Adjustment Information
MTL_PHYSICAL_INVENTORIES_DFVMTL_PHYSICAL_INVENTORIESPhysical Inventory
MTL_PHYSICAL_INVENTORY_TAG_DFVMTL_PHYSICAL_INVENTORY_TAGSPhysical inventory tags
MTL_PHYSICAL_INVENTORY_TA1_DFVMTL_PHYSICAL_TAGS_LOT_SERIALLot/Serial Number Information
MTL_PLANNERS_DFVMTL_PLANNERSPlanners
MTL_RESERVATIONS_DFVMTL_RESERVATIONSReservations
MTL_RESERVATIONS_INTERFACE_DFVMTL_RESERVATIONS_INTERFACEReservations Interface
MTL_RTG_ITEM_REVISIONS_DFVMTL_RTG_ITEM_REVISIONSRouting revisions
MTL_SECONDARY_INVENTORIES_DFVMTL_SECONDARY_INVENTORIESSubinventories
MTL_SERIAL_NUMBERS_DFVMTL_SERIAL_NUMBERSSerial numbers
MTL_SHORT_CHK_PARAM_DFVMTL_SHORT_CHK_PARAMShortage Parameter
MTL_SYSTEM_ITEMS_B_DFVMTL_SYSTEM_ITEMSItems
MTL_TRANSACTIONS_INTERFACE_DFVMTL_TRANSACTIONS_INTERFACETransaction interface
MTL_TRANSACTION_REASONS_DFVMTL_TRANSACTION_REASONSTransaction Reasons
MTL_TRANSACTION_TYPES_DFVMTL_TRANSACTION_TYPESTransaction types
MTL_TXN_REQUEST_LINES_DFVMTL_TXN_REQUEST_LINESTransfer Order Lines
MTL_TXN_SOURCE_TYPES_DFVMTL_TXN_SOURCE_TYPESTransaction source types
MTL_UNITS_OF_MEASURE_TL_DFVMTL_UNITS_OF_MEASUREDefine Unit of Measure
MTL_UOM_CLASSES_TL_DFVMTL_UOM_CLASSESUnit of measure classes
ORG_FREIGHT_TL_DFVORG_FREIGHTFreight carriers
MTL_TXN_SOURCE_TYPES1_DFVTransaction SourceTransaction Source
MTL_LOT_NUMBERS1_DFVLot AttributesLot Attributes
MTL_SERIAL_NUMBERS1_DFVSerial AttributesSerial Attributes
MTL_EAM_ASSET_ACTIVITIES_DFVMTL_EAM_ASSET_ACTIVITIESAsset Activity Association
MTL_EAM_ASSET_ATTR_VALUES_DFVMTL_EAM_ASSET_ATTR_VALUESAsset Attributes
MTL_EAM_NETWORK_ASSETS_DFVMTL_EAM_NETWORK_ASSETSAsset Routes Association
MTL_TXN_REQUEST_HEADERS_DFVMTL_TXN_REQUEST_HEADERSTransfer Order Header
MTL_TRANSACTION_FLOW_HEADE_DFVMTL_TXN_FLOW_HEADERS_DFFTransaction Flow Headers DFF
MTL_TRANSACTION_FLOW_LINES_DFVMTL_TXN_FLOW_LINES_DFFTransaction Flow Lines DFF
MTL_ACTIONS_B_DFVMTL_ACTIONSMaintain Actions
MTL_GRADES_B_DFVMTL_GRADESMaintain Grades