Go to primary content
Oracle Product Lifecycle Analytics Operational Data Reference Manual
Release 3.5
E70276-01
Contents
Previous
Next
List of Tables
1-1 Acronyms and definitions
2-1 Standard Table Prefixes in Staging Schema Tables
2-2 Standard Table Suffixes in Oracle Agile PLM BI Tables
2-3 ETL Control Entities
2-4 Metadata and Translation Entities
2-5 ODM_LISTDIM_CTRL
2-6 Columns in Dynamic and Normal lists
2-7 Cascade List Dimension Entities
2-8 Dimension tables available in Data Mart
2-9 Map Tables
2-10 Map tables in OPLA Operational Schema
2-11 Data Entities, Common
2-12 Data Entities, PPM
2-13 Data Entities, PC
2-14 Data Entities, PQM
2-15 Data Entities, PCM
2-16 Data Entities, PGC
2-17 Standard column suffixes in Agile PLM DM tables
3-1 AGILE_FLEX
3-2 DM_LOAD_CTL
3-3 LISTENTRY
3-4 LISTNAME
3-5 NODETABLE
3-6 ODM_ACTION_ITEM
3-7 ODM_ACTIVITY_BASELINE
3-8 ODM_ACTIVITY_DEPENDENCY
3-9 ODM_ACTIVITY_PLM_REF
3-10 ODM_ADMINMSATT
3-11 ODM_AGGR_SUBSTANCE
3-12 ODM_AGILEUSER
3-13 ODM_APPROVAL_ITEMS
3-14 ODM_ATT_DESIGNS
3-15 ODM_ATT_FILE_FLDR
3-16 ODM_ATT_HIST_RPT_FF
3-17 ODM_ATTR_METADATA
3-18 ODM_BASELINE_REV
3-19 ODM_BOM
3-20 ODM_BOM_RESULT
3-21 ODM_CACHE_FILE_MAP1
3-22 ODM_CHANGE_HISTORY
3-23 ODM_CHNG_CHG_ORDERS
3-24 ODM_CHNG_CHG_REQS
3-25 ODM_CHNG_DEVIATION
3-26 ODM_CHNG_MFR_ORDERS
3-27 ODM_CHNG_PRICE_CHGORDERS
3-28 ODM_CHNG_SITE_CHGORDERS
3-29 ODM_CHNG_STOP_SHIPS
3-30 ODM_CLASS_METADATA
3-31 ODM_COMPLIANCE
3-32 ODM_CONVERSION
3-33 ODM_CONTRACT
3-34 ODM_CURRENCY
3-35 ODM_CUSTOMER
3-36 ODM_DATA_DICTIONARY
3-37 ODM_DELETE_TXN
3-38 ODM_DISCUSSION
3-39 ODM_DOCS_MANU_BY
3-40 ODM_ESCALATIONS
3-41 ODM_EVENT_HISTORY
3-42 ODM_FILE_INFO
3-43 ODM_FILES
3-44 ODM_FLEXCOLS_METADATA
3-45 ODM_FOLDER
3-46 ODM_FOLDER_STRUCTURE
3-47 ODM_FUN_TEAM_OBJ_D
3-48 ODM_GEOGRAPHY_ROUTING
3-49 ODM_INDEX_COLUMN_CTL
3-50 ODM_ITEM_DOCS
3-51 ODM_ITEM_HISTORY
3-52 ODM_ITEM_HISTORY2
3-53 ODM_ITEM_PARTS
3-54 ODM_ITEM_SITES
3-55 ODM_LANGTABLE
3-56 ODM_LISTDIM_CTL
3-57 ODM_LISTENTRY_STG
3-58 ODM_LISTNAME_STG
3-59 ODM_MANU_BY
3-60 ODM_MANU_PARTS
3-61 ODM_MANUFACTURER
3-62 ODM_MANUFACTURERS
3-63 ODM_MASTER_INDEX_CTL
3-64 ODM_MATERIAL_DCLRNS_HGNUS
3-65 ODM_MATERIAL_DCLRNS_IPC_1
3-66 ODM_MATERIAL_DCLRNS_IPC_2
3-67 ODM_MATERIAL_DCLRNS_JGPSSI
3-68 ODM_MATERIAL_DCLRNS_PRTS
3-69 ODM_MATERIAL_DCLRNS_SBTNCE
3-70 ODM_MATERIAL_DCLRNS_SUPPLR
3-71 ODM_MSATT
3-72 ODM_NEWS
3-73 ODM_NOTIFICATION
3-74 ODM_OBJECT_LOCKS
3-75 ODM_OBJECTACL
3-76 ODM_ORGANIZATION
3-77 ODM_P3_SD_CTL
3-78 ODM_PAGE_THREE
3-79 ODM_PART_FAMILY
3-80 ODM_PARTS_MANU_BY
3-81 ODM_PDP
3-82 ODM_PRG_ACTIVITY
3-83 ODM_PRG_GATES
3-84 ODM_PRICE_HISTORY
3-85 ODM_PRICE_PUB_PRICE
3-86 ODM_PRICE_QUOTE_HIST
3-87 ODM_PRICEENTRY
3-88 ODM_PRICELINE
3-89 ODM_PRICEPOINT
3-90 ODM_PRODUCT_LINE
3-91 ODM_PROGRAM
3-92 ODM_PROGRAM_HISTORY
3-93 ODM_PROGRAM_TEMPLATE
3-94 ODM_PROJECT
3-95 ODM_PSR_NCR
3-96 ODM_PSR_NCR_ITEM
3-97 ODM_PSR_PR
3-98 ODM_PSR_PR_ITEM
3-99 ODM_QCR_AUDIT
3-100 ODM_QCR_AUDIT_ITEM
3-101 ODM_QCR_CAPA
3-102 ODM_QCR_CAPA_ITEM
3-103 ODM_QUOTE_HISTORY
3-104 ODM_REDLINE_ATTRIBUTE
3-105 ODM_REDLINE_MSATTRIBUTE
3-106 ODM_REFDESIG
3-107 ODM_REGULATION
3-108 ODM_RELATIONSHIP
3-109 ODM_RESPONSE
3-110 ODM_RESPONSE_HEADER
3-111 ODM_RESPONSE_RFQ_MAPPING
3-112 ODM_RES_SUBSTANC_COMPLIANCE
3-113 ODM_RESULT_OBJ_COMPLIANCE
3-114 ODM_REV
3-115 ODM_REV_CHG_ORDERS
3-116 ODM_REV_CHG_REQS
3-117 ODM_REV_DEVIATION
3-118 ODM_REV_DOCS
3-119 ODM_REV_MFR_ORDERS
3-120 ODM_REV_PARTS
3-121 ODM_REV_PRCE_CHGORDS
3-122 ODM_REV_SITE_CHGORDS
3-123 ODM_REV_STOP_SHIPS
3-124 ODM_RFQ_COMMENT_RECIPIENT
3-125 ODM_RFQ_COMMENTS
3-126 ODM_RFQ_HEADER
3-127 ODM_RFQ_LINE
3-128 ODM_RGULTN_P2_MAPPING
3-129 ODM_ROLLUP_COMPOSIT_DECL
3-130 ODM_ROLLUP_COMPOSITION
3-131 ODM_SC_AML
3-132 ODM_SC_BOM
3-133 ODM_SC_COMMENT
3-134 ODM_SC_COST_QTY_ROLLUP
3-135 ODM_SC_DELTA_BOM
3-136 ODM_SC_ITEM
3-137 ODM_SC_PROJECT_SITES
3-138 ODM_SC_SUPPLIERS
3-139 ODM_SC_WORK_IN_PROGRESS
3-140 ODM_SIGNOFF
3-141 ODM_SIMPLE_RELATION
3-142 ODM_SIMPLE_VISIT_HISTORY
3-143 ODM_SITE
3-144 ODM_SITES
3-145 ODM_SPECIFIC_SUBSTANCES
3-146 ODM_SUBSCRIPTIONS
3-147 ODM_SUBSTANCE_GROUPS
3-148 ODM_SUBSTANCE_MATERIALS
3-149 ODM_SUBSTANCE_SUBPARTS
3-150 ODM_SUBSTANCE_SUBSTANCES
3-151 ODM_TA_ESC
3-152 ODM_TEAM
3-153 ODM_TEAM_BASELINE
3-154 ODM_TIMESHEET
3-155 ODM_USAGE_HISTORY
3-156 ODM_USER_ASSIGNMENT
3-157 ODM_USER_FUNCTION_MAP
3-158 ODM_USER_GROUP
3-159 ODM_USER_ROLE
3-160 ODM_USER_SITE
3-161 ODM_USER_USAGE_HISTORY
3-162 ODM_VERSION
3-163 ODM_VISIT_HISTORY
3-164 ODM_WORKFLOW_METADATA
3-165 ODM_WORKFLOW_PROCESS
3-166 PARAMETER
3-167 PROPERTYTABLE
3-168 TLOG
3-169 TLOGLEVEL
3-170 VERSION
3-171 VLOG
