In this blog, I will be talking about the tables that are
created in the backend in the relational system after an EPM installation. This
is quite interesting to see since this is the nuts and bolts and rivets that
make up the EPM system.
I will outline the general method in which I have obtained
the tables since it is very well possible that some tables may be missing
because of different components that are chosen during the install.
Step 1 involved
me creating the following schemas in Oracle:-
- HYP_HSS -> Used for Hyperion Shared services
- HYP_EAS -> Used for EAS
- HYP_ESSSTD -> Used for Essbase Studio
- HYP_FCM -> Used for Financial Close Management
- HYP_FDMEE -> Used for FDMEE
- HYP_PCM -> Used for Profitability and Cost Management
- HYP_PLAN -> Used for Hyperion Planning. This is not the schema we use to create an application.
- HYP_RA -> Used for Reporting and Analysis.
Step 2 involved an EPM installation and configuration using these schemas. Couple of snapshots where the schemas being used is shown below:-
Step 3 involved
me logging into the schemas and checking the tables in the schema. Since all
the schemas are created fresh, ideally, there would not be any tables there.
The list of tables in the schemas are as follows.
Tables in Hyperion Shared
Services schema:-
1.
ANNOT_CONTEXTS14
2.
ANNOT_ELEMENT_GROUP114
3.
ANNOT_ELEMENT_GROUP214
4.
ANNOT_ELEMENT_GROUP314
5.
ANNOT_ELEMENT_GROUPS14
6.
ANNOT_ELEMENT_SETS14
7.
ANNOT_ELEMENT_VALUES14
8.
ANNOT_ELEMENTS14
9.
CES_ACL_INFO
10.
CES_APPS
11.
CES_AUTO_PROCESS_TASK
12.
CES_MESSAGES
13.
CES_PARTICIPANT_EVENTS
14.
CES_PARTICIPANT
15.
CES_PROCESS_DEF
16.
CES_PUSH_AUTO_PROCESS_TASK
17.
CES_SYSTEM
18.
CES_TASKS_RESULT
19.
CES_TASKS
20.
CES_USERS
21.
CES_WF_INSTANCES
22.
CONFIG_HISTORY
23.
CSS_DELEGATED_LIST
24.
CSS_DELEGATED_MEMBERS
25.
CSS_GROUP_CACHE_DELTA
26.
CSS_GROUP_MEMBERS
27.
CSS_GROUPS
28.
CSS_IDENTITY
29.
CSS_MEMBER_TYPE
30.
CSS_PROVISIONING_INFO
31.
CSS_ROLE_LOCALES
32.
CSS_ROLE_MEMBERS
33.
CSS_ROLES
34.
CSS_USER_PREFERENCES
35.
CSS_USERS
36.
EPM_REGISTRY_LOCK
37.
ESS_CLUSTER_SERVER_MAPPING
38.
ESS_FAILOVER_LEASE_OWNER
39.
ESS_FAILOVER_LEASE
40.
ESS_FAILOVER_RESOURCE
41.
FR_SCHEDULER_DATA14
42.
FR_USERPREFS
43.
HDB_SCHEDULED_TASKS
44.
HSS_COMPONENT_FILES
45.
HSS_COMPONENT_LINKS
46.
HSS_COMPONENT_PROPERTY_VALUES
47.
HSS_COMPONENT_TIERS
48.
HSS_COMPONENT_TYPES
49.
HSS_COMPONENT
50.
LCM_MIGRATION_TASK_DETAILS
51.
LCM_MIGRATION_TASK
52.
LCM_MIGRATION
53.
PRODUCT
54.
QRTZ_BLOB_TRIGGERS
55.
QRTZ_CALENDARS
56.
QRTZ_CRON_TRIGGERS
57.
QRTZ_FIRED_TRIGGERS
58.
QRTZ_JOB_DETAILS
59.
QRTZ_JOB_LISTENERS
60.
QRTZ_LOCKS
61.
QRTZ_PAUSED_TRIGGER_GRPS
62.
QRTZ_SCHEDULER_STATE
63.
QRTZ_SIMPLE_TRIGGERS
64.
QRTZ_TRIGGER_LISTENERS
65.
QRTZ_TRIGGERS
66.
REPOSITORY_OBJECT_ACLS
67.
REPOSITORY_OBJECT_PROP_INDEX
68.
REPOSITORY_OBJECT_PROPERTIES
69.
REPOSITORY_OBJECTS
70.
SMA_APPLICATION_CONFIG_MAP
71.
SMA_AUDIT_AREA_DIM
72.
SMA_AUDIT_ATTRIBUTE_FACT
73.
SMA_AUDIT_FACT
74.
SMA_CONFIG
75.
SMA_FILTER_DIM
76.
SMA_GLOBAL_CONFIG_MAP
77.
SMA_GLOBAL_SETTING
78.
SMA_PROJECT_CONFIG_MAP
79.
SMA_TASK_DIM
80.
SMA_TEMP_LCM_IN
81.
SMA_TEMP_USER_IN
82.
V8_KPS_ACTION_QUEUE14
83.
V8_METATYPE14
84.
V8_MON_POLL14
85.
V8_SRCH_CONT_EVENT14
86.
WKS_GROUP
87.
WKS_IDENTITY_XREF
88.
WKS_IDENTITY
89.
WKS_PROPERTY
90.
WKS_ROLE
91.
WKS_SUBJECT
92.
WKS_USER
93.
WKS_VERSION
Tables in Hyperion
EAS schema:-
1.
SERVERLOGID
2.
SERVERLOGDETAIL
3.
LOGCONDITION
4.
LOGCONDITION_DETAIL
Tables in Hyperion
Planning schema:-
1.
HSPSYS_CLUSTER
2.
HSPSYS_DATASOURCE
3.
HSPSYS_APPLICATION
4.
HSPSYS_APP_CLUSTER_DTL
5.
HSPSYS_PROPERTIES
Tables in Hyperion
FDMEE schema:-
1.
AIF_SOURCE_SYSTEMS
2.
AIF_CHART_OF_ACCOUNTS
3.
AIF_COA_SEGMENTS
4.
AIF_COA_SEGMENTS_TL
5.
AIF_COA_SEGMENT_TREES
6.
AIF_EBS_COA_SEGMENTS
7.
AIF_COA_LEDGERS
8.
AIF_TARGET_APPLICATIONS
9.
AIF_TARGET_APPL_DIMENSIONS
10.
AIF_DIMENSIONS_UPG
11.
AIF_TARGET_APPL_PROPERTIES
12.
AIF_MAPPING_RULES
13.
AIF_MAP_RULE_LINES
14.
AIF_MAP_DIM_DETAILS
15.
AIF_TARGET_APPL_DIM_MEMS
16.
AIF_MAP_HIERARCHIES
17.
AIF_MAP_HIER_DETAILS
18.
AIF_MAP_HIER_COMPONENT_T
19.
AIF_MAP_HIER_CONCAT_T
20.
AIF_BALANCE_RULES
21.
AIF_BAL_RULE_DETAILS
22.
AIF_BAL_RULE_LOADS
23.
AIF_GL_LOAD_AUDIT
24.
AIF_APPL_LOAD_AUDIT
25.
AIF_APPL_LOAD_PRD_AUDIT
26.
AIF_PURGE_RULES
27.
AIF_EBS_RESPONSIBILITY_STG
28.
AIF_EBS_COA_SEGMENTS_STG
29.
AIF_EBS_COA_SEGMENTS_TL_STG
30.
AIF_EBS_GL_ST_AC_UOM_STG
31.
AIF_DIM_MEMBERS_STG
32.
AIF_DIM_MEMBERS_STG_T
33.
AIF_DIM_HIERARCHIES_STG
34.
AIF_DIM_HIERARCHIES_STG_T
35.
AIF_EBS_FLEX_NM_HIER_STG
36.
AIF_TREES_STG
37.
AIF_TREES_TL_STG
38.
AIF_TREE_VERSIONS_STG
39.
AIF_TREE_VERSIONS_TL_STG
40.
AIF_EBS_GL_CCID_STG
41.
AIF_EBS_GL_BALANCES_STG
42.
AIF_GL_PERIODS_STG
43.
AIF_EXCHANGE_RATES_STG
44.
AIF_LOOKUP_STG
45.
AIF_SEQUENCES
46.
AIF_VERSIONS
47.
AIF_PROCESSES
48.
AIF_PROCESS_DETAILS
49.
AIF_PROCESS_STEPS
50.
AIF_PROCESS_LOGS
51.
AIF_LANGUAGES
52.
AIF_LOOKUP_TYPES
53.
AIF_LOOKUP_VALUES
54.
AIF_LOOKUP_VALUES_TL
55.
AIF_CURRENCY_LOOKUPS
56.
IM_DIMENSION
57.
IM_DIMENSION_ASSOCIATION
58.
IM_LOAD_INFO
59.
AIF_HS_DIM_MEMBER
60.
AIF_HS_DIM_HIERARCHY
61.
AIF_HS_DIM_PROPERTYARRAY
62.
AIF_HS_EXCHANGE_RATES
63.
AIF_EBS_GL_DAILY_BAL_STG
64.
AIF_PS_CF_METADATA
65.
AIF_PS_VALUE_SETS
66.
AIF_PS_SETID_TBL_STG
67.
AIF_PS_SET_CNTRL_TBL_STG
68.
AIF_PS_SET_CNTRL_REC_STG
69.
AIF_PS_SET_CNTRL_TREE_STG
70.
AIF_PS_PSRECDEFN_STG
71.
AIF_PS_PSRECFIELD_STG
72.
AIF_PS_FS_CF_TEMPLATE_STG
73.
AIF_PS_PSDBFLDLABLLANG_STG
74.
AIF_PS_FS_FLD_PROMPT_STG
75.
AIF_PS_BUS_UNIT_TBL_FS_STG
76.
AIF_PS_BUS_UNIT_LANG_STG
77.
AIF_PS_BUS_UNIT_TBL_GL_STG
78.
AIF_PS_LED_TMPLT_TBL_STG
79.
AIF_PS_LED_GRP_TBL_STG
80.
AIF_PS_LED_GRP_LANG_STG
81.
AIF_PS_LED_DEFN_TBL_STG
82.
AIF_PS_LED_DEFN_LANG_STG
83.
AIF_PS_LED_GRP_LED_TBL_STG
84.
AIF_PS_BU_LED_GRP_TBL_STG
85.
AIF_PS_PSTREESTRCT_STG
86.
AIF_PS_PSTREEDEFN_STG
87.
AIF_PS_PSTREEDEFNLANG_STG
88.
AIF_PS_BD_SCENARIO_TBL_STG
89.
AIF_PS_BOOK_CODE_TBL_STG
90.
AIF_PS_BU_BOOK_TBL_STG
91.
AIF_PS_LEDGER_STG
92.
AIF_LOOKUP_MAPPINGS
93.
TPOVPARTITION
94.
TPOVPERIOD
95.
TPOVPERIODADAPTOR
96.
TPOVCATEGORY
97.
TPOVCATEGORYADAPTOR
98.
TBHVIMPGROUP
99.
TBHVIMPITEMFILE
100.
TBHVIMPITEMERPI
101.
TINTDIMENSIONDEF
102.
TDATAMAP
103.
TDATAMAP_T
104.
TDATAMAPSEG
105.
TDATASEG
106.
TDATASEG_T
107.
AIF_WRITEBACK_RULES
108.
AIF_WRITEBACK_RULE_FLTRS
109.
AIF_FS_GL_BALANCES_CUBES_STG
110.
AIF_FDM_APPLICATIONS
111.
AIF_PROCESS_PERIODS
112.
TPOVPERIODADJUSTMENT
113.
AIF_BAL_RULE_PARAMS
114.
AIF_BAL_RULE_LOAD_PARAMS
115.
AIF_BATCHES
116.
AIF_BATCH_LOAD_AUDIT
117.
AIF_BATCH_JOBS
118.
AIF_OPEN_INTERFACE
119.
AIF_LEDGER_GROUPS
120.
AIF_LEDGER_GROUP_LEDGERS
121.
AIF_MAPPING_RULES_UPG
122.
AIF_PROFILE_OPTIONS
123.
AIF_PROFILE_OPTION_VALUES
124.
AIF_PS_KK_BUDGET_TYPE_STG
125.
AIF_PS_KK_SUBTYPE_STG
126.
AIF_PS_KK_FILTER_STG
127.
AIF_PS_KK_KEY_CF_STG
128.
AIF_PS_BUL_CNTL_BUD_STG
129.
AIF_PS_KK_CF_VALUE_STG
130.
AIF_SRC_ADAPTERS
131.
AIF_SRC_ADAPTER_PARAMETERS
132.
AIF_SRC_ADAPTER_PARAM_PROMPTS
133.
AIF_SRC_ADAPTER_DRILL_URLS
134.
AIF_SRC_ADAPTER_DRILL_PROMPTS
135.
TBHVIMPITEMADAPTER
136.
TPOVPERIODSOURCE
137.
AIF_SEC_USER_GROUPS
138.
TDATAMAP_STG
139.
AIF_ARTIFACT_AUDIT
140.
AIF_HS_DRM_LOADS
141.
AIF_HS_DRM_LOAD_HIERARCHIES
142.
AIF_MAP_DIM_DETAILS_FILE
143.
AIF_PATCHES
144.
AIF_ROLE_FUNCTIONS
145.
TBHVLOGICGROUP
146.
TBHVLOGICITEM
147.
TBHVLOGICITEMCRITERIA
148.
TBHVVALENTGROUP
149.
TBHVVALENTITEM
150.
TBHVVALRULEGROUP
151.
TBHVVALRULEITEM
152.
TBHVVALRULEITEMTARGETCELL
153.
TDATACHECK
154.
TDATACHECKTARGVALUE
155.
TLOGPROCESS
156.
TLOGPROCESSSTATES
157.
TQUERYDEFINITION
158.
TREPORTGROUP
159.
TREPORTGROUP_TL
160.
TREPORT
161.
TREPORT_TL
162.
TREPORTPARAMETER
163.
TREPORTPARAMETER_TL
164.
AIF_PROCESS_PARAMETERS
165.
AIF_APPL_CALC_SCRIPTS
166.
AIF_APPL_CALC_SCRIPT_PARMS
167.
TBHVVALENTITEMPARM
168.
TDATAARCHIVE
169.
AIF_BATCH_GROUPS
170.
AIF_CB_KEY_SEGMENTS
171.
TDATAMEMOITEMS
172.
AIF_SOURCE_SYSTEM_OPTIONS
173.
AIF_TARGET_APPL_MEMBERS
174.
AIF_TEMP
175.
SNP_ACTION
176.
SNP_AGENT
177.
SNP_AGENT_PROP
178.
SNP_AGENT_PROP_LST
179.
SNP_ALLOC_AGENT
180.
SNP_CONNECT
181.
SNP_CONNECT_PROP
182.
SNP_CONTEXT
183.
SNP_CONV_DT
184.
SNP_DATA
185.
SNP_DATASOURCE
186.
SNP_DT
187.
SNP_ENTITY
188.
SNP_ENT_ID
189.
SNP_ESS
190.
SNP_FF_VALUEM
191.
SNP_FIELD
192.
SNP_FIELD_LOOKUP
193.
SNP_FLEX_FIELD
194.
SNP_GRP_ACTION
195.
SNP_HIST_VERSION
196.
SNP_HOST
197.
SNP_HOST_MOD
198.
SNP_INDEX_TYPE
199.
SNP_INST_OBJ
200.
SNP_LAGENT
201.
SNP_LANG
202.
SNP_LANG_ELT
203.
SNP_LANG_TECHNO
204.
SNP_LB_AGENT
205.
SNP_LE_TECHNO
206.
SNP_LICENSE
207.
SNP_LINE_ACTION
208.
SNP_LINK
209.
SNP_LOC_REP
210.
SNP_LOOKUP
211.
SNP_LOOKUP_VALUE
212.
SNP_LSCHEMA
213.
SNP_METHOD
214.
SNP_MODULE
215.
SNP_MORIG_TXT
216.
SNP_MTXT
217.
SNP_MTXT_PART
218.
SNP_M_IMPORT_REP
219.
SNP_OBJECT
220.
SNP_OPEN_TOOL
221.
SNP_PROFILE
222.
SNP_PROF_METH
223.
SNP_PSCHEMA
224.
SNP_PSCHEMA_CONT
225.
SNP_PWD_POLICY
226.
SNP_PWD_RULE
227.
SNP_REM_REP
228.
SNP_SOLUTION
229.
SNP_SOL_ELT
230.
SNP_SUB_LANG
231.
SNP_TECHNO
232.
SNP_USER
233.
SNP_USER_METH
234.
SNP_USER_OBJ_METH
235.
SNP_USER_PREF
236.
SNP_USER_PROF
237.
SNP_U_O_M_REP
238.
SNP_VERSION
239.
AIF_WRITEBACK_LOADS
240.
AIF_WRITEBACK_LOAD_DTLS
241.
TDATASEGW
242.
AIF_WRITEBACK_ESS_DATA_T
243.
AIF_PS_BUS_UNIT_TBL_HR_STG
244.
AIF_PS_GL_ACCOUNT_TBL_STG
245.
AIF_PS_DEPT_CF_TBL_STG
246.
AIF_PS_PROJECT_TBL_STG
247.
AIF_PS_PRODUCT_TBL_STG
248.
AIF_PS_FUND_TBL_STG
249.
AIF_PS_PROGRAM_TBL_STG
250.
AIF_PS_CLASS_CF_TBL_STG
251.
AIF_PS_AFFILIATE_VW_STG
252.
AIF_PS_OPER_UNIT_TBL_STG
253.
AIF_PS_ALTACCT_TBL_STG
254.
AIF_PS_BUD_REF_TBL_STG
255.
AIF_PS_CHARTFIELD1_TBL_STG
256.
AIF_PS_CHARTFIELD2_TBL_STG
257.
AIF_PS_CHARTFIELD3_TBL_STG
258.
AIF_PS_NAMES_STG
259.
AIF_PS_JOBCODE_TBL_STG
260.
AIF_PS_DEPT_TBL_STG
261.
AIF_PS_UNION_TBL_STG
262.
AIF_PS_LOCATION_TBL_STG
263.
AIF_PS_SAL_PLAN_TBL_STG
264.
AIF_PS_SAL_GRADE_TBL_STG
265.
AIF_PS_SAL_STEP_TBL_STG
266.
AIF_PS_EARNINGS_TBL_STG
267.
AIF_PS_BENEF_PLAN_TBL_STG
268.
AIF_PS_POSITION_DATA_STG
269.
AIF_PS_JOB_STG
270.
AIF_PS_BP_JOB_STG
271.
AIF_PS_ACCT_CD_TBL_STG
272.
AIF_PS_PAYGROUP_TBL_STG
273.
AIF_PS_JOB_EARNS_DIST_STG
274.
AIF_PS_DEPT_BUDGET_ERN_STG
275.
AIF_PS_NEEDDIST_TMP
276.
AIF_PS_ACCTDIST_TMP
277.
AIF_PSXLATITEMLANG_STG
278.
AIF_TAB_COLUMNS
279.
AIF_TAB_COLUMNS_TL
280.
AIF_HR_MAP_RULES
281.
AIF_HR_MAP_RULE_POVS
282.
AIF_HR_MAP_RULE_POV_DTLS
283.
AIF_HR_MAP_RULE_DETAILS
284.
AIF_HR_MAP_RULE_LOADS
285.
AIF_HR_MAP_RULE_LOAD_DTLS
286.
AIF_HS_HR_DATA
287.
SNP_EXP_TXT
288.
SNP_EXP_TXT_HEADER
289.
SNP_FF_VALUEE
290.
SNP_ID
291.
SNP_IMPORT_REP
292.
SNP_LOAD_PLAN
293.
SNP_LOCK
294.
SNP_LOCKED_OBJECT
295.
SNP_LOC_REPW
296.
SNP_LPI_EC_VAR_LOG
297.
SNP_LPI_EXC_LOG
298.
SNP_LPI_RUN
299.
SNP_LPI_STEP
300.
SNP_LPI_STEP_LOG
301.
SNP_LPI_STEP_VAR
302.
SNP_LPI_TXT_LOG
303.
SNP_LPI_VAR
304.
SNP_LPI_VAR_LOG
305.
SNP_LP_INST
306.
SNP_LP_STEP
307.
SNP_LP_STEP_VAR
308.
SNP_LP_VAR
309.
SNP_PARAM_LPI_RUN
310.
SNP_PARAM_SESS
311.
SNP_PLAN_AGENT
312.
SNP_SCEN
313.
SNP_SCEN_FOLDER
314.
SNP_SCEN_REPORT
315.
SNP_SCEN_STEP
316.
SNP_SCEN_TASK
317.
SNP_SCEN_TXT
318.
SNP_SEQ_DATA
319.
SNP_SEQ_SCEN
320.
SNP_SEQ_SESS
321.
SNP_SESSION
322.
SNP_SESS_FOLDER
323.
SNP_SESS_STEP
324.
SNP_SESS_STEP_LV
325.
SNP_SESS_TASK
326.
SNP_SESS_TASK_LOG
327.
SNP_SESS_TASK_LS
328.
SNP_SESS_TXT_LOG
329.
SNP_STEP_LOG
330.
SNP_STEP_REPORT
331.
SNP_TASK_TXT
332.
SNP_VAR_DATA
333.
SNP_VAR_PLAN_AGENT
334.
SNP_VAR_SCEN
335.
SNP_VAR_SESS
336.
SNP_COL
337.
SNP_COND
338.
SNP_DATA_SET
339.
SNP_DIAGRAM
340.
SNP_DIAG_PARAM
341.
SNP_FF_VALUEW
342.
SNP_FOLDER
343.
SNP_GRP_STATE
344.
SNP_INDIRECT_MREF
345.
SNP_JOIN
346.
SNP_JOIN_COL
347.
SNP_KEY
348.
SNP_KEY_COL
349.
SNP_LINE_TRT
350.
SNP_LINE_TRT_UE
351.
SNP_LINK_COORD
352.
SNP_LINK_DIAG
353.
SNP_MISSING_REF
354.
SNP_MODEL
355.
SNP_MOD_FOLDER
356.
SNP_OBJECT_ID
357.
SNP_OBJECT_ID_COL
358.
SNP_OBJ_DIAG
359.
SNP_OBJ_STATE
360.
SNP_OBJ_TRACE
361.
SNP_ORIG_TXT
362.
SNP_PACKAGE
363.
SNP_PARTITION
364.
SNP_POP
365.
SNP_POP_CLAUSE
366.
SNP_POP_COL
367.
SNP_POP_CONSTRAINT
368.
SNP_POP_CONTEXT
369.
SNP_POP_MAPPING
370.
SNP_PROJECT
371.
SNP_REV_COL
372.
SNP_REV_COL_FFV
373.
SNP_REV_COND
374.
SNP_REV_COND_FFV
375.
SNP_REV_FOR_TABLE
376.
SNP_REV_JOIN
377.
SNP_REV_JOIN_COL
378.
SNP_REV_JOIN_FFV
379.
SNP_REV_KEY
380.
SNP_REV_KEY_COL
381.
SNP_REV_KEY_FFV
382.
SNP_REV_MODEL_FFV
383.
SNP_REV_PARTITION
384.
SNP_REV_SUB_MODEL
385.
SNP_REV_TABLE
386.
SNP_REV_TABLE_FFV
387.
SNP_SEQUENCE
388.
SNP_SOURCE_TAB
389.
SNP_SRC_SET
390.
SNP_STATE
391.
SNP_STATE2
392.
SNP_STEP
393.
SNP_SUB_MODEL
394.
SNP_TABLE
395.
SNP_TRT
396.
SNP_TXT
397.
SNP_TXT_CROSSR
398.
SNP_TXT_HEADER
399.
SNP_UE_ORIG
400.
SNP_UE_USED
401.
SNP_UFUNC
402.
SNP_UFUNC_IMPL
403.
SNP_UFUNC_TECHNO
404.
SNP_USER_EXIT
405.
SNP_VAR
Tables in Essbase
Studio Schema:-
1.
CP_CLASS
2.
CP_CONNECTION
3.
CP_DATAPOINT
4.
CP_NONE_PROPERTIES_INTEGER
5.
CP_NONE_PROPERTIES_LONG
6.
CP_NONE_PROPERTIES_BOOLEAN
7.
CP_NONE_PROPERTIES_CATEGORICAL
8.
CP_NONE_PROPERTIES_DATETIME
9.
CP_NONE_PROPERTIES_DATE
10.
CP_NONE_PROPERTIES_DATEPERIOD
11.
CP_NONE_PROPERTIES_BINARY
12.
CP_NONE_PROPERTIES_NUMBER
13.
CP_NONE_PROPERTIES_STRING
14.
CP_NONE_PROPERTIES_ID
15.
CP_DATASET
16.
CP_DOMAIN
17.
CP_EXPRESSION
18.
CP_FACT
19.
CP_FACTSET
20.
CP_FOLDER
21.
CP_HIERARCHY
22.
CP_INSTANCE
23.
CP_LOGICALELEMENT
24.
CP_LOGININFO
25.
CP_MEMBER
26.
CP_NONE_IDS
27.
CP_NONE_TRANSACTIONS
28.
CP_PACKAGE
29.
CP_REFERENCE
30.
CP_RULE
31.
CP_SCHEMA
32.
CP_SOURCE
33.
CP_SOURCECOMPONENT
34.
CP_TWIN
35.
CP_TWINSET
36.
CP_UNIT
37.
CP_USER
38.
CP_FORM
39.
CP_ROLE
40.
CP_GROUP
41.
CP_AUTHORITY
42.
CP_SERVER_KEY
43.
CP_ALIAS
44.
CP_ALIASSET
Tables in
Financial Close Management Schema:-
1.
S_ROW_ID
2.
FCM_USERS
3.
FCM_TEAMS
4.
FCM_TEAM_USERS
5.
FCM_SETTINGS
6.
FCM_CURRENCIES
7.
FCM_FILTERS
8.
FCM_CONDITIONS
9.
FCM_ATTRIBUTES
10.
FCM_ATTRIBUTE_LIST_VALUES
11.
FCM_REPORT_ACCESS
12.
FCM_REPORT_GROUPS
13.
FCM_REPORT_GROUPS_TL
14.
FCM_REPORT_PARAMETERS
15.
FCM_REPORT_PARAMETERS_TL
16.
FCM_REPORT_QUERIES
17.
FCM_REPORT_QUERIES_TL
18.
FCM_REPORTS
19.
FCM_REPORTS_TL
20.
FCM_REPORT_GROUP_MEMBERS
21.
FCM_NOTIF_CATEGORIES
22.
FCM_BATCH_EMAIL_DATA
23.
FCM_USER_NOTIF_PREFS
24.
FCM_USER_HISTORY
25.
FCM_ORG_UNITS
26.
FCM_ACCESS
27.
FCM_TASK_STEP_RESULTS
28.
FCM_CALENDARS
29.
FCM_HOLIDAY_RULES
30.
FCM_HOLIDAYS
31.
WL_LLR_FINANCIALCLOSE0
32.
WL_LLR_TAXMANAGEMENT0
33.
WL_LLR_EPMSERVER0
34.
WL_LLR_SOA_SERVER1
35.
FCM_INTEGRATIONS
36.
FCM_INTEGRATIONS_TL
37.
FCM_PARAMETERS
38.
FCM_PARAMETERS_TL
39.
FCM_PARAMETER_LOVS
40.
FCM_PARAMETER_LOVS_TL
41.
FCM_PARAMETER_DEPS
42.
FCM_CALCULATIONS
43.
FCM_CALCULATION_ITEMS
44.
FCM_RULES
45.
FCM_HISTORY_FIELDS
46.
FCM_HISTORY_CHANGE_TYPES
47.
FCC_YEARS
48.
FCC_WORKFLOW_ACTIONS
49.
FCC_USER_ATTRIBUTE_VALUES
50.
FCC_TEXT
51.
FCC_TEMPLATES
52.
FCC_TASKS
53.
FCC_TASK_TYPES_TL
54.
FCC_TASK_TYPES
55.
FCC_TASK_PREDECESSORS
56.
FCC_TASK_PARAMETER_VALUES
57.
FCC_TASK_PARAMETER_PROPS
58.
FCC_STATUSES
59.
FCC_REFERENCES
60.
FCC_QUESTIONS
61.
FCC_QUESTION_LIST_VALUES
62.
FCC_QUESTION_ANSWERS
63.
FCC_PORTLETS
64.
FCC_PERIODS
65.
FCC_LOOKUP
66.
FCC_INTEGRATION_APPS
67.
FCC_HISTORY
68.
FCC_EMBEDDED_TEMPLATES
69.
FCC_DEPLOYMENTS
70.
FCC_DAY_LABELS
71.
FCC_COMPOSITE_TEMPLATES
72.
FCC_COMMENTS
73.
FCC_CALENDAR_DAYS
74.
FCC_BPEL_INSTANCES
75.
FCC_ALERTS
76.
FCC_ALERT_TYPES
77.
FCC_ACCESS
78.
FCC_INTEGRATION_APP_PARAMS
79.
FCC_TASK_STEP_RESULTS
80.
FCC_GLOBAL_INTEGRATION_TOKENS
81.
FCC_ACCESS_SNAPSHOT
82.
FCC_ASSIGNMENT_REQUEST_ITEMS
83.
FCC_ASSIGNMENT_REQUESTS
84.
FCC_ROLE_ACCESS
85.
ARM_WORKFLOW_ACTIONS
86.
ARM_TRANSACTION_SUMMARIES
87.
ARM_TRANSACTION_AMOUNTS
88.
ARM_TRANSACTIONS
89.
ARM_TDATASEG_T
90.
ARM_SUMMARY_AMOUNTS
91.
ARM_STATUSES
92.
ARM_REFERENCES
93.
ARM_RECONCILIATION_BUCKETS
94.
ARM_RECONCILIATIONS
95.
ARM_RATE_TYPES
96.
ARM_QUESTION_LIST_VALUES
97.
ARM_QUESTIONS
98.
ARM_PROCESSES
99.
ARM_PORTLETS
100.
ARM_PERIODS
101.
ARM_LOOKUP
102.
ARM_INSTRUCTIONS
103.
ARM_HISTORY
104.
ARM_FREQUENCIES
105.
ARM_FORMAT_LABELS
106.
ARM_FORMAT_ATTRIBUTES
107.
ARM_FORMATS
108.
ARM_DATALOAD_TREE
109.
ARM_DATALOAD_RULES
110.
ARM_DATALOAD_EXECUTION
111.
ARM_CURRENCY_RATES
112.
ARM_CURRENCY_BUCKETS
113.
ARM_COMMENTS
114.
ARM_BALANCES
115.
ARM_ATTRIBUTE_VALUES
116.
ARM_ANSWERS
117.
ARM_AGING_PROFILES
118.
ARM_AGING_BUCKETS
119.
ARM_ACCOUNT_TYPES
120.
ARM_ACCESS
121.
ARM_GLOBAL_INTEGRATION_TOKENS
122.
ARM_WORKFLOW_HISTORY
123.
ARM_ASSIGNMENT_REQUESTS
124.
ARM_ASSIGNMENT_REQUEST_ITEMS
125.
ARM_SUMMARY_REC_CHILDREN
126.
ARM_SUMMARY_BALANCES
127.
ARM_PERIOD_FREQUENCIES
128.
ARM_DATALOADS
129.
ARM_DATALOAD_LOCATIONS
130.
ARM_SUMMARY_RECON_MISSING_RATE
131.
ARM_AMORTIZATION_SCHEDULE
132.
ARM_AMORTIZATIONS
133.
ARM_ROLE_ACCESS
134.
ARM_ACTION_PLAN
135.
ARM_PERIOD_CALENDARS
136.
SDM_INSTRUCTION
137.
SDM_REFERENCE
138.
SDM_HISTORY
139.
SDM_COMMENT
140.
SDM_CONNECTION
141.
SDM_INTEGRATION
142.
SDM_INTEGRATION_DIM
143.
SDM_INTEGRATION_DIM_ATTRIB
144.
SDM_CURRENCY
145.
SDM_FREQUENCY
146.
SDM_YEAR
147.
SDM_PERIOD
148.
SDM_SCENARIO
149.
SDM_ENTITY
150.
SDM_DATA_COLLECTION_PERIOD
151.
SDM_SYSTEM_PREFERENCES
152.
SDM_DIMENSION
153.
SDM_DIMENSION_ATTRIBUTE
154.
SDM_DIM_ATTRIBUTE_LIST_VAL
155.
SDM_DATA_SET
156.
SDM_DATA_SET_COLUMN
157.
SDM_DATA_SET_CLMN_LIST_VAL
158.
SDM_SV_TEMPLATE
159.
SDM_FORM
160.
SDM_FORM_SECTION
161.
SDM_FORM_COLUMN
162.
SDM_FORM_GROUP_BY
163.
SDM_FORM_MAPPING
164.
SDM_FORM_DCU
165.
SDM_FORM_ACCESS
166.
SDM_FORM_QUESTION
167.
SDM_FORM_QUESTION_LIST_VAL
168.
SDM_FORM_DEPLOY
169.
SDM_FORM_INSTANCE
170.
SDM_FORM_INS_ACCESS
171.
SDM_FORM_INS_ANSWER
172.
SDM_FORM_INS_POST
173.
SDM_STATUSES
174.
SDM_PORTLETS
175.
WL_LLR_ADMINSERVER
176.
ARM_DATALOAD_PROCESSING
177.
ARM_COPYTRANSACTIONS_PROC
Tables in
Profitability and Cost Management schema:-
1.
HPM_APPLICATION_TYPE
2.
HPM_APPLICATION
3.
HPM_APPLICATION_PREFERENCE
4.
HPM_ASSIGNMENT
5.
HPM_ASSIGNMENT_RULE
6.
HPM_CALC_SCRIPT
7.
HPM_DIM_MEM_GEN_LEV
8.
HPM_DIM_MEM_GRP
9.
HPM_DIM_MEM_GRP_MEM
10.
HPM_DIMENSION
11.
HPM_DIMENSION_ATTRIBUTE
12.
HPM_DIMENSION_MEMBER
13.
HPM_DIMENSION_MEMBER_ATTRIBUTE
14.
HPM_DIMENSION_MEMBER_PROP
15.
HPM_DIMENSION_PROP
16.
HPM_DIMENSION_TYPE
17.
HPM_DRIVER
18.
HPM_DRIVER_ASSOCIATION
19.
HPM_DRIVER_LAYER
20.
HPM_DRIVER_TYPE
21.
HPM_DRV_MSR_DIM_MEM_LOC
22.
HPM_DRV_MSR_DIM_MEM_MAP
23.
HPM_IMP_CONFIG
24.
HPM_IMP_CONFIG_LOG
25.
HPM_IMP_CONFIG_MAP
26.
HPM_IMP_CONFIG_MAP_ENTRY
27.
HPM_IMP_DB_CONN
28.
HPM_INSTALLATION
29.
HPM_INSTALLATION_PREFERENCE
30.
HPM_JOB_LOG
31.
HPM_LAYER
32.
HPM_LOOKUP_TYPE
33.
HPM_LOOKUP_TYPE_VALUE
34.
HPM_MDL_SRC_ND_CTX
35.
HPM_MODEL_CONTEXT
36.
HPM_CALC_PROC_TASK_MAP_S
37.
HPM_CALC_CONFIG_DETAIL_S
38.
HPM_CALC_CONFIG_DETAIL
39.
HPM_IMP_TUPLE_T
40.
HPM_IMP_NEW_TUPLE_T
41.
HPM_DRV_DIMGRP
42.
HPM_STGD_ASGN_RULE_SEL_T
43.
HPM_STGD_DRIVER_SEL_T
44.
HPM_STGD_DRIVER_EXCEP_T
45.
HPM_STG_ASGN_RULE_SEL_T
46.
HPM_STG_DRIVER_EXCEP_T
47.
HPM_STG_DRIVER_SEL_T
48.
HPM_CALC_RULE
49.
HPM_CALC_RULE_DRIVER
50.
HPM_CALC_RULE_ASG_RULE
51.
HPM_SV_QUERY
52.
HPM_APPD_DIMMEMBER
53.
HPM_ASSIGNMENT_RULE_TMP_POV
54.
HPM_DRIVER_ASSOCIATION_TMP_POV
55.
HPM_STAGE_DIMMEM_POS_MAP_TMP
56.
HPM_STGD_CALCRULE_SNGLSRC_T
57.
HPM_STGD_CALCRULE_CALCMSRS_T
58.
HPM_STGD_CALCRULE_MULTISRC_T
59.
HPM_STGD_CALCRULE_COL
60.
HPM_STG_ASSIGNMENT_T
61.
HPM_CALCULATION_PROGRAM
62.
HPM_CALC_PROG_RULE_SET
63.
HPM_CALC_PROG_RULE
64.
HPM_CALC_PROG_DIM_CONTEXT
65.
HPM_MODEL_VIEW
66.
HPM_MODEL_VIEW_DIMENSION
67.
HPM_USER_APP_PREFERENCE
68.
HPM_SERIAL_APP_LOCK
69.
HPM_STATISTIC
70.
HPM_STAT_COLLECTION
71.
HPM_STAT_DETAIL
72.
HPM_POV_DIM_MEM_GRP
73.
HPM_POV_STATE
74.
HPM_PREFERENCE_NAME
75.
HPM_PROP
76.
HPM_PROP_TYPE
77.
HPM_STAGE
78.
HPM_STAGE_DIMENSION
79.
HPM_STAGE_RULE
80.
HPM_JOB_LOG_LEVEL
81.
HPM_DRIVER_BASIS_TYPE
82.
HPM_DB_TYPE_DESC
83.
HPM_MODEL_CHANGE_EVENTS
84.
HPM_ALIAS_TABLE
85.
HPM_DIMENSION_ALIAS
86.
HPM_DIM_MEM_ALIAS
87.
HPM_APP_PREF_MAP
88.
HPM_DATA_ENTRY_VIEW
89.
HPM_DATA_ENTRY_DIM_MEM_VIEW
90.
HPM_TEMP_OBJECT
91.
HPM_MODEL_CONTEXT_TMP_POV
92.
HPM_MDL_SRC_ND_CTX_TMP_POV
93.
HPM_ASSIGNMENT_TMP_POV
94.
HPM_STG_ASSIGNMENT_TEMP
95.
HPM_SQL_LOG
96.
HPM_TABLE
97.
HPM_TABLE_COLUMN
98.
HPM_TABLE_JOINS
99.
HPM_TAB_PRIMARY_KEY_COL
100.
HPM_JOB
101.
HPM_CALCULATION
102.
HPM_CALCULATION_DATA_POV
103.
HPM_SQL_SCRIPT
104.
HPM_BULK_EDIT
105.
HPM_BULK_EDIT_SOURCE
106.
HPM_BULK_EDIT_DEST_ASGN_RULE
107.
HPM_BULK_EDIT_DEST_DRIVER
108.
HPM_BLK_EDT_IMP_TUPLE
109.
HPM_BLK_EDT_IMP_PIVOT
110.
HPM_BLK_EDT_IMP_T
111.
HPM_UPDATED_COLUMN
112.
HPM_OBJECT_USAGE_TYPE
113.
HPM_TEMP_OBJECT_COLUMN
114.
HPM_CALC_PROCESS_TYPE
115.
HPM_CALC_PROC_TEMPLATE
116.
HPM_CALC_PROCESS_TASK
117.
HPM_CALCULATION_PROCESS
118.
HPM_CALC_PROC_TASK_MAP
119.
HPM_CALC_PROC_TEMPLATE_S
120.
HPM_CALC_PROCESS_TASK_S
Tables in
Reporting and Analysis Schema:-
1.
V8_ASK_PARAMETER
2.
V8_BQ_SECTION
3.
V8_CNTNR_KEYWORDS
4.
V8_COLLECTION
5.
V8_COLLECTION_MBRS
6.
V8_CONTAINER
7.
V8_CONT_VERSION
8.
V8_DATABASE
9.
V8_DATA_CONTAINER
10.
V8_DBACCESS
11.
V8_DBCONNECT_PARMS
12.
V8_DBSERVER
13.
V8_DBSERVER_DB
14.
V8_DBTYPE
15.
V8_DOMAIN_PROPS
16.
V8_ENGINETYPE
17.
V8_ENV_VARS
18.
V8_EXCEPTION
19.
V8_EXECUTABLE
20.
V8_EXTLINK
21.
V8_FILE_SYSTEM_URL
22.
V8_FILE_TYPE
23.
V8_FLAGS
24.
V8_FOLDER
25.
V8_FOLDER_TREE
26.
V8_GC_LOCK
27.
V8_HOST
28.
V8_HTML_LAYOUT
29.
V8_INPUT_PARAMETER
30.
V8_INSTALL_SVC_GSM
31.
V8_INSTALL_SVC_LOG
32.
V8_JDBC
33.
V8_JOB_ACTIONS
34.
V8_JOB_CYCLES
35.
V8_LINK
36.
V8_METATYPE
37.
V8_METATYPE_EXT
38.
V8_OCE
39.
V8_OCE_FILE
40.
V8_OUTPUT_COLL
41.
V8_OUTPUT_MEMBER
42.
V8_OUT_MEM_ATTR
43.
V8_PARAMETER
44.
V8_PARAMETER_LIST
45.
V8_PARAM_VALUES
46.
V8_PARMMEMSELVALS
47.
V8_PARM_CUST_VALS
48.
V8_PGM_COLLECTION
49.
V8_PHYSRES
50.
V8_PHYSRES_VALS
51.
V8_PLATFORM
52.
V8_PRODUCT
53.
V8_PROGRAM
54.
V8_PUB_RATINGS
55.
V8_PUSHED_OBJECTS
56.
V8_QRY_DB_CONN
57.
V8_REQUIRED_FILES
58.
V8_SATYPE
59.
V8_SA_PROPS
60.
V8_SERVICEAGENT
61.
V8_SERVICE_MODE
62.
V8_SPFFILEOUTCOLL
63.
V8_SPF_FILE_COLL
64.
V8_SPF_OUT_OPTS
65.
V8_SQRINST_PROD
66.
V8_SQRPROGOUT
67.
V8_SQR_INSTANCE
68.
V8_SQR_PRODUCT
69.
V8_SS_SOURCE
70.
V8_SUB_SERVICE
71.
V8_USER_ATTRIBUTES
72.
V8_VERSION
73.
V8_VERSION_ATTRIBUTES
74.
V8_WHERE_CLAUSE
75.
V8_ABSTIMEEVENT
76.
V8_ASYNCJOBLOG
77.
V8_CALENDARYEAR
78.
V8_CUSTOMCALENDAR
79.
V8_CUSTOM_DATE
80.
V8_CUSTOM_PERIOD
81.
V8_DISTDEST
82.
V8_DISTDRVRSETNGS
83.
V8_DISTMESSAGE
84.
V8_DISTPARM
85.
V8_ETE_TRIGGER
86.
V8_EXTTRIGEVENT
87.
V8_JOBASKVALUES
88.
V8_JOBDEFINITION
89.
V8_JOBDEF_ACTIONS
90.
V8_JOBDEF_CUST_VAL
91.
V8_JOBDEF_CYCLES
92.
V8_JOBINPMULTVALS
93.
V8_JOBINPUTVALUES
94.
V8_JOBMEMSELVALS
95.
V8_MATCH_CANDIDATE
96.
V8_MSGBODYPART
97.
V8_NON_WORKING_DAY
98.
V8_RECURTIMEEVENT
99.
V8_RECUR_DOM
100.
V8_RECUR_DOW
101.
V8_RECUR_EVERY
102.
V8_RECUR_FSTORLST
103.
V8_RECUR_MONTHS
104.
V8_RECUR_TYPELY
105.
V8_RECUR_WOM
106.
V8_SCHEDADMINLOG
107.
V8_SCHEDULEDTASK
108.
V8_MASTER_SLAVE
109.
V8_SCHEDULELOG
110.
V8_SCHEDULEQUEUE
111.
V8_SCHEDULETIME
112.
V8_ST_DB_CONN
113.
V8_SUBSADMINLOG
114.
V8_SUBSCRIPTION
115.
V8_TASK
116.
V8_ACCESS_CTRL
117.
V8_AUTHEN_CONFIG
118.
V8_CSS_GROUP
119.
V8_CSS_ROLE
120.
V8_CSS_USER
121.
V8_EXTERN_GROUP
122.
V8_EXTERN_ROLE
123.
V8_EXTERN_USER
124.
V8_IDENTITY
125.
V8_METHODTABLE
126.
V8_MODELTABLE
127.
V8_PASSWORD
128.
V8_PERMMASKROLES
129.
V8_PERMMASKTYPE
130.
V8_PROP_DEFN
131.
V8_PROP_DEFN_ATTR
132.
V8_PROP_DEFN_CHILD
133.
V8_PROP_ENUM_VALUE
134.
V8_PROP_TYPE
135.
V8_PROP_VALIDATOR
136.
V8_PROP_VALUE
137.
V8_PUBMASK
138.
V8_RESMETHODASSC
139.
V8_RESOURCETYPE
140.
V8_RESOURCE_BUNDLE
141.
V8_RESOURCE_OWNER
142.
V8_RES_HIERARCHY
143.
V8_ROLEASSOC
144.
V8_ROLECONT
145.
V8_ROLEDEF
146.
V8_SCALAR_TYPE
147.
V8_SERVICE_PROPS
148.
V8_SUBJECT
149.
V8_USERROLEASSC
150.
V8_USAGE_ATTRIBUTES
151.
V8_USAGE_EVENT
152.
V8_USAGE_EVENT_JOB
153.
V8_USAGE_EVENT_KEYVAL
154.
V8_USAGE_EVENT_TYPE
155.
V8_USAGE_SERVICE_CLIENT
156.
V8_USAGE_TIMED_QUERY
157.
V8_H_CONSTANT
158.
V8_H_DOCUMENT
159.
V8_H_OBJECT_ID
160.
V8_H_SECTION
161.
V8_H_SECTION_DEP
162.
V8_H_HPSU_TABLE
163.
V8_H_HPSU_COLUMN
164.
V8_H_DB_DATABASE
165.
V8_H_DB_OWNER
166.
V8_H_DB_TABLE
167.
V8_H_DB_COLUMN
168.
V8_H_DM_SECTION
169.
V8_H_DM_TABLE
170.
V8_H_DM_COLUMN
171.
V8_H_DM_DIGEST
172.
V8_H_DM_META_DEP
173.
V8_H_DM_LEAF_COL
174.
V8_H_DM_JOIN
175.
V8_H_DM_LIMIT_COL
176.
V8_H_QRY_QUERY
177.
V8_H_QRY_COLUMN
178.
V8_H_QRY_DM_REF
179.
V8_H_QRYCOL_DMCOL
180.
V8_H_RS_COLUMN
181.
V8_H_RS_COMP_ITEM
182.
V8_H_RS_LIMIT_COL
183.
V8_H_QRYCOL_RSCOL
184.
V8_H_TBL_COLUMN
185.
V8_H_OLAP_NAMES
186.
V8_H_OLAP_QUERY
187.
V8_H_OLAP_FILTER
188.
V8_H_OLAP_DIM
189.
V8_H_OLAP_MBRSEL
190.
V8_H_OLAP_SECTION
191.
V8_H_WA_DATASRC
192.
V8_HS_REQUEST_LOG
193.
V8_HS_ACTION_LOG
194.
V8_HS_ACTION
195.
V8_TR_REQUEST_LOG
196.
V8_TR_ACTION_LOG
197.
V8_TR_OP_LOG
198.
V8_TR_SCRIPT_LOG
199.
V8_TR_ACTION
200.
V8_TR_PARAMETER
201.
BRIOSECG
202.
BRIOSECR
203.
BRIOSECP
204.
V8_MON_POLL
205.
V8_SRCH_CONT_EVENT
206.
V8_KPS_ACTION_QUEUE
207.
ANNOT_CONTEXTS
208.
ANNOT_ELEMENTS
209.
ANNOT_ELEMENT_GROUPS
210.
ANNOT_ELEMENT_GROUP1
211.
ANNOT_ELEMENT_GROUP2
212.
ANNOT_ELEMENT_GROUP3
213.
ANNOT_ELEMENT_SETS
214.
ANNOT_ELEMENT_VALUES
215.
FR_SCHEDULER_DATA
216.
OJB_HL_SEQ
217.
OJB_LOCKENTRY
218.
OJB_NRM
219.
OJB_DLIST
220.
OJB_DLIST_ENTRIES
221.
OJB_DSET
222.
OJB_DSET_ENTRIES
223.
OJB_DMAP
224.
OJB_DMAP_ENTRIES
225.
ATF_APPS
226.
ATF_SVCLOCKS
227.
ATF_NE_INFO
228.
ATF_SHORTCUTS
229.
ATF_LOCKS
230.
HYA_REPORT
231.
HYA_REPORTATTR
232.
HYA_ESS_DB
233.
HYA_SSAS_DB
234.
HYA_SAP_BAPI_DB
235.
HYA_HFM_DB
236.
HYA_VIRTCUBE_DB
237.
HYA_DB_FORMATS
238.
HYA_DB_PREFS
239.
HYA_USER_PREFS
240.
HYA_PRESENTATION
