Key ERP Tables

Below is the list of some of the important Oracle Apps Tables. If you are familiar with any other module and know the technical part of it then please feel free to submit the content and I will post it here. You may just send me the module and the table names. Enjoy!





FND : fnd_descriptive_flexs, fnd_descr_flex_column_usages

stores setup information about descriptive
flexfields. Each row includes the name of the table that contains the
descriptive flexfield columns, the name and title of the flexfield, the
identifier of the application with which the flexfield is registered,
whether the flexfield is currently frozen, whether this is a protected
descriptive flexfield, the name of the structure defining column for the
flexfield (CONTEXT_COLUMN_NAME), and other information about
how the flexfield is defined. You need one row for each descriptive
flexfield in each application. Oracle Application Object Library uses this
information to generate a compiled definition for a descriptive flexfield.

FND_DESCR_FLEX_COLUMN_USAGES stores the correspondences
between application table columns and the descriptive flexfield
segments. Each row includes an application identifier, the name of a
descriptive flexfield, and a column name. The context field value, also
known as the structure name, is in
DESCRIPTIVE_FLEX_CONTEXT_CODE. Each row also includes the
segment name (END_USER_COLUMN_NAME), the display
information about the segment such as prompts, display size, type of
default value, whether the segment is required or not, whether the
segment is part of a high, low segment pair, whether security is enabled
for the segment, whether to display the segment or not, and the value
set the segment uses. You need one row for each segment for each
context value (structure), including global data element segments, for
each descriptive flexfield of each application. Oracle Application Object
Library uses this information to create a compiled descriptive flexfield
definition to store in the FND_COMPILED_DESCRIPTIVE_FLEXS table.





Oracle Concurrent Requests : FND_CONCURRENT_REQUESTS


Oracle concurrent programs table: FND_EXECUTABLES







Oracle FND key tables , FND_FLEX_VALUE_HIERARCHIES (4)


Oracle FND key tables , FND_FLEX_VALUES (3)


Oracle FND key tables , FND_ID_FLEX_STRUCTURES (2)


Oracle FND key tables , FND_ID_FLEXS, FND_ID_FLEX_SEGMENTS (1)


Oracle Inventory (INV) key tables – mtl_demand (4)


Oracle Inventory (INV) key tables – mtl_category_sets_b, mtl_categories_b (3)


Oracle Purchasing (PO) key Vendor tables (5)


Oracle Fixed Assets (FA) Key Tables fa_categories_b, fa_deprn_detail

Oracle Fixed Assets (FA) Key Tables fa_books


Oracle Inventory (INV) key tables – mtl_item_categories, mtl_item_sub_inventories (2)


Oracle Inventory (INV) key tables – mtl_system_items (1)


Oracle Purchasing (PO) key requisition tables (4)


Oracle Purchasing (PO) key table – po_distributions_all (3)


Oracle Purchasing (PO) key table – po_lines_all (2)


Oracle HRMS (human resource management) HR key Tables (2)


Oracle HRMS key Tables (2)


Oracle Purchasing (PO) key table – po_headers_all (1)

Oracle Projects key views and tables PA (2)


Oracle HRMS key Tables (1)


Oracle Projects key Tables PA (1)


FA Key Tables fa_additions_b , fa_adjustments (2)


Bill of Materials Key tables bom_inventory_components(2)


Bill of Materials Key Tables (1)


CST (Cost) Key tables cst_cost_types, cst_standard_costs (2)


CST (Cost) Key Tables cst_item_costs , cst_item_cost_details (1)


WIP Key tables wip_lines , wip_operations (1)

WIP Key tables wip_entities , wip_discrete_jobs, wip_transactions (1)


FA Key Tables fa_deprn_summary, fa_deprn_periods (1)


Can you count the number of products Oracle has? (2)


Can you count the number of products Oracle has? (1)


GL Key Tables : GL_sets_of_books, gl_import_references,gl_daily_rates (4)


GL Key Tables : GL_lines, gl_periods (3)


GL Key Tables : GL_headers, gl_batches (2)


GL Key Tables : GL_Balances, gl_code_combinations (1)


Oracle Accounts Receivables (AR) – key Tables 3

Oracle Accounts Receivables (AR) – key Tables 2


Oracle Accounts Receivables (AR) – key Tables 1


Oracle Accounts Payables (AP) – Key Tables 2

Oracle Accounts Payables (AP) – Key Tables 1

Oracle Apps Tables and Brief Description

Leave a Comment