You are browsing the archive for GMI.

by oracleguru

Oracle Process Manufacturing Inventory Tables

ORACLE APPS COMMUNITY > Tutorial > GMI

Oracle Process Manufacturing Inventory – List of database tables

  • BISOPM_ONHANDSALE_SUM
  • BIS_OPM_PROD_SUM
  • GMI_AUTO_ALLOCATION_BATCH
  • GMI_CATEGORY_SETS
  • GMI_CLOS_WAREHOUSES
  • GMI_DISCRETE_TRANSFERS
  • GMI_DISCRETE_TRANSFER_LINES
  • GMI_DISCRETE_TRANSFER_LOTS
  • GMI_ITEMS_XML_INTERFACE
  • GMI_ITEM_CATEGORIES
  • GMI_ITEM_CONV_AUDIT
  • GMI_ITEM_CONV_AUDIT_DETAILS
  • GMI_ITEM_ORGANIZATIONS
  • GMI_LOTS_CONV_XML_INTERFACE
  • GMI_LOTS_XML_INTERFACE
  • GMI_LOT_TRACE
  • GMI_MASSTRANS_CTL
  • GMI_MIGRATION_PARAMETERS
  • GMI_OBSOLETE_ITEM_COLUMNS
  • GMI_QUANTITY_XML_INTERFACE
  • GMI_SUBLOT_GENERATE
  • GMI_TRAN_TMP
  • IC_ADJS_JNL
  • IC_ALLC_CLS
  • IC_ALOT_PRM
  • IC_CLDR_DTL
  • IC_CLDR_HDR
  • IC_CLDR_HDR_B
  • IC_CLDR_HDR_TL
  • IC_COMD_CDS
  • IC_COST_CLS
  • IC_CRUL_CLS
  • IC_CTMS_CLS
  • IC_CYCL_ADT
  • IC_CYCL_DTL
  • IC_CYCL_ERR
  • IC_CYCL_HDR
  • IC_CYCL_MSC
  • IC_DECM_MST
  • IC_FRGT_CLS
  • IC_GLED_CLS
  • IC_INVN_CLS
  • IC_INVN_TYP
  • IC_ITEM_CDT
  • IC_ITEM_CNV
  • IC_ITEM_CPG
  • IC_ITEM_HIERARCHY
  • IC_ITEM_MST
  • IC_ITEM_MST_B
  • IC_ITEM_MST_B_MIG
  • IC_ITEM_MST_TL
  • IC_ITEM_WHS
  • IC_JRNL_MST
  • IC_LOCT_INV
  • IC_LOCT_MST
  • IC_LOTS_CPG
  • IC_LOTS_MST
  • IC_LOTS_MST_MIG
  • IC_LOTS_STS
  • IC_PERD_BAL
  • IC_PHYS_CNT
  • IC_PHYS_ERR
  • IC_PKGS_MST
  • IC_PLNT_INV
  • IC_PRCE_CLS
  • IC_PRCH_CLS
  • IC_PURG_PRM
  • IC_RANK_MST
  • IC_SALE_CLS
  • IC_SHIP_CLS
  • IC_STAT_RPT
  • IC_STOR_CLS
  • IC_SUMM_INV
  • IC_TAXN_ASC
  • IC_TAXN_CLS
  • IC_TEXT_HDR
  • IC_TEXT_TBL_TL
  • IC_TRAN_ARC
  • IC_TRAN_CMP
  • IC_TRAN_PND
  • IC_TXN_REQUEST_HEADERS
  • IC_TXN_REQUEST_LINES
  • IC_WHSE_INV
  • IC_WHSE_MST
  • IC_WHSE_REL
  • IC_WHSE_STS
  • IC_XFER_MST
  • IN_ADDR_MST
  • IN_CTRY_MST
  • IN_ITEM_MST
  • IN_REGN_MST
  • IN_STAT_CTL
  • IN_STAT_DTL
  • IN_STAT_HDR
  • IN_STAT_MSG
  • IN_TEXT_HDR
  • IN_TEXT_TBL_TL
  • IN_TOFD_MST
  • SY_WF_ITEM_ROLES

Tags: , , 2 Comments »

by oracleguru

Process Manufacturing Inventory Profile Options

ORACLE APPS COMMUNITY > Tutorial > GMI

Oracle Process Manufacturing Inventory Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
PI$POSTING_METHOD GMI:Physical Count Posting Method
LOT_GEN_DELIMITER GMI:Lot Genealogy Delimiter
GMI_OVERWRITE_INV_ITEM GMI: Overwrite Item Data in Oracle Inventory
GMI_RMA_LOT_RESTRICT GMI: RMA Lot Restriction
IC$ALLOW_DISCRETE_ORGS GMI: Allow Discrete Organizations
IC$SHOW_LOC_WITH_NO_INV GMI: Show Locations With No On-hand Inventory
GMI_INT_ORD_LOT_STS GMI: Retain Shipped Lot Status
IC$USERORGSONLY GMI: Item Synchs User Orgs Only
GMI_COUNT_ENTRY_SORT_ORDER GMI: Count Entry Form Sort Order
IC$SHOW_LOT_WITH_NO_INV GMI:Show Lots With No On hand Inventory
IC$API_ALLOW_INACTIVE GMI: API ALLOW INACTIVE
PI$PREDATED_TRAN_ADJ GMI: Include Predated Transactions in Adjustment Method
GMI_ALLOW_ADJUST_BELOW_ALLOC GMI: Allow adjustment of inventory to drive onhand below allocated quantity
GMI_MAX_LOT_LENGTH GMI: Maximum Lot Length
GMI_SUBLOT_PAD_INDICATOR GMI: Sublot Pad Indicator
PI$ALLOW_DUP_ENTRIES GMI: Allow Duplicate Count Entries
GMI_INVENTORY_TRANS_ACCESS GMI: Grant Inventory Transactions Viewing Access
GMI_LOT_PAD_INDICATOR GMI: Lot Pad Indicator
GMI_LOT_SUBLOT_DELIMITER GMI: Lot Sublot Delimiter
GMI_USER_LOT_AUTO_ROUTINE GMI: User Lot Automation Routine
GMI_MAX_SUBLOT_LENGTH GMI: Maximum Sublot Length
GMI_ACC_ENTIRE_LOT GMI:Allocate All Specified Lots
GMI_WHETHER_TO_DEFAULT_TXN_DATE GMI: Default transaction date to current date/time
IC$DEFAULT_LOT_DESC GMI: Default Lot Description
GMI_ACC_INDIVISIBLE GMI:Lot/Sublot Always Indivisible
GMI_ERES_ACTIVE GMI: E-Signature Active

Tags: No Comments »

by oracleguru

Process Manufacturing Inventory Forms

ORACLE APPS COMMUNITY > Tutorial > GMI

Oracle Process Manufacturing Inventory Forms:

FORM SHORT CODE ORACLE FORM NAME
ICALCED2 Allocation Class
ICALLOC Allocated Inventory Summary
ICALLOC1 Allocated Inventory Detail
ICALOTED Allocation Parameters
ICCLDHD1 Inventory Calendar
ICCNVED Item/Lot Standard Conversion
ICCOMDED Commodity Codes
ICCSTED1 Item Cost Class
ICCTCLED Item Customs Class
ICFRCLED Item Freight Class
ICGLCLED General Ledger Class
ICINCLED Inventory Class
ICITMAPV Item Approval Hierarchy
ICITMED Item Master
ICITMQRY Query Item Master
ICITMROL Item Roles Form
ICITPED Inventory Types
ICLOCED Location
ICLOTED Lot/Sublot
ICLTSTED Lot Status
ICPLCLED Item Planning Class
ICPLTED1 Production Rules
ICPRCLED Item Price Class
ICPRDED1 Inventory Close
ICPUCLED Item Purchasing Class
ICPUCMP Purge Completed Transactions
ICPUINV Purge Empty Balances
ICPUPND Purge Pending Transactions
ICQTYED Quantities
ICQTYED2 Post Journals
ICQTYMAS Mass Inventory Transactions
ICQTYVW1 Item Inquiry
ICQTYVW2 Quantity on Hand
ICSHCLED Item Shipping Class
ICSLCLED Item Sales Class
ICSTCLED Item Storage Class
ICSUMVW1 Inventory Summary
ICSUMVW2 Inventory Summary Detail
ICTRNVW1 Transaction Inquiry
ICUALLOC Unallocated Inventory
ICWHINED Warehouse Rules
ICWHSED Warehouses
ICWHTED1 Warehouse Transfer Rules
ICXASED1 Tax Class Association
INADDED Address Supplemental Details Form
INBLDDB Build Intrastat Details Form
INCTRED EC Country Codes Form
INERRVW Error Messages Form
INITMED Item Supplemental Details Form
INREGED EC Region Codes Form
INSTATED EC Statistics Maintenance Form
INTODED EC Terms of Delivery Form
PICTCLED Count Classes
PICTGED Control Groups
PICYCED1 Daily Cycle Count
PICYENED Cycle Count Entry
PIDEFED Physical Inventory
PIPCNTED Physical Count Entry
PIRNKED ABC Rank Information

Tags: No Comments »