FND Tables (700)
FND - Application Object Library — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
AD_NODES_CONFIG_STATUS |
4 | |
AMS_INFMET_LEAD_GT |
6 | |
AMS_INFMET_ORDER_GT |
6 | |
AMS_INFMET_RESP_GT |
5 | |
AR_IL_CASH_RECEIPTS_GT |
27 | This is a global temporary table, used for israeli receipt printing program. |
AR_REM_CR_ID_GTT |
2 | |
BISM_AGGREGATES |
3 | |
BISM_ASSOCIATES |
4 | |
BISM_DATABASE |
1 | |
BISM_EXPORT |
6 | |
BISM_GROUPS |
2 | |
BISM_OBJECTS |
23 | |
BISM_OBJECT_TYPES |
2 | |
BISM_PARAMETERS |
2 | |
BISM_PERMISSIONS |
3 | |
BISM_PRIVILEGES |
3 | |
BISM_SUBJECTS |
3 | |
CSD_RO_PER_ITEM_MV |
2 | |
DDR_BS_BU_ITM_ASSC_WK_MV |
6 | |
DDR_BS_CLS_DAY_MV |
5 | |
DDR_BS_EXCPTN_SKU_BU_WK_C_MV |
16 | |
DDR_BS_FRCST_ITM_BU_WK_C_MV |
26 | |
DDR_BS_FRCST_ITM_BU_WK_MV |
28 | |
DDR_BS_FRCST_VRSN_MV |
10 | |
DDR_BS_INV_ITM_BU_WK_C_MV |
74 | |
DDR_BS_INV_ITM_BU_WK_MV |
76 | |
DDR_BS_INV_SKU_BU_DAY_MV |
70 | |
DDR_BS_ITM_BU_ASSC_DAY_MV |
8 | |
DDR_BS_MFG_SHIP_ITM_BU_WK_MV |
21 | |
DDR_BS_MFG_SHP_ITM_BU_WK_C_MV |
19 | |
DDR_BS_ORDR_ITM_BU_WK_C_MV |
20 | |
DDR_BS_ORDR_ITM_BU_WK_MV |
22 | |
DDR_BS_SHIP_ITM_BU_WK_C_MV |
27 | |
DDR_BS_SHIP_ITM_BU_WK_MV |
29 | |
DDR_BS_SLSR_ITM_BU_WK_C_MV |
41 | |
DDR_R_AOH_LVL_2_ATTR_MV |
11 | |
DDR_R_AOH_LVL_4_ATTR_MV |
15 | |
DDR_R_BASE_DAY_DN_MV |
48 | |
DDR_R_BSNS_MNTH_DN_MV |
32 | |
DDR_R_BSNS_QTR_DN_MV |
24 | |
DDR_R_BSNS_WK_DN_MV |
40 | |
DDR_R_BSNS_YR_DN_MV |
15 | |
DDR_R_CLNDR_DAY_DN_MV |
44 | |
DDR_R_CLNDR_MNTH_DN_MV |
30 | |
DDR_R_CLNDR_PRD_DRTN_DN_MV |
8 | |
DDR_R_CLNDR_QTR_DN_MV |
22 | |
DDR_R_CLNDR_WK_DN_MV |
14 | |
DDR_R_CLNDR_YR_DN_MV |
13 | |
DDR_R_MFG_ITEM_CLS_DN_MV |
19 | |
DDR_R_MFG_ITEM_DIV_DN_MV |
11 | |
DDR_R_MFG_ITEM_ITM_DN_MV |
36 | |
DDR_R_MFG_ITEM_SBC_DN_MV |
23 | |
DDR_R_MFG_ITEM_SKU_DN_MV |
72 | |
DDR_R_ORG_AREA_DN_MV |
18 | |
DDR_R_ORG_BU_DN_MV |
44 | |
DDR_R_ORG_CHN_DN_MV |
13 | |
DDR_R_ORG_DSTRCT_DN_MV |
28 | |
DDR_R_PRD_DRTN_DN_MV |
10 | |
DDR_R_RTL_ITEM_CLS_DN_MV |
24 | |
DDR_R_RTL_ITEM_DEPT_DN_MV |
20 | |
DDR_R_RTL_ITEM_DIV_DN_MV |
12 | |
DDR_R_RTL_ITEM_GRP_DN_MV |
16 | |
DDR_R_RTL_ITEM_ITM_DN_MV |
39 | |
DDR_SV_CLS_MNTH_MV |
7 | |
DDR_SV_CLS_QTR_MV |
7 | |
DDR_SV_CLS_WK_MV |
7 | |
DDR_SV_CLS_YR_MV |
7 | |
DDR_SV_EXCPTN_C_MV |
20 | |
DDR_SV_FRCST_C_MV |
30 | |
DDR_SV_INV_C_MV |
80 | |
DDR_SV_INV_INT_C_MV |
74 | |
DDR_SV_INV_MV |
81 | |
DDR_SV_ITM_BU_ASSC_MNTH_MV |
9 | |
DDR_SV_ITM_BU_ASSC_QTR_MV |
9 | |
DDR_SV_ITM_BU_ASSC_WK_MV |
9 | |
DDR_SV_ITM_BU_ASSC_YR_MV |
9 | |
DDR_SV_MFG_SHIP_C_MV |
20 | |
DDR_SV_ORDR_C_MV |
23 | |
DDR_SV_ORDR_MV |
23 | |
DDR_SV_SHIP_C_MV |
28 | |
DDR_SV_SLSR_C_MV |
45 | |
DDR_SV_SLSR_MV |
46 | |
ERROR_CODES_MAP |
3 | |
FND_ADG_COMMIT_WAIT |
2 | |
FND_ADG_CONCURRENT_PROGRAM |
12 | |
FND_ADG_CONTROL |
56 | |
FND_ADG_PACKAGE |
8 | |
FND_ADG_SIMULATED_STNDBY_TRC |
9 | |
FND_AM_POOL_STATS |
37 | This table holds information about Application Module Pool operations and is mainly intended for performance diagnostics. The data contained |
FND_APPLICATION |
10 | Applications registered with Oracle Application Object Library |
FND_APPLICATION_SERVERS |
8 | List of application servers authenticated to access this instance |
FND_APPLICATION_TL |
11 | Translations for FND_APPLICATION |
FND_APPL_SESSIONS |
7 | Auditing information for non-Forms based applications sessions |
FND_APPL_TOPS |
11 | This table tracks the mount points for the APPL_TOPs in an Applications system. Each mount point has a distinct host and path. A single, p |
FND_APPS_SYSTEM |
11 | This lists system level attributes. There will be only one row in this table. That row represents the local system. An exact copy of thi |
FND_APP_SERVERS |
13 | This table will track the servers used by the E-Business Suite system. This includes the internal server configured by AutoConfig, and any |
FND_ATTACHED_DOCUMENTS |
40 | Attached documents |
FND_ATTACHMENT_BLK_ENTITIES |
26 | Document and attachment information |
FND_ATTACHMENT_BLOCKS |
17 | Blocks with attachments |
FND_ATTACHMENT_FUNCTIONS |
13 | Forms and form functions with attachments |
FND_AUDIT_COLUMNS |
12 | Table columns being audited |
FND_AUDIT_DISP_COLS |
6 | This table stores display columns for the Audit Query Navigator |
FND_AUDIT_GROUPS |
11 | Application tables and columns being audited as groups |
FND_AUDIT_LKUPS |
9 | This table stores Lookup Type information to show decoded column values in the Audit Query Navigator. |
FND_AUDIT_REP_DTL |
12 | Data in this table is temporary and is used for Audit Trail Reporting |
FND_AUDIT_REP_HDR |
12 | Data in this table is temporary and is used for Audit Trail Reporting |
FND_AUDIT_SCHEMAS |
10 | Audit schema |
FND_AUDIT_TABLES |
11 | Application tables being audited |
FND_AUDIT_TMPLT_DTL |
8 | This table stores the relation between Industry Templates and Audit Groups. |
FND_AUDIT_TMPLT_MST |
7 | This table stores Industry Templates. |
FND_AW_DEF_INTERFACE |
12 | |
FND_BUSINESS_PURPOSES_B |
27 | |
FND_BUSINESS_PURPOSES_TL |
12 | |
FND_CHILD_ANNOTATIONS |
6 | Child Annotations for Integration Repository |
FND_COLUMNS |
26 | Columns in all the registered application tables |
FND_COL_PRIV_ATTRIBUTES_B |
30 | |
FND_COL_PRIV_ATTRIBUTES_TL |
13 | |
FND_COMPILED_DESCRIPTIVE_FLEXS |
9 | Compiled information about descriptive flexfields |
FND_COMPILED_ID_FLEXS |
9 | Compiled information about key flexfields |
FND_COMPILED_ID_FLEX_STRUCTS |
10 | Compiled information about key flexfield structures |
FND_COMPILED_MENU_FUNCTIONS |
3 | This table compiles the information from FND_MENU_ENTRIES to facilitateruntime lookups of which functions are on which menus. |
FND_COMPONENT_DEBUG_OPTIONS |
8 | FND_COMPONENT_DEBUG_OPTIONS |
FND_CONCURRENT_COMPLEX_LINES |
12 | Concurrent manager complex rule lines |
FND_CONCURRENT_COMPLEX_RULES |
9 | Complex rules for specializing concurrent managers |
FND_CONCURRENT_DEBUG_INFO |
16 | Stores debug information when certain debug mechanisms are activated at the request of an Oracle developer |
FND_CONCURRENT_PROCESSES |
33 | Operating system and ORACLE process IDs for concurrent managers |
FND_CONCURRENT_PROCESSORS |
12 | Immediate concurrent program libraries |
FND_CONCURRENT_PROGRAMS |
72 | Concurrent programs |
FND_CONCURRENT_PROGRAMS_TL |
12 | Translations for FND_CONCURRENT_PROGRAMS |
FND_CONCURRENT_PROGRAM_SERIAL |
14 | Incompatible concurrent programs |
FND_CONCURRENT_QUEUES |
57 | Concurrent managers setup information |
FND_CONCURRENT_QUEUES_TL |
13 | Translations for FND_CONCURRENT_QUEUES |
FND_CONCURRENT_QUEUE_CONTENT |
12 | Specialization rules for concurrent managers |
FND_CONCURRENT_QUEUE_PARAMS |
9 | Concurrent manager parameters |
FND_CONCURRENT_QUEUE_SIZE |
16 | Number of requests concurrent managers can process at a time within their work shifts |
FND_CONCURRENT_REQUESTS |
132 | Concurrent requests information |
FND_CONCURRENT_REQUEST_CLASS |
9 | Concurrent request types |
FND_CONCURRENT_TIME_PERIODS |
16 | Concurrent processing work shifts |
FND_CONC_DEFERRED_ARGUMENTS |
108 | FND_CONC_DEFERRED_ARGUMENTS |
FND_CONC_NT_PROCESSES |
9 | FND_CONC_NT_PROCESSES stores information about processes created by the concurrent manager in the NT environment |
FND_CONC_OS_PROCESSES |
10 | - Retrofitted |
FND_CONC_PP_ACTIONS |
31 | Post Concurrent Request processing actions table |
FND_CONC_PP_TEMPLATES |
8 | Post-processing templates for the concurrent processor |
FND_CONC_PP_TEMPLATES_TL |
10 | Translations for FND_CONC_PP_TEMPLATES |
FND_CONC_PP_TEMPLATE_MEMBERS |
17 | - Retrofitted |
FND_CONC_PROCESSOR_PROGRAMS |
9 | Immediate concurrent programs included in concurrent program libraries |
FND_CONC_PROG_ANNOTATIONS |
9 | To store annotation information for a concurrent program. |
FND_CONC_PROG_ONSITE_INFO |
31 | The Fnd_Conc_Prog_OnSite_Info table stores information about Concurrent Programs on site runtime information |
FND_CONC_RELEASE_CLASSES |
22 | Concurrent Schedules |
FND_CONC_RELEASE_CLASSES_TL |
12 | Translations for FND_CONC_RELEASE_CLASSES |
FND_CONC_RELEASE_DISJS |
15 | Disjunctions used in Advanced Schedules |
FND_CONC_RELEASE_DISJS_TL |
11 | Translations for FND_CONC_RELEASE_DISJS |
FND_CONC_RELEASE_PERIODS |
19 | Concurrent Periods used in Advanced Schedules |
FND_CONC_RELEASE_PERIODS_TL |
11 | Translations for FND_CONC_RELEASE_PERIODS |
FND_CONC_RELEASE_STATES |
17 | Concurrent States used in Advanced Schedules |
FND_CONC_RELEASE_STATES_TL |
11 | Translations for FND_CONC_RELEASE_STATES |
FND_CONC_REL_CONJ_MEMBERS |
12 | Members of Conjunctions |
FND_CONC_REL_DISJ_MEMBERS |
17 | Members of Disjunctions |
FND_CONC_REQUEST_ARGUMENTS |
76 | Arguments 26 through 100 for concurrent requests |
FND_CONC_REQ_OUTPUTS |
8 | This table stores output files created by Concurrent Request. Initial output file generated by Concurrent Request will be stored in FND_CONC |
FND_CONC_REQ_STAT |
4 | - Retrofitted |
FND_CONC_STATE_LOOKUPS |
13 | Values for Concurrent States |
FND_CONC_STATE_LOOKUPS_TL |
11 | Translations of FND_CONC_STATE_LOOKUPS |
FND_CONC_STATE_LOOKUP_TYPES |
13 | Sets of Values for Concurrent States |
FND_CONC_STATE_LOOKUP_TYPES_TL |
10 | Translations of FND_CONC_STATE_LOOKUPS_TYPES |
FND_CONC_STAT_GROUPS |
7 | |
FND_CONC_STAT_G_P_SUMMARY |
12 | |
FND_CONC_STAT_LIST |
2 | - Retrofitted |
FND_CONC_STAT_PERIODS |
8 | |
FND_CONC_STAT_PROG |
1 | - Retrofitted |
FND_CONC_STAT_SUMMARY |
11 | - Retrofitted |
FND_CONFLICTS_DOMAIN |
11 | Stores Conflict Resolution Manager conflict domain information |
FND_CONFLICTS_DOMAIN_STATUS |
9 | - Retrofitted |
FND_CP_DELIVERY_COMMANDS |
7 | |
FND_CP_DELIVERY_OPTIONS |
10 | |
FND_CP_IPP_PRINTERS |
24 | |
FND_CP_SERVICES |
34 | Service Information |
FND_CP_SERVICES_TL |
12 | FND_CP_SERVICES_TL table stores translated information about services in each of the translated languages |
FND_CP_SQL_REQUESTS |
3 | |
FND_CRM_HISTORY |
6 | |
FND_CURRENCIES |
58 | Currencies enabled for use at your site |
FND_CURRENCIES_TL |
11 | Translations for FND_CURRENCIES |
FND_DATABASES |
14 | This table stores information about the database that is not instance specific. |
FND_DATABASE_ASSIGNMENTS |
7 | Fnd_Database_Assignments table assigns specific functions to a database |
FND_DATABASE_INSTANCES |
18 | Fnd_Database_Instances table stores instance specific information |
FND_DATABASE_SERVICES |
9 | FND_DATABASE_SERVICES table tracks the named database services |
FND_DATA_GROUPS |
9 | Data groups registered with Oracle Application Object Library |
FND_DATA_GROUP_UNITS |
9 | ORACLE accounts for applications assigned to various data groups |
FND_DBA_LOCKS_TEMP |
6 | - Retrofitted |
FND_DB_INSTANCE_PARAMS |
8 | Instance specific parameters will be saved in this table. |
FND_DB_SERVICE_MEMBERS |
9 | The FND_DB_SERVICE_MEMBERS table tracks the instances that belong to a given DB Service. |
FND_DEBUG_OPTIONS |
11 | FND_DEBUG_OPTIONS |
FND_DEBUG_OPTIONS_TL |
11 | FND_DEBUG_OPTIONS_TL |
FND_DEBUG_OPTION_VALUES |
13 | Debug Option Values represent valid values for the debug option |
FND_DEBUG_OPTION_VALUES_TL |
12 | Debug Option Values TL table for translation purpose |
FND_DEBUG_RULES |
20 | Debug Rule is a valid debug option set by System Administrator to |
FND_DEBUG_RULE_EXECUTIONS |
24 | FND_DEBUG_RULE_EXECUTIONS |
FND_DEBUG_RULE_OPTIONS |
8 | 1. Removed 2 columns from fnd_debug_rules 2. Added new table as fnd_debug_rule_options |
FND_DEFAULT_CONTEXT_FIELDS |
10 | Name of fields on forms that users can use as reference fields for descriptive flexfields |
FND_DEFAULT_FOLDERS |
10 | Default folder definitions |
FND_DESCRIPTIVE_FLEXS |
24 | Descriptive flexfields registration information |
FND_DESCRIPTIVE_FLEXS_TL |
13 | Translations for FND_DESCRIPTIVE_FLEXS |
FND_DESCR_FLEX_COLUMN_USAGES |
25 | Correspondences between application table columns and descriptive flexfield segments |
FND_DESCR_FLEX_COL_USAGE_TL |
15 | Translations for FND_DESCR_FLEX_COLUMN_USAGES |
FND_DESCR_FLEX_CONTEXTS |
11 | Structure names for descriptive flexfields |
FND_DESCR_FLEX_CONTEXTS_TL |
13 | Translations for FND_DESCR_FLEX_CONTEXTS |
FND_DESKTOP_OBJECTS |
7 | Stores Icons for Navigator objects |
FND_DM_ACCESSNAMES |
2 | This table holds the internal names of the access levels/privileges that can be granted to the user on a repository item |
FND_DM_DOCUMENT_ENTITIES_EXT |
8 | This table holds the security and where-used related apis/sqls for the business entity. |
FND_DM_FOLDERATTACHMENTEXT |
2 | This table specifies whether the attached folder is the default folder. |
FND_DM_FOLDERROLEMAPS |
13 | Stores the mapping information for a business object security to a OFO folder security |
FND_DM_FUNCTIONS |
7 | Document management functions supported through Open Interface |
FND_DM_FUNCTION_PARAMETERS |
3 | Document management system function parameters |
FND_DM_NODES |
9 | Document manager system nodes |
FND_DM_PRODUCTS |
5 | Supported Document Management software products |
FND_DM_PRODUCTS_TL |
5 | This table holds the transalated name of the repository |
FND_DM_PRODUCT_FUNCTION_SYNTAX |
4 | Syntaxes for Document Management product functions |
FND_DM_PRODUCT_PARM_SYNTAX |
5 | Syntaxes for function parameters of document management system products |
FND_DOCUMENTS |
30 | Documents |
FND_DOCUMENTS_LONG_RAW |
2 | Long raw documents |
FND_DOCUMENTS_LONG_TEXT |
3 | Long text documents |
FND_DOCUMENTS_SHORT_TEXT |
3 | Short text documents |
FND_DOCUMENTS_TL |
34 | Translations for FND_DOCUMENTS |
FND_DOCUMENT_CATEGORIES |
28 | Document categories |
FND_DOCUMENT_CATEGORIES_TL |
12 | Translation table for FND_DOCUMENT_CATEGORIES |
FND_DOCUMENT_DATATYPES |
13 | Document datatypes |
FND_DOCUMENT_ENTITIES |
16 | Document entities |
FND_DOCUMENT_ENTITIES_TL |
12 | Translation table for FND_DOCUMENT_ENTITIES |
FND_DOCUMENT_SEQUENCES |
32 | Document sequences registered with Oracle Application Object Library |
FND_DOC_CATEGORY_USAGES |
11 | Relationships between document categories and form or form functions |
FND_DOC_SEQUENCE_ACCESS |
8 | Information about who can access a document sequence |
FND_DOC_SEQUENCE_ASSIGNMENTS |
25 | Assigns a sequence to a document |
FND_DOC_SEQUENCE_AUDIT |
5 | Keeps track of documents |
FND_DOC_SEQUENCE_CATEGORIES |
11 | Document category definitions |
FND_DOC_SEQUENCE_USERS |
10 | User assigned document sequences |
FND_DUAL |
1 | Dummy base table used by a form block that does not have a real base table (for commit purposes) |
FND_ENABLED_PLSQL |
9 | List of PL/SQL packages/procedures accessible by web server |
FND_ENV_CONTEXT |
3 | FND_ENV_CONTEXT stores information about environment name and value for each of the concurrent process |
FND_EVENTS |
21 | |
FND_EVENT_TOKENS |
4 | |
FND_EXCEPTION_NOTES |
8 | This table allows DBAs to store notes associated with an exception |
FND_EXCLUDE_TABLE_STATS |
9 | Default data for application interface tables |
FND_EXECUTABLES |
14 | Concurrent program executables |
FND_EXECUTABLES_TL |
12 | Translations for FND_EXECUTABLES |
FND_EXTNSTATS_COLS |
14 | |
FND_FILE_TEMP |
17 | - Retrofitted |
FND_FLEXBUILDER_ASSIGNMENTS |
20 | Flexbuilder assignments |
FND_FLEXBUILDER_FUNCTIONS |
11 | Flexbuilder functions setup information |
FND_FLEXBUILDER_PARAMETERS |
27 | Flexbuilder parameters |
FND_FLEXBUILDER_PARAMS_TL |
12 | Translations for FND_FLEXBUILDER_PARAMETERS |
FND_FLEX_EXCLUDE_RULE_LINES |
72 | Stores cross-validation rule elements |
FND_FLEX_HASH |
6 | Prevents conflicts when creating new flexfield combinations |
FND_FLEX_HIERARCHIES |
9 | Flexfield hierarchy name for flexfield values |
FND_FLEX_HIERARCHIES_TL |
12 | Translations for FND_FLEX_HIERARCHIES |
FND_FLEX_INCLUDE_RULE_LINES |
72 | Store cross-validation rule elements |
FND_FLEX_SEC_RULE_ALLOWED_VALS |
7 | |
FND_FLEX_TEST |
155 | - Retrofitted |
FND_FLEX_VALIDATION_EVENTS |
9 | Validation events for special validated value sets |
FND_FLEX_VALIDATION_QUALIFIERS |
7 | Assignment information for flexfield qualifiers |
FND_FLEX_VALIDATION_RULES |
14 | Key flexfield cross-validation rules or line detail |
FND_FLEX_VALIDATION_RULE_LINES |
16 | Cross-validation rule elements for key flexfields |
FND_FLEX_VALIDATION_RULE_STATS |
12 | Statistics on the number of key flexfield cross-validation rules |
FND_FLEX_VALIDATION_TABLES |
27 | Flexfield validation tables |
FND_FLEX_VALUES |
70 | Valid values for flexfield segments |
FND_FLEX_VALUES_TL |
11 | Translations for FND_FLEX_VALUES |
FND_FLEX_VALUE_HIERARCHIES |
11 | Child value ranges for key flexfield segment values |
FND_FLEX_VALUE_HIER_ALL |
13 | All value hierarchy ranges for key flexfield segment |
FND_FLEX_VALUE_NORM_HIERARCHY |
13 | Multiple level hierarchies |
FND_FLEX_VALUE_RULES |
11 | Security rules for flexfield values |
FND_FLEX_VALUE_RULES_TL |
11 | Translations for FND_FLEX_VALUE_RULES |
FND_FLEX_VALUE_RULE_LINES |
13 | Rule elements for flexfield value security rules |
FND_FLEX_VALUE_RULE_USAGES |
12 | Flexfield security rules assigned to responsibilities |
FND_FLEX_VALUE_SETS |
24 | Value sets used by both key and descriptive flexfields |
FND_FLEX_VDATION_RULES_TL |
14 | Translations for FND_FLEX_VALIDATION_RULES |
FND_FLEX_WORKFLOW_PROCESSES |
11 | Workflow to generate flexfield code combinations |
FND_FOLDERS |
14 | Customized folder definitions |
FND_FOLDER_COLUMNS |
13 | Displayed columns in folders |
FND_FOREIGN_KEYS |
18 | Foreign keys registered with Oracle Application Object Library |
FND_FOREIGN_KEY_COLUMNS |
12 | Foreign key columns registered with Oracle Application Object Library |
FND_FORM |
10 | Application forms registered with Oracle Application Object Library |
FND_FORM_CUSTOM_ACTIONS |
31 | Holds the Actions for a specified Rule - used by FNDCUSTM.fmb and APPCORE to apply customizations. |
FND_FORM_CUSTOM_PARAMS |
12 | Parameters to Pass to a CP when executed using Form Customizations |
FND_FORM_CUSTOM_PROP_LIST |
12 | Lookup table for the Properties which can be altered |
FND_FORM_CUSTOM_PROP_VALUES |
9 | The Values available for items with argument type of L - Lookup |
FND_FORM_CUSTOM_RULES |
18 | The Rules for the form customizations. A rule must have 1 more more FND_FORM_CUSTOM_SCOPES and a rule may have 1 or more FND_FORM_CUSTOM_ACT |
FND_FORM_CUSTOM_SCOPES |
10 | The Scopes for which the FND_FORM_CUSTOM_RULES apply |
FND_FORM_FUNCTIONS |
37 | Functionality groupings |
FND_FORM_FUNCTIONS_TL |
11 | Translations for FND_FORM_FUNCTIONS |
FND_FORM_TL |
12 | Translations for FND_FORM |
FND_GRANTS |
40 | Grants are rows that indicate a user or group has permission to execute a menu (role) of functions, under a specific context |
FND_HELP_DOCUMENTS |
8 | Information about on-line help documents |
FND_HELP_TARGETS |
3 | On-line help targets |
FND_HELP_TREE |
14 | On-line help system navigation tree. |
FND_HISTOGRAM_COLS |
12 | Histogram candidate columns for cost-based optimization |
FND_HTTP_SERVICE_TICKETS |
4 | |
FND_HTTP_TICKETS |
5 | Table to store short-lifespan and one-time-use tickets |
FND_ID_FLEXS |
21 | Registration information about key flexfields |
FND_ID_FLEX_SEGMENTS |
26 | Key flexfield segments setup information and correspondences between table columns and key flexfield segments |
FND_ID_FLEX_SEGMENTS_TL |
15 | Translations for FND_ID_FLEX_SEGMENTS |
FND_ID_FLEX_STRUCTURES |
19 | Key flexfield structure information |
FND_ID_FLEX_STRUCTURES_TL |
14 | Translations for FND_ID_FLEX_STRUCTURES |
FND_IMP_AFFECTEDFILES |
13 | FND_IMP_AFFECTEDFILES |
FND_IMP_BUGSET |
12 | fnd_imp_bugset |
FND_IMP_BUGSET_TEMP |
2 | Temporary table used during patch impact analysis |
FND_IMP_DEPMODIFIEDTIME |
10 | FND_IMP_DEPMODIFIEDTIME |
FND_IMP_DEPOBJECTS |
28 | FND_IMP_DEPOBJECTS |
FND_IMP_DEPRELATIONS |
18 | FND_IMP_DEPRELATIONS |
FND_IMP_DIAGMAP |
8 | FND_IMP_DIAGMAP |
FND_IMP_LANG_SUMMARY |
4 | |
FND_IMP_MENU_DEP2 |
10 | FND_IMP_MENU_DEP2 |
FND_IMP_MENU_DEP_SUMMARY2 |
10 | FND_IMP_MENU_DEP_SUMMARY2 |
FND_IMP_MENU_DEP_SUMMARY3 |
6 | FND_IMP_MENU_DEP_SUMMARY3 |
FND_IMP_MONITOR |
14 | FND_IMP_MONITOR |
FND_IMP_PFILEINFO |
3 | FND_IMP_PFILEINFO |
FND_IMP_PFILEINFO2 |
6 | FND_IMP_PFILEINFO2 |
FND_IMP_PISUMMARY |
14 | FND_IMP_PISUMMARY |
FND_IMP_PSCOMMON |
9 | FND_IMP_PSCOMMON |
FND_IMP_PSMASTER2 |
15 | FND_IMP_PSMASTER2 |
FND_IMP_PSNEW |
8 | FND_IMP_PSNEW |
FND_IMP_SFILEDEP |
7 | FND_IMP_SFILEDEP |
FND_INDEXES |
21 | Unique and non-unique indexes registered with Oracle Application Object Library |
FND_INDEX_COLUMNS |
11 | Index columns registered with Oracle Application Object Library |
FND_INDUSTRIES |
11 | The table holds the listing of standard industries that may be translated. |
FND_IREP_CLASSES |
37 | Integration Repository information concerning executable interfaces |
FND_IREP_CLASSES_TL |
12 | TL Table for IREP Classes table |
FND_IREP_CLASS_DATASOURCES |
11 | Stores metadata about data sources exposed on a Service |
FND_IREP_CLASS_PARENT_ASSIGNS |
3 | Parent Assignments for Integration Repository |
FND_IREP_DEFERRED_LOAD_FILES |
16 | |
FND_IREP_FUNCTION_FLAVORS |
9 | Overload flavors for functions |
FND_IREP_SERVICE_ARTIFACTS |
9 | |
FND_IREP_USES_MAPS |
4 | Uses Maps Information for iRep |
FND_IREP_USES_TABLES |
5 | Tables used by open interfaces |
FND_ISO_LANGUAGES |
9 | Language table based on ISO-649 |
FND_ISO_LANGUAGES_TL |
11 | Translations for FND_ISO_LANGUAGES |
FND_JAF_ASYNC_QUEUE |
10 | |
FND_JAF_EVENT_LOG |
7 | |
FND_JAF_MESSAGE |
3 | |
FND_KBF_SUBSCRIPTION |
13 | OAM Notification Setup Table for Exceptions |
FND_LANGUAGES |
17 | National dialects |
FND_LANGUAGES_TL |
10 | Translations for FND_LANGUAGES |
FND_LOADER_OPEN_INTERFACE |
13 | Regular database table that stores configuration information required by the batch invocation |
FND_LOBS |
11 | LOBs being managed by the Generic File Manager |
FND_LOBS_DOCUMENT |
8 | These tables mirror the standard WebDB doc tables but use our own name. |
FND_LOBS_DOCUMENTPART |
3 | These tables mirror the standard WebDB doc tables but use our own name. |
FND_LOB_ACCESS |
3 | LOB access table for the Generic File Manager |
FND_LOCK_HOLDERS |
7 | - Retrofitted |
FND_LOGINS |
13 | Sign-On Audit information about who signs on to an application and when |
FND_LOGIN_RESPONSIBILITIES |
8 | Sign-On Audit information about when and who changes responsibilities in an application |
FND_LOGIN_RESP_FORMS |
9 | Sign-On Audit information about when and who used which forms in an application |
FND_LOG_ATTACHMENTS |
9 | Stores large FND log message attachments |
FND_LOG_EXCEPTIONS |
9 | store the extended exception information that is needed for efficient queries |
FND_LOG_MESSAGES |
20 | Stores debug log messages generated from the FND_LOG package. |
FND_LOG_METRICS |
19 | This new table will store logged metrics |
FND_LOG_TRANSACTION_CONTEXT |
13 | This table stores the context information for a transaction |
FND_LOG_UNIQUE_EXCEPTIONS |
12 | Used to track unique exceptions |
FND_LOOKUP_ASSIGNMENTS |
16 | Used for categorization purposes, intersection table between fnd_lookup_values and any product team table. |
FND_LOOKUP_PARENT_ASSIGNS |
4 | Parent Hierarchy for lookups |
FND_LOOKUP_TYPES |
12 | Oracle Application Object Library QuickCodes |
FND_LOOKUP_TYPES_TL |
13 | Translations for FND_LOOKUP_TYPES |
FND_LOOKUP_VALUES |
36 | QuickCode values |
FND_LOOKUP_VALUES_IL |
14 | Table that holds seed data for industry translated lookup values |
FND_LOV_CHOICE_VALUES |
10 | Stores values for LOV Choice List |
FND_MENUS |
9 | New menu tabl for Release 10SC |
FND_MENUS_TL |
11 | Translations for FND_MENUS |
FND_MENU_ENTRIES |
11 | Individual entries in navigate window menus for Release 10SC |
FND_MENU_ENTRIES_TL |
12 | Translations for FND_MENU_ENTRIES |
FND_METRIC_DEF_TL |
5 | This table contains the definition of a metric for the benefit of the UI |
FND_MIME_TYPES |
11 | |
FND_MIME_TYPES_TL |
12 | Mime types |
FND_MO_PRODUCT_INIT |
8 | This table stores the application short name of the applications that have Multi-Org Access Control enabled |
FND_MO_SP_PREFERENCES |
13 | |
FND_NATURAL_LANGUAGES |
10 | Language table storing natural language |
FND_NATURAL_LANGUAGES_TL |
11 | Translations for FND_NATURAL_LANGUAGES |
FND_NEW_MESSAGES |
17 | Application messages for Oracle Applications in GUI mode |
FND_NEW_MESSAGES_IL |
13 | Table that holds seed data for industry translated messages |
FND_NODES |
26 | Nodes or machines used to install and run Oracle Applications |
FND_OAM_ADV_CFG_VALIDATIONS |
6 | Stores Context editor Advanced Configuration validation status |
FND_OAM_APP_SYS_STATUS |
10 | OAM Applications System Status Information |
FND_OAM_BF |
8 | This table will contain the business flow definitions for predefined business flows |
FND_OAM_BF_ASSOC |
9 | This table stores the association between parent and child business flows for predefined flows. |
FND_OAM_BF_ASSOC_CUST |
9 | This table stores the association between parent and child business flows for user defined flows |
FND_OAM_BF_COMP |
11 | This table stores the association between business flows and individual components for predefined flows |
FND_OAM_BF_COMP_CUST |
11 | This table stores the association between business flows and individual components for user defined flows |
FND_OAM_BF_COMP_INFO |
16 | This table stores the health indicator information at the individual component level for components associated with business flows |
FND_OAM_BF_CUST |
8 | This table will contain the business flow definitions for user defined business flows |
FND_OAM_BF_CUST_TL |
10 | This table stores the display names and descriptions per language for user defined business flows |
FND_OAM_BF_MODEL |
8 | This table will store the hierarchical XML representation of each top level key business flow |
FND_OAM_BF_ROLLUP_INFO |
16 | This table stores the health indicator information for business flows |
FND_OAM_BF_TL |
10 | This table stores the display names and descriptions per language for predefined business flows |
FND_OAM_BF_WIT |
9 | This table stores the association between business flows with Work Item Types for predefined flows |
FND_OAM_BF_WIT_CUST |
9 | This table stores the association between business flows with Work Item Types for user defined flows |
FND_OAM_BF_WIT_INFO |
8 | This table stores the workflow work item type related indicators for work item types that are associated with business flows |
FND_OAM_BIZEX_SENT_NOTIF |
3 | Used to track sent notifications |
FND_OAM_BIZEX_SUBSCRIP |
14 | OAM Notification Setup Table for Exceptions |
FND_OAM_CHARTS |
13 | OAM charts |
FND_OAM_CHARTS_TL |
11 | Translation table for fnd_oam_charts |
FND_OAM_CHART_GRPS |
10 | used for OAM chart groups |
FND_OAM_CHART_GRPS_TL |
11 | translation table for fnd_oam_chart_grps |
FND_OAM_CHART_ITEMS |
10 | OAM chart items |
FND_OAM_CHART_ITEMS_TL |
11 | Translation table for fnd_oam_chart_items_tl |
FND_OAM_CHART_METRICS |
9 | Concurrent Processing Chart Metrics |
FND_OAM_CHART_SETTINGS |
10 | OAM Chart settings |
FND_OAM_CLONE_JOBS |
8 | To information pertaining to cloning jobs. |
FND_OAM_CLONE_LOGS |
12 | To information pertaining to cloning logs |
FND_OAM_CLONE_NOTIF |
7 | To relate notifications to cloning jobs |
FND_OAM_CONTEXT_CUSTOM |
7 | To store custom context variables |
FND_OAM_CONTEXT_FILES |
15 | FND_OAM_CONTEXT_FILES stores all context files and metadata file belongs to the application instance. Each Row contains context name, actual |
FND_OAM_CPSTATS_PROGRAM |
13 | Concurrent Processing Statistics Group by Program |
FND_OAM_CPSTATS_USER |
9 | Concurrent Processing Statistics Group by User |
FND_OAM_CP_OVERVIEW_CHARTS |
4 | Chart setting for the concurrent processing overview page |
FND_OAM_CSA_COLLECTIONS |
8 | Table is for storing XML data files generated by Client System Analyzer tool |
FND_OAM_DOC_CATEGORY |
8 | Stores information about document categories |
FND_OAM_DOC_CATEGORY_ASSOC |
9 | Stores information about association between document categories |
FND_OAM_DOC_CATEGORY_TYPE |
10 | Document Category Types |
FND_OAM_DOC_LINK |
6 | Metadata information to create URLs for Metalink Documents |
FND_OAM_DOC_METADATA |
10 | Document Metadata |
FND_OAM_DSCFG_INSTANCES |
18 | This table holds the Data Scrambling Intermediate Configuration Instance objects. A configuration instance identifies the set of objects an |
FND_OAM_DSCFG_MAPPED_KEYS |
22 | This table is not yet used by the Data Scrambling Feature. |
FND_OAM_DSCFG_OBJECTS |
16 | This table holds the Data Scrambling Intermediate Configuration Object objects. Each operation to be performed by the engine is stored as an |
FND_OAM_DSCFG_PROCS |
15 | This table holds the Data Scrambling Intermediate Configuration Procedure objects. The EM orchestration engine makes use of this table to p |
FND_OAM_DSCFG_PROPERTIES |
11 | This table holds the Data Scrambling Intermediate Configuration Properties objects. Each operation to be performed by the engine is stored a |
FND_OAM_DSCRAM_ARGS_B |
22 | This is the base table for the Data Scrambling Engine Argument object.The arguments infrastructure is used by the engine is a place were tra |
FND_OAM_DSCRAM_ARGS_TL |
10 | This is the translated base table for the Data Scrambling Engine Argument object. |
FND_OAM_DSCRAM_ARG_VALUES |
15 | this table holds the values for Data Scrambling Engine Argument objects. These are used may be provided to and/or generated by the engine. |
FND_OAM_DSCRAM_BUNDLES |
15 | This table holds the Data Scrambling Engine Bundle object. Each engine run is composed of one or more bundles which identify a set of tasks |
FND_OAM_DSCRAM_DMLS |
15 | this table holds DML statements which belong to a specific unit used by the Data Scrambling Engine. |
FND_OAM_DSCRAM_PLSQLS |
13 | This table holds references to PL SQL procedures which belong to a specific unit used by the Data Scrambling Engine. |
FND_OAM_DSCRAM_RUNS_B |
14 | This is the base table for the Data Scrambling Engine Run object. A run is used to uniquely identify a single execution of the engine. If |
FND_OAM_DSCRAM_RUNS_TL |
10 | This is the translated base table for the Data Scrambling Engine Run object. A run is used to uniquely identify a single execution of the e |
FND_OAM_DSCRAM_STATS |
24 | This table holds statistics collected during the execution of the Data Scrambling Engine. |
FND_OAM_DSCRAM_TASKS |
12 | This table holds the Data Scrambling Engine Task object. A task is a group of units and is used to isolate blocks of work which have interd |
FND_OAM_DSCRAM_UNITS |
23 | This table holds the Data Scrambling Engine Unit object. A unit is used to identify a group of work which is related to a single table in t |
FND_OAM_DS_ALGOS_B |
14 | This is the base table for the Data Scrambling Algorithm objects. An algorithm is a snippet of SQL which is associated with a PII attribute |
FND_OAM_DS_ALGOS_TL |
11 | This is the translated base table for the Data Scrambling Algorithm objects. |
FND_OAM_DS_DELETES |
10 | This table holds the table purge directives used by the Data Scrambling feature. |
FND_OAM_DS_PII_EXTENSIONS |
13 | This table holds additional metadata which is specific to Data Scrambling, is related to PII elements and is not stored in the PII schema ob |
FND_OAM_DS_POLICIES_B |
8 | This is the base table for the Data Scrambling Policy object. |
FND_OAM_DS_POLICIES_TL |
10 | This is the translated base table for the Data Scrambling Policy object. |
FND_OAM_DS_POLICY_ELMNTS |
10 | This table stores the many-to-many relationship entries between Data Scrambling Policies and the elements which can be contained within a po |
FND_OAM_DS_PSETS_B |
8 | This is the base table for the Data Scrambling Policy Set object. |
FND_OAM_DS_PSETS_TL |
10 | This is the translated base table for the Data Scrambling Policy Set object. |
FND_OAM_DS_PSET_ELMNTS |
8 | This table stores the many-to-many relationship entries between Policy Sets and Policies. |
FND_OAM_FORMS_RTI |
14 | Forms Listener runtime process info. |
FND_OAM_FRD_LOG |
3 | Forms Listener runtime process FRD log info. |
FND_OAM_GCS_JOBS |
26 | Job details will be saved in this table. |
FND_OAM_METALINK_CRED |
9 | This table will store Applications user's metalink credentials |
FND_OAM_METALINK_DOCS |
10 | Stores information about Metalink documents |
FND_OAM_METALINK_DOC_ASSOC |
9 | ssociation information between documents and categories |
FND_OAM_METS_TL |
11 | OAM Dashboard Metrics Translated Table |
FND_OAM_METVAL |
21 | FROM FND_CONCURRENT_PROGRAMS_VL |
FND_OAM_METVAL_INST |
8 | OAM Dashboard Metric Value Group by Instance |
FND_OAM_METVAL_NODE |
8 | OAM Dashboard Metric Value Group by Node |
FND_OAM_MET_GRPS_TL |
12 | OAM Dashboard Metric Groups Translated Table |
FND_OAM_RESTR_MODES |
19 | Scheduled Downtime Information |
FND_OAM_SVCI_INFO |
10 | Information related to Service Instances monitored by OAM Dashboard Collection Program. |
FND_OAM_UPLOAD_STATUS |
6 | OAM upload status info. |
FND_OBJECTS |
55 | Objects of data elements that can be secured in data security grantsInitially an object is a database table or view. |
FND_OBJECTS_TL |
11 | Object translation subtable |
FND_OBJECT_DEFINITIONS |
18 | |
FND_OBJECT_INSTANCE_SETS |
10 | Object instance sets are groups of object instances. Initially instance sets define groups of database rows via a SQL predicate |
FND_OBJECT_INSTANCE_SETS_TL |
11 | Object Instance Set translation subtable |
FND_OBJECT_KEY_SETS |
14 | |
FND_OBJECT_TABLESPACES |
14 | This table contains Tablespace classifications for Objects like Tables, Materialized Views based on their I/O characteristics |
FND_OBJECT_TYPE_MEMBERS |
31 | Type members for Integration Repository shaped data |
FND_OPS_INSTANCES |
13 | Service Name mapping for each Oracle Parallel Server instance |
FND_ORACLE_HOMES |
13 | This table tracks ORACLE_HOME mount points |
FND_ORACLE_USERID |
13 | ORACLE accounts that contain application data |
FND_PARAMETERS |
16 | Integration Repository method parameters |
FND_PCOLL_CONTROL |
4 | Maintains the list of the BC4J persistent collection storage tables |
FND_PERFORMANCE_DATA |
36 | Network performance test data |
FND_PERFORMANCE_RESULTS |
13 | Results of network performance tests |
FND_PERFORMANCE_TESTS |
15 | Data from performance tests |
FND_PERF_EVENT_LOOKUP |
7 | - Retrofitted |
FND_PERF_VARIABLES |
7 | - Retrofitted |
FND_PORTLET_DEPENDENCY |
8 | stores the relationship between a row in fnd_form_functions and the data collector program that effects the content that is displayed in tha |
FND_PRIMARY_KEYS |
14 | Primary and unique keys registered with Oracle Application Object Library |
FND_PRIMARY_KEY_COLUMNS |
11 | Primary and unique key columns registered with Oracle Application Object Library |
FND_PRINTER |
8 | Printers registered with Oracle Application Object Library |
FND_PRINTER_DRIVERS |
35 | Printer drivers |
FND_PRINTER_INFORMATION |
9 | Printer styles and drivers used by printer types |
FND_PRINTER_STYLES |
14 | Printer styles |
FND_PRINTER_STYLES_TL |
10 | Translations for FND_PRINTER_STYLES |
FND_PRINTER_SUBROUTINES |
9 | Printer subroutines |
FND_PRINTER_TL |
10 | Translations for FND_PRINTER |
FND_PRINTER_TYPES |
9 | Printer Types |
FND_PRIVACY_ATTRIBUTES_B |
30 | |
FND_PRIVACY_ATTRIBUTES_TL |
12 | |
FND_PRIVACY_ATTRIBUTE_CHILDREN |
9 | |
FND_PRODUCT_INITIALIZATION |
8 | Stores each Application's initialization function name. |
FND_PRODUCT_INIT_CONDITION |
8 | Stores each Applicatoin's valid initialization condition. |
FND_PRODUCT_INIT_DEPENDENCY |
8 | Stores each Application's initialization dependency information. |
FND_PROFILE_CATS |
9 | Stores Profile (Option) Categories |
FND_PROFILE_CATS_TL |
12 | Translations for FND_PROFILE_CATS |
FND_PROFILE_CAT_OPTIONS |
12 | Intersection table between FND_PROFILE_OPTIONS and FND_PROFILE_CATS |
FND_PROFILE_CAT_OPTIONS_TL |
11 | Translations for FND_PROFILE_CAT_OPTIONS |
FND_PROFILE_OPTIONS |
31 | User profile options |
FND_PROFILE_OPTIONS_TL |
11 | Translations for FND_PROFILE_OPTIONS |
FND_PROFILE_OPTION_VALUES |
13 | Values of user profile options defined at different profile levels |
FND_PS_TXN |
5 | Stores snapshots of pending changes made to BC4J application module instances |
FND_PURPOSE_ATTRIBUTES |
11 | |
FND_RAND_STATES |
37 | This table stores the state information used by the secure pseudo random number generator |
FND_RAW_DELETEME_TEST |
1 | |
FND_REGISTRATIONS |
44 | Table containing common data for User Management Framework (UMF). |
FND_REGISTRATION_DETAILS |
14 | Table containing detailed and flex data for User Management Framework (UMF). |
FND_REQUEST_GROUPS |
11 | Report security groups |
FND_REQUEST_GROUP_UNITS |
11 | Reports and groups within each report security group |
FND_REQUEST_SETS |
19 | Reports sets |
FND_REQUEST_SETS_TL |
12 | Translations for FND_REQUEST_SETS |
FND_REQUEST_SET_PROGRAMS |
20 | Reports within report sets |
FND_REQUEST_SET_PROGRAM_ARGS |
18 | Default values for report set arguments |
FND_REQUEST_SET_STAGES |
23 | Stores request set stages |
FND_REQUEST_SET_STAGES_TL |
13 | Translation for FND_REQUEST_SET_STAGES |
FND_REQUEST_TEMP |
3 | - Retrofitted |
FND_RESPONSIBILITY |
20 | Responsibilities |
FND_RESPONSIBILITY_TL |
12 | Translations for FND_RESPONSIBILITY |
FND_RESP_FUNCTIONS |
10 | Function Security |
FND_RT_REQUESTS |
2 | Stores concurrent requests |
FND_RUN_REQUESTS |
117 | Setup information for running reports within report sets |
FND_RUN_REQ_LANGUAGES |
9 | Language selections for multilingual concurrent requests |
FND_RUN_REQ_PP_ACTIONS |
27 | FND_RUN_REQ_PP_ACTIONS stores the post request processing actions |
FND_SEARCHABLE_CHANGE_LOG |
19 | |
FND_SEARCH_RUNTIME_INFO |
8 | |
FND_SECURITY_GROUPS |
8 | Service bureau data security groups. |
FND_SECURITY_GROUPS_TL |
11 | Translations for FND_SECURITY_GROUPS |
FND_SEED_STAGE_CONFIG |
312 | FND_SEED_STAGE_CONFIG |
FND_SEED_STAGE_CONFIG_DEBUG |
312 | |
FND_SEED_STAGE_ENTITY |
313 | FND_SEED_STAGE_ENTITY |
FND_SEED_STAGE_ENTITY_DEBUG |
313 | |
FND_SEGMENT_ATTRIBUTE_TYPES |
14 | Key flexfield qualifiers |
FND_SEGMENT_ATTRIBUTE_VALUES |
12 | Values of flexfield qualifiers for different segments of key flexfield structures |
FND_SEG_RPT_ATTRIBUTES |
27 | Reporting attributes |
FND_SELAUDIT_GROUPS |
10 | Created to store the configuration of the columns for which Select Auditing is active |
FND_SELAUDIT_LOG |
11 | FND_SELAUDIT_LOG |
FND_SELAUDIT_TABLES |
11 | Created to store the configuration of the columns for which Select Auditing is active |
FND_SEQUENCES |
17 | Sequences registered with Oracle Application Object Library |
FND_SERVERS |
13 | |
FND_SERVERS_TL |
10 | |
FND_SESSIONS |
2 | Current sessions of Oracle Application Object Library |
FND_SESSION_VALUES |
10 | Stores servlet session values |
FND_SHORTHAND_FLEX_ALIASES |
31 | Alias information for shorthand flexfield entry |
FND_SIDS |
7 | This table registers the SIDs in use on the system. |
FND_SIF_ATTACHMENTS |
11 | |
FND_SIF_DEFINITIONS |
21 | |
FND_SIF_DEFINITIONS_TL |
12 | |
FND_SIF_POLICIES |
10 | |
FND_SIF_POLICY_PROPS |
11 | |
FND_SIF_SETTINGS |
17 | |
FND_SIF_WSDLS |
9 | |
FND_SOA_ATTACHMENT |
14 | |
FND_SOA_BODY_PIECE |
15 | |
FND_SOA_LOG_CATEGORY |
4 | |
FND_SOA_LOG_SERVICE_DETAILS |
6 | |
FND_SOA_REQUEST |
43 | |
FND_SOA_RESPONSE |
26 | |
FND_SOA_RESPONSE_METHOD |
15 | |
FND_SOA_RUNTIME_ERROR |
18 | |
FND_SOA_SERVICES |
11 | |
FND_SOA_SERVICE_DT_ERRORS |
5 | |
FND_SOA_SERVICE_OPERATIONS |
10 | |
FND_SOA_SERVICE_POLICIES |
9 | |
FND_SQL_SAMPLES |
4 | - Retrofitted |
FND_STAGE_FN_PARAMETERS_TL |
13 | Translation for FND_STAGE_FN_PARAMETERS |
FND_STAGE_FN_PARAMETER_VALUES |
12 | - Retrofitted |
FND_STAGE_LINK_VERTICES |
13 | |
FND_STATS_HIST |
13 | Time required by FND_STATS to gather statistics |
FND_SVC_COMPONENTS |
22 | Service Components |
FND_SVC_COMP_PARAMS_B |
15 | Service Component Parameter Definitions |
FND_SVC_COMP_PARAMS_TL |
11 | MLS table for the FND_SVC_COMP_PARAMS_B table |
FND_SVC_COMP_PARAM_VALS |
12 | Service Component Parameter Values |
FND_SVC_COMP_REQUESTS |
15 | Scheduled Service Component Events |
FND_SVC_COMP_REQUESTS_H |
18 | Service Component Event Requests History |
FND_SVC_COMP_TYPES_B |
11 | Service Component-Types |
FND_SVC_COMP_TYPES_TL |
11 | MLS table for the FND_SVC_COMP_TYPES_B table |
FND_SYSTEM_SERVER_MAP |
7 | This table is included only for reference at this point. It is not needed since only one system is currently modeled in the Apps DB.Howe |
FND_TABLES |
25 | Tables registered in applications |
FND_TABLESPACES |
8 | FND_TABLESPACES will map the logical to physical tablespace name |
FND_TEMP_FILES |
6 | Stores names of database server PL/SQL temporary files available for use |
FND_TEMP_FILE_PARAMETERS |
2 | Temporary table for secure file upload or download |
FND_TERRITORIES |
17 | Territories, also known as countries |
FND_TERRITORIES_TL |
11 | Translations for FND_TERRITORIES |
FND_TIMEZONES_B |
12 | List of Timezone names (translated) for LOV purposes |
FND_TIMEZONES_TL |
10 | List of Timezone names (translated) for LOV purposes |
FND_TM_EVENTS |
14 | |
FND_TNS_ALIASES |
11 | FND_TNS_ALIASES will be used by AutoConfig for building the tnsnames.ora |
FND_TNS_ALIAS_ADDRESSES |
7 | This table points to the listeners for a specific TNS alias |
FND_TNS_ALIAS_ADDRESS_LISTS |
10 | Each description in the description list for a TNS alias will have one or more address lists. This table contains the information needed to |
FND_TNS_ALIAS_DESCRIPTIONS |
14 | A TNS Alias will have a description list that contains one or more connection descriptions. The FND_TNS_ALIAS_DESCRIPTIONS table contains i |
FND_TNS_ALIAS_SETS |
8 | FND_TNS_ALIAS_SETS |
FND_TNS_ALIAS_SET_USAGE |
7 | FND_TNS_ALIAS_SET_USAGE |
FND_TNS_LISTENERS |
9 | FND_TNS_LISTENERS table tracks the TNS Listeners |
FND_TNS_LISTENER_PORTS |
9 | Each TNS listener may have multiple ports. Those ports are tracked here. |
FND_TRACE_LOG |
9 | Log for tests of cost-based optimization; not for use in production environment |
FND_TRANSLATION_EXCEPTIONS |
13 | This table is used exclusively by the Seed Data Translation tool and is not needed during application runtime |
FND_TREE_FOLDERS |
14 | APPTREE personal and public nodes |
FND_TS_MIG_CMDS |
21 | This table contains the commands generated for migrating Objects from old tablesapce to new tablespace |
FND_TS_MIG_RULES |
9 | FND_TS_MIG_RULES |
FND_TS_MIG_STATUS |
9 | |
FND_TS_PROD_INSTS |
5 | FND_TS_PROD_INSTS |
FND_TS_SIZING |
19 | This table contains sizing estimates for Objects/schemas |
FND_UMS_BUGFIXES |
11 | Bugfix definitions for UMS. |
FND_UMS_BUGFIX_FILE_VERSIONS |
2 | List of files in a bugfix. |
FND_UMS_BUGFIX_RELATIONSHIPS |
3 | Relationships between bugfixes |
FND_UMS_FILES |
4 | File definitions for UMS. |
FND_UMS_FILE_VERSIONS |
3 | File versions for UMS. |
FND_UNSUCCESSFUL_LOGINS |
4 | Sign-On Audit information about unsuccessful login attempts |
FND_USER |
27 | Application users |
FND_USER_DESKTOP_OBJECTS |
15 | Documents saved by a user on the Navigator |
FND_USER_PREFERENCES |
4 | Runtime user preference settings |
FND_VALUE_ATTRIBUTE_TYPES |
17 | Key flexfield segment qualifiers |
FND_VAL_ATTRIBUTE_TYPES_TL |
14 | Translations for FND_VALUE_ATTRIBUTE_TYPES |
FND_VIEWS |
13 | Views registered with Oracle Application Object Library |
FND_VIEW_COLUMNS |
11 | View columns registered with Oracle Application Object Library |
FND_WAIT_SAMPLES |
6 | - Retrofitted |
FUN_BAL_INTER_INT3_GT |
9 | |
FV_EXTRACT_DETAIL_GT |
69 | |
FWK_PORTLET_GEN |
5 | |
HRI_TIME_CAL_DAY_MV |
11 | |
IBY_DOCS_IN_PMT_GT |
37 | |
IEU_UWQM_ITEMS_GTT |
49 | |
IEX_POP_UWQ_SUMM_GT |
3 | |
IGI_CIS_MTH_RET_PAY_GT |
10 | |
JDR_ATTRIBUTES |
6 | JDR_ATTRIBUTES |
JDR_ATTRIBUTES_TRANS |
6 | JDR_ATTRIBUTES_TRANS |
JDR_COMPONENTS |
11 | JDR_COMPONENTS |
JDR_PATHS |
13 | JDR_PATHS |
JL_REMIT1_GT |
31 | |
JL_REV_TMP |
5 | |
JTY_DENORM_TERR_ATTR_VALUES_GT |
99 | |
MO_GLOB_ORG_ACCESS_TMP |
4 | |
MSC_PHUB_SUPPLIERS_MV |
13 | |
MTH_EQUIP_OP_SUM_DD_MV |
29 | |
MTH_EQUIP_OP_SUM_PM_MV |
35 | |
MTH_EQUIP_PROD_SCH_DD_MV |
17 | |
MTH_EQUIP_PROD_SCH_PM_MV |
23 | |
MTH_EQUIP_SHFT_DD_MV |
15 | |
MTH_EQUIP_SHFT_PM_MV |
21 | |
MTH_EQUIP_ST_SUM_DD_MV |
25 | |
MTH_EQUIP_ST_SUM_PM_MV |
31 | |
MTH_ITEM_COST_MV |
4 | |
MTH_MTL_CONS_IT_MV |
22 | |
MTH_MTL_CONS_LT_MV |
27 | |
MTH_MTL_PROD_IT_MV |
32 | |
MTH_MTL_PROD_LT_MV |
41 | |
MTH_RESOURCE_COST_MV |
4 | |
MTH_RES_REQ_IT_MV |
9 | |
MTH_RES_REQ_LT_MV |
14 | |
MTH_RES_TXN_IT_MV |
9 | |
MTH_RES_TXN_LT_MV |
14 | |
MTH_SHIFT_GREGORIAN_DENORM_MV |
15 | |
OAM_PAT_WS_ATTACHMENT |
14 | |
OAM_PAT_WS_BODY_PIECE |
14 | |
OAM_PAT_WS_REQUEST |
33 | |
OAM_PAT_WS_RESPONSE |
26 | |
OAM_PAT_WS_RESPONSE_METHOD |
15 | |
OE_ITEMS_MV |
20 | |
PA_BILLING_PROCESS_GT |
3 | Having project ids elgible for revenue/invoice process |
PA_FI_ASSIG_TEMP |
2 | |
UMX_LSA_ROLE |
21 | |
UMX_LSA_ROLE_GLOBAL_PRIVS |
15 | |
UMX_LSA_ROLE_SET_CRITERIA |
10 | |
UMX_LSA_ROLE_SET_ROLES |
7 | |
UMX_REG_REQUESTS |
20 | Stores information about registration requests |
UMX_REG_SERVICES_B |
19 | Stores metadata for various registration processes available through the Oracle User Management module. |
UMX_REG_SERVICES_TL |
13 | Translation table for UMX_REG_SERVICES_B |
WF_ACTIVITIES |
26 | Defines a unit of work that contributes to the accomplishment of a process. |
WF_ACTIVITIES_TL |
11 | Translations for WF_ACTIVITIES |
WF_ACTIVITY_ATTRIBUTES |
16 | Defines attributes for activities |
WF_ACTIVITY_ATTRIBUTES_TL |
12 | Translations for WF_ACTIVITY_ATTRIBUTES |
WF_ACTIVITY_ATTR_VALUES |
10 | Values for activity attributes |
WF_ACTIVITY_TRANSITIONS |
8 | Transition definitions |
WF_AGENTS |
21 | Agent definitions for Business Event System |
WF_AGENT_GROUPS |
4 | Agent Group Relations |
WF_ATTRIBUTE_CACHE |
7 | This table is used to store attribute name / attribute value pairs for entities. |
WF_BES_SUBSCRIBER_PINGS |
7 | This table contains one row for each ping for each queue subscriber |
WF_COMMENTS |
13 | This is a table for notification comments |
WF_DIG_CAS |
3 | certificate authorities table |
WF_DIG_CERTS |
13 | digital certificates table |
WF_DIG_CRLS |
6 | certificate revocation lists table |
WF_DIG_SIGS |
19 | digital signatures table |
WF_DIG_SIG_SPI_FLAVORS |
11 | digital signature service provider interface info table |
WF_DIRECTORY_PARTITIONS |
10 | Lookup table for orig system in partitioned tables. |
WF_DIRECTORY_PARTITIONS_TL |
6 | Translated Directory Partitions |
WF_ENTITY_CHANGES |
5 | Stores pending changes for OID |
WF_EVENTS |
13 | Event definitions for Business Event System |
WF_EVENTS_TL |
7 | Translatable portions of events for Business Event System |
WF_EVENT_GROUPS |
4 | Groups of events for Business Event System |
WF_EVENT_SUBSCRIPTIONS |
30 | Subscription for Business Event System |
WF_ITEMS |
14 | Workflow runtime table |
WF_ITEM_ACTIVITY_STATUSES |
19 | Runtime table for a work item |
WF_ITEM_ACTIVITY_STATUSES_H |
19 | Stores history of WF_ITEM_ACTIVITY_STATUSES |
WF_ITEM_ATTRIBUTES |
13 | Stores item attribute definitions |
WF_ITEM_ATTRIBUTES_TL |
10 | Translations for WF_ITEM_ATTRIBUTES |
WF_ITEM_ATTRIBUTE_VALUES |
9 | Contains values for item attributes |
WF_ITEM_TYPES |
17 | Item type definition |
WF_ITEM_TYPES_TL |
9 | Translations for WF_ITEM_TYPES |
WF_LOCAL_LANGUAGES |
7 | Local languages table |
WF_LOCAL_ROLES |
24 | Local Roles table |
WF_LOCAL_ROLES_OLD |
24 | |
WF_LOCAL_ROLES_STAGE |
24 | |
WF_LOCAL_ROLES_TL |
13 |