Search Results pa_projects_all




The PA_PROJECTS_ALL table is a fundamental data structure within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically designed to support the Project Accounting (PA) module. This table serves as the central repository for all project-related information, storing comprehensive details about projects across the organization. As a key component of Oracle Projects, it enables robust project tracking, financial management, and reporting capabilities.

Table Structure and Key Columns

The PA_PROJECTS_ALL table contains numerous columns that define project attributes, relationships, and control parameters. Some of the most critical columns include:
  • PROJECT_ID: Primary key identifier for each project
  • SEGMENT1: Key flexfield segment for project numbering
  • NAME: Descriptive name of the project
  • PROJECT_TYPE: Classification (Contract, Capital, Indirect, etc.)
  • CARRYING_OUT_ORGANIZATION_ID: Owning operating unit
  • START_DATE/COMPLETION_DATE: Project timeline
  • PROJECT_STATUS_CODE: Current lifecycle status
  • TEMPLATE_FLAG: Indicates if record is a project template

Integration Points

The table integrates with multiple Oracle EBS modules through foreign key relationships:
  • General Ledger: Ties projects to accounting segments
  • Accounts Payable/Receivable: Links project expenditures and invoices
  • Human Resources: Associates project teams and resources
  • Inventory: Tracks project-related material movements

Functional Significance

In Oracle Projects implementation, PA_PROJECTS_ALL enables:
  • Multi-organization project definitions with security by operating unit
  • Flexible project hierarchies through parent-child relationships
  • Project templates for standardized project creation
  • Work breakdown structure (WBS) management
  • Project funding and budget control
  • Cross-module reporting and analytics

Technical Considerations

Implementation teams should note:
  • The "_ALL" suffix indicates multi-org architecture support
  • Key flexfield configurations impact data structure
  • Table is heavily indexed for performance optimization
  • Custom extensions should use descriptive flexfields
  • Data access requires proper MOAC security setup

Upgrade Implications

Between 12.1.1 and 12.2.2 versions:
  • Core table structure remains largely unchanged
  • New columns may be added for enhanced functionality
  • Indexing strategies may be optimized
  • Integration points may expand with new modules
The PA_PROJECTS_ALL table's comprehensive design and tight integration with other EBS modules make it indispensable for organizations implementing Oracle Projects. Proper understanding of its structure and relationships is critical for successful implementations, customizations, and reporting solutions in both Oracle EBS 12.1.1 and 12.2.2 environments.

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_IND_RATE_SCHEDULES_ALL_BG 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_IND_RATE_SCHEDULES_ALL_BG,  object_name:PA_IND_RATE_SCHEDULES_ALL_BG,  status:VALID,  product: PA - Projects ,  description: Implementation-defined burden schedules ,  implementation_dba_data: PA.PA_IND_RATE_SCHEDULES_ALL_BG , 

  • Table: PA_IND_RATE_SCHEDULES_ALL_BG 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_IND_RATE_SCHEDULES_ALL_BG,  object_name:PA_IND_RATE_SCHEDULES_ALL_BG,  status:VALID,  product: PA - Projects ,  description: Implementation-defined burden schedules ,  implementation_dba_data: PA.PA_IND_RATE_SCHEDULES_ALL_BG , 

  • Table: PA_ROLE_LISTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_LISTS,  object_name:PA_ROLE_LISTS,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_LISTS stores lists of roles defined with the system. ,  implementation_dba_data: PA.PA_ROLE_LISTS , 

  • Table: PA_ROLE_LISTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_LISTS,  object_name:PA_ROLE_LISTS,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_LISTS stores lists of roles defined with the system. ,  implementation_dba_data: PA.PA_ROLE_LISTS , 

  • Table: PA_PERF_TRANSACTIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERF_TRANSACTIONS,  object_name:PA_PERF_TRANSACTIONS,  status:VALID,  product: PA - Projects ,  description: This table records performance transaction data. ,  implementation_dba_data: PA.PA_PERF_TRANSACTIONS , 

  • Table: PA_PERF_TRANSACTIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERF_TRANSACTIONS,  object_name:PA_PERF_TRANSACTIONS,  status:VALID,  product: PA - Projects ,  description: This table records performance transaction data. ,  implementation_dba_data: PA.PA_PERF_TRANSACTIONS , 

  • Table: PA_INVOICE_FORMATS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_INVOICE_FORMATS,  object_name:PA_INVOICE_FORMATS,  status:VALID,  product: PA - Projects ,  description: Implementation-defined configurations of columns, text, and layout of invoice lines ,  implementation_dba_data: PA.PA_INVOICE_FORMATS , 

  • Table: PA_INVOICE_FORMATS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_INVOICE_FORMATS,  object_name:PA_INVOICE_FORMATS,  status:VALID,  product: PA - Projects ,  description: Implementation-defined configurations of columns, text, and layout of invoice lines ,  implementation_dba_data: PA.PA_INVOICE_FORMATS , 

  • View: PA_PROJECT_DRIVERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_DRIVERS_V,  object_name:PA_PROJECT_DRIVERS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_DRIVERS_V , 

  • View: PA_PROJECT_DRIVERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_DRIVERS_V,  object_name:PA_PROJECT_DRIVERS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_DRIVERS_V , 

  • View: PA_PROJ_PAGE_REGIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_PAGE_REGIONS_V,  object_name:PA_PROJ_PAGE_REGIONS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJ_PAGE_REGIONS_V , 

  • View: PA_PROJ_PAGE_REGIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_PAGE_REGIONS_V,  object_name:PA_PROJ_PAGE_REGIONS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJ_PAGE_REGIONS_V , 

  • View: PA_CP_GENERATE_ASSET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CP_GENERATE_ASSET_V,  object_name:PA_CP_GENERATE_ASSET_V,  status:VALID,  product: PA - Projects ,  description: 10SC Only ,  implementation_dba_data: APPS.PA_CP_GENERATE_ASSET_V , 

  • Table: PA_BUDGETARY_CONTROL_OPTIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGETARY_CONTROL_OPTIONS,  object_name:PA_BUDGETARY_CONTROL_OPTIONS,  status:VALID,  product: PA - Projects ,  description: pa_budgetary_control_options stores all the default budgetary control levels and time intervals ,  implementation_dba_data: PA.PA_BUDGETARY_CONTROL_OPTIONS , 

  • Table: PA_BUDGETARY_CONTROL_OPTIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGETARY_CONTROL_OPTIONS,  object_name:PA_BUDGETARY_CONTROL_OPTIONS,  status:VALID,  product: PA - Projects ,  description: pa_budgetary_control_options stores all the default budgetary control levels and time intervals ,  implementation_dba_data: PA.PA_BUDGETARY_CONTROL_OPTIONS , 

  • Table: PA_PROJECT_SET_LINES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_SET_LINES,  object_name:PA_PROJECT_SET_LINES,  status:VALID,  product: PA - Projects ,  description: This is an intersection table between PA_PROJECTS_ALL and PA_PROJECT_SETS_B. It stores the elements (which will be projects) of the project set. ,  implementation_dba_data: PA.PA_PROJECT_SET_LINES , 

  • View: PA_RETIREMENT_COSTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RETIREMENT_COSTS_V,  object_name:PA_RETIREMENT_COSTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_RETIREMENT_COSTS_V , 

  • Table: PA_COMP_RULE_OT_DEFAULTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMP_RULE_OT_DEFAULTS_ALL,  object_name:PA_COMP_RULE_OT_DEFAULTS_ALL,  status:VALID,  product: PA - Projects ,  description: This table stores the overtime default project and task details for a Labor costing rule. ,  implementation_dba_data: PA.PA_COMP_RULE_OT_DEFAULTS_ALL , 

  • View: PA_CP_GENERATE_ASSET_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CP_GENERATE_ASSET_V,  object_name:PA_CP_GENERATE_ASSET_V,  status:VALID,  product: PA - Projects ,  description: 10SC Only ,  implementation_dba_data: APPS.PA_CP_GENERATE_ASSET_V , 

  • Table: PA_PERF_KPA_SUMMARY 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERF_KPA_SUMMARY,  object_name:PA_PERF_KPA_SUMMARY,  status:VALID,  product: PA - Projects ,  description: This table records the exception summary for a given object across all KPAs. ,  implementation_dba_data: PA.PA_PERF_KPA_SUMMARY , 

  • View: PA_RETIREMENT_COSTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RETIREMENT_COSTS_V,  object_name:PA_RETIREMENT_COSTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_RETIREMENT_COSTS_V , 

  • Table: PA_BUDGETARY_CONTROLS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGETARY_CONTROLS,  object_name:PA_BUDGETARY_CONTROLS,  status:VALID,  product: PA - Projects ,  description: PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions ,  implementation_dba_data: PA.PA_BUDGETARY_CONTROLS , 

  • Table: PA_PROJECT_CTX_SEARCH 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_CTX_SEARCH,  object_name:PA_PROJECT_CTX_SEARCH,  status:VALID,  product: PA - Projects ,  description: PA_PROJECT_CTX_SEARCH stores the concatenated attributes for the columns of PA_PROJECTS_ALL that we perform keyword search on, including Name, Long Name, Segment1 and Description ,  implementation_dba_data: PA.PA_PROJECT_CTX_SEARCH , 

  • Table: PA_PROJECT_CTX_SEARCH 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_CTX_SEARCH,  object_name:PA_PROJECT_CTX_SEARCH,  status:VALID,  product: PA - Projects ,  description: PA_PROJECT_CTX_SEARCH stores the concatenated attributes for the columns of PA_PROJECTS_ALL that we perform keyword search on, including Name, Long Name, Segment1 and Description ,  implementation_dba_data: PA.PA_PROJECT_CTX_SEARCH , 

  • Table: PA_PERF_KPA_SUMMARY 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERF_KPA_SUMMARY,  object_name:PA_PERF_KPA_SUMMARY,  status:VALID,  product: PA - Projects ,  description: This table records the exception summary for a given object across all KPAs. ,  implementation_dba_data: PA.PA_PERF_KPA_SUMMARY , 

  • Table: PA_RES_FORMATS_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RES_FORMATS_B,  object_name:PA_RES_FORMATS_B,  status:VALID,  product: PA - Projects ,  description: Stores all valid resource formats for planning resources. ,  implementation_dba_data: PA.PA_RES_FORMATS_B , 

  • Table: PA_RES_FORMATS_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RES_FORMATS_B,  object_name:PA_RES_FORMATS_B,  status:VALID,  product: PA - Projects ,  description: Stores all valid resource formats for planning resources. ,  implementation_dba_data: PA.PA_RES_FORMATS_B , 

  • Table: PA_PERF_OBJECT_RULES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERF_OBJECT_RULES,  object_name:PA_PERF_OBJECT_RULES,  status:VALID,  product: PA - Projects ,  description: This table stores the association between Exception Rule and the actual object. ,  implementation_dba_data: PA.PA_PERF_OBJECT_RULES , 

  • Table: PA_PERF_OBJECT_RULES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PERF_OBJECT_RULES,  object_name:PA_PERF_OBJECT_RULES,  status:VALID,  product: PA - Projects ,  description: This table stores the association between Exception Rule and the actual object. ,  implementation_dba_data: PA.PA_PERF_OBJECT_RULES , 

  • Table: PA_PROJECT_SET_LINES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_SET_LINES,  object_name:PA_PROJECT_SET_LINES,  status:VALID,  product: PA - Projects ,  description: This is an intersection table between PA_PROJECTS_ALL and PA_PROJECT_SETS_B. It stores the elements (which will be projects) of the project set. ,  implementation_dba_data: PA.PA_PROJECT_SET_LINES , 

  • View: PA_PROJECT_OPTIONS_SS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_OPTIONS_SS_V,  object_name:PA_PROJECT_OPTIONS_SS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_OPTIONS_SS_V , 

  • Table: PA_COMP_RULE_OT_DEFAULTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMP_RULE_OT_DEFAULTS_ALL,  object_name:PA_COMP_RULE_OT_DEFAULTS_ALL,  status:VALID,  product: PA - Projects ,  description: This table stores the overtime default project and task details for a Labor costing rule. ,  implementation_dba_data: PA.PA_COMP_RULE_OT_DEFAULTS_ALL , 

  • Table: PA_BUDGETARY_CONTROLS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGETARY_CONTROLS,  object_name:PA_BUDGETARY_CONTROLS,  status:VALID,  product: PA - Projects ,  description: PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions ,  implementation_dba_data: PA.PA_BUDGETARY_CONTROLS , 

  • Table: PA_CC_TP_SCHEDULES_BG 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CC_TP_SCHEDULES_BG,  object_name:PA_CC_TP_SCHEDULES_BG,  status:VALID,  product: PA - Projects ,  description: Transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged labor and non-labor transactions. ,  implementation_dba_data: PA.PA_CC_TP_SCHEDULES_BG , 

  • Table: PA_ORG_FCST_ELEMENTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ORG_FCST_ELEMENTS,  object_name:PA_ORG_FCST_ELEMENTS,  status:VALID,  product: PA - Projects ,  description: This table stores denormalized header information for Organization Forecasts. ,  implementation_dba_data: PA.PA_ORG_FCST_ELEMENTS , 

  • Table: PA_ORG_FCST_ELEMENTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ORG_FCST_ELEMENTS,  object_name:PA_ORG_FCST_ELEMENTS,  status:VALID,  product: PA - Projects ,  description: This table stores denormalized header information for Organization Forecasts. ,  implementation_dba_data: PA.PA_ORG_FCST_ELEMENTS , 

  • Table: PA_CC_TP_SCHEDULES_BG 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_CC_TP_SCHEDULES_BG,  object_name:PA_CC_TP_SCHEDULES_BG,  status:VALID,  product: PA - Projects ,  description: Transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged labor and non-labor transactions. ,  implementation_dba_data: PA.PA_CC_TP_SCHEDULES_BG , 

  • Table: PA_BC_BALANCES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BC_BALANCES,  object_name:PA_BC_BALANCES,  status:VALID,  product: PA - Projects ,  description: PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat ,  implementation_dba_data: PA.PA_BC_BALANCES , 

  • View: PA_PROJECT_OPTIONS_SS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_OPTIONS_SS_V,  object_name:PA_PROJECT_OPTIONS_SS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_OPTIONS_SS_V , 

  • Table: PA_LOCATIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_LOCATIONS,  object_name:PA_LOCATIONS,  status:VALID,  product: PA - Projects ,  description: This table is used to store the locations that are used in Projects. A new location is created when a new location is assigned to a project or a team role. There would be no way for user to enter new locations into this table ,  implementation_dba_data: PA.PA_LOCATIONS , 

  • Table: PA_BC_BALANCES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BC_BALANCES,  object_name:PA_BC_BALANCES,  status:VALID,  product: PA - Projects ,  description: PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat ,  implementation_dba_data: PA.PA_BC_BALANCES , 

  • Table: PA_STD_BILL_RATE_SCHEDULES_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_STD_BILL_RATE_SCHEDULES_ALL,  object_name:PA_STD_BILL_RATE_SCHEDULES_ALL,  status:VALID,  product: PA - Projects ,  description: Sets of standard bill rates that can be assigned as groups to projects and tasks ,  implementation_dba_data: PA.PA_STD_BILL_RATE_SCHEDULES_ALL , 

  • Table: PA_STD_BILL_RATE_SCHEDULES_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_STD_BILL_RATE_SCHEDULES_ALL,  object_name:PA_STD_BILL_RATE_SCHEDULES_ALL,  status:VALID,  product: PA - Projects ,  description: Sets of standard bill rates that can be assigned as groups to projects and tasks ,  implementation_dba_data: PA.PA_STD_BILL_RATE_SCHEDULES_ALL , 

  • Table: PA_WORK_TYPES_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_WORK_TYPES_B,  object_name:PA_WORK_TYPES_B,  status:VALID,  product: PA - Projects ,  description: This table stores implementation-defined types of work being carried out in Projects in the base language. ,  implementation_dba_data: PA.PA_WORK_TYPES_B , 

  • Table: PA_WORK_TYPES_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_WORK_TYPES_B,  object_name:PA_WORK_TYPES_B,  status:VALID,  product: PA - Projects ,  description: This table stores implementation-defined types of work being carried out in Projects in the base language. ,  implementation_dba_data: PA.PA_WORK_TYPES_B , 

  • Table: PA_DRAFT_INVOICE_DETAILS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_DRAFT_INVOICE_DETAILS_ALL,  object_name:PA_DRAFT_INVOICE_DETAILS_ALL,  status:VALID,  product: PA - Projects ,  description: Intercompany invoice details for cross charged transactions ,  implementation_dba_data: PA.PA_DRAFT_INVOICE_DETAILS_ALL , 

  • Table: PA_DRAFT_INVOICE_DETAILS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_DRAFT_INVOICE_DETAILS_ALL,  object_name:PA_DRAFT_INVOICE_DETAILS_ALL,  status:VALID,  product: PA - Projects ,  description: Intercompany invoice details for cross charged transactions ,  implementation_dba_data: PA.PA_DRAFT_INVOICE_DETAILS_ALL , 

  • Table: PA_LOCATIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_LOCATIONS,  object_name:PA_LOCATIONS,  status:VALID,  product: PA - Projects ,  description: This table is used to store the locations that are used in Projects. A new location is created when a new location is assigned to a project or a team role. There would be no way for user to enter new locations into this table ,  implementation_dba_data: PA.PA_LOCATIONS ,