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!

  • Q&A: How to find current Inventory Quantity?
  • How to find a column in database
  • FND : fnd_descriptive_flexs, fnd_descr_flex_column_usages
  • Oracle Sysadmin: FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_PROCESSES
  • Oracle Concurrent Requests : FND_CONCURRENT_REQUESTS
  • Oracle concurrent programs table: FND_EXECUTABLES
  • FND_FLEX_VALUE_NORM_HIERARCHY
  • Oracle FND_FLEX_VALUE_SETS
  • Oracle Workflow tables:WF_ACTIVITIES, WF_ITEMS, WF_NOTIFICATIONS
  • 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

    •  

    FND : fnd_descriptive_flexs, fnd_descr_flex_column_usages



    FND_DESCRIPTIVE_FLEXS     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.

    –>