Oracle Advanced Supply Chain Planning

Oracle Advanced Supply Chain Planning Tables Oracle ASCP – List of database tables: MSC_ABC_CLASSES MSC_ALLOCATIONS MSC_ALLOCATION_ASSIGNMENTS MSC_ALLOCATION_RULES MSC_ALLOC_DEMANDS MSC_ALLOC_RULE_TIME_PHASES MSC_ALLOC_SUPPLIES MSC_AMONG_VALUES MSC_ANSWERS MSC_APPS_INSTANCES MSC_ASSIGNMENT_SETS MSC_ATP_PARAMETERS MSC_ATP_PEGGING MSC_ATP_RULES MSC_ATP_SUMMARY_RES MSC_ATP_SUMMARY_SD MSC_ATP_SUMMARY_SO MSC_ATP_SUMMARY_SUP MSC_AVAILABLE_TO_PROMISE MSC_BILL_OF_RESOURCES MSC_BIS_BUSINESS_PLANS MSC_BIS_INV_CAT_MV_TAB MSC_BIS_INV_DATE_MV_TAB MSC_BIS_INV_DETAIL MSC_BIS_PERFORMANCE_MEASURES MSC_BIS_PERIODS MSC_BIS_RES_DATE_MV_TAB MSC_BIS_RES_SUMMARY MSC_BIS_SUPPLIER_SUMMARY MSC_BIS_TARGETS MSC_BIS_TARGET_LEVELS MSC_BOMS MSC_BOM_BOD_INTERFACE MSC_BOM_COMPONENTS MSC_BOM_TEMP MSC_BOR_REQUIREMENTS MSC_CALENDARS MSC_CALENDAR_DATES MSC_CALENDAR_EXCEPTIONS MSC_CALENDAR_SHIFTS MSC_CAL_WEEK_START_DATES MSC_CAL_YEAR_START_DATES MSC_CAPACITY_PLANS MSC_CATEGORY_SETS MSC_CATEGORY_SET_ID_LID MSC_COLL_PARAMETERS MSC_COMPANIES MSC_COMPANY_ID_LID MSC_COMPANY_RELATIONSHIPS MSC_COMPANY_SITES MSC_COMPANY_SITE_ID_LID MSC_COMPANY_USERS MSC_COMPONENT_SUBSTITUTES MSC_CRITERIA MSC_CRITICAL_PATHS MSC_DEMANDS MSC_DEMAND_CLASSES MSC_DEMAND_MV_TAB MSC_DEPARTMENT_RESOURCES MSC_DESIGNATORS MSC_ERRORS MSC_EXCEPTION_DETAILS MSC_EXCEPTION_PREFERENCES MSC_EXCEPTION_THRESHOLDS MSC_EXCEPTION_THRESHOLD_VALUES MSC_EXC_DETAILS_ALL MSC_FCTI_HEADERS_INTERFACE MSC_FCTI_LINES_INTERFACE MSC_FILES MSC_FORECAST_UPDATES MSC_FORM_QUERY MSC_FULL_PEGGING MSC_GANTT_QUERY MSC_GROUPS MSC_GROUP_COMPANIES MSC_INSTANCE_ORGS MSC_INST_PARTITIONS MSC_INTERORG_SHIP_METHODS MSC_ITEMS MSC_ITEM_CATEGORIES MSC_ITEM_CUSTOMERS MSC_ITEM_EXCEPTIONS MSC_ITEM_ID_LID MSC_ITEM_SOURCING MSC_ITEM_SUBSTITUTES MSC_ITEM_SUPPLIERS MSC_JOB_OPERATIONS MSC_JOB_OPERATION_NETWORKS MSC_JOB_OP_RESOURCES MSC_JOB_OP_RES_INSTANCES MSC_JOB_REQUIREMENT_OPS MSC_LATE_ORDER_MV_TAB MSC_LOCAL_ID_DEMAND MSC_LOCAL_ID_ITEM MSC_LOCAL_ID_MISC MSC_LOCAL_ID_SETUP MSC_LOCAL_ID_SUPPLY MSC_LOCATION_ASSOCIATIONS MSC_MATERIAL_PLANS MSC_NEC_COMPARE_PLANS MSC_NEC_EXC_DTL_COMPARE MSC_NET_CHANGE_CRITERIA MSC_NET_RESOURCE_AVAIL MSC_NET_RES_INST_AVAIL MSC_OE_DATA_TEMP MSC_OPERATION_COMPONENTS MSC_OPERATION_NETWORKS MSC_OPERATION_RESOURCES MSC_OPERATION_RESOURCE_SEQS MSC_ORG_ACCESS MSC_OUTBOUND_ENTRIES MSC_PARAMETERS MSC_PARTNER_CONTACTS MSC_PDR_PARAMETERS MSC_PDR_PARAMETERS_NEW MSC_PERIOD_START_DATES MSC_PLANNERS MSC_PLANS MSC_PLAN_BUCKETS MSC_PLAN_ORGANIZATIONS MSC_PLAN_ORG_KPIS MSC_PLAN_ORG_STATUS MSC_PLAN_ORG_STATUSES MSC_PLAN_PARTITIONS MSC_PLAN_REFRESHES MSC_PLAN_SCHEDULES MSC_PO_REQUISITIONS_INTERFACE MSC_PO_RESCHEDULE_INTERFACE MSC_PQ_RESULTS MSC_PROCESS_EFFECTIVITY MSC_PROFILES MSC_PROJECTS MSC_PROJECT_TASKS MSC_PURCHASE_ORDER_INTERFACE MSC_QUERY MSC_QUESTIONS_B MSC_QUESTIONS_TL MSC_REGIONS MSC_REGIONS_TEMP MSC_REGION_LOCATIONS MSC_RELATED_EXCEPTIONS MSC_REPETITIVE_PERIODS MSC_RESERVATIONS MSC_RESOURCE_CHANGES MSC_RESOURCE_GROUPS MSC_RESOURCE_INSTANCE_REQS MSC_RESOURCE_REQUIREMENTS MSC_RESOURCE_SHIFTS MSC_ROUTINGS MSC_ROUTING_OPERATIONS MSC_SAFETY_STOCKS MSC_SALES_ORDERS MSC_SCHEDULING_RULES MSC_SECURITY_RULES MSC_SELECTION_CRITERIA MSC_SEQUENCE_DEPENDENT_SETUPS MSC_SERIAL_NUMBERS MSC_SHIFT_DATES MSC_SHIFT_EXCEPTIONS MSC_SHIFT_TIMES MSC_SIMULATION_SETS MSC_SINGLE_LVL_PEG MSC_SNAPSHOT_TASKS MSC_SORT_DATA MSC_SOURCING_HISTORY MSC_SOURCING_RULES MSC_SOURCING_TRANSACTIONS MSC_SQLLOAD_PARAMETERS MSC_SR_ASSIGNMENTS MSC_SR_RECEIPT_ORG MSC_SR_SOURCE_ORG MSC_ST_ASSIGNMENT_SETS MSC_ST_ATP_RULES MSC_ST_BILL_OF_RESOURCES MSC_ST_BIS_BUSINESS_PLANS MSC_ST_BIS_PERIODS MSC_ST_BIS_PFMC_MEASURES MSC_ST_BIS_TARGETS MSC_ST_BIS_TARGET_LEVELS MSC_ST_BOMS MSC_ST_BOM_COMPONENTS MSC_ST_BOR_REQUIREMENTS MSC_ST_CALENDARS MSC_ST_CALENDAR_DATES MSC_ST_CALENDAR_EXCEPTIONS MSC_ST_CALENDAR_SHIFTS MSC_ST_CAL_WEEK_START_DATES MSC_ST_CAL_YEAR_START_DATES MSC_ST_CATEGORY_SETS MSC_ST_COMPANY_USERS MSC_ST_COMPONENT_SUBSTITUTES MSC_ST_CO_PRODUCTS MSC_ST_DEMANDS MSC_ST_DEMAND_CLASSES MSC_ST_DEPARTMENT_RESOURCES MSC_ST_DESIGNATORS MSC_ST_GROUPS MSC_ST_GROUP_COMPANIES MSC_ST_INTERORG_SHIP_METHODS MSC_ST_ITEM_CATEGORIES MSC_ST_ITEM_CUSTOMERS MSC_ST_ITEM_SOURCING MSC_ST_ITEM_SUBSTITUTES MSC_ST_ITEM_SUPPLIERS MSC_ST_JOB_OPERATIONS MSC_ST_JOB_OP_RESOURCES MSC_ST_JOB_REQUIREMENT_OPS MSC_ST_LOCATION_ASSOCIATIONS MSC_ST_NET_RESOURCE_AVAIL MSC_ST_NET_RES_INST_AVAIL MSC_ST_OPERATION_COMPONENTS MSC_ST_OPERATION_NETWORKS MSC_ST_OPERATION_RESOURCES MSC_ST_OPERATION_RESOURCE_SEQS MSC_ST_PARAMETERS MSC_ST_PARTNER_CONTACTS MSC_ST_PERIOD_START_DATES MSC_ST_PLANNERS MSC_ST_PROCESS_EFFECTIVITY MSC_ST_PROFILES MSC_ST_PROJECTS MSC_ST_PROJECT_TASKS MSC_ST_REGIONS MSC_ST_REGION_LOCATIONS MSC_ST_RESERVATIONS MSC_ST_RESOURCE_CHANGES MSC_ST_RESOURCE_GROUPS MSC_ST_RESOURCE_INSTANCE_REQS MSC_ST_RESOURCE_REQUIREMENTS MSC_ST_RESOURCE_SHIFTS MSC_ST_ROUTINGS MSC_ST_ROUTING_OPERATIONS MSC_ST_SAFETY_STOCKS MSC_ST_SALES_ORDERS MSC_ST_SERIAL_NUMBERS MSC_ST_SHIFT_DATES MSC_ST_SHIFT_EXCEPTIONS MSC_ST_SHIFT_TIMES MSC_ST_SIMULATION_SETS MSC_ST_SOURCING_HISTORY MSC_ST_SOURCING_RULES MSC_ST_SR_ASSIGNMENTS MSC_ST_SR_RECEIPT_ORG MSC_ST_SR_SOURCE_ORG MSC_ST_SUB_INVENTORIES MSC_ST_SUPPLIER_CAPACITIES MSC_ST_SUPPLIER_FLEX_FENCES MSC_ST_SUPPLIES MSC_ST_SYSTEM_ITEMS MSC_ST_TRADING_PARTNERS MSC_ST_TRADING_PARTNER_SITES MSC_ST_UNITS_OF_MEASURE MSC_ST_UNIT_NUMBERS MSC_ST_UOM_CLASS_CONVERSIONS MSC_ST_UOM_CONVERSIONS MSC_ST_WORKDAY_PATTERNS MSC_ST_ZONE_REGIONS MSC_SUB_INVENTORIES MSC_SUPDEM_HDRS_INTERFACE MSC_SUPDEM_LINES_INTERFACE MSC_SUPPLIER_CAPACITIES MSC_SUPPLIER_FLEX_FENCES MSC_SUPPLIER_LT_OUTCOMES MSC_SUPPLIER_PLANS MSC_SUPPLIER_REQUIREMENTS MSC_SUPPLIES MSC_SUP_DEM_ENTRIES MSC_SUP_DEM_HISTORY MSC_SUP_HEADERS_INTERFACE MSC_SUP_LINES_INTERFACE MSC_SYSTEM_ITEMS MSC_TEMP_ALLOC_DEMANDS MSC_TEMP_ALLOC_SUPPLIES MSC_TEMP_REGION_LOCATIONS MSC_TEMP_SALES_ORDERS MSC_TEMP_SUMM_RES MSC_TEMP_SUMM_SD MSC_TEMP_SUMM_SO MSC_TEMP_SUMM_SUP MSC_TP_ID_LID MSC_TP_SITE_ID_LID MSC_TRADING_PARTNERS MSC_TRADING_PARTNER_MAPS MSC_TRADING_PARTNER_SITES MSC_UNDO_DETAILS MSC_UNDO_SUMMARY MSC_UNITS_OF_MEASURE MSC_UNIT_NUMBERS MSC_UOM_CLASS_CONVERSIONS MSC_UOM_CONVERSIONS MSC_USER_ADV_EXPRESSIONS MSC_USER_EXCEPTIONS MSC_USER_EXCEPTION_COMPONENTS MSC_USER_EXCEPTION_NTFS MSC_WIP_JOB_DTLS_INTERFACE MSC_WIP_JOB_SCHEDULE_INTERFACE MSC_WORKBENCH_DISPLAY_OPTIONS MSC_WORKDAY_PATTERNS MSC_X_EXCEPTION_DETAILS MSC_X_SECURITY_RULES MSC_ZONE_REGIONS -------------------------------------------------- Oracle Supply Chain Trading Connector for RosettaNet database tables information: CLN_AP_INVOICE_REJECTION_ARCH CLN_CH_COLL_PROPERTIES CLN_CH_DISPLAY_LABELS_DTL_B CLN_CH_DISPLAY_LABELS_DTL_TL CLN_CH_DISPLAY_LABELS_HDR CLN_CH_XMLGTXN_MAPPING CLN_COLL_COMPLETED_STATUS CLN_COLL_HIST_DTL CLN_COLL_HIST_HDR CLN_COLL_MESSAGES CLN_CST_DTLS_TEMP CLN_ITEMMST_DELETED_ITEMS CLN_NOTIFICATION_ACTION_DTL CLN_NOTIFICATION_ACTION_HDR CLN_NOTIFICATION_CODES_B CLN_NOTIFICATION_CODES_TL CLN_RN_VALIDATIONS ---------------------------------------------------- Oracle Supply Chain Localizations – List of database tables: JMF_GTA_AR_DIFFERENCE_TEMP JMF_GTA_BATCH_NUMBERING JMF_GTA_DIFFERENCE_TEMP JMF_GTA_IMPORT_REP_TEMP JMF_GTA_MISSING_ARTRX_TEMP JMF_GTA_RULE_DFFS_ALL JMF_GTA_RULE_HEADERS_ALL JMF_GTA_RULE_TRX_TYPES_ALL JMF_GTA_SYSTEM_PARAMETERS_ALL JMF_GTA_TRANSFER_TEMP JMF_GTA_TRXIMP_TMP JMF_GTA_TRX_HEADERS_ALL JMF_GTA_TRX_LINES_ALL JMF_GTA_UNMATCHED_TEMP JMF_SHIKYU_ADJUSTMENTS JMF_SHIKYU_ALLOCATIONS JMF_SHIKYU_CFR_MID_TEMP JMF_SHIKYU_CFR_RPT_TEMP JMF_SHIKYU_COMPONENTS JMF_SHIKYU_CUR_RPT_TEMP JMF_SHIKYU_REPLENISHMENTS JMF_SHIKYU_SPR_RPT_TEMP JMF_SUBCONTRACT_ORDERS JMF_SUBCONTRACT_ORDERS_TEMP ----------------------------------------------------- Oracle Supply Chain Trading Connector for Rosettanet Concurrent Programs CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME CLNOMCP Concurrent Program For 3A6 CLNSHSPSND CLN: Send XML Show Shipment Document CLNSYCTSND CLN: Publish Product Catalog Concurrent Program CLNINVRT Generate Inventory Report XML CLNSYITSND CLN: Publish Item Master Concurrent Program CLNUPMPN CLN : Update Manufacture Part Number M4UWQGEN M4U: 1Sync Query Worklist M4UQRREG M4U: 1Sync Global Registry Query M4UQRPAR M4U: 1Sync Party Query M4USETUP M4U: Setup HR location and ECX Transactions M4U_DMD_RETRY_REQUEST M4U: Demand Retry Request M4U_DMD_CLN_SETUP M4U: Demand Setup Collaboration Tracking ----------------------------------------------------- Oracle supply chain intelligence module – List of database tables EDW_MRP_DCDM_DM_LSTG EDW_MRP_DCDM_DM_LTC EDW_MRP_DM_CLS_A_LTC EDW_MRP_DM_CLS_M EDW_MRP_FCDM_FCS_LSTG EDW_MRP_FCDM_FCS_LTC EDW_MRP_FCDM_SET_LSTG EDW_MRP_FCDM_SET_LTC EDW_MRP_FORECAST_M EDW_MRP_PLAN_M EDW_MRP_PNDM_PLN_LSTG EDW_MRP_PNDM_PLN_LTC EDW_OE_SCHN_SCHN_LSTG EDW_OE_SCHN_SCHN_LTC EDW_OE_SLCHNL_A_LTC EDW_OE_SLCHNL_M ISC_DBI_CFM_008_MV ISC_DBI_CFM_012_MV ISC_DBI_CPM_001_MV ISC_DBI_CPM_002_MV ISC_DBI_CPM_003_MV ISC_DBI_CPM_004_MV ISC_DBI_CPM_005_MV ISC_DBI_DEMANDS_F ISC_DBI_EXCEPTION_DETAILS_F ISC_DBI_FM_0001_MV ISC_DBI_FM_0003_MV ISC_DBI_FM_0006_MV ISC_DBI_FM_0007_MV ISC_DBI_FM_0008_MV ISC_DBI_FULL_PEGGING_F ISC_DBI_INV_DETAIL_F ISC_DBI_INV_DETAIL_SNAPSHOTS ISC_DBI_PM_0000_MV ISC_DBI_PM_0001_MV ISC_DBI_PM_0002_MV ISC_DBI_PM_0003_MV ISC_DBI_PM_0004_MV ISC_DBI_RES_SUMMARY_F ISC_DBI_RES_SUM_SNAPSHOTS ISC_DBI_SHORTFALL_SNAPSHOTS ISC_DBI_SUPPLIES_F ISC_DBI_SUPPLIES_SNAPSHOTS ISC_EDW_BACKLOGS_F ISC_EDW_BACKLOGS_FSTG ISC_EDW_BOOKINGS_F ISC_EDW_BOOKINGS_FSTG ISC_EDW_BOOKINGS_F_DLOG ISC_EDW_BOOK_SUM1_F ISC_EDW_BOOK_SUM1_FSTG ISC_TMP_BACK ISC_TMP_BOOK_SUM1 ISC_TMP_PK ----------------------------------------------------- Oracle Regional Localizations – List of database table JG_ZZ_AP_BALANCES JG_ZZ_AP_IR_REP_ITF JG_ZZ_AP_TMP_ACCOUNT JG_ZZ_AP_TMP_BAL JG_ZZ_AP_TMP_DETAIL JG_ZZ_AP_WHT_ITF JG_ZZ_AR_BALANCES JG_ZZ_AR_SRC_TRX_TY_ALL JG_ZZ_AR_TMP_ACCOUNT JG_ZZ_AR_TMP_BAL JG_ZZ_AR_TMP_DETAIL JG_ZZ_ENTITY_ASSOC JG_ZZ_FA_REG_ITF JG_ZZ_GL_RECON_TRX JG_ZZ_GL_UNREC_TRX JG_ZZ_II_INT_RATES_ALL JG_ZZ_INTEREST_BATCHES_ALL JG_ZZ_INTEREST_INVOICES_ALL JG_ZZ_INT_INV_LINES_ALL JG_ZZ_INVOICE_INFO JG_ZZ_JGZZCSLP_MESSAGES JG_ZZ_JGZZVSLP_MESSAGES JG_ZZ_PAY_FORMAT_INFO JG_ZZ_PAY_SCHED_INFO JG_ZZ_SYS_FORMATS_ALL_B JG_ZZ_SYS_FORMATS_ALL_TL JG_ZZ_TAXABLE_DETAIL_ITF JG_ZZ_TA_ACCOUNT_RANGES JG_ZZ_TA_ALLOCATED_LINES JG_ZZ_TA_CC_RANGES JG_ZZ_TA_RULE_LINES JG_ZZ_TA_RULE_SETS JG_ZZ_TMP_RPT_HEADERS JG_ZZ_VAT_ALLOC_RULES JG_ZZ_VAT_BOX_ALLOCS JG_ZZ_VAT_BOX_ERRORS JG_ZZ_VAT_DOC_SEQUENCES JG_ZZ_VAT_FINAL_REPORTS JG_ZZ_VAT_REGISTERS_B JG_ZZ_VAT_REGISTERS_TL JG_ZZ_VAT_REP_ENTITIES JG_ZZ_VAT_REP_STATUS JG_ZZ_VAT_TRX_DETAILS JG_ZZ_VAT_TRX_GT JG_ZZ_VAT_TRX_UPG_STG JG_ZZ_VAT_UPG_STG JG_ZZ_VEND_SITE_INFO ----------------------------------------------------- Oracle Advanced Supply Chain Forms: FORM SHORT CODE ORACLE FORM NAME MSCCHORG Change Organization MSCFDDSR Define Sourcing Rules/Bills of Distribution MSCFDSRA Assign Sourcing Rule/BOD MSCFINST Define Application Instances MSCFNSCW Planner Workbench MSCFPCMN Define Plan Names MSCFPPMR Define Plan Options MSCFUDAY View Work Dates MSCFUDPP Define Plan Parameters MSCFVSAH View Sourcing Assignment Hierarchy MSCFVSCB View Supply Chain Bill MSCOSCWB ATP Inquiry MSCSCHRS Define Priority Rules MSC_MSCBALWB Order Backlog Workbench MSCBALWB ORDER BACKLOG WORKBENCH MSCPLDTL Planning Detailed Report MSCATPSD Supply Demand MSCFDARL Define Allocation Rule MSCFAARL Assign Allocation Rule MSCVWALC View Allocation MSCCPPLN Copy Plan MSCSLFLT Service Levels & Fulfillment Lead Time MSCFPPSC Define Plan Options – Supply Chain MSCFPCSC Define Plan Names – Supply Chain Plans MSCRSPRM Resource Parameters MSCDSPOP Define Schedule Options MSCDSPNM Define Schedule Names MSCITMNT Define Item Attributes Mass Maintenance for ASCP MSCTRUPD Transportation Update MSCFCRLS SRP Forecast Parameters MSCFNSRP Service Planner Workbench MSCSPPOP Define Service Plan Options MSCSPPNM Define Service Plan Names MSCFNSDA Supply Demand Analysis MSCUSRGP Define SRP User Groups MSCUPREF SRP User Preference MSCPQLDR Define Criticality Matrix for SRP MSCTRTIM Transit Times MSCFNDRP Planner Workbench – DRP MSCFPDRP Define DRP Options MSCFPCDP Define DRP Names MSCFSALC Supply Allocation Rules MSCINVLV Enter Inventory Levels MSCPRIRL Demand Type-Class Priority MSCIOPOP Define Plan Options -Inventory Planner MSCIOPNM Define Plan Names -Inventory Planner MSCFBDGT Specify Budget -----------------------------------------------------